Changeset 5d9409d for src/sql/sqlengine.cpp

Timestamp:

03/03/10 16:47:00 (13 years ago)

Author:

timkoma <timkoma@…>

Branches:

master, qt5

Children:

5bd6aba

Parents:

7270ae0

Message:

UTC/LocalTime fix for import conference XML, DB queries for multiple conferences fixes

File:

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

src/sql/sqlengine.cpp

@@ -153 +153 @@
             /*qDebug() << QString("DEBUG: Track %1 added to DB").arg(name);*/
         }
-        QDateTime startDateTime = QDateTime(QDate::fromString(aEvent["date"],DATE_FORMAT),QTime::fromString(aEvent["start"],TIME_FORMAT));
+        QDateTime startDateTime;
+        startDateTime.setTimeSpec(Qt::UTC);
+        startDateTime = QDateTime(QDate::fromString(aEvent["date"],DATE_FORMAT),QTime::fromString(aEvent["start"],TIME_FORMAT),Qt::UTC);
+        qDebug() << "startDateTime: " << startDateTime.toString();
         QString values = QString("'%1', '%2', '%3', '%4', '%5', '%6', '%7', ? , ? , ? , ? , ? , '%8', '%9'") \
                          .arg(aEvent["conference_id"]) \
@@ -169 +172 @@
             .arg(values);
 
+        qDebug() << query;
         QSqlQuery result;
         result.prepare(query);
@@ -369 +373 @@
     execQuery( db, query );
 
-    //TODO: retun number of rows from SEARCH_EVENT
     return 1;
 }