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
|
#include "columncollatepanel.h"
#include "ui_columncollatepanel.h"
#include "parser/ast/sqlitecreatetable.h"
#include "schemaresolver.h"
#include "uiutils.h"
#include <QStringListModel>
ColumnCollatePanel::ColumnCollatePanel(QWidget *parent) :
ConstraintPanel(parent),
ui(new Ui::ColumnCollatePanel)
{
ui->setupUi(this);
init();
}
ColumnCollatePanel::~ColumnCollatePanel()
{
delete ui;
}
void ColumnCollatePanel::changeEvent(QEvent *e)
{
QWidget::changeEvent(e);
switch (e->type()) {
case QEvent::LanguageChange:
ui->retranslateUi(this);
break;
default:
break;
}
}
void ColumnCollatePanel::init()
{
collationModel = new QStringListModel(this);
ui->collationCombo->setModel(collationModel);
connect(ui->namedCheck, SIGNAL(toggled(bool)), this, SIGNAL(updateValidation()));
connect(ui->namedEdit, SIGNAL(textChanged(QString)), this, SIGNAL(updateValidation()));
connect(ui->collationCombo->lineEdit(), SIGNAL(textChanged(QString)), this, SIGNAL(updateValidation()));
connect(ui->namedCheck, SIGNAL(toggled(bool)), this, SLOT(updateState()));
updateState();
}
void ColumnCollatePanel::readConstraint()
{
SqliteCreateTable::Column::Constraint* constr = dynamic_cast<SqliteCreateTable::Column::Constraint*>(constraint.data());
ui->collationCombo->setCurrentText(constr->collationName);
if (!constr->name.isNull())
{
ui->namedCheck->setChecked(true);
ui->namedEdit->setText(constr->name);
}
}
void ColumnCollatePanel::readCollations()
{
SchemaResolver resolver(db);
QStringList collList = resolver.getCollations();
if (collList.size() > 0)
collList.prepend("");
collationModel->setStringList(collList);
}
void ColumnCollatePanel::updateState()
{
ui->namedEdit->setEnabled(ui->namedCheck->isChecked());
}
bool ColumnCollatePanel::validate()
{
bool nameOk = true;
if (ui->namedCheck->isChecked() && ui->namedEdit->text().isEmpty())
nameOk = false;
bool collationOk = !ui->collationCombo->currentText().isEmpty();
setValidState(ui->namedEdit, nameOk, tr("Enter a name of the constraint."));
setValidState(ui->collationCombo, collationOk, tr("Enter a collation name."));
return nameOk && collationOk;
}
void ColumnCollatePanel::constraintAvailable()
{
if (constraint.isNull())
return;
readCollations();
readConstraint();
}
void ColumnCollatePanel::storeConfiguration()
{
if (constraint.isNull())
return;
SqliteCreateTable::Column::Constraint* constr = dynamic_cast<SqliteCreateTable::Column::Constraint*>(constraint.data());
constr->type = SqliteCreateTable::Column::Constraint::COLLATE;
if (ui->namedCheck->isChecked())
constr->name = ui->namedEdit->text();
else
constr->name.clear();
constr->collationName = ui->collationCombo->currentText();
}
|
