db

type Completer interface {
	/*
	 *	set update data
	 * 	m equals struct matching db relation
	 */
	Set(m map[string]interface{}) Completer
	/*
	 * 	execute non returning query like update and delete
	 */
	Apply() error
	/*
	 * 	execute non returning query like update and delete with context
	 */
	ApplyCtx(ctx context.Context) error
	/*
	 * 	execute non returning query like update and delete with context in a transaction
	 */
	TxApplyCtx(ctx context.Context, tx *sql.Tx) error
	/*
	 * 	execute select or queries returning many rows
	 */
	Many(i interface{}) error
	/*
	 * 	execute select or queries returning many rows with context
	 */
	ManyCtx(ctx context.Context, i interface{}) error
	/*
	 * 	execute select or queries returning many rows with context in a transaction
	 */
	TxManyCtx(ctx context.Context, tx *sql.Tx, i interface{}) error
	/*
	 * 	execute select scan into provided interface
	 */
	One(i interface{}) error
	/*
	 * 	execute select scan into provided interface with context
	 */
	OneCtx(ctx context.Context, i interface{}) error
	/*
	 * 	execute select scan into provided interface with context in a transaction
	 */
	TxOneCtx(ctx context.Context, tx *sql.Tx, i interface{}) error
	/*
	 *	where condition
	 *	could be map[string]interface{} or []map[string]interface{}
	 *  e.g. map[string]interface{ "id": 1 }
	 */
	Where(any) Completer
	/*
	 * 	perform query for values in list
	 */
	In(field string, values []interface{}) Completer
	/*
	 * limit query result
	 */
	Take(limit int64) Completer
	/*
	 * offset query result
	 */
	Skip(offset int64) Completer
}

type Query struct {
	Conn *sql.DB
}