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
98
99
100
101
102
103
104
105
106
107
108
|
/*
Copyright (C) 2012 Intel Corporation
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2.1 of the License, or (at your option) any later version.
This library 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
Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public
License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*/
#include "db.h"
#include <debugout.h>
#include <QObject>
#include <QSqlError>
#include <QSqlRecord>
#include <QtQml>
extern "C" std::map<std::string, QObject*> create(std::map<std::string, std::string> config, QObject* parent)
{
std::map<std::string, QObject*> moduleInstances;
moduleInstances["database"] = new BluemonkeyDatabaseModule(parent);
return moduleInstances;
}
bool Database::open(QString connectionName, QString filename)
{
db = QSqlDatabase::addDatabase("QSQLITE", connectionName);
db.setDatabaseName(filename);
return db.open();
}
void Database::close()
{
if(db.isOpen())
{
db.close();
}
}
QObject *Database::exec(QString query)
{
return new Query(db.exec(query), this);
}
QString Database::lastError()
{
return db.lastError().text();
}
Query::Query(QSqlQuery q, QObject* parent)
:QObject(parent)
{
query = q;
}
Query::Query(QString connectionName)
{
setConnectionName(connectionName);
}
void Query::setConnectionName(QString connectionName)
{
mConnectionName = connectionName;
db = QSqlDatabase::database(connectionName);
query = QSqlQuery(db);
}
bool Query::exec(QString queryStr)
{
query.setNumericalPrecisionPolicy(QSql::HighPrecision);
return query.exec(queryStr);
}
QVariantList Query::results()
{
QVariantList results;
QSqlRecord r = query.record();
while(query.next())
{
QVariantMap prop;
///iterate on the properties:
for(int i=0; i< r.count(); i++)
{
QString name = r.fieldName(i);
QVariant val = query.value(i);
prop[name] = val;
}
results << prop;
}
return results;
}
|