dbschema 0.1.4

Define database schema's as HCL files, and generate idempotent SQL migrations
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

enum "StatusType" {
  schema = "public"
  values = ["active", "disabled"]
}

table "status_usage_test" {
  schema = "public"

  column "id" {
    type = "text"
    nullable = false
  }

  column "status" {
    type = "StatusType"
    nullable = false
  }

  primary_key { columns = ["id"] }

}

test "status_enum" {
  assert = [
    "SELECT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'StatusType')",
    "SELECT 'active'::\"StatusType\" IS NOT NULL",
    "WITH inserted AS (INSERT INTO public.status_usage_test (id, status) VALUES ('usage-test', 'active'::\"StatusType\") RETURNING 1) SELECT EXISTS (SELECT 1 FROM inserted)"
  ]
  assert_fail = [
    "SELECT 'unknown'::\"StatusType\""
  ]
}