Documentation
¶
Index ¶
- func Exec(tbl sqlapi.Table, req require.Requirement, query string, args ...interface{}) (int64, error)
- func Query(tbl sqlapi.Table, query string, args ...interface{}) (*sql.Rows, error)
- func QueryOneNullThing(tbl sqlapi.Table, req require.Requirement, holder interface{}, query string, ...) error
- func ReplaceTableName(tbl sqlapi.Table, query string) string
- func SliceFloat32List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]float32, error)
- func SliceFloat64List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]float64, error)
- func SliceInt16List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]int16, error)
- func SliceInt32List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]int32, error)
- func SliceInt64List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]int64, error)
- func SliceInt8List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]int8, error)
- func SliceIntList(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]int, error)
- func SliceStringList(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]string, error)
- func SliceUint16List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]uint16, error)
- func SliceUint32List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]uint32, error)
- func SliceUint64List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]uint64, error)
- func SliceUint8List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]uint8, error)
- func SliceUintList(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, ...) ([]uint, error)
- func UpdateFields(tbl sqlapi.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 sqlapi.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 Query ¶
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 sqlapi.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 SliceFloat32List ¶
func SliceFloat32List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]float32, error)
SliceFloat32List requests a columnar slice of float32s from a specified column.
func SliceFloat64List ¶
func SliceFloat64List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]float64, error)
SliceFloat64List requests a columnar slice of float64s from a specified column.
func SliceInt16List ¶
func SliceInt16List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]int16, error)
SliceInt16List requests a columnar slice of int16s from a specified column.
func SliceInt32List ¶
func SliceInt32List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]int32, error)
SliceInt32List requests a columnar slice of int32s from a specified column.
func SliceInt64List ¶
func SliceInt64List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]int64, error)
SliceInt64List requests a columnar slice of int64s from a specified column.
func SliceInt8List ¶
func SliceInt8List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]int8, error)
SliceInt8List requests a columnar slice of int8s from a specified column.
func SliceIntList ¶
func SliceIntList(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]int, error)
SliceIntList requests a columnar slice of ints from a specified column.
func SliceStringList ¶
func SliceStringList(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]string, error)
SliceStringList requests a columnar slice of strings from a specified column.
func SliceUint16List ¶
func SliceUint16List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]uint16, error)
SliceUint16List requests a columnar slice of uint16s from a specified column.
func SliceUint32List ¶
func SliceUint32List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]uint32, error)
SliceUint32List requests a columnar slice of uint32s from a specified column.
func SliceUint64List ¶
func SliceUint64List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]uint64, error)
SliceUint64List requests a columnar slice of uint64s from a specified column.
func SliceUint8List ¶
func SliceUint8List(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]uint8, error)
SliceUint8List requests a columnar slice of uint8 from a specified column.
func SliceUintList ¶
func SliceUintList(tbl sqlapi.Table, req require.Requirement, sqlname string, wh where.Expression, qc where.QueryConstraint) ([]uint, error)
SliceUintList requests a columnar slice of uints from a specified column.
func UpdateFields ¶
func UpdateFields(tbl sqlapi.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.
Source Files