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

materialized "user_counts" {
  schema = "public"
  with_data = true
  sql = <<-SQL
    SELECT 1 as id
  SQL
}

test "materialized_view" {
  setup = [
    "REFRESH MATERIALIZED VIEW public.user_counts"
  ]
  assert = [
    "SELECT id = 1 FROM public.user_counts"
  ]
}