Documentation
¶
Index ¶
- func Exec(tbl sqlgen2.Table, req require.Requirement, query string, args ...interface{}) (int64, error)
- func GetInt64List(tbl sqlgen2.Table, req require.Requirement, sqlname string, ...) ([]int64, error)
- func Query(tbl sqlgen2.Table, query string, args ...interface{}) (*sql.Rows, error)
- func QueryOneNullThing(tbl sqlgen2.Table, req require.Requirement, holder interface{}, query string, ...) error
- func ReplaceTableName(tbl sqlgen2.Table, query string) string
- func UpdateFields(tbl sqlgen2.Table, req require.Requirement, wh where.Expression, ...) (int64, error)
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
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.
The query is logged using whatever logger is configured. If an error arises, this too is logged.
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 Query ¶ added in v0.16.0
Query is the low-level request method for this table.
The query is logged using whatever logger is configured. If an error arises, this too is logged.
The args are for any placeholder parameters in the query.
The caller must call rows.Close() on the result.
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 ¶
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.
Types ¶
This section is empty.