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

!!!TEST external table should not have associated CREATE TABLE or DROP TABLE
scalar test = sql"INTEGER" @external;

table External {
	test;
	@external;
};
!!!UPDATE any updates in external tables should be passed as is
scalar test = sql"INTEGER" @external;

table External {
	test "test3";
	test2: test;
	test4: test;
	@external;
};

table Other {
	test ~ External;
};
!!!UPDATE even updates are assumed
scalar test "othertest" = sql"OTHERTHING" @check (_ != 0) @external;

table External "otherexternal" {
	test;
	test2: test;
	@external;
};

table Other {
	test ~ External;
};
!!!RESULT
-- updated: external table should not have associated CREATE TABLE or DROP TABLE --

-- updated: any updates in external tables should be passed as is --
CREATE TABLE others (
	test test NOT NULL
);
ALTER TABLE others ADD CONSTRAINT others_test_fk FOREIGN KEY(test) REFERENCES externals(test3);
-- updated: even updates are assumed --

-- updated: cleanup schema changes --
ALTER TABLE others DROP CONSTRAINT others_test_fk;
DROP TABLE others;