Changeset 5293ef0 in confclerk_git for src/sql

Timestamp:

09/25/12 20:31:03 (10 years ago)

Author:

gregor herrmann <gregoa@…>

Branches:

master, qt5

Children:

4403ab4

Parents:

14c46c7

Message:

Remove unsed (and removed from db) 'days' column fro xml parser and all sql parts.

Location:

src/sql

Files:

• schedulexmlparser.cpp (modified) (1 diff)
• sqlengine.cpp (modified) (2 diffs)

src/sql/schedulexmlparser.cpp

@@ -62 +62 @@
             conference["start"] = conferenceElement.firstChildElement("start").text(); // date
             conference["end"] = conferenceElement.firstChildElement("end").text(); // date
-            conference["days"] = conferenceElement.firstChildElement("days").text(); // int
             conference["day_change"] = conferenceElement.firstChildElement("day_change").text(); // time
             conference["timeslot_duration"] = conferenceElement.firstChildElement("timeslot_duration").text(); // time

src/sql/sqlengine.cpp

@@ -131 +131 @@
     if (conferenceId <= 0) // insert conference
     {
-        query.prepare("INSERT INTO CONFERENCE (title,url,subtitle,venue,city,start,end,days,"
+        query.prepare("INSERT INTO CONFERENCE (title,url,subtitle,venue,city,start,end,"
                                                 "day_change,timeslot_duration,active) "
-                        " VALUES (:title,:url,:subtitle,:venue,:city,:start,:end,:days,"
+                        " VALUES (:title,:url,:subtitle,:venue,:city,:start,:end,"
                                                 ":day_change,:timeslot_duration,:active)");
-        foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city" << "days")) {
+        foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city")) {
             query.bindValue(QString(":") + prop_name, aConference[prop_name]);
         }
@@ -148 +148 @@
     else // update conference
     {
-        query.prepare("UPDATE CONFERENCE set title=:title, url=:url, subtitle=:subtitle, venue=:venue, city=:city, start=:start, end=:end, days=:days,"
+        query.prepare("UPDATE CONFERENCE set title=:title, url=:url, subtitle=:subtitle, venue=:venue, city=:city, start=:start, end=:end,"
                                             "day_change=:day_change, timeslot_duration=:timeslot_duration, active=:active "
                       "WHERE id=:id");
-        foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city" << "days")) {
+        foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city")) {
             query.bindValue(QString(":") + prop_name, aConference[prop_name]);
         }