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
52
53

!!!TEST two tables
scalar idd = sql"INTEGER";
table TestA {
	idd;
};
table TestB {
	idd;
};
!!!UPDATE add link from B to A
scalar idd = sql"INTEGER";
table TestA {
	idd @primary_key;
};
table TestB {
	idd ~ TestA;
};
!!!UPDATE ...remove it
scalar idd = sql"INTEGER";
table TestA {
	idd @primary_key;
};
table TestB {
	idd;
};
!!!UPDATE and add it again
scalar idd = sql"INTEGER";
table TestA {
	idd @primary_key;
};
table TestB {
	idd ~ TestA;
};
!!!RESULT
-- updated: two tables --
CREATE DOMAIN idd AS INTEGER;
CREATE TABLE test_as (
	idd idd NOT NULL
);
CREATE TABLE test_bs (
	idd idd NOT NULL
);
-- updated: add link from B to A --
ALTER TABLE test_as ADD CONSTRAINT test_as_idd_pkey PRIMARY KEY(idd);
ALTER TABLE test_bs ADD CONSTRAINT test_bs_idd_fk FOREIGN KEY(idd) REFERENCES test_as(idd);
-- updated: ...remove it --
ALTER TABLE test_bs DROP CONSTRAINT test_bs_idd_fk;
-- updated: and add it again --
ALTER TABLE test_bs ADD CONSTRAINT test_bs_idd_fk FOREIGN KEY(idd) REFERENCES test_as(idd);
-- updated: cleanup schema changes --
ALTER TABLE test_bs DROP CONSTRAINT test_bs_idd_fk;
DROP TABLE test_as;
DROP TABLE test_bs;
DROP DOMAIN idd;