diff src/util.cpp @ 253:eadffc38ab43

Add support for initial INSERT statements for database creation in schema array.
author Matti Hamalainen <ccr@tnsp.org>
date Tue, 08 May 2018 15:00:41 +0300
parents 4d2b37a0acf2
children 0e0ad52994ca
line wrap: on
line diff
--- a/src/util.cpp	Tue May 08 15:00:17 2018 +0300
+++ b/src/util.cpp	Tue May 08 15:00:41 2018 +0300
@@ -158,6 +158,28 @@
                 return false;
 
             tcreate.finish();
+
+            // If any inserts are specified, do them
+            for (int n = 0; n < SQL_MAX_SCHEMA_INSERTS; n++)
+            {
+                const QString str = table.inserts[n];
+                if (!str.isEmpty())
+                {
+                    QSqlQuery insert(db);
+                    sql =
+                        QStringLiteral("INSERT INTO %1 VALUES(%2)").
+                        arg(table.name).
+                        arg(str);
+
+                    insert.exec(sql);
+
+                    if (!slCheckAndReportSQLError(
+                        sql, insert.lastError(), true))
+                        return false;
+
+                    insert.finish();
+                }
+            }
         }
     }