immigrant-generator-postgres 0.2.0

Immigrant migrations generator for postgres SQL dialect
Documentation 
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

!!!TEST view creation toposort, Baz should be created before Qux.
scalar foo = sql"INTEGER" @inline;

table Bar {
	foo;
};
view Qux = sql"""
	SELECT * FROM {Baz};
""";
view Baz = sql"""
	SELECT * FROM {Bar};
""";
!!!UPDATE also for views
scalar foo = sql"TEXT" @inline;

table Bar {
	foo;
};
view Qux = sql"""
	SELECT * FROM {Baz};
""";
view Baz = sql"""
	SELECT * FROM {Bar};
""";
!!!RESULT
-- updated: view creation toposort, Baz should be created before Qux. --
CREATE TABLE bars (
	foo INTEGER NOT NULL
);
CREATE VIEW bazs AS
	SELECT * FROM bars;
;
CREATE VIEW quxes AS
	SELECT * FROM bazs;
;
-- updated: also for views --
ALTER VIEW quxes RENAME TO moveaway_1;
ALTER VIEW bazs RENAME TO moveaway_2;
DROP VIEW moveaway_1;
DROP VIEW moveaway_2;
ALTER TABLE bars ALTER COLUMN foo SET DATA TYPE TEXT;
CREATE VIEW bazs AS
	SELECT * FROM bars;
;
CREATE VIEW quxes AS
	SELECT * FROM bazs;
;
-- updated: cleanup schema changes --
DROP VIEW quxes;
DROP VIEW bazs;
DROP TABLE bars;