dbschema 0.1.1

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

variable "cols" {
  default = {
    id   = { type = "serial", nullable = false }
    name = { type = "text",   nullable = true }
  }
}

table "users" {
  dynamic "column" {
    for_each = var.cols
    labels   = [each.key]
    content {
      type     = each.value.type
      nullable = each.value.nullable
    }
  }
}

test "dynamic_columns" {
  assert = [
    "SELECT COUNT(*) = 2 FROM information_schema.columns WHERE table_schema='public' AND table_name='users'"
  ]
  assert_fail = [
    "INSERT INTO public.users(id) VALUES (NULL)"
  ]
}