SQLC

version: "2"
sql:
  - engine: "sqlite"
    queries: "db/query.sql"
    schema: "db/schema.sql"
    gen:
      go:
        # 基礎設定
        package: "sqlite"
        out: "db/sqlite"

        # 代碼生成選項
        emit_interface: true                     # 生成 Querier 介面
        emit_json_tags: true                     # 生成 JSON 標籤
        emit_prepared_queries: true              # 使用預處理語句
        emit_exact_table_names: false            # 表名是否保持原樣
        emit_empty_slices: true                  # 空結果返回空切片
        emit_exported_queries: true              # 導出 SQL 查詢
        emit_result_struct_pointers: false       # 結果是否為指針
        emit_params_struct_pointers: false       # 參數是否為指針

        # 枚舉相關
        emit_enum_valid_method: true             # 生成枚舉驗證方法
        emit_all_enum_values: true               # 生成所有枚舉值列表

        # 字段命名
        emit_pointers_for_null_types: true       # NULL 值使用指針

        # 註釋生成
        emit_file_header_comments: true          # 文件頭部註釋
        emit_doc_comments: true                  # 生成文檔註釋

        # 框架整合
        emit_db_tags: true                       # 生成 db 標籤

type Querier interface {
    GetBook(ctx context.Context, id int64) (Book, error)
    ListBooks(ctx context.Context) ([]Book, error)
}

type Book struct {
    ID    int64  `json:"id"`
    Title string `json:"title"`
}

// true: books = []Book{}
// false: books = nil
var books []Book

const getBookSQL = `SELECT * FROM books WHERE id = $1`

func (q *Queries) GetUserByID(ctx context.Context, arg *GetUserByIDParams) (*User, error)
func (q *Queries) CreateUser(ctx context.Context, arg *CreateUserParams) (*User, error)

func (e UserStatus) Valid() bool {
    switch e {
    case UserStatusActive, UserStatusInactive, UserStatusSuspended:
        return true
    }
    return false
}

var AllSubscriptionTier = []SubscriptionTier{
    SubscriptionTierFree,
    SubscriptionTierBasic,
    SubscriptionTierPremium,
    SubscriptionTierEnterprise,
}