Adding more filtering options
[multilist] / src / multilist_gtk.py
index 6e32044..4cf649c 100755 (executable)
@@ -1,6 +1,8 @@
 #!/usr/bin/env python
 # -*- coding: utf-8 -*-
 
+from __future__ import with_statement
+
 """
 This file is part of Multilist.
 
@@ -21,22 +23,16 @@ Copyright (C) 2008 Christoph Würstle
 """
 
 import os
-import sys
 import logging
+import ConfigParser
 
 import gtk
 
 try:
        import hildon
-       isHildon=True
+       isHildon = True
 except:
-       isHildon=False
-       class hildon():
-               def __init__(self):
-                       print "PseudoClass hildon"
-               class Program():
-                       def __init__(self):
-                               print "PseudoClass hildon.Program"
+       isHildon = False
 
 try:
        import osso
@@ -45,9 +41,12 @@ except ImportError:
 
 import constants
 import hildonize
+import gtk_toolbox
 
 import libspeichern
-import libsqldialog
+import search
+import sqldialog
+import settings
 import libselection
 import libview
 import libliststorehandler
@@ -82,103 +81,167 @@ class Multilist(hildonize.get_app_class()):
                                raise
 
                self.db = libspeichern.Speichern()
-               self.window_in_fullscreen = False #The window isn't in full screen mode initially.
+               self.__window_in_fullscreen = False #The window isn't in full screen mode initially.
+               self.__isPortrait = False
 
                #Haupt vbox für alle Elemente
                self.window = gtk.Window()
-               self.vbox = gtk.VBox(homogeneous=False, spacing=0)
+               self.__settingsWindow = None
+               self.__settingsManager = None
+               self.vbox = gtk.VBox(homogeneous = False, spacing = 0)
 
                self.selection = libselection.Selection(self.db, isHildon)
+               self._search = search.Search()
                self.liststorehandler = libliststorehandler.Liststorehandler(self.db, self.selection)
                self.view = libview.View(self.db, self.liststorehandler, self.window)
                self.bottombar = libbottombar.Bottombar(self.db, self.view, isHildon)
 
                #Menue
                if hildonize.GTK_MENU_USED:
-                       dateimenu = gtk.Menu()
+                       fileMenu = gtk.Menu()
 
                        menu_items = gtk.MenuItem(_("Choose database file"))
-                       dateimenu.append(menu_items)
-                       menu_items.connect("activate", self.select_db_dialog, None)
+                       menu_items.connect("activate", self._on_select_db, None)
+                       fileMenu.append(menu_items)
 
                        menu_items = gtk.MenuItem(_("SQL history"))
-                       dateimenu.append(menu_items)
-                       menu_items.connect("activate", self.view_sql_history, None)
+                       menu_items.connect("activate", self._on_view_sql_history, None)
+                       fileMenu.append(menu_items)
 
                        menu_items = gtk.MenuItem(_("SQL optimize"))
-                       dateimenu.append(menu_items)
-                       menu_items.connect("activate", self.optimizeSQL, None)
+                       menu_items.connect("activate", self._on_optimize_sql, None)
+                       fileMenu.append(menu_items)
 
                        menu_items = gtk.MenuItem(_("Sync items"))
-                       dateimenu.append(menu_items)
                        menu_items.connect("activate", self.sync_notes, None)
+                       fileMenu.append(menu_items)
 
                        menu_items = gtk.MenuItem(_("Quit"))
-                       dateimenu.append(menu_items)
-                       menu_items.connect("activate", self.destroy, None)
-                       #menu_items.show()
+                       menu_items.connect("activate", self._on_destroy, None)
+                       fileMenu.append(menu_items)
 
-                       datei_menu = gtk.MenuItem(_("File"))
-                       datei_menu.show()
-                       datei_menu.set_submenu(dateimenu)
+                       fileMenuItem = gtk.MenuItem(_("File"))
+                       fileMenuItem.show()
+                       fileMenuItem.set_submenu(fileMenu)
 
-                       toolsmenu = gtk.Menu()
+                       listmenu = gtk.Menu()
 
