db

type Condition struct {
	Column string
	Op     Operator
	Value  any
}

type DataManipulater interface {
	Select(ctx context.Context, table string, columns func() map[string]any, where []Condition) (Result, error)
	Insert(ctx context.Context, table string, rows []map[string]any) (Result, error)
	Update(ctx context.Context, table string, assignments map[string]any, conditions map[string]any) error
	Delete(ctx context.Context, table string, conditions map[string]any) error

	CreateTables(context.Context, []Table) error
	CreateIndexes(context.Context, []Index) error
	CreateViews(context.Context, []View) error
	DropTables(context.Context, []Table) error

	Close() error
}

type Index struct {
	Name  string
	Table string
	Cols  []string
}

type JSON map[string]any

type KVDBer interface {
	Get(ctx context.Context, key ...string) (map[string][]byte, error)
	Put(ctx context.Context, entries map[string][]byte, ttl time.Duration) error
	Delete(ctx context.Context, key ...string) error
	List(ctx context.Context, prefix *string, limit *uint) ([]string, uint64, error)
	DeleteAll(ctx context.Context) error
	Head(ctx context.Context, key ...string) (bool, error)

	Close() error
}

type Mapper interface {
	CreateTable() []Table
	CreateIndexes() []Index
	CreateViews() []View
}

type Operator = uint8

type Result struct {
	LastID *int64
	Rows   []JSON
}

type Table struct {
	Name    string   `json:"name"`
	Columns []string `json:"columns"`
}

type View struct {
	Name   string
	Select string
}