Quick fix for ticket: #32: if the schedule XML doesn't contain a city, we put "n...

In the long run we might want to find a system for changing the database scheme; too bad sqlite has only limited ALTER TABLE support.

diff --git a/src/sql/sqlengine.cpp b/src/sql/sqlengine.cpp
index 9ee08ae7fa6865acef827a3bd8d203d5b97606b0..1c1c0cfb0b6cfb4356e8591fe11d47eaff9ed4ba 100644 (file)
--- a/src/sql/sqlengine.cpp
+++ b/src/sql/sqlengine.cpp
@@ -109,6 +109,11 @@ void SqlEngine::addConferenceToDB(QHash<QString,QString> &aConference)
 
         if(!confId) // conference 'aConference' isn't in the table => insert
         {
+            // HACK
+            // When city is empty, assign a dummy value. We probably want to find a way to change the database scheme ...
+            // cf. #32
+            if (aConference["city"] == "") aConference["city"] = "n/a";
+
             QSqlQuery query(db);
             query.prepare("INSERT INTO CONFERENCE (title,url,subtitle,venue,city,start,end,days,"
                                                     "day_change,timeslot_duration,active) "