version: "2"
servers:
- engine: postgresql
  uri: ${PG_URL}
sql:
  - name: repo
    engine: postgresql
    schema: src/db/migration/
    queries: src/internal/const/query/
    gen:
      go:
        sql_package: "pgx/v5"
        package: db
        out: src/internal/domain/db/
        emit_db_tags: true
        emit_json_tags: true
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        # sql_package: "pgx/v5"
    database:
      managed: true
    rules:
      - sqlc/db-prepare
      - no-pg
      - no-delete
rules:
  - name: no-pg
    message: "invalid engine: postgresql"
    rule: |
      config.engine == "postgresql"
  - name: no-delete
    message: "don't use delete statements"
    rule: |
      query.sql.contains("DELETE")