-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqltablemodel.cpp
105 lines (84 loc) · 2.34 KB
/
sqltablemodel.cpp
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
// Copyright 2013 Guillaume Denry (guillaume.denry@gmail.com)
// This file is part of ShowDevant.
//
// ShowDevant is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// ShowDevant 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 General Public License
// along with ShowDevant. If not, see <http://www.gnu.org/licenses/>.
#include <QSqlRecord>
#include "sqltablemodel.h"
SqlTableModel::SqlTableModel(QObject *parent) :
QSqlTableModel(parent),
_synchronized(false),
_synchronizing(false),
_sortOrder(Qt::AscendingOrder)
{
}
QVariant SqlTableModel::data(const QModelIndex &index, int role) const
{
if (index.row() >= rowCount())
return QString("");
if (role < Qt::UserRole)
return QSqlTableModel::data(index, role);
return QSqlTableModel::data(this->index(index.row(), role - Qt::UserRole - 1), Qt::DisplayRole);
}
void SqlTableModel::generateRoleNames()
{
roles.clear();
int nbCols = this->columnCount();
for (int i = 0; i < nbCols; i++) {
roles[Qt::UserRole + i + 1] = QVariant(this->headerData(i, Qt::Horizontal).toString()).toByteArray();
}
}
void SqlTableModel::setTable(const QString &tableName)
{
QSqlTableModel::setTable(tableName);
generateRoleNames();
int col = fieldIndex(_sortField);
if (col >= 0) {
setSort(col, _sortOrder);
}
select();
}
Qt::SortOrder SqlTableModel::getSortOrder() const
{
return _sortOrder;
}
void SqlTableModel::setSortOrder(Qt::SortOrder order)
{
if (_sortOrder == order)
return;
_sortOrder = order;
}
const QString &SqlTableModel::getSortField() const
{
return _sortField;
}
void SqlTableModel::setSortField(const QString &field)
{
if (_sortField == field)
return;
_sortField = field;
}
void SqlTableModel::setSynchronized(bool value)
{
if (_synchronized == value)
return;
_synchronized = value;
emit synchronizedChanged();
}
void SqlTableModel::setSynchronizing(bool value)
{
if (_synchronizing == value)
return;
_synchronizing = value;
emit synchronizingChanged();
}