config

type ConstantsDefaultsConfig struct {
	IncludeColumnNames bool `yaml:"include_column_names,omitempty"`
}

type CrudDefaultsConfig struct {
	AutoClean        bool                     `yaml:"auto_clean,omitempty"`
	ExcludeTableName bool                     `yaml:"exclude_table_name,omitempty"`
	Methods          map[string]*MethodConfig `yaml:"methods,omitempty"`
}

type CustomQueryConfig struct {
	Name      string `yaml:"name" validate:"required"`
	Type      string `yaml:"type" validate:"required,oneof=one many exec copyfrom"`
	Table     string `yaml:"table,omitempty"`
	OutputDir string `yaml:"output_dir,omitempty"`
	SQL       string `yaml:"sql" validate:"required"`
}

type CustomTagConfig struct {
	Name   string `yaml:"name" validate:"required"`
	Format string `yaml:"format,omitempty"` // applied to NOT NULL columns
}

type DefaultsConfig struct {
	// Pattern A: per-table repos
	QueriesDirPrefix string `yaml:"queries_dir_prefix,omitempty"`
	OutputDirPrefix  string `yaml:"output_dir_prefix,omitempty"`

	// Pattern B: single repo
	QueriesDir string `yaml:"queries_dir,omitempty"`
	OutputDir  string `yaml:"output_dir,omitempty"`

	Crud      *CrudDefaultsConfig      `yaml:"crud,omitempty"`
	Constants *ConstantsDefaultsConfig `yaml:"constants,omitempty"`
}

type MethodConfig struct {
	Name            string                      `yaml:"name,omitempty"`
	Returning       string                      `yaml:"returning,omitempty"`
	Where           map[string]WhereParamConfig `yaml:"where,omitempty"`
	WhereAdditional []string                    `yaml:"where_additional,omitempty"`
	SkipColumns     []string                    `yaml:"skip_columns,omitempty"`
	ColumnValues    map[string]string           `yaml:"column_values,omitempty"`
	Limit           bool                        `yaml:"limit,omitempty"`
	Order           *OrderConfig                `yaml:"order,omitempty"`
}

type ModelsConfig struct {
	OutputDir             string               `yaml:"output_dir" validate:"required"`
	OutputFileName        string               `yaml:"output_file_name,omitempty"`
	PackageName           string               `yaml:"package_name" validate:"required"`
	PackagePath           string               `yaml:"package_path,omitempty"`
	CustomTypes           []string             `yaml:"custom_types,omitempty"`
	SkipTables            []string             `yaml:"skip_tables,omitempty"`
	SkipEnums             []string             `yaml:"skip_enums,omitempty"`
	EmitJsonTags          bool                 `yaml:"emit_json_tags,omitempty"`
	EmitDbTags            bool                 `yaml:"emit_db_tags,omitempty"`
	EmitPointersForNull   bool                 `yaml:"emit_pointers_for_null,omitempty"`
	IncludeStructComments bool                 `yaml:"include_struct_comments,omitempty"`
	SqlPackage            string               `yaml:"sql_package,omitempty" validate:"omitempty,oneof=pgx/v5 pgx/v4 database/sql"`
	TypeOverrides         []TypeOverrideConfig `yaml:"type_overrides,omitempty"`
	CustomTags            []CustomTagConfig    `yaml:"custom_tags,omitempty"`
}

type OrderConfig struct {
	By        string `yaml:"by" validate:"required"`
	Direction string `yaml:"direction,omitempty"` // default: DESC
}

type SchemaConfig struct {
	Name          string                 `yaml:"name" validate:"required"`
	Engine        string                 `yaml:"engine" validate:"required,oneof=postgresql mysql sqlite"`
	SchemaDir     string                 `yaml:"schema_dir" validate:"required"`
	Models        *ModelsConfig          `yaml:"models,omitempty"`
	Sqlc          *SqlcConfig            `yaml:"sqlc,omitempty"`
	Defaults      *DefaultsConfig        `yaml:"defaults,omitempty"`
	Tables        map[string]TableConfig `yaml:"tables,omitempty"`
	CustomQueries []CustomQueryConfig    `yaml:"custom_queries,omitempty"`
}

