sqlc.yaml

version: "2"
sql:
  - engine: "postgresql"
    queries: "assets/queries.sql"
    schema: "assets/migrations/"
    gen:
      go:
        sql_package: "pgx/v5"
        package: "db"
        out: "lib/db"
        emit_json_tags: true
        emit_empty_slices: true
        overrides:
          - column: "rotas.metadata"
            go_type:
              type: "RotaMetadata"
          - column: "members.metadata"
            go_type:
              type: "MemberMetadata"
    database:
      uri: "postgresql://rotabot@localhost:5432/rotabot?sslmode=disable"
    rules:
      - sqlc/db-prepare
      - has-index
rules:
  - name: has-index
    rule: >
      query.sql.startsWith("SELECT") && !(postgresql.explain.plan.plans.all(p, has(p.index_name) || p.plans.all(p, has(p.index_name))))