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

!!!TEST depth 2 composite with check on it, which will be propagated to table.

scalar test = sql"INTEGER";

struct a {
	test @check (_ != 123);
};
struct b {
	a_field: a @check (_.test != 246);
};

table Example {
	b;
};
!!!RESULT
-- updated: depth 2 composite with check on it, which will be propagated to table. --
CREATE DOMAIN test AS INTEGER;
CREATE TYPE a AS (
	test test
);
CREATE TYPE b AS (
	a_field a
);
CREATE TABLE examples (
	b b NOT NULL
,	CONSTRAINT composite_nullability_check CHECK ((b IS NULL OR b.a_field IS NOT NULL) AND (b.a_field IS NULL OR b.a_field.test IS NOT NULL))
,	CONSTRAINT examples_b_check CHECK (b.a_field.test <> 246 AND b.a_field.test <> 123)
);
-- updated: cleanup schema changes --
DROP TABLE examples;
DROP TYPE b;
DROP TYPE a;
DROP DOMAIN test;