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
33
34
35

table "orders" {
  schema = "public"
  column "id" {
    type = "serial"
    nullable = false
  }
  column "updated_at" {
    type = "timestamptz"
    nullable = true
  }
  primary_key { columns = ["id"] }
}

module "timestamps" {
  source = "./modules/timestamps"
  schema = "public"
  table  = "orders"
  column = "updated_at"
}

test "module_trigger" {
  assert = [
    "SELECT EXISTS (SELECT 1 FROM pg_trigger WHERE tgname = 'set_col_on_update')"
  ]
}

test "module_behavior" {
  setup = [
    "INSERT INTO public.orders DEFAULT VALUES",
    "UPDATE public.orders SET updated_at = updated_at"
  ]
  assert = [
    "SELECT COUNT(*) = 1 FROM public.orders WHERE updated_at IS NOT NULL"
  ]
}