type SoftDeleteConfig struct {
	Column string `yaml:"column" validate:"required"`
}

type SqlcColumnOverride struct {
	Column      string      `yaml:"column" validate:"required"`
	GoType      interface{} `yaml:"go_type,omitempty"`
	GoStructTag string      `yaml:"go_struct_tag,omitempty"`
}

type SqlcConfig struct {
	Defaults  *SqlcDefaultsConfig  `yaml:"defaults,omitempty"`
	Overrides *SqlcOverridesConfig `yaml:"overrides,omitempty"`
}

type SqlcDefaultsConfig struct {
	SqlPackage               string `yaml:"sql_package,omitempty" validate:"omitempty,oneof=pgx/v5 pgx/v4 database/sql"`
	EmitPreparedQueries      bool   `yaml:"emit_prepared_queries"`
	EmitInterface            bool   `yaml:"emit_interface"`
	EmitJsonTags             bool   `yaml:"emit_json_tags"`
	EmitDbTags               bool   `yaml:"emit_db_tags"`
	EmitExportedQueries      bool   `yaml:"emit_exported_queries"`
	EmitExactTableNames      bool   `yaml:"emit_exact_table_names"`
	EmitEmptySlices          bool   `yaml:"emit_empty_slices"`
	EmitResultStructPointers bool   `yaml:"emit_result_struct_pointers"`
	EmitParamsStructPointers bool   `yaml:"emit_params_struct_pointers"`
	EmitEnumValidMethod      bool   `yaml:"emit_enum_valid_method"`
	EmitAllEnumValues        bool   `yaml:"emit_all_enum_values"`
	QueryParameterLimit      *int   `yaml:"query_parameter_limit,omitempty"`
	JsonTagsCaseStyle        string `yaml:"json_tags_case_style,omitempty"`
}

type SqlcOverridesConfig struct {
	Rename  map[string]string    `yaml:"rename,omitempty"`
	Types   []SqlcTypeOverride   `yaml:"types,omitempty"`
	Columns []SqlcColumnOverride `yaml:"columns,omitempty"`
}

type SqlcTypeOverride struct {
	DbType   string      `yaml:"db_type" validate:"required"`
	GoType   interface{} `yaml:"go_type" validate:"required"` // string or {type: ..., import: ...}
	Nullable bool        `yaml:"nullable,omitempty"`
}

type TableConfig struct {
	PrimaryColumn string                `yaml:"primary_column,omitempty"`
	QueriesDir    string                `yaml:"queries_dir,omitempty"` // override
	OutputDir     string                `yaml:"output_dir,omitempty"`  // override
	Sqlc          *TableSqlcConfig      `yaml:"sqlc,omitempty"`
	Crud          *TableCrudConfig      `yaml:"crud,omitempty"`
	Constants     *TableConstantsConfig `yaml:"constants,omitempty"`
	SoftDelete    *SoftDeleteConfig     `yaml:"soft_delete,omitempty"`
}

type TableConstantsConfig struct {
	IncludeColumnNames *bool `yaml:"include_column_names,omitempty"`
}

type TableCrudConfig struct {
	Methods map[string]*MethodConfig `yaml:"methods,omitempty"`
}

type TableSqlcConfig struct {
	QueryParameterLimit *int `yaml:"query_parameter_limit,omitempty"`
}

type TemplatesConfig struct {
	CrudDir   string `yaml:"crud_dir,omitempty"`
	ModelsDir string `yaml:"models_dir,omitempty"`
}

type TypeOverrideConfig struct {
	SqlType string `yaml:"sql_type" validate:"required"`
	GoType  string `yaml:"go_type" validate:"required"`
	Import  string `yaml:"import,omitempty"`
}

type V2Config struct {
	Version   string           `yaml:"version" validate:"required,eq=2"`
	Schemas   []SchemaConfig   `yaml:"schemas" validate:"required,min=1,dive"`
	Templates *TemplatesConfig `yaml:"templates,omitempty"`
}

type WhereParamConfig struct {
	Value    string `yaml:"value,omitempty"`
	Operator string `yaml:"operator,omitempty"` // default: =
}