db

type Builder interface {
	Sql() goqu.DialectWrapper
	SqlSelect() *goqu.SelectDataset
	SqlInsert() *goqu.InsertDataset
	SqlUpdate() *goqu.UpdateDataset
	SqlDelete() *goqu.DeleteDataset
}

type Client interface {
	GetClient() *sqlx.DB
	IsConnected() bool
	Connect() error
	Disconnect()
}

type ConnectionOptions interface {
	Apply(db *sqlx.DB) error
}

type Counter interface {
	Count() (int64, error)
	CountWhere(fieldValues map[string]any) (int64, error)
}

type Deleter interface {
	Delete(qry *goqu.DeleteDataset) error
	DeleteWhere(fieldNameValue map[string]any) error
	DeleteByKey(keyField string, value any) error
}

type Dialect interface {
}

type Executor interface {
	Exec(qry *goqu.SelectDataset) error
	RawExec(sql string, args ...any) error
	Select(sql string, target any, args ...any) error
}

type FV map[string]any // alias for fieldValues maps

type FnRepositoryFactory func(ctx context.Context, conn *SqlClient, tableName string) Repository

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

type GridError struct {
	Scope   string `json:"scope"`
	Field   string `json:"field"`
	Message string `json:"message"`
}

type GridFilterFunc func(lookupValue any) (any, error)

type GridOps interface {
	Grid(record any) (*Grid, error)
	QueryGrid(record any, args *GridQuery, dest any) error
}

type GridQuery struct {
	SearchType   uint              `db:"searchType"`
	SearchText   string            `json:"searchText,omitempty"`
	FilterFields map[string]any    `json:"filterFields,omitempty"`
	SortFields   map[string]string `json:"sortFields,omitempty"`
	Offset       uint              `json:"offset,omitempty"`
	Limit        uint              `json:"limit,omitempty"`
}

type Identifier interface {
	Db() *sqlx.DB
	Name() string
}

type Reader interface {
	FetchOne(qry *goqu.SelectDataset, target any) error
	FetchRecord(fieldValues map[string]any, target any) error
	Fetch(qry *goqu.SelectDataset, target any) error
	FetchWhere(fieldValues map[string]any, target any) error
	FetchByKey(keyField string, value any, target any) error
	Exists(fieldName string, fieldValue any, skip ...any) (bool, error)
}

type Repository interface {
	Identifier
	Builder
	Reader
	Executor
	Writer
	Deleter
	Updater
	Counter
	GridOps
	SqlBuilder
	NewTransaction(opts *sql.TxOptions) (Transaction, error)
}

type SqlAdapter interface {
	sqlx.QueryerContext
	sqlx.ExecerContext
	SqlxReaderCtx
}

type SqlBuilder interface {
	SqlDialect() qb.SqlDialect
	SqlBuilder() *qb.SqlBuilder
	SqlUpdateX(record any) *qb.UpdateBuilder
	Do(qry any, target ...any) error
}

type SqlClient struct {
	Conn       *sqlx.DB
	Dsn        string
	DriverName string
	// contains filtered or unexported fields
}

type SqlxReaderCtx interface {
	SelectContext(ctx context.Context, dest interface{}, query string, args ...interface{}) error
}

type Transaction interface {
	Builder
	Reader
	Executor
	Writer
	Deleter
	Updater
	Counter
	SqlBuilder
	Db() *sqlx.Tx
	Name() string

	Commit() error
	Rollback() error
}

type Updater interface {
	Update(qry *goqu.UpdateDataset) error
	UpdateReturning(record any, whereFieldsValues map[string]any, returnFields []string, target ...any) error
	UpdateRecord(record any, whereFieldsValues map[string]any) error
	UpdateFields(record any, fieldsValues map[string]any, whereFieldsValues map[string]any) error
	UpdateFieldsReturning(record any, fieldsValues map[string]any, whereFieldsValues map[string]any, returnFields []string, target ...any) error
	UpdateByKey(record any, keyField string, value any) error
}

type Writer interface {
	Insert(records ...any) error
	InsertReturning(record any, returnFields []string, target ...any) error
}