aboutsummaryrefslogtreecommitdiffstats
path: root/SQLiteStudio3/guiSQLiteStudio/dbobjlistmodel.cpp
blob: 99d3f279fadff58a9ccc757514a058872eff8995 (plain) (blame)
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
#include "dbobjlistmodel.h"
#include "db/db.h"
#include <QDebug>
#include <schemaresolver.h>

DbObjListModel::DbObjListModel(QObject *parent) :
    QAbstractListModel(parent)
{
}

QVariant DbObjListModel::data(const QModelIndex& index, int role) const
{
    if (index.row() < 0 || index.row() >= objectList.size())
        return QVariant();

    if (role == Qt::DisplayRole || role == Qt::EditRole)
    {
        if (sortMode == SortMode::Alphabetical)
            return objectList[index.row()];
        else
            return unsortedObjectList[index.row()];
    }

    return QVariant();
}

int DbObjListModel::rowCount(const QModelIndex& parent) const
{
    if (parent.isValid())
        return 0;

    return objectList.count();
}

QModelIndex DbObjListModel::sibling(int row, int column, const QModelIndex& idx) const
{
    if (!idx.isValid() || column != 0 || row >= objectList.count())
        return QModelIndex();

    return createIndex(row, 0);
}

Db* DbObjListModel::getDb() const
{
    return db;
}

void DbObjListModel::setDb(Db* value)
{
    db = value;
    updateList();
}

DbObjListModel::SortMode DbObjListModel::getSortMode() const
{
    return sortMode;
}

void DbObjListModel::setSortMode(const SortMode& value)
{
    sortMode = value;
    beginResetModel();
    endResetModel();
}

DbObjListModel::ObjectType DbObjListModel::getType() const
{
    return type;
}

void DbObjListModel::setType(const ObjectType& value)
{
    type = value;
    updateList();
}

void DbObjListModel::updateList()
{
    if (!db || type == ObjectType::null)
        return;

    beginResetModel();
    SchemaResolver resolver(db);
    resolver.setIgnoreSystemObjects(!includeSystemObjects);
    objectList = resolver.getObjects(typeString().toLower());
    unsortedObjectList = objectList;
    qSort(objectList);
    endResetModel();
}

QString DbObjListModel::typeString() const
{
    switch (type)
    {
        case ObjectType::TABLE:
            return "TABLE";
        case ObjectType::INDEX:
            return "INDEX";
        case ObjectType::TRIGGER:
            return "TRIGGER";
        case ObjectType::VIEW:
            return "VIEW";
        case ObjectType::null:
            break;
    }
    return QString::null;
}
bool DbObjListModel::getIncludeSystemObjects() const
{
    return includeSystemObjects;
}

void DbObjListModel::setIncludeSystemObjects(bool value)
{
    includeSystemObjects = value;
}