Changeset c129da26 for src/sql

Timestamp:

04/12/10 14:38:00 (12 years ago)

Author:

kirilma <kirilma@…>

Branches:

master, qt5

Children:

cdc7679

Parents:

77e06ae

Message:

fix event insert or update

• add error reporting for queries
• actually run check query
• properly get conference_is from event
• fix checking of non-empty result
• fix insert query

File:

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

src/sql/sqlengine.cpp

@@ -162 +162 @@
             QSqlQuery check_event_query;
             check_event_query.prepare("SELECT * FROM EVENT WHERE xid_conference = :xid_conference AND id = :id");
-            check_event_query.bindValue(":xid_conference", aEvent["xid_conference"]);
+            check_event_query.bindValue(":xid_conference", aEvent["conference_id"]);
             check_event_query.bindValue(":id", aEvent["id"]);
-            if (check_event_query.isActive() and check_event_query.isSelect() and check_event_query.first()) {
+            if (!check_event_query.exec()) {
+                qWarning() << "check event failed, conference id:" << aEvent["xid_conference"]
+                        << "event id:" << aEvent["id"]
+                        << "error:" << check_event_query.lastError()
+                        ;
+                return;
+            }
+            if (check_event_query.isActive() and check_event_query.isSelect() and check_event_query.next()) {
                 event_exists = true;
             }
@@ -187 +194 @@
                             " (xid_conference, id, start, duration, xid_track, type, "
                                 " language, tag, title, subtitle, abstract, description) "
-                            " VALUES (:xid_conference, :id, :start, :duration, :xid_track "
+                            " VALUES (:xid_conference, :id, :start, :duration, :xid_track, :type, "
                                 ":language, :tag, :title, :subtitle, :abstract, :description)");
         }
@@ -199 +206 @@
             result.bindValue(QString(":") + prop_name, aEvent[prop_name]);
         }
-        result.exec();
+        if (!result.exec()) {
+            qWarning() << "event insert/update failed:" << result.lastError();
+        }
     }
 }