-                       menu_items = gtk.MenuItem(_("Choose columns"))
-                       toolsmenu.append(menu_items)
-                       menu_items.connect("activate", self.show_columns_dialog, None)
+                       menu_items = gtk.MenuItem(_("Search"))
+                       menu_items.connect("activate", self._on_toggle_search)
+                       listmenu.append(menu_items)
 
-                       menu_items = gtk.MenuItem(_("Rename Category"))
-                       toolsmenu.append(menu_items)
-                       menu_items.connect("activate", self.bottombar.rename_category, None)
+                       menu_items = gtk.MenuItem(_("Checkout All"))
+                       menu_items.connect("activate", self._on_checkout_all)
+                       listmenu.append(menu_items)
 
                        menu_items = gtk.MenuItem(_("Rename List"))
-                       toolsmenu.append(menu_items)
                        menu_items.connect("activate", self.bottombar.rename_list, None)
+                       listmenu.append(menu_items)
+
+                       menu_items = gtk.MenuItem(_("Rename Category"))
+                       menu_items.connect("activate", self.bottombar.rename_category, None)
+                       listmenu.append(menu_items)
+
+                       listMenuItem = gtk.MenuItem(_("List"))
+                       listMenuItem.show()
+                       listMenuItem.set_submenu(listmenu)
+
+                       viewMenu = gtk.Menu()
+
+                       menu_items = gtk.MenuItem(_("Show Active"))
+                       menu_items.connect("activate", self._on_toggle_filter, None)
+                       viewMenu.append(menu_items)
+
+                       menu_items = gtk.MenuItem(_("Settings"))
+                       menu_items.connect("activate", self._on_settings, None)
+                       viewMenu.append(menu_items)
 
-                       tools_menu = gtk.MenuItem(_("Tools"))
-                       tools_menu.show()
-                       tools_menu.set_submenu(toolsmenu)
+                       viewMenuItem = gtk.MenuItem(_("View"))
+                       viewMenuItem.show()
+                       viewMenuItem.set_submenu(viewMenu)
 
-                       hilfemenu = gtk.Menu()
+                       helpMenu = gtk.Menu()
                        menu_items = gtk.MenuItem(_("About"))
-                       hilfemenu.append(menu_items)
-                       menu_items.connect("activate", self.show_about, None)
-
-                       hilfe_menu = gtk.MenuItem(_("Help"))
-                       hilfe_menu.show()
-                       hilfe_menu.set_submenu(hilfemenu)
-
-                       menu_bar = gtk.MenuBar()
-                       menu_bar.show()
-                       menu_bar.append (datei_menu)
-                       menu_bar.append (tools_menu)
-                       # unten -> damit als letztes menu_bar.append (hilfe_menu)
+                       helpMenu.append(menu_items)
+                       menu_items.connect("activate", self._on_about, None)
+
+                       helpMenuItem = gtk.MenuItem(_("Help"))
+                       helpMenuItem.show()
+                       helpMenuItem.set_submenu(helpMenu)
+
+                       menuBar = gtk.MenuBar()
+                       menuBar.show()
+                       menuBar.append (fileMenuItem)
+                       menuBar.append (listMenuItem)
+                       menuBar.append (viewMenuItem)
+                       # unten -> damit als letztes menuBar.append (helpMenuItem)
                        #Als letztes menü
-                       menu_bar.append (hilfe_menu)
+                       menuBar.append (helpMenuItem)
 
-                       self.vbox.pack_start(menu_bar, False, False, 0)
+                       self.vbox.pack_start(menuBar, False, False, 0)
                else:
                        menuBar = gtk.MenuBar()
                        menuBar.show()
                        self.vbox.pack_start(menuBar, False, False, 0)
 
                #add to vbox below (to get it on top)
-               self.vbox.pack_end(self.bottombar, expand=False, fill=True, padding=0)
-               self.vbox.pack_end(self.view, expand=True, fill=True, padding=0)
-               self.vbox.pack_end(self.selection, expand=False, fill=True, padding=0)
+               self.vbox.pack_end(self._search, expand = False, fill = True)
+               self.vbox.pack_end(self.bottombar, expand = False, fill = True, padding = 0)
+               self.vbox.pack_end(self.view, expand = True, fill = True, padding = 0)
+               self.vbox.pack_end(self.selection, expand = False, fill = True, padding = 0)
 
                #Get the Main Window, and connect the "destroy" event
                self.window.add(self.vbox)
 
                self.window = hildonize.hildonize_window(self, self.window)
                hildonize.set_application_title(self.window, "%s" % constants.__pretty_app_name__)
