-
Notifications
You must be signed in to change notification settings - Fork 6
/
blueprint.cpp
97 lines (83 loc) · 2 KB
/
blueprint.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
#include "blueprint.h"
#include <QStringList>
#include <QDebug>
#include <QSqlQuery>
#include <QSqlError>
#include "db.h"
BluePrint::BluePrint(const QString &predicate, const QString &table) :
predicate(predicate),
table(table)
{
}
BluePrint::~BluePrint()
{
for (Column *c : columns)
delete c;
}
BluePrint::Column *BluePrint::increment(const QString &name)
{
columns.append(new Column(name, DB::isSqlite() ? "integer" : "int"));
return columns.back()->primaryKey()->autoIncrement();
}
BluePrint::Column *BluePrint::integer(const QString &name)
{
columns.append(new Column(name, DB::isSqlite() ? "integer" : "int"));
return columns.back();
}
BluePrint::Column *BluePrint::string(const QString &name)
{
columns.append(new Column(name, "char(255)"));
return columns.back();
}
void BluePrint::timestamps()
{
columns.append(new Column("created_at", "timestamp"));
columns.append(new Column("updated_at", "timestamp"));
}
bool BluePrint::commit()
{
QStringList lines;
for (Column *c : columns)
lines.append(c->toSql());
QString statement = QString("%1 %2 (%3)").arg(predicate, table, lines.join(", "));
return Builder::exec(statement);
}
BluePrint::Column::Column(const QString &name, const QString &type, bool primaryKey) :
name(name),
type(type),
pk(primaryKey)
{
}
BluePrint::Column *BluePrint::Column::primaryKey()
{
pk = true;
return this;
}
BluePrint::Column *BluePrint::Column::nullable()
{
nn = false;
return this;
}
BluePrint::Column *BluePrint::Column::unique()
{
u = true;
return this;
}
BluePrint::Column *BluePrint::Column::autoIncrement()
{
ai = true;
return this;
}
QString BluePrint::Column::toSql()
{
QString line = QString("%1 %2").arg(name).arg(type);
if (pk)
line.append(" primary key");
if (u)
line.append(" unique");
if (ai)
line.append(DB::isSqlite() ? " autoincrement" : " auto_increment");
if (nn)
line.append(" not null");
return line;
}