sequel

type AutoIncrKeyer interface {
	PrimaryKeyer
	IsAutoIncr()
}

type BasicTypes interface {
	string | bool | int64 | float64 | []byte | time.Time
}

type ColumnClause[T any] interface {
	ColumnName() string
	Value() T
}

type ColumnConvertClause[T any] interface {
	ColumnClause[T]
	Convert(T) any
}

type ColumnValuer interface {
	Tabler
	Columner
	Valuer
}

type Columner interface {
	Columns() []string
}

type CompositeKeyer interface {
	Keyer
	CompositeKey() ([]string, []int, []any)
}

type ConvertFunc[T any] func(T) any

type DB interface {
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
	QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error)
	QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row
}

type Databaser interface {
	DatabaseName() string
}

type EmptyResult struct{}

type InsertColumner interface {
	InsertColumns() []string
}

type Inserter interface {
	ColumnValuer
	InsertPlaceholders(row int) string
}

type KeyDeleter interface {
	Keyer
	DeleteOneByPKStmt() (string, []any)
}

type KeyFinder interface {
	Keyer
	FindOneByPKStmt() (string, []any)
}

type KeyUpdater interface {
	Keyer
	UpdateOneByPKStmt() (string, []any)
}

type KeyValueScanner[T any] interface {
	KeyValuer
	PtrScanner[T]
}

type KeyValuer interface {
	Keyer
	Tabler
	Columner
	Valuer
}

type Keyer interface {
	HasPK()
}

type OrderByClause interface {
	ColumnName() string
	Asc() bool
}

type PrimaryKeyer interface {
	Keyer
	PK() (string, int, any)
}

type PtrScanner[T any] interface {
	*T
	Scanner
}

type QueryFunc func(placeholder string) string

type SQLColumnClause[T any] interface {
	ColumnConvertClause[T]
	SQLColumn(placeholder string) string
}

type SQLColumner interface {
	SQLColumns() []string
}

type Scanner interface {
	Addrs() []any
}

type SetClause func(StmtBuilder)

type SingleInserter interface {
	InsertOneStmt() (string, []any)
}

type Stmt interface {
	StmtBuilder
	fmt.Formatter
	Query() string
	Args() []any
	Reset()
}

type StmtBuilder interface {
	StmtWriter
	Var(v any) string
	// Vars will group the valus in parenthesis
	Vars(vals []any) string
}

type StmtWriter interface {
	io.Writer
	io.StringWriter
	io.ByteWriter
}

type TableName struct{}

type Tabler interface {
	TableName() string
}

type Valuer interface {
	Values() []any
}

type WhereClause func(StmtBuilder)