-               menu_bar = hildonize.hildonize_menu(
+               menuBar = hildonize.hildonize_menu(
                        self.window,
-                       menu_bar,
+                       menuBar,
                )
                if hildonize.IS_FREMANTLE_SUPPORTED:
-                       pass
+                       button = hildonize.hildon.GtkRadioButton(gtk.HILDON_SIZE_AUTO, None)
+                       button.set_label("All")
+                       menuBar.add_filter(button)
+                       button.connect("clicked", self._on_click_menu_filter, self.liststorehandler.SHOW_ALL)
+                       button.set_mode(False)
+                       filterGroup = button
+
+                       button = hildonize.hildon.GtkRadioButton(gtk.HILDON_SIZE_AUTO, filterGroup)
+                       button.set_label("New")
+                       menuBar.add_filter(button)
+                       button.connect("clicked", self._on_click_menu_filter, self.liststorehandler.SHOW_NEW)
+                       button.set_mode(False)
+
+                       button = hildonize.hildon.GtkRadioButton(gtk.HILDON_SIZE_AUTO, filterGroup)
+                       button.set_label("Active")
+                       menuBar.add_filter(button)
+                       button.connect("clicked", self._on_click_menu_filter, self.liststorehandler.SHOW_ACTIVE)
+                       button.set_mode(False)
+
+                       button = hildonize.hildon.GtkRadioButton(gtk.HILDON_SIZE_AUTO, filterGroup)
+                       button.set_label("Done")
+                       menuBar.add_filter(button)
+                       button.connect("clicked", self._on_click_menu_filter, self.liststorehandler.SHOW_COMPLETE)
+                       button.set_mode(False)
+
+                       renameListButton= gtk.Button(_("Rename List"))
+                       renameListButton.connect("clicked", self.bottombar.rename_list)
+                       menuBar.append(renameListButton)
+
+                       renameCategoryButton = gtk.Button(_("Rename Category"))
+                       renameCategoryButton.connect("clicked", self.bottombar.rename_category)
+                       menuBar.append(renameCategoryButton)
+
+                       searchButton= gtk.Button(_("Search Category"))
+                       searchButton.connect("clicked", self._on_toggle_search)
+                       menuBar.append(searchButton)
+
+                       searchButton= gtk.Button(_("Settings"))
+                       searchButton.connect("clicked", self._on_settings)
+                       menuBar.append(searchButton)
+
+                       menuBar.show_all()
 
                if not hildonize.IS_HILDON_SUPPORTED:
                        _moduleLogger.info("No hildonization support")
@@ -193,15 +256,115 @@ class Multilist(hildonize.get_app_class()):
                        _moduleLogger.info("No osso support")
                        self._osso_c = None
 
-               self.window.connect("delete_event", self.delete_event)
-               self.window.connect("destroy", self.destroy)
+               self.window.connect("delete_event", self._on_delete_event)
+               self.window.connect("destroy", self._on_destroy)
                self.window.connect("key-press-event", self.on_key_press)
-               self.window.connect("window-state-event", self.on_window_state_change)
+               self.window.connect("window-state-event", self._on_window_state_change)
+               self._search.connect("search_changed", self._on_search)
 
                self.window.show_all()
-               self.prepare_sync_dialog()
-               self.ladeAlles()
+               self._search.hide()
+               self._load_settings()
+               self._prepare_sync_dialog()
+
+       def _save_settings(self):
+               config = ConfigParser.SafeConfigParser()
+               self.save_settings(config)
+               with open(self._user_settings, "wb") as configFile:
+                       config.write(configFile)
+
+       def save_settings(self, config):
+               config.add_section(constants.__pretty_app_name__)
+               config.set(constants.__pretty_app_name__, "portrait", str(self.__isPortrait))
+               config.set(constants.__pretty_app_name__, "fullscreen", str(self.__window_in_fullscreen))
+
+       def _load_settings(self):
+               config = ConfigParser.SafeConfigParser()
+               config.read(self._user_settings)
+               self.load_settings(config)
+
+       def load_settings(self, config):
+               isPortrait = False
+               window_in_fullscreen = False
+               try:
+                       isPortrait = config.getboolean(constants.__pretty_app_name__, "portrait")
+                       window_in_fullscreen = config.getboolean(constants.__pretty_app_name__, "fullscreen")
+               except ConfigParser.NoSectionError, e:
+                       _moduleLogger.info(
+                               "Settings file %s is missing section %s" % (
+                                       self._user_settings,
+                                       e.section,
+                               )
+                       )
+
+               if isPortrait ^ self.__isPortrait:
+                       if isPortrait:
+                               orientation = gtk.ORIENTATION_VERTICAL
+                       else:
+                               orientation = gtk.ORIENTATION_HORIZONTAL
+                       self.set_orientation(orientation)
 
+               self.__window_in_fullscreen = window_in_fullscreen
+               if self.__window_in_fullscreen:
+                       self.window.fullscreen()
+               else:
+                       self.window.unfullscreen()
+
+       def _toggle_search(self):
+               if self._search.get_property("visible"):
+                       self._search.hide()
+               else:
+                       self._search.show()
+
+       def set_orientation(self, orientation):
+               if orientation == gtk.ORIENTATION_VERTICAL:
+                       hildonize.window_to_portrait(self.window)
+                       self.bottombar.set_orientation(gtk.ORIENTATION_VERTICAL)
+                       self.selection.set_orientation(gtk.ORIENTATION_VERTICAL)
+                       self.__isPortrait = True
+               elif orientation == gtk.ORIENTATION_HORIZONTAL:
+                       hildonize.window_to_landscape(self.window)
+                       self.bottombar.set_orientation(gtk.ORIENTATION_HORIZONTAL)
+                       self.selection.set_orientation(gtk.ORIENTATION_HORIZONTAL)
+                       self.__isPortrait = False
+               else:
+                       raise NotImplementedError(orientation)
+
+       def get_orientation(self):
+               return gtk.ORIENTATION_VERTICAL if self.__isPortrait else gtk.ORIENTATION_HORIZONTAL
+
+       def _toggle_rotate(self):
+               if self.__isPortrait:
+                       self.set_orientation(gtk.ORIENTATION_HORIZONTAL)
+               else:
+                       self.set_orientation(gtk.ORIENTATION_VERTICAL)
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_checkout_all(self, widget):
+               self.liststorehandler.checkout_rows()
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_search(self, widget):
+               self.liststorehandler.get_liststore(self._search.get_search_pattern())
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_click_menu_filter(self, button, val):
+               self.liststorehandler.set_filter(val)
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_toggle_search(self, *args):
+               self._toggle_search()
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_toggle_filter(self, *args):
+               if self.liststorehandler.get_filter() == self.liststorehandler.SHOW_ALL:
+                       self.liststorehandler.set_filter(self.liststorehandler.SHOW_ACTIVE)
+               elif self.liststorehandler.get_filter() == self.liststorehandler.SHOW_ACTIVE:
+                       self.liststorehandler.set_filter(self.liststorehandler.SHOW_ALL)
+               else:
+                       assert False, "Unknown"
+
+       @gtk_toolbox.log_exception(_moduleLogger)
        def on_key_press(self, widget, event, *args):
                RETURN_TYPES = (gtk.keysyms.Return, gtk.keysyms.ISO_Enter, gtk.keysyms.KP_Enter)
                isCtrl = bool(event.get_state() & gtk.gdk.CONTROL_MASK)
@@ -210,19 +373,22 @@ class Multilist(hildonize.get_app_class()):
                        event.keyval in RETURN_TYPES and isCtrl
                ):
                        # The "Full screen" hardware key has been pressed 
