sqlc.yaml

version: "2"
sql:
  - engine: "mysql"
    queries: "db/query"
    schema: "db/migrate"
    gen:
      go:
        package: "sqlc"
        out: "app/sqlc"
        emit_json_tags: true
        emit_interface: true
        emit_empty_slices: true
        json_tags_case_style: "camel"
        overrides:
          - db_type: text
            nullable: true
            go_type:
              type: string
              pointer: false

          - db_type: varchar
            nullable: true
            go_type:
              type: string
              pointer: false

          - db_type: int
            nullable: true
            go_type:
              type: int
              pointer: false

          - db_type: int
            nullable: false
            go_type:
              type: int
              pointer: false

          - db_type: tinyint
            nullable: true
            go_type:
              type: int
              pointer: false

          - db_type: date
            nullable: true
            go_type:
              type: time.Time
              pointer: false

          - db_type: datetime
            nullable: true
            go_type:
              type: time.Time
              pointer: false