From ec8035899f5fb92154623eb302b3c698ada11433 Mon Sep 17 00:00:00 2001 From: APTX Date: Sat, 14 Jul 2012 16:44:57 +0200 Subject: [PATCH] Call finish on select queries --- localmylist/database.cpp | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/localmylist/database.cpp b/localmylist/database.cpp index caebdd1..a6317c2 100644 --- a/localmylist/database.cpp +++ b/localmylist/database.cpp @@ -259,7 +259,7 @@ OpenFileData Database::firstUnwatchedByTitle(const QString &title) q.bindValue(":title", title); q.bindValue(":fuzzyTitle", "%" + title + "%"); q.bindValue(":hostId", MyList::instance()->hostId()); - qDebug() << q.lastError().text(); + return readOpenFileData(q); } @@ -998,6 +998,9 @@ QStringList Database::getWatchedDirectories(int hostId) { ret << q.value(0).toString(); } + + q.finish(); + return ret; } @@ -1301,7 +1304,10 @@ OpenFileData Database::readOpenFileData(QSqlQuery &q) return data; if (!q.next()) + { + q.finish(); return data; + } data.fid = q.value(0).toInt(); data.animeTitle = q.value(1).toString(); @@ -1309,10 +1315,11 @@ OpenFileData Database::readOpenFileData(QSqlQuery &q) data.epno = q.value(3).toInt(); data.path = q.value(4).toString(); + q.finish(); + return data; } - QSqlQuery &Database::prepare(const char *const sql) { auto it = d->preparedQueries.find(sql); -- 2.52.0