Changeset View
Changeset View
Standalone View
Standalone View
runners/bookmarks/fetchsqlite.cpp
Show First 20 Lines • Show All 91 Lines • ▼ Show 20 Line(s) | |||||
92 | { | 92 | { | ||
93 | QMutexLocker lock(&m_mutex); | 93 | QMutexLocker lock(&m_mutex); | ||
94 | 94 | | |||
95 | auto db = openDbConnection(m_databaseFile); | 95 | auto db = openDbConnection(m_databaseFile); | ||
96 | 96 | | |||
97 | //qDebug() << "query: " << sql; | 97 | //qDebug() << "query: " << sql; | ||
98 | QSqlQuery query(db); | 98 | QSqlQuery query(db); | ||
99 | query.prepare(sql); | 99 | query.prepare(sql); | ||
100 | foreach(const QString &variableName, bindObjects.keys()) { | 100 | const auto keys = bindObjects.keys(); | ||
101 | for (const QString &variableName : keys) { | ||||
101 | query.bindValue(variableName, bindObjects.value(variableName)); | 102 | query.bindValue(variableName, bindObjects.value(variableName)); | ||
102 | //qDebug() << "* Bound " << variableName << " to " << query.boundValue(variableName); | 103 | //qDebug() << "* Bound " << variableName << " to " << query.boundValue(variableName); | ||
103 | } | 104 | } | ||
104 | 105 | | |||
105 | if(!query.exec()) { | 106 | if(!query.exec()) { | ||
106 | QSqlError error = db.lastError(); | 107 | QSqlError error = db.lastError(); | ||
107 | //qDebug() << "query failed: " << error.text() << " (" << error.type() << ", " << error.number() << ")"; | 108 | //qDebug() << "query failed: " << error.text() << " (" << error.type() << ", " << error.number() << ")"; | ||
108 | //qDebug() << query.lastQuery(); | 109 | //qDebug() << query.lastQuery(); | ||
Show All 23 Lines |