Changeset f09a1b9 for src/sql/sqlengine.cpp

Timestamp:

06/23/11 14:13:09 (11 years ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master, qt5

Children:

a0f3e32

Parents:

141a5c2

Message:

Fixed a bug I introduced when reparing the addRoomToDB function.

File:

• src/sql/sqlengine.cpp (modified) (3 diffs)

src/sql/sqlengine.cpp

@@ -154 +154 @@
         startDateTime.setTimeSpec(Qt::UTC);
         startDateTime = QDateTime(QDate::fromString(aEvent["date"],DATE_FORMAT),QTime::fromString(aEvent["start"],TIME_FORMAT),Qt::UTC);
-        qDebug() << "startDateTime: " << startDateTime.toString();
+        // qDebug() << "startDateTime: " << startDateTime.toString();
 
         bool event_exists = false;
@@ -248 +248 @@
         if(query.next()) // ROOM record with 'name' already exists: we need to get its 'id'
         {
-            aRoom["id"] = query.value(0).toInt();
+            aRoom["id"] = query.value(0).toString();
         }
         else // ROOM record doesn't exist yet, need to create it
@@ -258 +258 @@
             query.bindValue(":xid_picture", aRoom["picture"]);
             if (!query.exec()) qDebug() << "Could not execute 'insert into room ...' query." << query.lastError();
-            aRoom["id"] = query.lastInsertId().toInt(); // 'id' is assigned automatically
+            aRoom["id"]= query.lastInsertId().toString(); // 'id' is assigned automatically
             //LOG_AUTOTEST(query);
         }
         query = QSqlQuery(db);
-        query.prepare("INSERT INTO EVENT_ROOM (xid_conference,xid_event,xid_room) VALUES (:conference_id, :event_id, :roomId)");
+        query.prepare("INSERT INTO EVENT_ROOM (xid_conference,xid_event,xid_room) VALUES (:conference_id, :event_id, :room_id)");
         query.bindValue(":conference_id", aRoom["conference_id"]);
         query.bindValue(":event_id", aRoom["event_id"]);
-        query.bindValue(":roomId", aRoom["id"]);
+        query.bindValue(":room_id", aRoom["id"]);
         if (!query.exec()) qDebug() << "Could not 'execute insert into event_room' query:" << query.lastError();
         //LOG_AUTOTEST(query);