persist

type CacheHandler interface {
	Set([]byte, []byte) error
	SetWithTTL([]byte, []byte, time.Duration) error
	Get([]byte) ([]byte, error)
	GetTTL([]byte) (time.Duration, error)
	Del(...[]byte) error

	Close() error
}

type DBConfig struct {
	Type         string // "mysql" 或 "sqlite"，可扩展 "pg"
	Host         string // MySQL/PG
	Port         int    // MySQL/PG
	DBName       string // MySQL/PG
	Args         string // 连接参数
	Username     string // MySQL/PG
	Password     string // MySQL/PG
	Path         string // SQLite 路径
	ShowSQL      bool   // 是否显示 SQL 日志
	MaxOpenConns int    // 最大连接数
	MaxIdleConns int    // 最大空闲连接数
}

type DBHandler interface {
	DB() *gorm.DB
	Query(param *QueryParam) *gorm.DB
	// auto migrate
	AutoMigrate(dst ...any) error
	// tx
	Begin(opts ...*sql.TxOptions) DBHandler
	Commit() error
	Rollback() error

	Close() error
	// 兼容 go-sqlbuilder，执行原生SQL
	ExecSQL(ctx context.Context, sql string, args ...interface{}) (*gorm.DB, error)
	RawQuery(ctx context.Context, sql string, args ...interface{}) (*gorm.DB, error)
}

type EqFilter struct {
	Name  string
	Value any
}

type FieldOrder struct {
	Field    string
	Reversed bool
}

type Filter interface {
	Where(db *gorm.DB) *gorm.DB
}

type Filters []Filter

type InFilter[T any] struct {
	Name   string
	Values []T
}

type JSONArrayContainsFilter struct {
	Name  string
	Value any
}

type LikeFilter struct {
	Name  string
	Value string
}

type Model interface {
	CacheKey() string
	CacheTTL() time.Duration
}

type NeFilter struct {
	Name  string
	Value any
}

type Number interface {
	~int | ~int32 | ~int64 | ~uint | ~uint32 | ~uint64 | ~float32 | ~float64
}

type Option func(db *gorm.DB) *gorm.DB

type OrFilter[T any] struct {
	Name   string
	Values []T
}

type Order interface {
	Order(db *gorm.DB) *gorm.DB
}

type OriginalOrFilter struct {
	Filters Filters
}

type OriginalWhereFilter struct {
	Query string
	Args  []any
}

type PeriodFilter struct {
	Name  string
	Start time.Time
	End   time.Time
}

type PrefixFilter struct {
	*LikeFilter
}

type QueryParam struct {
	Filters Filters
	Page    *meta.Paging
	Options []Option
}

type RangeFilter[T Number] struct {
	Name  string
	Start T
	End   T
}

type SuffixFilter struct {
	*LikeFilter
}