/
data_definer.go
128 lines (109 loc) · 2.9 KB
/
data_definer.go
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
package postgres
import (
"context"
"fmt"
"github.com/cortezaproject/corteza/server/pkg/dal"
"github.com/cortezaproject/corteza/server/store/adapters/rdbms/ddl"
"github.com/jmoiron/sqlx"
)
type (
// dataDefiner for MySQL
dataDefiner struct {
dbName string
conn *sqlx.DB
is *informationSchema
d *postgresDialect
}
reTypeColumn struct {
Dialect *postgresDialect
Table string
Column string
Type *ddl.ColumnType
}
)
var (
_ ddl.DataDefiner = new(dataDefiner)
)
func DataDefiner(dbName string, conn *sqlx.DB) *dataDefiner {
return &dataDefiner{
dbName: dbName,
conn: conn,
is: InformationSchema(conn),
d: Dialect(),
}
}
func (dd *dataDefiner) ConvertModel(m *dal.Model) (*ddl.Table, error) {
return ddl.ConvertModel(m, dd.d)
}
func (dd *dataDefiner) ConvertAttribute(attr *dal.Attribute) (*ddl.Column, error) {
return ddl.ConvertAttribute(attr, dd.d)
}
func (dd *dataDefiner) TableCreate(ctx context.Context, t *ddl.Table) error {
return ddl.Exec(ctx, dd.conn, &ddl.CreateTable{Table: t, Dialect: dd.d})
}
func (dd *dataDefiner) TableDrop(ctx context.Context, t string) error {
return ddl.Exec(ctx, dd.conn, &ddl.DropTable{
Dialect: dd.d,
Table: t,
})
}
func (dd *dataDefiner) TableLookup(ctx context.Context, t string) (*ddl.Table, error) {
return dd.is.TableLookup(ctx, t, "public", dd.dbName)
}
func (dd *dataDefiner) ColumnAdd(ctx context.Context, t string, c *ddl.Column) error {
return ddl.Exec(ctx, dd.conn, &ddl.AddColumn{
Dialect: dd.d,
Table: t,
Column: c,
})
}
func (dd *dataDefiner) ColumnDrop(ctx context.Context, t, col string) error {
return ddl.Exec(ctx, dd.conn, &ddl.DropColumn{
Dialect: dd.d,
Table: t,
Column: col,
})
}
func (dd *dataDefiner) ColumnRename(ctx context.Context, t string, o string, n string) error {
return ddl.Exec(ctx, dd.conn, &ddl.RenameColumn{
Dialect: dd.d,
Table: t,
Old: o,
New: n,
})
}
func (dd *dataDefiner) ColumnReType(ctx context.Context, t string, col string, tp *ddl.ColumnType) error {
return ddl.Exec(ctx, dd.conn, &reTypeColumn{
Dialect: dd.d,
Table: t,
Column: col,
Type: tp,
})
}
func (dd *dataDefiner) IndexLookup(ctx context.Context, i, t string) (*ddl.Index, error) {
if index, err := dd.is.IndexLookup(ctx, i, t, dd.dbName); err != nil {
return nil, err
} else {
return index, nil
}
}
func (dd *dataDefiner) IndexCreate(ctx context.Context, t string, i *ddl.Index) error {
return ddl.Exec(ctx, dd.conn, &ddl.CreateIndex{
Dialect: dd.d,
Index: i,
})
}
func (dd *dataDefiner) IndexDrop(ctx context.Context, t, i string) error {
return ddl.Exec(ctx, dd.conn, &ddl.DropIndex{
Dialect: dd.d,
Ident: i,
})
}
func (c *reTypeColumn) ToSQL() (sql string, aa []interface{}, err error) {
return fmt.Sprintf(
`ALTER TABLE %s ALTER COLUMN %s TYPE %s`,
c.Dialect.QuoteIdent(c.Table),
c.Dialect.QuoteIdent(c.Column),
c.Type.Name,
), nil, nil
}