encore-dev-template/sqlc.yaml at main · oppa-archive/encore-dev-template · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
version: "2"

overrides:
  go:
    overrides:
      - go_type: "encore.app/internal/types.Vector"
        db_type: "vector"
      - go_type: "encore.dev/types/uuid.UUID"
        db_type: "uuid"
      - go_type:
          import: "encore.dev/types/uuid"
          type: "UUID"
          pointer: true
        db_type: "uuid"
        nullable: true

sql:
  - queries: "db/queries/account.sql"
    schema: "db/migrations"
    engine: "postgresql"
    gen:
      go:
        sql_package: "pgx/v5"
        package: "repository"
        out: "db/repository"
        emit_db_tags: true
        emit_json_tags: true
        emit_prepared_queries: true
        emit_empty_slices: true
        emit_methods_with_db_argument: false
        emit_result_struct_pointers: true
        emit_enum_valid_method: true
        emit_all_enum_values: true
        emit_exported_queries: true
  - queries: "db/queries/account_shortcode.sql"
    schema: "db/migrations"
    engine: "postgresql"
    gen:
      go:
        sql_package: "pgx/v5"
        package: "repository"
        out: "db/repository"
        emit_db_tags: true
        emit_json_tags: true
        emit_prepared_queries: true
        emit_empty_slices: true
        emit_methods_with_db_argument: false
        emit_result_struct_pointers: true
        emit_enum_valid_method: true
        emit_all_enum_values: true
        emit_exported_queries: true