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
!!!TEST scalar and multiple checks on it
scalar test = sql"INTEGER"
	@check(_ > 0)
	@check (_ < 1000)
	@check (_ != 5)
	@check "not_6_or_12" (_ != 6)
	@check "not_6_or_12" (_ != 12);
!!!RESULT
-- updated: scalar and multiple checks on it --
CREATE DOMAIN test AS INTEGER
	CONSTRAINT not_6_or_12 CHECK (VALUE <> 6 AND VALUE <> 12)
	CONSTRAINT test_check CHECK (VALUE > 0 AND VALUE < 1000 AND VALUE <> 5);
-- updated: cleanup schema changes --
DROP DOMAIN test;