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
30
31
32

# Rule

Defines a query rewrite rule for a table.

```hcl
rule "notify_users" {
  table   = "users"
  event   = "UPDATE"
  command = "NOTIFY users_changed"
}
```

## Attributes
- `name` (label): rule name.
- `table` (string): target table.
- `schema` (string, optional): schema of the table. Defaults to `public`.
- `event` (string): triggering event.
- `where` (string, optional): condition expression.
- `instead` (bool, optional): use `INSTEAD` instead of `ALSO`.
- `command` (string): command to execute when the rule fires.
- `comment` (string, optional): comment for the rule.

## Examples

```hcl
rule "no_delete_users" {
  table   = "users"
  event   = "DELETE"
  instead = true
  command = "RAISE EXCEPTION 'cannot delete'"
}
```