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

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

# Ensure the role referenced by the policy exists
role "app_user" {
  login = false
}

policy "user_select" {
  schema  = "public"
  table   = "users"
  command = "select"
  roles   = ["postgres"]
  using   = "true"
}

test "policy" {
  assert = "SELECT EXISTS (SELECT 1 FROM pg_policy WHERE polname = 'user_select')"
}