db

Nov 11, 2020

Changes in this version

type Q

+ func (m Q) BuildFilter(ctx context.Context, filters []F, sql string) (string, error)

Oct 30, 2020

Changes in this version

+ func NotFound(err error) bool

+ func ScanAll(dst interface{}, rows Rows) error

+ func ScanOne(dst interface{}, rows Rows) error

+ func ScanRow(dst interface{}, rows Rows) error

+ type RowScanner struct

+ func NewRowScanner(rows Rows) *RowScanner

+ func (rs *RowScanner) Scan(dst interface{}) error

+ type Rows interface

+ Close func() error

+ Columns func() ([]string, error)

+ Err func() error

+ Next func() bool

+ Scan func(dest ...interface{}) error

Sep 21, 2020

Changes in this version

+ const FieldLogicNotIn

Sep 16, 2020

Changes in this version

+ const FieldLogicEgt

+ const FieldLogicElt

+ const FieldLogicEq

+ const FieldLogicGt

+ const FieldLogicIn

+ const FieldLogicLeftLike

+ const FieldLogicLike

+ const FieldLogicLt

+ const FieldLogicNeq

+ const FieldLogicRightLike

+ const FieldTypeDate

+ const FieldTypeDateTime

+ const FieldTypeInteger

+ const FieldTypeListMultiple

+ const FieldTypeListOne

+ const FieldTypePositiveInteger

+ const FieldTypePositiveRealNumber

+ const FieldTypeRealNumber

+ const FieldTypeText

+ const IsMultipleFalse

+ const IsMultipleTrue

+ func IsDuplicateEntryErr(err error) bool

+ func IsNoRowsErr(err error) bool

+ func Reset()

+ type C struct

+ Data string

+ OnDuplicateKeyUpdate []string

+ TableName string

+ func (m C) BuildSQL(ctx context.Context) (sql string, err error)

+ type Conn interface

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

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

+ QueryRowContext func(ctx context.Context, query Query, args ...interface{}) *sql.Row

+ type DB struct

+ func Get(ctx context.Context, name string) *DB

+ func (db *DB) ExecContext(ctx context.Context, query Query, args ...interface{}) (sql.Result, error)

+ func (db *DB) ExecTx(ctx context.Context, f TxFunc) error

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

+ func (db *DB) QueryRowContext(ctx context.Context, query Query, args ...interface{}) *sql.Row

+ type F struct

+ FieldLogic int64

+ FieldName string

+ FieldType int64

+ IsMultiple int64

+ Value string

+ func (f F) BuildFilter(ctx context.Context, filters []F, sql string) (string, error)

+ type Q struct

+ CurrentPage int64

+ Filters []F

+ PageSize int64

+ ReplaceGroupBy string

+ ReplaceOrderBy string

+ Sql string

+ func (m Q) BuildSql(ctx context.Context) (sql string, err error)

+ type Query struct

+ func SQLDelete(table string, sql string) Query

+ func SQLInsert(table string, sql string) Query

+ func SQLSelect(table string, sql string) Query

+ func SQLUpdate(table string, sql string) Query

+ type Row interface

+ Scan func(dest ...interface{}) error

+ type Tx struct

+ func (tx *Tx) ExecContext(ctx context.Context, query Query, args ...interface{}) (sql.Result, error)

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

+ func (tx *Tx) QueryRowContext(ctx context.Context, query Query, args ...interface{}) *sql.Row

+ type TxFunc func(ctx context.Context, tx Conn) error

+ type U struct

+ Data string

+ Filters []F

+ SQL string

+ func (m U) BuildSQL(ctx context.Context) (sql string, err error)