dbschema 0.1.2

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
36
37
38
39
40

variable "table_name" {
  type    = "string"
  default = "object_variable_example"
}

variable "columns" {
  type = "list(object({ name = string, type = string, nullable = optional(bool) }))"
  default = [
    { name = "label",   type = "text",  nullable = true },
    { name = "payload", type = "jsonb", nullable = false },
  ]
}

table "object_variable_example" {
  schema = "public"
  table_name = var.table_name

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

  dynamic "column" {
    for_each = var.columns
    labels   = [each.value.name]
    content {
      type     = each.value.type
      nullable = each.value.nullable
    }
  }

  primary_key { columns = ["id"] }
}

test "object_variable_columns" {
  assert = [
    "SELECT COUNT(*) = 3 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = '${var.table_name}'",
    "SELECT array_agg(column_name::text ORDER BY ordinal_position) = ARRAY['id', 'label', 'payload'] FROM information_schema.columns WHERE table_schema = 'public' AND table_name = '${var.table_name}'"
  ]
}