[billreminder/billreminder-0.3.3] Make amountDue an optional field in the DB; validating that db upgrade routine works. More to come.

[Og B. Maciel <ogmaciel src gnome org>]

commit 4dfeae8c0acd4215616c2a4a61e3caf5f68dfd0a
Author: Og B. Maciel <ogmaciel src gnome org>
Date:   Thu Sep 25 21:56:17 2008 +0000

    Make amountDue an optional field in the DB; validating that db upgrade routine works. More to come.
    
    svn path=/trunk/; revision=650
---
 ChangeLog            |   26 ++++++++++++++++++++++++++
 src/db/billstable.py |    4 ++--
 src/lib/dal.py       |    5 +++--
 3 files changed, 31 insertions(+), 4 deletions(-)

diff --git a/ChangeLog b/ChangeLog
index 66e8211..602691b 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,29 @@
+=======
+2008-09-25 Og Maciel <ogmaciel gnome org>
+
+	* src/db/billstable.py: Bump version and make amountDue optional.
+	* src/lib/dal.py: Validating that the tables update routine does its job.
+
+2008-09-24 Og Maciel <ogmaciel gnome org>
+
+	* src/gui/widgets/calendarwidget.py: Added mnemonics.
+	* src/gui/widgets/genericlistview.py: Added a filter.
+	* src/gui/widgets/SearchEntry.py: Borrowed code to add smart filtering capabilities.
+	* src/gui/widgets/Makefile.am: Added missing and new files.
+	* src/gui/maindialog.py: Added the new filtering widget.
+	* src/daemon/alarm.py, dbus_manager.py: Added new method call to dbus.
+	* src/lib/actions.py, dbus_actions.py: Fixed new methods to be dbus aware.
+
+2008-09-23 Og Maciel <ogmaciel gnome org>
+
+	* src/gui/widgets/calendarwidget.py: New calendaring widget for the main dialog.
+	* src/gui/widgets/chartwidget.py: New charting widget.
+	* src/gui/widgets/charting.py: Charting library based off the hamster-applet.
+	* src/gui/maindialog.py: Added new calendar and chart widget.
+	* src/lib/actions.py: Added partial support for new method.
+	* src/lib/dbus_actions.py: Added partial support for new method.
+	* po/POTFILES.in: Added calendarwidget.py.
+
 ==== BillReminder 0.3.2 ====
 
 2008-09-10 Og Maciel <ogmaciel gnome org>
diff --git a/src/db/billstable.py b/src/db/billstable.py
index a040d04..8408122 100644
--- a/src/db/billstable.py
+++ b/src/db/billstable.py
@@ -6,7 +6,7 @@ from generictable import GenericTable
 
 class BillsTable(GenericTable):
     """ Table to hold information for all bills created. """
-    Version = 3
+    Version = 4
     Key = "Id"
     KeyAuto = True
     Name = "br_BillsTable"
@@ -16,7 +16,7 @@ class BillsTable(GenericTable):
             catId INTEGER,
             payee TEXT NOT NULL,
             dueDate INTEGER NOT NULL,
-            amountDue INTEGER NOT NULL,
+            amountDue INTEGER,
             notes TEXT,
             paid INTEGER DEFAULT 0,
             alarm INTEGER)
diff --git a/src/lib/dal.py b/src/lib/dal.py
index 0a21063..8ba34fd 100644
--- a/src/lib/dal.py
+++ b/src/lib/dal.py
@@ -83,6 +83,7 @@ class DAL(object):
 
     def _validate_tables(self):
         """ Validates that all tables are up to date. """
+        print "Got here"
         stmt = "select tbl_name from sqlite_master where " \
                "type = 'table' and tbl_name like 'br_%'"
         self.cur.execute(stmt)
@@ -105,14 +106,14 @@ class DAL(object):
             except:
                 ver = -1
             # Table is obsolete and will be deleted
-            if tblname not in self._tables:
+            if tblname not in self._tables.keys():
                 # We should revisit this logic
                 print '%s is an obsolete table and it will be deleted' % \
                        tblname
                 self._delete_table(tblname)
                 continue
             if self._tables[tblname].Version != int(ver) :
-                print '%s is NOT a valid table' % tblname
+                print '%s is outdated and will be updated!' % tblname
                 self._update_table(self._tables[tblname])
                 # Save tables version info
                 self._update_table_version(self._tables[tblname])