pgxgen.yaml

version: 1
sqlc:
  - schema_dir: sql/migrations
    models:
      replace_sqlc_nullable_types: true
      move:
        output_dir: internal/models
        output_file_name: models_gen.go
        package_name: models
        package_path: github.com/sxwebdev/pgxgen-example/internal/models
    crud:
      auto_remove_generated_files: true
      exclude_table_name_from_methods: true
      tables:
        # Authors
        authors:
          output_dir: sql/queries/authors
          primary_column: id
          methods:
            create:
              skip_columns:
                - id
                - updated_at
              returning: "*"
            update:
              skip_columns:
                - id
                - created_at
              returning: "*"
            find:
              order:
                by: created_at
                direction: DESC
            get:
              name: GetAuthorByID
            delete:
            total:

        # Books
        books:
          output_dir: sql/queries/books
          primary_column: id
          methods:
            create:
              skip_columns:
                - id
                - updated_at
              returning: "*"
            update:
              skip_columns:
                - id
                - created_at
                - author_id
              returning: "*"
            get:
              name: GetBookByID
            delete:
            total:
    constants:
      tables:
        authors:
          output_dir: internal/store/repos/repo_authors
        books:
          output_dir: internal/store/repos/repo_books