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

!!!TEST table with indexed column
scalar test = sql"TEXT";

table A {
	field: test @index;
};
!!!UPDATE index is dropped
scalar test = sql"TEXT";

table A {
	field: test;
};
!!!UPDATE index is returned back
scalar test = sql"TEXT";

table A {
	field: test @index;
};
!!!UPDATE a name was assigned to the index
scalar test = sql"TEXT";

table A {
	field: test @index "custom_name";
};
!!!RESULT
-- updated: table with indexed column --
CREATE DOMAIN test AS TEXT;
CREATE TABLE "as" (
	field test NOT NULL
);
CREATE INDEX as_field_idx ON "as"(
	field
);
-- updated: index is dropped --
DROP INDEX as_field_idx;
-- updated: index is returned back --
CREATE INDEX as_field_idx ON "as"(
	field
);
-- updated: a name was assigned to the index --
ALTER INDEX as_field_idx RENAME TO custom_name;
-- updated: cleanup schema changes --
DROP TABLE "as";
DROP DOMAIN test;