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
27
28
29
30

table "users" {
  schema = "public"
  column "id" {
    type = "serial"
    nullable = false
  }
  column "email" {
    type = "text"
    nullable = false
  }
  primary_key { columns = ["id"] }
}

view "active_users" {
  schema = "public"
  replace = true
  sql = <<-SQL
    SELECT id, email FROM public.users
  SQL
}

test "view" {
  setup = ["INSERT INTO public.users (email) VALUES ('test@example.com')"]
  assert = [
    "SELECT COUNT(*) = 1 FROM public.active_users WHERE email = 'test@example.com'"
  ]
  assert_fail = [
    "INSERT INTO public.active_users (email) VALUES (NULL)"
  ]
}