-
Notifications
You must be signed in to change notification settings - Fork 0
/
querymodel.cpp
56 lines (46 loc) · 1.49 KB
/
querymodel.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
#include "querymodel.h"
SqlQueryModel::SqlQueryModel(QObject *parent) :
QSqlQueryModel(parent)
{
}
void SqlQueryModel::setQuery(const QString &query, const QSqlDatabase &db)
{
QSqlQueryModel::setQuery(query, db);
if (QSqlQueryModel::lastError().isValid())
qDebug() << QSqlQueryModel::lastError();
//qDebug()<<"setquey called 1";
qDebug() << "zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz";
generateRoleNames();
}
void SqlQueryModel::setQuery(const QSqlQuery & query)
{
QSqlQueryModel::setQuery(query);
if (QSqlQueryModel::lastError().isValid())
qDebug() << QSqlQueryModel::lastError();
qDebug() << "setqooopppppppppppppppppppppppppppppppppppp";
//qDebug() << "setquery called 1" << endl << query.lastError();
generateRoleNames();
}
void SqlQueryModel::generateRoleNames()
{
m_roleNames.clear();
for( int i = 0; i < record().count(); i ++) {
m_roleNames.insert(Qt::UserRole + i + 1, record().fieldName(i).toUtf8());
//m_roleNames.insert(Qt::UserRole + i + 1,);
//qDebug()<<m_roleNames;
}
qDebug() << m_roleNames;
}
QVariant SqlQueryModel::data(const QModelIndex &index, int role) const
{
QVariant value;
if(role < Qt::UserRole) {
value = QSqlQueryModel::data(index, role);
}
else {
int columnIdx = role - Qt::UserRole - 1;
QModelIndex modelIndex = this->index(index.row(), columnIdx);
value = QSqlQueryModel::data(modelIndex, Qt::DisplayRole);
}
return value;
}