sqlutil

Apr 4, 2023

Changes in this version

+ func DeleteWithOptions(ctx context.Context, db Querier, flavor Flavor, tableName string, ...) error

+ func UpdateWithOptions(ctx context.Context, db Querier, flavor Flavor, tableName string, ...) error

+ type DeleteOptions = sqlquery.DeleteOptions

+ func NewDeleteOptions(flavor Flavor) *DeleteOptions

+ type UpdateOptions = sqlquery.UpdateOptions

+ func NewUpdateOptions(flavor Flavor) *UpdateOptions

Jul 24, 2021

Changes in this version

+ type Querier interface

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

Jul 23, 2021

Changes in this version

+ func Delete(ctx context.Context, db *sql.DB, flavor Flavor, tableName string, ...) error

+ func DeleteQuery(flavor Flavor, tableName string, id interface{}) (string, []interface{})

+ func FindAllQuery(tableName string, options *FindAllOptions) (string, []interface{})

+ func FindQuery(tableName string, options *FindOptions) (string, []interface{})

+ func Get(ctx context.Context, db *sql.DB, tableName string, options *FindOptions, ...) error

+ func Insert(ctx context.Context, db *sql.DB, flavor Flavor, tag, tableName string, ...) error

+ func InsertQuery(flavor Flavor, tag, tableName string, structValue interface{}) (string, []interface{})

+ func Select(ctx context.Context, db *sql.DB, tableName string, options *FindAllOptions, ...) error

+ func Update(ctx context.Context, db *sql.DB, flavor Flavor, tag, tableName string, ...) error

+ func UpdateQuery(flavor Flavor, tag, tableName string, id interface{}, structValue interface{}) (string, []interface{})

+ type FindAllOptions struct

+ Fields []string

+ Filters map[string]interface{}

+ Flavor Flavor

+ Limit int

+ Offset int

+ OrderBy string

+ func NewFindAllOptions(flavor Flavor) *FindAllOptions

+ func (f *FindAllOptions) WithFields(fields []string) *FindAllOptions

+ func (f *FindAllOptions) WithFilter(field string, value interface{}) *FindAllOptions

+ func (f *FindAllOptions) WithLimit(limit int) *FindAllOptions

+ func (f *FindAllOptions) WithOffset(offset int) *FindAllOptions

+ func (f *FindAllOptions) WithOrderBy(orderBy string) *FindAllOptions

+ type FindOptions struct

+ Fields []string

+ Filters map[string]interface{}

+ Flavor Flavor

+ func NewFindOptions(flavor Flavor) *FindOptions

+ func (f *FindOptions) WithFields(fields []string) *FindOptions

+ func (f *FindOptions) WithFilter(field string, value interface{}) *FindOptions

+ type Flavor int

+ const MySQLFlavor

+ const PostgreSQLFlavor

+ const SQLiteFlavor