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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
/****************************************************************************
**
** Copyright (C) 2015 Pelagicore AG
** Contact: http://www.qt.io/ or http://www.pelagicore.com/
**
** This file is part of the Neptune IVI UI.
**
** $QT_BEGIN_LICENSE:GPL3-PELAGICORE$
** Commercial License Usage
** Licensees holding valid commercial Pelagicore Neptune IVI UI
** licenses may use this file in accordance with the commercial license
** agreement provided with the Software or, alternatively, in accordance
** with the terms contained in a written agreement between you and
** Pelagicore. For licensing terms and conditions, contact us at:
** http://www.pelagicore.com.
**
** GNU General Public License Usage
** Alternatively, this file may be used under the terms of the GNU
** General Public License version 3 as published by the Free Software
** Foundation and appearing in the file LICENSE.GPLv3 included in the
** packaging of this file. Please review the following information to
** ensure the GNU General Public License version 3 requirements will be
** met: http://www.gnu.org/licenses/gpl-3.0.html.
**
** $QT_END_LICENSE$
**
** SPDX-License-Identifier: GPL-3.0
**
****************************************************************************/
#include "sqlquerydatasource.h"
#include "sqlquerymodel.h"
SqlQueryDataSource::SqlQueryDataSource(QObject *parent)
: QObject(parent)
, m_model(new SqlQueryModel(this))
, m_status(SqlQueryDataSource::Null)
{
connect(m_model, &SqlQueryModel::rowsInserted, this, &SqlQueryDataSource::countChanged);
connect(m_model, &SqlQueryModel::rowsRemoved, this, &SqlQueryDataSource::countChanged);
connect(m_model, &SqlQueryModel::layoutChanged, this, &SqlQueryDataSource::countChanged);
connect(m_model, &SqlQueryModel::modelReset, this, &SqlQueryDataSource::countChanged);
}
QVariantMap SqlQueryDataSource::get(int index) const
{
if (!m_model) { return QVariantMap(); }
return m_model->get(index);
}
QString SqlQueryDataSource::database() const
{
return m_database.connectionName();
}
SqlQueryDataSource::Status SqlQueryDataSource::status() const
{
return m_status;
}
int SqlQueryDataSource::count() const
{
if (!m_model) { return 0; }
return m_model->rowCount();
}
QString SqlQueryDataSource::query() const
{
if (!m_query.isValid()) {
return QString();
}
return m_query.lastQuery();
}
void SqlQueryDataSource::setQuery(QString queryString)
{
qDebug() << "SqlQueryDataSource::setQuery() " << queryString;
if (m_queryString != queryString) {
m_queryString = queryString;
updateModel();
emit queryChanged(queryString);
}
}
void SqlQueryDataSource::setDatabase(QString databaseName)
{
if (m_databaseName != databaseName) {
m_databaseName = databaseName;
updateModel();
emit databaseChanged(databaseName);
}
}
void SqlQueryDataSource::updateModel()
{
if (m_databaseName.isEmpty() || m_queryString.isEmpty()) {
setStatus(Null);
return;
}
if (!m_databaseName.isEmpty()) {
if (QSqlDatabase::contains(m_databaseName)) {
m_database = QSqlDatabase::database(m_databaseName);
} else {
m_database = QSqlDatabase::addDatabase("QSQLITE", m_databaseName);
QString databasePath = QDir(QStandardPaths::writableLocation(QStandardPaths::HomeLocation)).filePath(m_databaseName + ".db");
m_database.setDatabaseName(databasePath);
qDebug() << "database path: " << databasePath;
}
if (!m_database.isOpen()) {
m_database.open();
}
}
if (m_database.isValid() && !m_queryString.isEmpty()) {
setStatus(Loading);
m_query = QSqlQuery(m_queryString, m_database);
m_model->setQuery(m_query);
m_model->updateRoleNames();
if (m_query.lastError().isValid()) {
qDebug() << "Error" << m_query.lastError().text();
setStatus(Error);
} else {
setStatus(Ready);
}
}
emit modelChanged(m_model);
}
QObject *SqlQueryDataSource::model() const
{
return m_model;
}
void SqlQueryDataSource::setStatus(SqlQueryDataSource::Status arg)
{
if (m_status != arg) {
m_status = arg;
emit statusChanged(arg);
}
}
QString SqlQueryDataSource::storageLocation() const
{
return QDir::homePath();
}
|