-                       if self.window_in_fullscreen:
+                       if self.__window_in_fullscreen:
                                self.window.unfullscreen ()
                        else:
                                self.window.fullscreen ()
                        return True
-               #elif event.keyval == gtk.keysyms.f and isCtrl:
-               #       self._toggle_search()
-               #       return True
+               elif event.keyval == gtk.keysyms.r and isCtrl:
+                       self._toggle_rotate()
+                       return True
+               elif event.keyval == gtk.keysyms.f and isCtrl:
+                       self._toggle_search()
+                       return True
                elif (
                        event.keyval in (gtk.keysyms.w, gtk.keysyms.q) and
                        event.get_state() & gtk.gdk.CONTROL_MASK
                ):
-                       self._window.destroy()
+                       self.window.destroy()
                elif event.keyval == gtk.keysyms.l and event.get_state() & gtk.gdk.CONTROL_MASK:
                        with open(constants._user_logpath_, "r") as f:
                                logLines = f.xreadlines()
@@ -230,73 +396,80 @@ class Multilist(hildonize.get_app_class()):
                                self._clipboard.set_text(str(log))
                        return True
 
-       def on_window_state_change(self, widget, event, *args):
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_window_state_change(self, widget, event, *args):
                if event.new_window_state & gtk.gdk.WINDOW_STATE_FULLSCREEN:
