db

type Database interface {
	// GORM returns the underlying *gorm.DB for query building.
	GORM() *gorm.DB
	// SQL returns the underlying *sql.DB for ping/close/pool control.
	SQL() *sql.DB
	// Driver returns the configured driver name, e.g. "mysql" or "postgres".
	Driver() string
	// Ping runs a health-check against the underlying connection.
	Ping(ctx context.Context) error
	// Close releases the underlying connection pool.
	Close() error
}

type DatabaseConfig struct {
	Driver          string `json:"driver" yaml:"driver"`
	DSN             string `json:"dsn" yaml:"dsn"`
	MaxOpenConns    int    `json:"max_open_conns" yaml:"max_open_conns"`
	MaxIdleConns    int    `json:"max_idle_conns" yaml:"max_idle_conns"`
	ConnMaxLifetime string `json:"conn_max_lifetime" yaml:"conn_max_lifetime"`
	SlowThreshold   string `json:"slow_threshold" yaml:"slow_threshold"`
	LogLevel        string `json:"log_level" yaml:"log_level"`

	// AutoCreateDatabase creates the target PostgreSQL database when it does not
	// exist. It is intentionally implemented only for Postgres because MySQL DSN
	// permissions and creation semantics vary widely between deployments.
	AutoCreateDatabase bool `json:"auto_create_database" yaml:"auto_create_database"`
	// AutoCreate is a legacy alias used by older Hub configs.
	AutoCreate bool `json:"autoCreate" yaml:"autoCreate"`
	// MaintenanceDB is the database used to run CREATE DATABASE for Postgres.
	// Defaults to "postgres".
	MaintenanceDB string `json:"maintenance_db" yaml:"maintenance_db"`

	// Postgres-only options. Ignored when Driver != postgres.
	// SearchPath is encoded into the connection DSN via the Postgres "options"
	// runtime parameter so every pooled connection receives the same setting.
	// Leave empty to use the server/default schema resolution, usually public.
	SearchPath string `json:"search_path" yaml:"search_path"`
	// SSLMode overrides the sslmode query-param. Only applied when the DSN does
	// not already contain sslmode. Common values: disable, require, verify-ca,
	// verify-full. Defaults to "disable" for dev convenience.
	SSLMode string `json:"ssl_mode" yaml:"ssl_mode"`
}

type JSONB[T any] struct {
	Data T
	// Null indicates whether the column value was SQL NULL on scan.
	// Set to true by Scan when the database returns NULL. Setting
	// Null=true before insert/updated causes GORM to write NULL.
	Null bool
}

type MySQL struct {
	DB    *gorm.DB
	SQLDB *sql.DB
	// contains filtered or unexported fields
}

type Option func(*options)

type PageRequest struct {
	Page     int
	PageSize int
	// Sort is kept for trusted internal callers only. Do not pass raw HTTP input
	// into Sort. Prefer SortBy + SortOrder with an allowed-column map.
	Sort string
	// SortBy is a logical external sort key, resolved through an allowlist.
	SortBy string
	// SortOrder supports "asc" or "desc". Any other value is treated as asc.
	SortOrder string
}

type PageResult[T any] struct {
	Items    []T   `json:"items"`
	Total    int64 `json:"total"`
	Page     int   `json:"page"`
	PageSize int   `json:"page_size"`
}

type Postgres struct {
	DB    *gorm.DB
	SQLDB *sql.DB
	// contains filtered or unexported fields
}

type PostgresConfig = DatabaseConfig

type TxManager struct {
	// contains filtered or unexported fields
}