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

!!!TEST init
// Comment on domain
scalar test = sql"TEXT";
// Comment on table
table A {
	// Comment on column
	test;
};
!!!UPDATE
// Updated comment on domain
scalar test = sql"TEXT";
// Updated comment on table
table A {
	// Updated comment on column
	test;
	// Comment on added column
	test2: test;
};
!!!UPDATE
scalar test = sql"TEXT";
table A {
	test;
	test2: test;
};
!!!RESULT
-- updated: init --
CREATE DOMAIN test AS TEXT;
CREATE TABLE "as" (
	test test NOT NULL
);
COMMENT ON COLUMN "as".test IS 'Comment on column';
COMMENT ON TABLE "as" IS 'Comment on table';
COMMENT ON DOMAIN test IS 'Comment on domain';
-- updated --
ALTER TABLE "as" ADD COLUMN test2 test NOT NULL;
COMMENT ON COLUMN "as".test2 IS 'Comment on added column';
COMMENT ON COLUMN "as".test IS 'Updated comment on column';
COMMENT ON TABLE "as" IS 'Updated comment on table';
COMMENT ON DOMAIN test IS 'Updated comment on domain';
-- updated --
COMMENT ON COLUMN "as".test IS NULL;
COMMENT ON COLUMN "as".test2 IS NULL;
COMMENT ON TABLE "as" IS NULL;
COMMENT ON DOMAIN test IS NULL;
-- updated: cleanup schema changes --
DROP TABLE "as";
DROP DOMAIN test;