blob: f29b6517cdc7943faa0013c224f70fec5ce129bb (
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
121
122
123
124
125
126
127
128
129
|
#ifndef INDEXDIALOG_H
#define INDEXDIALOG_H
#include "db/db.h"
#include "guiSQLiteStudio_global.h"
#include "parser/ast/sqlitecreateindex.h"
#include "common/strhash.h"
#include <QDialog>
#include <QStringListModel>
namespace Ui {
class IndexDialog;
}
class QGridLayout;
class QSignalMapper;
class QCheckBox;
class QComboBox;
class QTableWidget;
class GUI_API_EXPORT IndexDialog : public QDialog
{
Q_OBJECT
public:
IndexDialog(Db* db, QWidget *parent = 0);
IndexDialog(Db* db, const QString& index, QWidget *parent = 0);
~IndexDialog();
void setTable(const QString& value);
protected:
void changeEvent(QEvent *e);
private:
class Column
{
public:
Column(const QString& name, QTableWidget* table);
Column(SqliteExpr* expr, QTableWidget* table);
~Column();
void assignToNewRow(int row);
void prepareForNewRow();
QCheckBox* getCheck() const;
void setCheck(QCheckBox* cb);
QWidget* getCheckParent() const;
void setCheckParent(QWidget* w);
QComboBox* getSort() const;
void setSort(QComboBox* cb);
QComboBox* getCollation() const;
void setCollation(QComboBox* cb);
bool hasCollation() const;
QString getName() const;
SqliteExpr* getExpr() const;
void setExpr(SqliteExpr* expr);
bool isExpr() const;
QString getKey() const;
private:
QWidget* defineContainer(QWidget* w);
QWidget* column1Contrainer = nullptr;
QWidget* column2Contrainer = nullptr;
QWidget* column3Contrainer = nullptr;
QWidget* checkParent = nullptr;
QCheckBox* check = nullptr;
QComboBox* sort = nullptr;
QComboBox* collation = nullptr;
QTableWidget* table = nullptr;
QString name;
SqliteExpr* expr = nullptr;
};
void init();
void readIndex();
void readCollations();
void buildColumn(const QString& name, int row);
Column* buildColumn(SqliteOrderBy* orderBy, int row);
Column* buildColumn(SqliteExpr* expr, int row);
void buildColumn(Column* column, int row);
void applyColumnValues();
void applyIndex();
SqliteOrderBy* addIndexedColumn(const QString& name);
SqliteOrderBy* addIndexedColumn(SqliteExpr* expr);
void addCollation(SqliteOrderBy* col, const QString& name);
void rebuildCreateIndex();
void queryDuplicates();
void clearColumns();
void rebuildColumnsByNewOrder();
QString getKey(SqliteOrderBy* col) const;
QStringList getExistingColumnExprs(const QString& exceptThis = QString()) const;
QStringList getTableColumns() const;
bool existingIndex = false;
Db* db = nullptr;
QString table;
QString index;
SqliteCreateIndexPtr createIndex;
SqliteCreateIndexPtr originalCreateIndex;
QStringList tableColumns;
QSignalMapper* columnStateSignalMapping = nullptr;
QStringListModel collations;
StrHash<Column*> columns;
QList<Column*> columnsByRow;
int totalColumns = 0;
Ui::IndexDialog *ui = nullptr;
private slots:
void updateValidation();
void buildColumns();
void updateTable(const QString& value);
void updateColumnState(const QString& columnKey);
void updatePartialConditionState();
void updateDdl();
void tabChanged(int tab);
void moveColumnUp();
void moveColumnDown();
void updateToolBarButtons(const QModelIndex& idx = QModelIndex());
void addExprColumn();
void editExprColumn(int row = -1);
void delExprColumn();
public slots:
void accept();
};
#endif // INDEXDIALOG_H
|
