Changeset 1bad318

Timestamp:

04/09/10 14:02:26 (13 years ago)

Author:

kirilma <kirilma@…>

Branches:

master, qt5

Children:

f548c17

Parents:

5bd6aba

Message:

use transactions to make import faster

Location:

src/sql

Files:

• schedulexmlparser.cpp (modified) (2 diffs)
• sqlengine.cpp (modified) (1 diff)
• sqlengine.h (modified) (1 diff)

src/sql/schedulexmlparser.cpp

@@ -37 +37 @@
 
     QDomElement scheduleElement = document.firstChildElement("schedule");
+
+    SqlEngine::beginTransaction();
 
     int confId = 0;
@@ -145 +147 @@
         } // parsing day elements
     } // schedule element
+    SqlEngine::commitTransaction();
 
     return confId;

src/sql/sqlengine.cpp

@@ -376 +376 @@
 }
 
+bool SqlEngine::beginTransaction()
+{
+    QSqlDatabase db = QSqlDatabase::database();
+
+    return execQuery(db, "BEGIN IMMEDIATE TRANSACTION");
+}
+
+bool SqlEngine::commitTransaction()
+{
+    QSqlDatabase db = QSqlDatabase::database();
+
+    return execQuery(db, "COMMIT");
+}
+
 bool SqlEngine::execQuery(QSqlDatabase &aDatabase, const QString &aQuery)
 {

src/sql/sqlengine.h

@@ -38 +38 @@
         static void addRoomToDB(QHash<QString,QString> &aRoom);
 
+        static bool beginTransaction();
+        static bool commitTransaction();
+
         // search Events for ....
         static int searchEvent(int conferenceId, const QHash<QString,QString> &columns, const QString &keyword);