Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <QtCore/QCoreApplication>
- #include <QtSql>
- QSqlDatabase db;
- QSqlQuery* query;
- bool InitDb()
- {
- db = QSqlDatabase::addDatabase("QSQLITE");
- db.setDatabaseName("qtsqlproblem.db");
- if (!db.open())
- return false;
- query = new QSqlQuery(db);
- if (!query->exec("CREATE TABLE PersonsMultiple ( Name varchar(255) )"))
- return false;
- if (!query->exec("CREATE TABLE PersonsSingle ( Name varchar(255) )"))
- return false;
- return true;
- }
- bool MultipleInserts()
- {
- QString finalInsert;
- for (int i = 0; i < 5; i++)
- finalInsert += QString("INSERT INTO PersonsMultiple VALUES ('Person%0');").arg(QString::number(i));
- return query->exec(finalInsert);
- }
- bool SingleInserts()
- {
- QSqlQuery query(db);
- for (int i = 0; i < 5; i++)
- if (!query.exec(QString("INSERT INTO PersonsSingle VALUES ('Person%0');").arg(QString::number(i))))
- return false;
- return true;
- }
- int main(int argc, char *argv[])
- {
- // QCoreApplication a(argc, argv);
- // return a.exec();
- if (!InitDb())
- qDebug() << "InitDB error:" << query->lastError().text();
- if (!SingleInserts())
- qDebug() << "SingleInserts error:" << query->lastError().text();
- if (!MultipleInserts())
- qDebug() << "MultipleInserts error:" << query->lastError().text();
- return 0;
- }
Add Comment
Please, Sign In to add comment