-
Notifications
You must be signed in to change notification settings - Fork 0
/
migrator.go
133 lines (104 loc) · 3.29 KB
/
migrator.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
129
130
131
132
133
package chorm
import (
"context"
"fmt"
"time"
"github.com/0x19/go-clickhouse-orm/models"
"github.com/google/uuid"
"github.com/vahid-sohrabloo/chconn/v3"
"go.uber.org/zap"
)
type Migration struct {
models.Model `clickhouse:"table:migrations, engine:MergeTree(), order: uuid"`
UUID uuid.UUID `clickhouse:"name:uuid, type:UUID, primary:true"`
Name string `clickhouse:"name:name, type:String"`
Migrated bool `clickhouse:"name:migrated, type:Boolean"`
CreatedAt time.Time `clickhouse:"name:created_at, type:DateTime"`
UpdatedAt time.Time `clickhouse:"name:updated_at, type:DateTime"`
}
func (m *Migration) TableName() string {
return "migrations"
}
func (m *Migration) Settings() []string {
return []string{}
}
type MigrationRecord struct {
migration string
up func(ctx context.Context, orm *ORM, migrator *Migrator) error
down func(ctx context.Context, orm *ORM, migrator *Migrator) error
}
type Migrator struct {
orm *ORM
migrations map[string]MigrationRecord
}
func NewMigrator(orm *ORM) (*Migrator, error) {
// We need to first register the migration model for the ORM to function correctly.
if err := orm.GetManager().RegisterModel(&Migration{}); err != nil {
return nil, err
}
return &Migrator{
orm: orm,
migrations: make(map[string]MigrationRecord, 0),
}, nil
}
func (m *Migrator) GetMigrations() map[string]MigrationRecord {
return m.migrations
}
func (m *Migrator) RegisterMigration(
name string,
up func(ctx context.Context, orm *ORM, migrator *Migrator) error,
down func(ctx context.Context, orm *ORM, migrator *Migrator) error,
) error {
if _, ok := m.migrations[name]; ok {
return fmt.Errorf("migration with name %s already exists", name)
}
m.migrations[name] = MigrationRecord{
migration: name,
up: up,
down: down,
}
return nil
}
func (m *Migrator) Migrate(ctx context.Context, queryOptions *chconn.QueryOptions) error {
for name, migration := range m.migrations {
// Check if the migration has already been applied.
// Apply the migration.
if err := migration.up(ctx, m.orm, m); err != nil {
return err
}
// Create a new migration record.
migration := &Migration{
UUID: uuid.New(),
Name: name,
Migrated: true,
CreatedAt: time.Now().UTC(),
UpdatedAt: time.Now().UTC(),
}
if _, _, err := m.orm.Insert(ctx, migration, queryOptions); err != nil {
return err
}
zap.L().Debug("Successfully migrated", zap.String("migration", name))
}
return nil
}
func (m *Migrator) Rollback(ctx context.Context, queryOptions *chconn.QueryOptions) error {
return nil
}
func (m *Migrator) Setup(ctx context.Context, queryOptions *chconn.QueryOptions) error {
if _, err := m.orm.CreateDatabase(ctx, m.orm.GetDatabaseName(), true, queryOptions); err != nil {
return err
}
zap.L().Debug("Successfully created database", zap.String("database", m.orm.GetDatabaseName()))
if _, err := NewCreateTable(ctx, m.orm, &Migration{}, queryOptions); err != nil {
return err
}
zap.L().Debug("Successfully created migrations table")
return nil
}
func (m *Migrator) Destroy(ctx context.Context, queryOptions *chconn.QueryOptions) error {
if _, err := NewDropTable(ctx, m.orm, &Migration{}, queryOptions); err != nil {
return err
}
zap.L().Debug("Successfully created migrations table")
return nil
}