UI functionality added to main view

[biaweb_qt.git] / main_window.py

diff --git a/main_window.py b/main_window.py
index 3632075..b6cb96d 100644 (file)
--- a/main_window.py
+++ b/main_window.py
@@ -4,6 +4,7 @@
 import PyQt4
 import ui_main_window
 import site_configuration_dialog as scd
+import category_dialog as catd
 import biaweb_db
 import sys
 
@@ -13,8 +14,66 @@ class MainWindow (PyQt4.QtGui.QMainWindow, ui_main_window.Ui_MainWindow):
                self.setupUi (self)
                self.current_db = None
 
+       # refresh the category list
+       def repopulate_categories (self):
+               recs = biaweb_db.get_categories (self.current_db)
+               if recs == False:
+                       PyQt4.QtGui.QMessageBox.critical (self, "Error", "SQLite 3 error in getting the categories")
+                       return
+
+               self.categories.clear ()
+               for (id, name, desc, stub) in recs:
+                       qrow = PyQt4.QtGui.QTreeWidgetItem ([str(id), str(name)])
+                       self.categories.addTopLevelItem (qrow)
+
+       # refresh the articles list
+       def repopulate_articles (self, catid=None):
+               recs = biaweb_db.get_articles (self.current_db, catid)
+               if recs == False:
+                       PyQt4.QtGui.QMessageBox.critical (self, "Error", "SQLite 3 error in getting the articles")
+                       return
+
+               self.articles.clear ()
+               for item in recs:
+                       qrow = PyQt4.QtGui.QTreeWidgetItem ([str(item[0]), str(item[1])])
+                       self.articles.addTopLevelItem (qrow)
+
+       # category add action
+       def onCategoryAdd (self):
+               # if there is no database
+               if self.current_db == None:
+                       PyQt4.QtGui.QMessageBox.critical (self, "Error",
+                                                       "Cannot add category. You need to create or open a website first.")
+               else:
+                       # show the category add dialog
+                       dlg = catd.CategoryDialog (self)
+                       # if OK button is pressed
+                       if dlg.exec_ () == PyQt4.QtGui.QDialog.Accepted:
+                               cat_name = str (dlg.category_name.text ()).strip ()
+                               cat_desc = str (dlg.category_desc.text ()).strip ()
+                               cat_stub = str (dlg.category_stub.text ()).strip ()
+                               ret = biaweb_db.create_category (self.current_db, cat_name, cat_desc, cat_stub)
+                               if ret == True:
+                                       PyQt4.QtGui.QMessageBox.information (self, "Success", "Category successfully created")
+                                       self.repopulate_categories ()
+                                       self.repopulate_articles ()
+                               else:
+                                       PyQt4.QtGui.QMessageBox.critical (self, "Error", "SQLite 3 error in creating category")
+
+       # file open menu is clicked
+       def onFileOpen (self):
+               filename = PyQt4.QtGui.QFileDialog.getOpenFileName (self, "Open Site Database")
+               if filename:
+                       self.current_db = str (filename)
+                       self.setWindowTitle ("BiaWeb - " + self.current_db)
+                       self.repopulate_categories ()
+                       self.repopulate_articles ()
+
+       # file new menu is clicked
        def onFileNew (self):
+               # show the site configuration dialog to get the new site details
                dlg = scd.SiteConfigDialog (self)
+               # if OK button is pressed
                if dlg.exec_ () == PyQt4.QtGui.QDialog.Accepted:
                        site_title = str (dlg.site_title.text ()).strip ()
                        site_url = str (dlg.site_url.text ()).strip ()
@@ -27,15 +86,18 @@ class MainWindow (PyQt4.QtGui.QMainWindow, ui_main_window.Ui_MainWindow):
                        savefilename = PyQt4.QtGui.QFileDialog.getSaveFileName (self, "Save site database to")
 
                        if savefilename:
-                               self.current_db = savefilename
+                               self.current_db = str (savefilename)
                                self.setWindowTitle ("BiaWeb - " + self.current_db)
-                               flag = biaweb_db.create_db (str (savefilename), site_title, site_url, keywords, description,
+                               flag = biaweb_db.create_db (self.current_db, site_title, site_url, keywords, description,
                                                                copyright, num_rss, destination)
                                if flag == True:
                                        PyQt4.QtGui.QMessageBox.information (self, "Success",
                                                                                                                        "New site db successfully created")
+                                       self.articles.clear ()
+                                       self.categories.clear ()
                                else:
-                                       PyQt4.QtGui.QMessageBox.critical (self, "Error", "SQLite 3 error in creating database.")
+                                       PyQt4.QtGui.QMessageBox.critical (self, "Error", "System or SQLite 3 error in creating database")
 
+       # file quit is clicked
        def onFileQuit (self):
                sys.exit (0)