Movign functons around to be in some kind of order
[quicknote] / src / libquicknote.py
1 #/usr/bin/env python2.5
2 # -*- coding: utf-8 -*-
3
4 """
5  Copyright (C) 2007 Christoph Würstle
6
7 This program is free software; you can redistribute it and/or modify
8 it under the terms of the GNU General Public License version 2 as
9 published by the Free Software Foundation.
10
11 @todo Add an edit menu with select all, cut, copy, and paste
12 @todo Add undo directly into the UI
13 @todo Add Note Export (txt File) and Export All (json dump?)
14 @todo Save word wrap and zoom setting 
15 """
16
17
18 import os
19 import gc
20 import logging
21
22 import gtk
23
24 try:
25         import hildon
26         IS_HILDON = True
27 except ImportError:
28         import fakehildon as hildon
29         IS_HILDON = False
30
31 try:
32         import osso
33 except ImportError:
34         osso = None
35
36 import libspeichern
37 import libkopfzeile
38 import libnotizen
39 import libsync
40
41
42 try:
43         _
44 except NameError:
45         _ = lambda x: x
46
47
48 class QuicknoteProgram(hildon.Program):
49
50         __pretty_app_name__ = "quicknote"
51         __app_name__ = "quicknote"
52         __version__ = "0.7.7"
53
54         def __init__(self):
55                 super(QuicknoteProgram, self).__init__()
56
57                 home_dir = os.path.expanduser('~')
58                 dblog = os.path.join(home_dir, "quicknote.log")
59
60                 # define a Handler which writes INFO messages or higher to the sys.stderr
61                 console = logging.StreamHandler()
62                 console.setLevel(logging.DEBUG)
63                 # set a format which is simpler for console use
64                 formatter = logging.Formatter('%(asctime)s  %(levelname)-8s %(message)s')
65                 # tell the handler to use this format
66                 console.setFormatter(formatter)
67                 # add the handler to the root logger
68                 logging.getLogger('').addHandler(console)
69
70                 logging.info('Starting quicknote')
71
72                 if osso is not None:
73                         self._osso_c = osso.Context(self.__app_name__, self.__version__, False)
74                         self._deviceState = osso.DeviceState(self._osso_c)
75                         self._deviceState.set_device_state_callback(self._on_device_state_change, 0)
76                 else:
77                         self._osso_c = None
78                         self._deviceState = None
79
80                 #Get the Main Window, and connect the "destroy" event
81                 self._window = hildon.Window()
82                 self.add_window(self._window)
83
84                 self._window.set_title(self.__pretty_app_name__)
85                 self._window.connect("delete_event", self._on_delete_event)
86                 self._window.connect("destroy", self._on_destroy)
87                 self._window.connect("key-press-event", self._on_key_press)
88                 self._window.connect("window-state-event", self._on_window_state_change)
89                 self._window_in_fullscreen = False #The window isn't in full screen mode initially.
90
91                 self._db = libspeichern.Speichern()
92                 self._syncDialog = None
93                 self._prepare_sync_dialog()
94
95                 #Create GUI main vbox
96                 vbox = gtk.VBox(homogeneous = False, spacing = 0)
97
98                 #Create Menu and apply it for hildon
99                 filemenu = gtk.Menu()
100
101                 menu_items = gtk.MenuItem(_("Set DB file"))
102                 filemenu.append(menu_items)
103                 menu_items.connect("activate", self.set_db_file, None)
104
105                 menu_items = gtk.MenuItem(_("SQL History"))
106                 filemenu.append(menu_items)
107                 menu_items.connect("activate", self._on_view_sql_history, None)
108
109                 menu_items = gtk.MenuItem(_("Sync notes"))
110                 filemenu.append(menu_items)
111                 menu_items.connect("activate", self._on_sync_notes, None)
112
113                 menu_items = gtk.MenuItem(_("Quit"))
114                 filemenu.append(menu_items)
115                 menu_items.connect("activate", self._on_destroy, None)
116
117                 file_menu = gtk.MenuItem(_("File"))
118                 file_menu.show()
119                 file_menu.set_submenu(filemenu)
120
121                 categorymenu = gtk.Menu()
122
123                 menu_items = gtk.MenuItem(_("delete"))
124                 categorymenu.append(menu_items)
125                 menu_items.connect("activate", self._on_delete_category, None)
126
127                 menu_items = gtk.MenuItem(_("move to category"))
128                 categorymenu.append(menu_items)
129                 menu_items.connect("activate", self._on_move_category, None)
130
131                 category_menu = gtk.MenuItem(_("Category"))
132                 category_menu.show()
133                 category_menu.set_submenu(categorymenu)
134
135                 viewmenu = gtk.Menu()
136
137                 menu_items = gtk.MenuItem(_("Word Wrap"))
138                 viewmenu.append(menu_items)
139                 menu_items.connect("activate", self._on_toggle_word_wrap, None)
140                 self._wordWrapEnabled = False
141
142                 view_menu = gtk.MenuItem(_("View"))
143                 view_menu.show()
144                 view_menu.set_submenu(viewmenu)
145
146                 helpmenu = gtk.Menu()
147
148                 menu_items = gtk.MenuItem(_("About"))
149                 helpmenu.append(menu_items)
150                 menu_items.connect("activate", self._on_show_about, None)
151
152                 help_menu = gtk.MenuItem(_("Help"))
153                 help_menu.show()
154                 help_menu.set_submenu(helpmenu)
155
156                 menu_bar = gtk.MenuBar()
157                 menu_bar.show()
158                 menu_bar.append (file_menu)
159                 menu_bar.append (category_menu)
160                 menu_bar.append (view_menu)
161                 menu_bar.append (help_menu)
162
163                 menu_bar.show()
164                 if IS_HILDON:
165                         menu = gtk.Menu()
166                         for child in menu_bar.get_children():
167                                 child.reparent(menu)
168                         self._window.set_menu(menu)
169                         menu_bar.destroy()
170                 else:
171                         vbox.pack_start(menu_bar, False, False, 0)
172
173                 #Create GUI elements
174                 self._topBox = libkopfzeile.Kopfzeile(self._db)
175                 vbox.pack_start(self._topBox, False, False, 0)
176
177                 self._notizen = libnotizen.Notizen(self._db, self._topBox)
178                 vbox.pack_start(self._notizen, True, True, 0)
179
180                 self._window.add(vbox)
181                 self._window.show_all()
182                 self._on_toggle_word_wrap()
183
184         def main(self):
185                 gtk.main()
186
187         def set_db_file(self, widget = None, data = None):
188                 dlg = hildon.FileChooserDialog(parent=self._window, action=gtk.FILE_CHOOSER_ACTION_SAVE)
189
190                 if self._db.ladeDirekt('datenbank'):
191                         dlg.set_filename(self._db.ladeDirekt('datenbank'))
192
193                 dlg.set_title(_("Choose database file"))
194                 if dlg.run() == gtk.RESPONSE_OK:
195                         fileName = dlg.get_filename()
196                         self._db.speichereDirekt('datenbank', fileName)
197
198                         self._db.openDB()
199                         self._topBox.load_categories()
200                         self._notizen.load_notes()
201                         dlg.destroy()
202
203         def _prepare_sync_dialog(self):
204                 self._syncDialog = gtk.Dialog(_("Sync"), None, gtk.DIALOG_MODAL | gtk.DIALOG_DESTROY_WITH_PARENT, (gtk.STOCK_OK, gtk.RESPONSE_ACCEPT))
205
206                 self._syncDialog.set_position(gtk.WIN_POS_CENTER)
207                 sync = libsync.Sync(self._db, self._window, 50504)
208                 self._syncDialog.vbox.pack_start(sync, True, True, 0)
209                 self._syncDialog.set_size_request(500, 350)
210                 self._syncDialog.vbox.show_all()
211                 sync.connect("syncFinished", self._on_sync_finished)
212
213         def _on_device_state_change(self, shutdown, save_unsaved_data, memory_low, system_inactivity, message, userData):
214                 """
215                 For system_inactivity, we have no background tasks to pause
216
217                 @note Hildon specific
218                 """
219                 if memory_low:
220                         gc.collect()
221
222                 if save_unsaved_data or shutdown:
223                         pass
224
225         def _on_window_state_change(self, widget, event, *args):
226                 if event.new_window_state & gtk.gdk.WINDOW_STATE_FULLSCREEN:
227                         self._window_in_fullscreen = True
228                 else:
229                         self._window_in_fullscreen = False
230
231         def _on_key_press(self, widget, event, *args):
232                 if event.keyval == gtk.keysyms.F6:
233                         # The "Full screen" hardware key has been pressed 
234                         if self._window_in_fullscreen:
235                                 self._window.unfullscreen ()
236                         else:
237                                 self._window.fullscreen ()
238                 elif event.keyval == gtk.keysyms.F7:
239                         # Zoom In
240                         self._topBox.hide()
241                         self._notizen.show_history_area(False)
242                 elif event.keyval == gtk.keysyms.F8:
243                         # Zoom Out
244                         self._topBox.show()
245                         self._notizen.show_history_area(True)
246
247         def _on_view_sql_history(self, widget = None, data = None, data2 = None):
248                 import libsqldialog
249                 sqldiag = libsqldialog.sqlDialog(self._db)
250                 res = sqldiag.run()
251                 sqldiag.hide()
252                 if res == 444:
253                         logging.info("exporting sql")
254
255                         dlg = hildon.FileChooserDialog(parent=self._window, action=gtk.FILE_CHOOSER_ACTION_SAVE)
256
257                         dlg.set_title(_("Select SQL export file"))
258                         if dlg.run() == gtk.RESPONSE_OK:
259                                 fileName = dlg.get_filename()
260                                 dlg.destroy()
261                                 sqldiag.exportSQL(fileName)
262                         else:
263                                 dlg.destroy()
264
265                 sqldiag.destroy()
266
267         def _on_move_category(self, widget = None, data = None):
268                 dialog = gtk.Dialog(_("Choose category"), self._window, gtk.DIALOG_MODAL | gtk.DIALOG_DESTROY_WITH_PARENT, (gtk.STOCK_CANCEL, gtk.RESPONSE_REJECT, gtk.STOCK_OK, gtk.RESPONSE_ACCEPT))
269
270                 dialog.set_position(gtk.WIN_POS_CENTER)
271                 comboCategory = gtk.combo_box_new_text()
272
273                 comboCategory.append_text('undefined')
274                 sql = "SELECT id, liste FROM categories WHERE id = 0 ORDER BY liste"
275                 rows = self._db.ladeSQL(sql)
276                 for row in rows:
277                         comboCategory.append_text(row[1])
278
279                 dialog.vbox.pack_start(comboCategory, True, True, 0)
280
281                 dialog.vbox.show_all()
282                 #dialog.set_size_request(400, 300)
283
284                 if dialog.run() == gtk.RESPONSE_ACCEPT:
285                         n = comboCategory.get_active()
286                         if -1 < n and self._notizen.noteId != -1:
287                                 model = comboCategory.get_model()
288                                 active = comboCategory.get_active()
289                                 if active < 0:
290                                         return None
291                                 cat_id = model[active][0]
292
293                                 noteid, category, note = self._db.loadNote(self._notizen.noteId)
294                                 #print noteid, category, cat_id
295                                 self._db.saveNote(noteid, note, cat_id, pcdatum = None)
296                                 self._topBox.category_combo_changed()
297                         else:
298                                 mbox = gtk.MessageDialog(self._window, gtk.DIALOG_MODAL, gtk.MESSAGE_ERROR, gtk.BUTTONS_OK, _("No note selected."))
299                                 response = mbox.run()
300                                 mbox.hide()
301                                 mbox.destroy()
302
303                 dialog.destroy()
304
305         def _on_delete_category(self, widget = None, data = None):
306                 if self._topBox.get_category() == "%" or self._topBox.get_category() == "undefined":
307                         mbox = gtk.MessageDialog(None, gtk.DIALOG_MODAL, gtk.MESSAGE_ERROR, gtk.BUTTONS_OK, _("This category can not be deleted"))
308                         response = mbox.run()
309                         mbox.hide()
310                         mbox.destroy()
311                         return
312
313                 mbox = gtk.MessageDialog(None, gtk.DIALOG_MODAL, gtk.MESSAGE_WARNING, gtk.BUTTONS_YES_NO, _("Are you sure to delete the current category?"))
314                 response = mbox.run()
315                 mbox.hide()
316                 mbox.destroy()
317                 if response == gtk.RESPONSE_YES:
318                         sql = "UPDATE notes SET category = ? WHERE category = ?"
319                         self._db.speichereSQL(sql, ("undefined", self._topBox.get_category()))
320                         sql = "DELETE FROM categories WHERE liste = ?"
321                         self._db.speichereSQL(sql, (self._topBox.get_category(), ))
322                         model = self._topBox.categoryCombo.get_model()
323                         pos = self._topBox.categoryCombo.get_active()
324                         if (pos>1):
325                                 self._topBox.categoryCombo.remove_text(pos)
326                                 self._topBox.categoryCombo.set_active(0)
327
328         def _on_sync_finished(self, data = None, data2 = None):
329                 self._topBox.load_categories()
330                 self._notizen.load_notes()
331
332         def _on_sync_notes(self, widget = None, data = None):
333                 self._syncDialog.run()
334                 self._syncDialog.hide()
335
336         def _on_toggle_word_wrap(self, *args):
337                 self._wordWrapEnabled = not self._wordWrapEnabled
338                 self._notizen.set_wordwrap(self._wordWrapEnabled)
339
340         def _on_delete_event(self, widget, event, data = None):
341                 return False
342
343         def _on_destroy(self, widget = None, data = None):
344                 self._db.close()
345                 if self._osso_c:
346                         self._osso_c.close()
347                 gtk.main_quit()
348
349         def _on_show_about(self, widget = None, data = None):
350                 dialog = gtk.AboutDialog()
351                 dialog.set_position(gtk.WIN_POS_CENTER)
352                 dialog.set_name(self.__pretty_app_name__)
353                 dialog.set_version(self.__version__)
354                 dialog.set_copyright("")
355                 dialog.set_website("http://axique.de/index.php?f=Quicknote")
356                 comments = _("%s is a note taking program; it is optimised for quick save and search of notes") % self.__pretty_app_name__
357                 dialog.set_comments(comments)
358                 dialog.run()
359                 dialog.destroy()