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

!!!TEST enum and a table, which defined enum field with the default value
table Table {
	a: myenum @default("test"::myenum);
};

enum myenum "myenumname"{
	test "test";
};
!!!UPDATE enum entry is dropped, other entry is added instead, table default is rewritten to it
table Table {
	a: myenum @default("test2"::myenum);
};

enum myenum "myenumname"{
	test2 "test2";
};
!!!RESULT
-- updated: enum and a table, which defined enum field with the default value --
CREATE TYPE myenumname AS ENUM (
	'test'
);

CREATE TABLE tables (
	a myenumname NOT NULL DEFAULT (('test')::myenumname)
);
-- updated: enum entry is dropped, other entry is added instead, table default is rewritten to it --
ALTER TYPE myenumname
	RENAME TO moveaway_1
;
CREATE TYPE myenumname AS ENUM (
	'test2'
);

ALTER TABLE tables
	ALTER COLUMN a SET DATA TYPE myenumname
,	ALTER COLUMN a SET DEFAULT ('test2')::myenumname
;
DROP TYPE moveaway_1;
-- updated: cleanup schema changes --
DROP TABLE tables;
DROP TYPE myenumname;