1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
/*
* Copyright 2007 Glenn Ergeerts <glenn.ergeerts@telenet.be>
* Copyright 2012 Glenn Ergeerts <marco.gulino@gmail.com>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU Library General Public License as
* published by the Free Software Foundation; either version 2, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details
*
* You should have received a copy of the GNU Library General Public
* License along with this program; if not, write to the
* Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
#include "fetchsqlite.h"
#include <QFile>
#include <QDebug>
#include "bookmarksrunner_defs.h"
#include <QSqlQuery>
#include <QSqlError>
#include <QSqlRecord>
FetchSqlite::FetchSqlite(const QString &originalFilePath, const QString ©To, QObject *parent) :
QObject(parent), m_databaseFile(copyTo)
{
m_db = QSqlDatabase::addDatabase(QStringLiteral("QSQLITE"), originalFilePath);
m_db.setHostName(QStringLiteral("localhost"));
QFile originalFile(originalFilePath);
QFile(copyTo).remove();
bool couldCopy = originalFile.copy(copyTo);
if(!couldCopy) {
//qDebug() << "error copying favicon database from " << originalFile.fileName() << " to " << copyTo;
//qDebug() << originalFile.errorString();
}
}
FetchSqlite::~FetchSqlite()
{
if(m_db.isOpen()) m_db.close();
QFile(m_databaseFile).remove();
}
void FetchSqlite::prepare()
{
m_db.setDatabaseName(m_databaseFile);
bool ok = m_db.open();
//qDebug() << "Sqlite Database " << m_databaseFile << " was opened: " << ok;
if(!ok) {
//qDebug() << "Error: " << m_db.lastError().text();
}
}
void FetchSqlite::teardown()
{
m_db.close();
}
QList<QVariantMap> FetchSqlite::query(BuildQuery *buildQuery, QMap<QString, QVariant> bindObjects)
{
return query(buildQuery->query(&m_db), bindObjects);
}
QList<QVariantMap> FetchSqlite::query(const QString &sql, QMap<QString, QVariant> bindObjects)
{
//qDebug() << "query: " << sql;
QSqlQuery query(m_db);
query.prepare(sql);
foreach(const QString &variableName, bindObjects.keys()) {
query.bindValue(variableName, bindObjects.value(variableName));
//qDebug() << "* Bound " << variableName << " to " << query.boundValue(variableName);
}
if(!query.exec()) {
QSqlError error = m_db.lastError();
//qDebug() << "query failed: " << error.text() << " (" << error.type() << ", " << error.number() << ")";
//qDebug() << query.lastQuery();
}
QList<QVariantMap> result;
while(query.next()) {
QVariantMap recordValues;
QSqlRecord record = query.record();
for(int field=0; field<record.count(); field++) {
QVariant value = record.value(field);
recordValues.insert(record.fieldName(field), value );
}
result << recordValues;
}
return result;
}
|