-                       self.window_in_fullscreen = True
+                       self.__window_in_fullscreen = True
                else:
-                       self.window_in_fullscreen = False
-
-       def speichereAlles(self,data=None,data2=None):
-               logging.info("Speichere alles")
-
-       def ladeAlles(self,data=None,data2=None):
-               logging.info("Lade alles")
+                       self.__window_in_fullscreen = False
 
-       def beforeSync(self,data=None,data2=None):
-               logging.info("Lade alles")
-
-       def sync_finished(self,data=None,data2=None):
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_sync_finished(self, data = None, data2 = None):
                self.selection.comboList_changed()
                self.selection.comboCategory_changed()
                self.liststorehandler.update_list()
 
-       def prepare_sync_dialog(self):
-               self.sync_dialog = gtk.Dialog(_("Sync"),None,gtk.DIALOG_MODAL | gtk.DIALOG_DESTROY_WITH_PARENT,(gtk.STOCK_OK, gtk.RESPONSE_ACCEPT))
+       def _prepare_sync_dialog(self):
+               self.sync_dialog = gtk.Dialog(_("Sync"), None, gtk.DIALOG_MODAL | gtk.DIALOG_DESTROY_WITH_PARENT, (gtk.STOCK_OK, gtk.RESPONSE_ACCEPT))
 
                self.sync_dialog.set_position(gtk.WIN_POS_CENTER)
-               sync=libsync.Sync(self.db,self.window,50503)
-               sync.connect("syncFinished",self.sync_finished)
+               sync = libsync.Sync(self.db, self.window, 50503)
+               sync.connect("syncFinished", self._on_sync_finished)
                self.sync_dialog.vbox.pack_start(sync, True, True, 0)
-               self.sync_dialog.set_size_request(500,350)
+               self.sync_dialog.set_size_request(500, 350)
                self.sync_dialog.vbox.show_all()
-               sync.connect("syncFinished",self.sync_finished)
 
-       def sync_notes(self,widget=None,data=None):
-               if self.sync_dialog==None:
-                       self.prepare_sync_dialog()
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def sync_notes(self, widget = None, data = None):
+               if self.sync_dialog is None:
+                       self._prepare_sync_dialog()
                self.sync_dialog.run()
                self.sync_dialog.hide()
 
