sqlc.yaml

version: "2"
sql:
  - engine: "postgresql"
    queries: "query.sql"
    schema: "../lexicon-beneficial-ownership-database-migration/lexicon-bo-crawler-v2/"
    gen:
      go:
        package: "repository"
        out: "repository"
        sql_package: "pgx/v5"
        emit_pointers_for_null_types: true
        overrides:
          - db_type: "uuid"
            go_type:
              import: "github.com/google/uuid"
              type: "UUID"
          - db_type: "timestamptz"
            go_type:
              import: "time"
              type: "Time"
          - db_type: "inet"
            go_type:
              import: "net"
              type: "IP"
          - column: "url_frontiers.metadata"
            go_type:
              import: "lexicon/singapore-supreme-court-crawler/crawler/models"
              package: "crawlerModel"
              type: "UrlFrontierMetadata"
          - column: "extractions.metadata"
            go_type:
              import: "lexicon/singapore-supreme-court-crawler/scrapper/models"
              package: "scrapperModel"
              type: "Metadata"