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
|
atlas migrate diff --env local
cmpmig 0 diff.sql
# reset
exec rm -rf migrations
atlas migrate diff --env src_list
cmpmig 0 diff.sql
# reset
exec rm -rf migrations
atlas migrate diff --env single_elem
cmpmig 0 diff.sql
-- atlas.hcl --
env "local" {
url = "URL"
dev = "sqlite://test?mode=memory&_fk=1"
src = "./schema"
migration {
dir = "file://migrations"
format = atlas
}
}
env "src_list" {
url = "URL"
dev = "sqlite://test?mode=memory&_fk=1"
src = [
"./schema/1.hcl",
"./schema/2.hcl",
]
migration {
dir = "file://migrations"
format = atlas
}
}
env "single_elem" {
url = "URL"
dev = "sqlite://test?mode=memory&_fk=1"
src = [
"./schema/",
]
migration {
dir = "file://migrations"
format = atlas
}
}
-- schema/1.hcl --
table "users" {
schema = schema.main
column "id" {
null = false
type = int
}
}
-- schema/2.hcl --
schema "main" {
}
-- diff.sql --
-- create "users" table
CREATE TABLE `users` (`id` int NOT NULL);
-- empty.sql --
|
