Changeset 4b8ce66 in confclerk_git for src/sql

Timestamp:

06/22/11 23:33:29 (12 years ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master, qt5

Children:

06eef78

Parents:

c8b84e1

Message:

The database is now created from the program. We don't need to copy or provide fosdem.sqlite anymore.

File:

• src/sql/sqlengine.cpp (modified) (1 diff)

src/sql/sqlengine.cpp

@@ -51 +51 @@
     if(!QFile::exists(aDatabaseName)) // the DB (tables) doesn't exists, and so we have to create one
     {
-        // copy conference Db from resource, instead of creating
-        // empty tables and then parsing the schedule
-        QFile dbFile(aDatabaseName);
-        QFile(":/fosdem.sqlite").copy(aDatabaseName);
-        dbFile.setPermissions(QFile::ReadOwner | QFile::WriteOwner | QFile::ReadGroup | QFile::WriteGroup);
-        database.open();
+        // create Db
+        if (!database.open()) qDebug() << "Could not open database" << database.lastError();
+        QFile file(":/create_tables.sql");
+        file.open(QIODevice::ReadOnly | QIODevice::Text);
+        QString allSqlStatements = file.readAll();
+        foreach(QString sql, allSqlStatements.split(";")) {
+            QSqlQuery query(database);
+            if (!query.exec(sql)) qDebug() << "Could not execute query" << query.lastError();
+        }
     }
     else