| 178 | } |
| 179 | |
| 180 | bool SQLiteDB::load() |
| 181 | { |
| 182 | bool success = false; |
| 183 | |
| 184 | if(db.open()) { |
| 185 | QSqlQuery query; |
| 186 | query.exec("PRAGMA foreign_keys = ON"); |
| 187 | query.exec("PRAGMA synchronous = OFF"); |
| 188 | query.exec("PRAGMA user_version = 1"); |
| 189 | query.exec("PRAGMA journal_mode = MEMORY"); |
| 190 | query.exec("PRAGMA recursive_triggers = true"); |
| 191 | query.exec("PRAGMA vacuum_db.synchronous = OFF"); |
| 192 | |
| 193 | qDebug() << "Database created/registered"; |
| 194 | success = !initialize(); |
| 195 | } else { |
| 196 | const QSqlError error = db.lastError(); |
| 197 | qWarning() << "Error opening connection to the database:" << error.text(); |
| 198 | } |
| 199 | |
| 200 | return success; |
| 201 | } |
| 202 | |
| 203 | bool SQLiteDB::rescan() |
| 204 | { |
no test coverage detected