Changeset 5293ef0 in confclerk_git for src/sql/sqlengine.cpp


Ignore:
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.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/sql/sqlengine.cpp

    r14c46c7 r5293ef0  
    131131    if (conferenceId <= 0) // insert conference
    132132    {
    133         query.prepare("INSERT INTO CONFERENCE (title,url,subtitle,venue,city,start,end,days,"
     133        query.prepare("INSERT INTO CONFERENCE (title,url,subtitle,venue,city,start,end,"
    134134                                                "day_change,timeslot_duration,active) "
    135                         " VALUES (:title,:url,:subtitle,:venue,:city,:start,:end,:days,"
     135                        " VALUES (:title,:url,:subtitle,:venue,:city,:start,:end,"
    136136                                                ":day_change,:timeslot_duration,:active)");
    137         foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city" << "days")) {
     137        foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city")) {
    138138            query.bindValue(QString(":") + prop_name, aConference[prop_name]);
    139139        }
     
    148148    else // update conference
    149149    {
    150         query.prepare("UPDATE CONFERENCE set title=:title, url=:url, subtitle=:subtitle, venue=:venue, city=:city, start=:start, end=:end, days=:days,"
     150        query.prepare("UPDATE CONFERENCE set title=:title, url=:url, subtitle=:subtitle, venue=:venue, city=:city, start=:start, end=:end,"
    151151                                            "day_change=:day_change, timeslot_duration=:timeslot_duration, active=:active "
    152152                      "WHERE id=:id");
    153         foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city" << "days")) {
     153        foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city")) {
    154154            query.bindValue(QString(":") + prop_name, aConference[prop_name]);
    155155        }
Note: See TracChangeset for help on using the changeset viewer.