dbschema 0.1.0

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
41

table "users" {
  schema = "public"
  if_not_exists = true

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

  primary_key { columns = ["id"] }
  check "email_not_empty" {
    expression = "email <> ''"
  }
}

index "users_email_key" {
  table   = "users"
  columns = ["email"]
  unique  = true
}

test "table" {
  # Positive assert
  assert = [
    "SELECT to_regclass('public.users') IS NOT NULL"
  ]
}

# Negative test: unique index prevents duplicates
test "table_unique_enforced" {
  setup = [
    "INSERT INTO public.users(email) VALUES ('dup')"
  ]
  assert_fail = [
    "INSERT INTO public.users(email) VALUES ('dup')"
  ]
}