database

type CachedSchema struct {
	Type       reflect.Type
	Fields     []FieldInfo
	Insertable []FieldInfo
	PKIndex    int
	FieldMap   map[string]FieldInfo

	InsertColsMysql  string
	InsertPlaceMysql string
	InsertColsPG     string
	InsertPlacePG    string
}

type Config struct {
	Type       string
	NullAble   bool
	Identity   bool
	PrimaryKey bool
	Unique     bool
}

type Database[T any] interface {
	Create(string, map[string]Config) error
	GetTable(string, T) (Table[T], error)
	DeleteTable(string) error

	// Close releases resources such as connection pools. Backends holding
	// none return nil. Safe to call more than once.
	Close() error
}

type DbType int

type FieldInfo struct {
	Index       int
	ColumnName  string
	IsAutoInc   bool
	IsNullable  bool
	IsPrimary   bool
	IsUnique    bool
	GoFieldName string
	GoKind      reflect.Kind
}

type FieldNotFoundError struct {
	Name string
}

type Options struct {
	// Order sorts the result, applied in the order given.
	Order []Order
	// Limit caps the row count; zero or less means no cap.
	Limit int
	// Offset skips rows.
	Offset int
}

type Order struct {
	Column string
	Desc   bool
}

type ScanTypeError struct {
	Got reflect.Type
}

type Table[T any] interface {
	// Ins inserts one row.
	Ins(val T, ttl time.Duration) error

	// Get reads the rows matching whereFields, whose values are taken from
	// val. An empty whereFields matches every row. opts narrows and orders the
	// result.
	Get(val T, whereFields []string, opts Options, ttl time.Duration) ([]T, error)

	// Set updates rows where the columns named in whereFields equal their
	// values in old, assigning the columns named in setFields the values in
	// updated. Passing the same model for both is the common case.
	Set(old, updated T, whereFields, setFields []string, ttl time.Duration) error

	// Del removes the rows matching whereFields, whose values are taken from
	// val.
	Del(val T, whereFields []string, ttl time.Duration) error
}