Mercurial > hg > syntilista
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(); + } + } } }