sqlc.yaml

version: 2
sql:
  - engine: sqlite
    schema: migrations
    queries: db/query.sql
    gen:
      go:
        package: db
        out: db
        emit_pointers_for_null_types: true
        emit_json_tags: true
        rename:
          qr_state: QRState
          qr_id: QRID
        overrides:
          - column: locations.inserted_at
            go_type: go.universe.tf/garden/types.TextTime
          - column: locations.updated_at
            go_type: go.universe.tf/garden/types.TextTime
          - column: locations.qr_state
            go_type: go.universe.tf/garden/types.QRState

          - column: seeds.family
            go_type: go.universe.tf/garden/types/plantfamily.PlantFamily
          - column: seeds.edible
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.needs_trellis
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.needs_bird_netting
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.is_keto
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.is_native
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.is_invasive
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.is_cover_crop
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.grows_well_from_seed
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.is_bad_for_cats
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.is_deer_resistant
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.needs_stratification
            go_type: go.universe.tf/garden/types/tribool.Tribool
          - column: seeds.sun_type
            go_type: go.universe.tf/garden/types/suntype.SunType
          - column: seeds.soil_type
            go_type: go.universe.tf/garden/types/soiltype.SoilType
          - column: seeds.lifespan
            go_type: go.universe.tf/garden/types/plantlifespan.PlantLifespan
          - column: seeds.latin_name
            go_type: string

          - column: plant_locations.end
            go_type: go.universe.tf/garden/types.TextTime
          - column: plant_locations.start
            go_type: go.universe.tf/garden/types.TextTime