Changeset 763b877
- Timestamp:
- 08/18/21 21:17:28 (18 months ago)
- Branches:
- master
- Children:
- a59d5c4
- Parents:
- ff579df
- Location:
- src/sql
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
src/sql/schedulexmlparser.cpp
rff579df r763b877 85 85 conference["display_time_shift"] = QString(); 86 86 conference["url"] = url; 87 sqlEngine->addConferenceToDB(conference, conferenceId );87 sqlEngine->addConferenceToDB(conference, conferenceId, conferenceId != 0); 88 88 conferenceId = conference["id"].toInt(); 89 89 conference_title = conference["title"]; … … 193 193 // Re-write conference as utc_offset was not known previously 194 194 if (!conference.value("utc_offset").isEmpty()) { 195 sqlEngine->addConferenceToDB(conference, conferenceId );195 sqlEngine->addConferenceToDB(conference, conferenceId, conferenceId != 0); 196 196 } 197 197 -
src/sql/sqlengine.cpp
rff579df r763b877 145 145 146 146 147 void SqlEngine::addConferenceToDB(QHash<QString,QString> &aConference, int conferenceId ) {147 void SqlEngine::addConferenceToDB(QHash<QString,QString> &aConference, int conferenceId, bool omit_display_time_shift) { 148 148 QSqlQuery query(db); 149 149 bool insert = conferenceId <= 0; … … 154 154 ":day_change,:timeslot_duration,:utc_offset,:display_time_shift,:active)"); 155 155 } else { // update conference 156 query.prepare("UPDATE CONFERENCE set title=:title, url=:url, subtitle=:subtitle, venue=:venue, city=:city, start=:start, end=:end," 157 "day_change=:day_change, timeslot_duration=:timeslot_duration, utc_offset=:utc_offset, display_time_shift=:display_time_shift, active=:active " 158 "WHERE id=:id"); 156 QString update = "UPDATE CONFERENCE set title=:title, url=:url, subtitle=:subtitle, venue=:venue, city=:city, start=:start, end=:end, " 157 "day_change=:day_change, timeslot_duration=:timeslot_duration, utc_offset=:utc_offset"; 158 if (!omit_display_time_shift) update += ", display_time_shift=:display_time_shift"; 159 update += ", active=:active WHERE id=:id"; 160 query.prepare(update); 159 161 } 160 162 foreach (QString prop_name, (QList<QString>() << "title" << "url" << "subtitle" << "venue" << "city")) { … … 169 171 if (!aConference.value("utc_offset").isEmpty()) utc_offset = aConference["utc_offset"].toInt(); 170 172 query.bindValue(":utc_offset", utc_offset); 171 QVariant display_time_shift; 172 if (!aConference.value("display_time_shift").isEmpty()) display_time_shift = aConference["display_time_shift"].toInt(); 173 query.bindValue(":display_time_shift", display_time_shift); 173 if (!omit_display_time_shift) { 174 QVariant display_time_shift; 175 if (!aConference.value("display_time_shift").isEmpty()) display_time_shift = aConference["display_time_shift"].toInt(); 176 query.bindValue(":display_time_shift", display_time_shift); 177 } 174 178 query.bindValue(":active", 1); 175 179 if (!insert) query.bindValue(":id", conferenceId); -
src/sql/sqlengine.h
rff579df r763b877 60 60 bool applySqlFile(const QString sqlFile); 61 61 62 // if a confer neceId != 0 is given, the confernce is updated instead of inserted.63 void addConferenceToDB(QHash<QString,QString> &aConference, int conferenceId );62 // if a conferenceId != 0 is given, the conference is updated instead of inserted. 63 void addConferenceToDB(QHash<QString,QString> &aConference, int conferenceId, bool omit_display_time_shift = false); 64 64 void addEventToDB(QHash<QString,QString> &aEvent); 65 65 void addPersonToDB(QHash<QString,QString> &aPerson);
Note: See TracChangeset
for help on using the changeset viewer.