-       def show_columns_dialog(self,widget=None,data=None):
-               col_dialog = gtk.Dialog(_("Choose columns"),self.window,gtk.DIALOG_MODAL | gtk.DIALOG_DESTROY_WITH_PARENT, (gtk.STOCK_CANCEL, gtk.RESPONSE_REJECT, gtk.STOCK_OK, gtk.RESPONSE_ACCEPT))
-
-               col_dialog.set_position(gtk.WIN_POS_CENTER)
-               cols=libview.Columns_dialog(self.db,self.liststorehandler)
-
-               col_dialog.vbox.pack_start(cols, True, True, 0)
-               col_dialog.set_size_request(500,350)
-               col_dialog.vbox.show_all()
-
-               resp=col_dialog.run()
-               col_dialog.hide()
-               if resp==gtk.RESPONSE_ACCEPT:
-                       logging.info("changing columns")
-                       cols.save_column_setting()
-                       self.view.reload_view()
-                       #children=self.vbox.get_children()
-                       #while len(children)>1:
-                       #       self.vbox.remove(children[1])
-
-                       #self.vbox.pack_end(self.bottombar, expand=True, fill=True, padding=0)
-                       #self.vbox.pack_end(view, expand=True, fill=True, padding=0)
-                       #self.vbox.pack_end(self.selection, expand=False, fill=True, padding=0)
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_settings(self, *args):
+               if self.__settingsWindow is None:
+                       vbox = gtk.VBox()
+                       self.__settingsManager = settings.SettingsDialog(vbox, self.db, self.liststorehandler)
+
+                       self.__settingsWindow = gtk.Window()
+                       self.__settingsWindow.add(vbox)
+                       self.__settingsWindow = hildonize.hildonize_window(self, self.__settingsWindow)
+
+                       self.__settingsWindow.set_title(_("Settings"))
+                       self.__settingsWindow.set_transient_for(self.window)
+                       self.__settingsWindow.set_default_size(*self.window.get_size())
+                       self.__settingsWindow.connect("delete-event", self._on_settings_delete)
+               self.__settingsManager.set_portrait_state(self.__isPortrait)
+               self.__settingsWindow.set_modal(True)
+               self.__settingsWindow.show_all()
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_settings_delete(self, *args):
+               self.__settingsWindow.emit_stop_by_name("delete-event")
+               self.__settingsWindow.hide()
+               self.__settingsWindow.set_modal(False)
+
+               logging.info("changing columns")
+               self.__settingsManager.save(self.db)
+               self.view.reload_view()
+
+               isPortrait = self.__settingsManager.is_portrait()
+               if isPortrait ^ self.__isPortrait:
+                       if isPortrait:
+                               orientation = gtk.ORIENTATION_VERTICAL
+                       else:
+                               orientation = gtk.ORIENTATION_HORIZONTAL
+                       self.set_orientation(orientation)
 
-               col_dialog.destroy()
+               return True
 
-       def destroy(self, widget=None, data=None):
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_destroy(self, widget = None, data = None):
                try:
-                       self.speichereAlles()
                        self.db.close()
+                       self._save_settings()
+
                        try:
                                self._osso_c.close()
                        except AttributeError:
@@ -304,34 +477,19 @@ class Multilist(hildonize.get_app_class()):
                finally:
                        gtk.main_quit()
 
-       def delete_event(self, widget, event, data=None):
-               #print "delete event occurred"
-               return False
-
-       def dlg_delete(self,widget,event,data=None):
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_delete_event(self, widget, event, data = None):
                return False
 
-       def show_about(self, widget=None,data=None):
-               dialog = gtk.AboutDialog()
-               dialog.set_position(gtk.WIN_POS_CENTER)
-               dialog.set_name(constants.__pretty_app_name__)
-               dialog.set_version(constants.__version__)
-               dialog.set_copyright("")
-               dialog.set_website("http://axique.de/f=Multilist")
-               comments = "%s is a program to handle multiple lists." % constants.__pretty_app_name__
-               dialog.set_comments(comments)
-               dialog.set_authors(["Christoph Wurstle <n800@axique.net>", "Ed Page <eopage@byu.net> (Blame him for the most recent bugs)"])
-               dialog.run()
-               dialog.destroy()
-
-       def on_info1_activate(self,menuitem):
-               self.show_about(menuitem)
-
-       def view_sql_history(self,widget=None,data=None,data2=None):
-               sqldiag=libsqldialog.sqlDialog(self.db)
-               res=sqldiag.run()
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_view_sql_history(self, widget = None, data = None, data2 = None):
+               sqldiag = sqldialog.SqlDialog(self.db)
+               res = sqldiag.run()
                sqldiag.hide()
-               if res==444:
+
+               try:
+                       if res != gtk.RESPONSE_OK:
+                               return
                        logging.info("exporting sql")
 
                        if not isHildon:
@@ -342,42 +500,53 @@ class Multilist(hildonize.get_app_class()):
                                dlg.add_button( gtk.STOCK_CANCEL, gtk.RESPONSE_CANCEL)
                                dlg.add_button( gtk.STOCK_OK, gtk.RESPONSE_OK)
                        else:
