- Timestamp:
- 07/04/11 23:42:02 (12 years ago)
- Branches:
- master, qt5
- Children:
- 526128c
- Parents:
- 8dd3dd2
- Location:
- src/sql
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
src/sql/schedulexmlparser.cpp
r8dd3dd2 re6ab8a2 104 104 room["event_id"] = eventElement.attribute("id"); 105 105 room["conference_id"] = QString::number(confId,10); 106 room["picture"] = ""; // TODO: implement some mapping to assign correct picture to specified room_name107 106 SqlEngine::addRoomToDB(room); 108 107 -
src/sql/sqlengine.cpp
r8dd3dd2 re6ab8a2 67 67 database.open(); 68 68 } 69 70 checkConferenceMap(database);71 69 72 70 //LOG_INFO(QString("Opening '%1' database '%2'").arg(aDatabaseType).arg(aDatabaseName)); … … 257 255 { 258 256 query = QSqlQuery(db); 259 query.prepare("INSERT INTO ROOM (xid_conference,name,picture) VALUES (:xid_conference, :name, :picture)");257 query.prepare("INSERT INTO ROOM (xid_conference,name,picture) VALUES (:xid_conference, :name, '')"); 260 258 query.bindValue(":xid_conference", aRoom["conference_id"]); 261 259 query.bindValue(":xid_name", aRoom["name"]); 262 query.bindValue(":xid_picture", aRoom["picture"]);263 260 if (!query.exec()) qDebug() << "Could not execute 'insert into room ...' query." << query.lastError(); 264 261 aRoom["id"]= query.lastInsertId().toString(); // 'id' is assigned automatically … … 402 399 return true; 403 400 } 404 405 void SqlEngine::checkConferenceMap(QSqlDatabase &aDatabase)406 {407 QSqlQuery sqlQuery(aDatabase);408 sqlQuery.prepare("SELECT map FROM conference");409 if (!sqlQuery.exec()) {410 qWarning() << "column conference.map is missing; adding";411 execQuery(aDatabase, "ALTER TABLE conference ADD COLUMN map VARCHAR");412 }413 } -
src/sql/sqlengine.h
r8dd3dd2 re6ab8a2 49 49 static bool execQuery(QSqlDatabase &aDatabase, const QString &aQuery); 50 50 static bool execQueryWithParameter(QSqlDatabase &aDatabase, const QString &aQuery, const QHash<QString, QVariant>& params); 51 52 static void checkConferenceMap(QSqlDatabase &aDatabase);53 51 }; 54 52
Note: See TracChangeset
for help on using the changeset viewer.