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

!!!TEST fk removal should depend on unique removal
scalar test1 = sql"INT";
scalar test2 = sql"INT";

table AA {
	test1;
	test2;
	@unique(test1, test2);
};
table BB {
	test1;
	test2;
	(test1, test2) ~ AA;
};
!!!UPDATE both unique and fk are deleted, fk should be dropped first
scalar test1 = sql"INT";
scalar test2 = sql"INT";

table AA {
	test1;
	test2;
};
table BB {
	test1;
	test2;
};
!!!RESULT
-- updated: fk removal should depend on unique removal --
CREATE DOMAIN test1 AS INT;
CREATE DOMAIN test2 AS INT;
CREATE TABLE aas (
	test1 test1 NOT NULL
,	test2 test2 NOT NULL
,	CONSTRAINT aas_test1_test2_key UNIQUE(test1, test2)

);
CREATE TABLE bbs (
	test1 test1 NOT NULL
,	test2 test2 NOT NULL
);
ALTER TABLE bbs ADD CONSTRAINT bbs_test1_test2_fk FOREIGN KEY(test1, test2) REFERENCES aas(test1, test2);
-- updated: both unique and fk are deleted, fk should be dropped first --
ALTER TABLE bbs DROP CONSTRAINT bbs_test1_test2_fk;
ALTER TABLE aas DROP CONSTRAINT aas_test1_test2_key;
-- updated: cleanup schema changes --
DROP TABLE aas;
DROP TABLE bbs;
DROP DOMAIN test1;
DROP DOMAIN test2;