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

!!!SETUP
scalar test = sql"TEXT";
!!!TEST table with a column check
table A {
	field: test @check(_ != "foo");
};
!!!UPDATE drop check from the column
table A {
	field: test;
};
!!!UPDATE return check back
table A {
	field: test @check(_ != "foo");
};
!!!UPDATE update the check
table A {
	field: test @check(_ != "bar");
};
!!!RESULT
-- updated: setup --
CREATE DOMAIN test AS TEXT;
-- updated: table with a column check --
CREATE TABLE "as" (
	field test NOT NULL
,	CONSTRAINT as_field_check CHECK (field <> 'foo')
);
-- updated: drop check from the column --
ALTER TABLE "as" DROP CONSTRAINT as_field_check;
-- updated: return check back --
ALTER TABLE "as" ADD CONSTRAINT as_field_check CHECK (field <> 'foo');
-- updated: update the check --
ALTER TABLE "as"
	DROP CONSTRAINT as_field_check
,	ADD CONSTRAINT as_field_check CHECK (field <> 'bar')
;
-- updated: cleanup schema changes --
DROP TABLE "as";
-- updated: cleanup setup --
DROP DOMAIN test;