-                               #dlg = hildon.FileChooserDialog(parent = self.window, action = gtk.FILE_CHOOSER_ACTION_SAVE)
-                               dlg=hildon.FileChooserDialog(self.window, gtk.FILE_CHOOSER_ACTION_SAVE)
+                               dlg = hildon.FileChooserDialog(self.window, gtk.FILE_CHOOSER_ACTION_SAVE)
 
                        dlg.set_title(_("Select SQL export file"))
-                       if dlg.run() == gtk.RESPONSE_OK:
-                               fileName = dlg.get_filename()
-                               dlg.destroy()
-                               sqldiag.exportSQL(fileName)
-                       else:
+                       exportFileResponse = dlg.run()
+                       try:
+                               if exportFileResponse == gtk.RESPONSE_OK:
+                                       fileName = dlg.get_filename()
+                                       sqldiag.exportSQL(fileName)
+                       finally:
                                dlg.destroy()
+               finally:
+                       sqldiag.destroy()
 
-               sqldiag.destroy()
-
-       def optimizeSQL(self,widget=None,data=None,data2=None):
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_optimize_sql(self, widget = None, data = None, data2 = None):
                #optimiere sql
-               self.db.speichereSQL("VACUUM",log=False)
+               self.db.speichereSQL("VACUUM", log = False)
 
-       def select_db_dialog(self,widget=None,data=None,data2=None):
-               if (isHildon==False):
-                       dlg = gtk.FileChooserDialog(parent = self.window, action = gtk.FILE_CHOOSER_ACTION_SAVE)
-                       dlg.add_button( gtk.STOCK_CANCEL, gtk.RESPONSE_CANCEL)
-                       dlg.add_button( gtk.STOCK_OK, gtk.RESPONSE_OK)
-               else:
-                       #dlg = hildon.FileChooserDialog(parent = self.window, action = gtk.FILE_CHOOSER_ACTION_SAVE)
-                       dlg=hildon.FileChooserDialog(self.window, gtk.FILE_CHOOSER_ACTION_SAVE)
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_select_db(self, widget = None, data = None, data2 = None):
+               dlg = hildon.FileChooserDialog(parent=self._window, action=gtk.FILE_CHOOSER_ACTION_SAVE)
 
                if self.db.ladeDirekt('datenbank'):
                        dlg.set_filename(self.db.ladeDirekt('datenbank'))
                dlg.set_title(_("Choose your database file"))
-               if dlg.run() == gtk.RESPONSE_OK:
-                       fileName = dlg.get_filename()
-                       self.db.speichereDirekt('datenbank',fileName)
-                       self.speichereAlles()
-                       self.db.openDB()
-                       self.ladeAlles()
-               dlg.destroy()
+               resp = dlg.run()
+               try:
+                       if resp == gtk.RESPONSE_OK:
+                               fileName = dlg.get_filename()
+                               self.db.speichereDirekt('datenbank', fileName)
+                               self.db.openDB()
+               finally:
+                       dlg.destroy()
+
+       @gtk_toolbox.log_exception(_moduleLogger)
+       def _on_about(self, widget = None, data = None):
+               dialog = gtk.AboutDialog()
+               dialog.set_position(gtk.WIN_POS_CENTER)
+               dialog.set_name(constants.__pretty_app_name__)
+               dialog.set_version(constants.__version__)
+               dialog.set_copyright("")
+               dialog.set_website("http://axique.de/f = Multilist")
+               comments = "%s is a program to handle multiple lists." % constants.__pretty_app_name__
+               dialog.set_comments(comments)
+               dialog.set_authors(["Christoph Wurstle <n800@axique.net>", "Ed Page <eopage@byu.net> (Blame him for the most recent bugs)"])
+               dialog.run()
+               dialog.destroy()
 
 
 def run_multilist():
@@ -389,5 +558,5 @@ def run_multilist():
 
 
 if __name__ == "__main__":
-       logging.basicConfig(level=logging.DEBUG)
+       logging.basicConfig(level = logging.DEBUG)
        run_multilist()