support

func Exec ¶

func Exec(tbl sqlgen2.Table, req require.Requirement, query string, args ...interface{}) (int64, error)

Exec executes a modification query (insert, update, delete, etc) and returns the number of items affected.

func GetInt64List ¶ added in v0.13.0

func GetInt64List(tbl sqlgen2.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]int64, error)

func QueryOneNullThing ¶

func QueryOneNullThing(tbl sqlgen2.Table, req require.Requirement, holder interface{}, query string, args ...interface{}) error

QueryOneNullThing queries for one cell of one record. Normally, the holder will be sql.NullString or similar.

func ReplaceTableName ¶

func ReplaceTableName(tbl sqlgen2.Table, query string) string

ReplaceTableName replaces all occurrences of "{TABLE}" with the table's name.

func UpdateFields ¶

func UpdateFields(tbl sqlgen2.Table, req require.Requirement, wh where.Expression, fields ...sql.NamedArg) (int64, error)

UpdateFields writes certain fields of all the records matching a 'where' expression.