sqlex

package module

Go to main page

Versions in this module

v1

v1.5.3

Jun 26, 2026

Changes in this version

type Rows

+ func (r *Rows) NextResultSet() bool

v1.5.2

Jun 23, 2026

Changes in this version

type DB

+ func NewDB(db *sql.DB, driverName string, opts ...Opt) *DB

+ type OpType string

+ const OpBegin

+ const OpCommit

+ const OpExec

+ const OpQuery

+ const OpRollback

type QueryEvent

+ LastInsertID int64

+ RowsAffected int64

v1.5.1

Jun 18, 2026

v1.5.0

Jun 16, 2026

Changes in this version

+ const AT

+ const DOLLAR

+ const NAMED

+ const QUESTION

+ const UNKNOWN

+ var NameMapper = strings.ToLower

+ func AsList(slice any) any

+ func AsValue(v any) any

+ func BindDriver(driverName string, bindType int)

+ func BindNamed(bindType int, query string, arg any) (string, []any, error)

+ func BindType(driverName string) int

+ func Get(q Queryer, dest any, query string, args ...any) error

+ func GetContext(ctx context.Context, q QueryerContext, dest any, query string, args ...any) error

+ func In(query string, args ...any) (string, []any, error)

+ func MapScan(r ColScanner, dest map[string]any) error

+ func MustExec(e Execer, query string, args ...any) sql.Result

+ func MustExecContext(ctx context.Context, e ExecerContext, query string, args ...any) sql.Result

+ func Named(query string, arg any) (string, []any, error)

+ func NamedExec(e Ext, query string, arg any) (sql.Result, error)

+ func NamedExecContext(ctx context.Context, e ExtContext, query string, arg any) (sql.Result, error)

+ func Rebind(bindType int, query string) string

+ func ScanAll(rows rowsi, dest any) error

+ func Select(q Queryer, dest any, query string, args ...any) error

+ func SelectContext(ctx context.Context, q QueryerContext, dest any, query string, args ...any) error

+ func SliceScan(r ColScanner) ([]any, error)

+ func StructScan(rows rowsi, dest any) error

+ type BindExt interface

+ Exec func(query string, args ...any) (sql.Result, error)

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

+ Get func(dest any, query string, args ...any) error

+ GetContext func(ctx context.Context, dest any, query string, args ...any) error

+ QueryRowx func(query string, args ...any) *Row

+ QueryRowxContext func(ctx context.Context, query string, args ...any) *Row

+ Queryx func(query string, args ...any) (*Rows, error)

+ QueryxContext func(ctx context.Context, query string, args ...any) (*Rows, error)

+ Select func(dest any, query string, args ...any) error

+ SelectContext func(ctx context.Context, dest any, query string, args ...any) error

+ type ColScanner interface

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

+ Err func() error

+ Scan func(dest ...any) error

+ type Conn struct

+ Mapper *reflectx.Mapper

+ func (c *Conn) BeginTxx(ctx context.Context, opts *sql.TxOptions) (*Tx, error)

+ func (c *Conn) BindNamed(query string, arg any) (string, []any, error)

+ func (c *Conn) DriverName() string

+ func (c *Conn) Exec(query string, args ...any) (sql.Result, error)

+ func (c *Conn) ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)

+ func (c *Conn) Get(dest any, query string, args ...any) error

+ func (c *Conn) GetContext(ctx context.Context, dest any, query string, args ...any) error

+ func (c *Conn) GetMapper() *reflectx.Mapper

+ func (c *Conn) IsStrict() bool

+ func (c *Conn) MustExec(query string, args ...any) sql.Result

+ func (c *Conn) MustExecContext(ctx context.Context, query string, args ...any) sql.Result

+ func (c *Conn) NamedExec(query string, arg any) (sql.Result, error)

+ func (c *Conn) NamedExecContext(ctx context.Context, query string, arg any) (sql.Result, error)

+ func (c *Conn) NamedGet(dest any, query string, param any) error

+ func (c *Conn) NamedGetContext(ctx context.Context, dest any, query string, param any) error

+ func (c *Conn) NamedQuery(query string, arg any) (*Rows, error)

+ func (c *Conn) NamedQueryContext(ctx context.Context, query string, arg any) (*Rows, error)

+ func (c *Conn) NamedSelect(dest any, query string, param any) error

+ func (c *Conn) NamedSelectContext(ctx context.Context, dest any, query string, param any) error

+ func (c *Conn) Prepare(query string) (*sql.Stmt, error)

+ func (c *Conn) PrepareNamedContext(ctx context.Context, query string) (*NamedStmt, error)

+ func (c *Conn) PreparexContext(ctx context.Context, query string) (*Stmt, error)

+ func (c *Conn) Query(query string, args ...any) (*sql.Rows, error)

+ func (c *Conn) QueryRowx(query string, args ...any) *Row

+ func (c *Conn) QueryRowxContext(ctx context.Context, query string, args ...any) *Row

+ func (c *Conn) Queryx(query string, args ...any) (*Rows, error)

+ func (c *Conn) QueryxContext(ctx context.Context, query string, args ...any) (*Rows, error)

+ func (c *Conn) Rebind(query string) string

+ func (c *Conn) Select(dest any, query string, args ...any) error

+ func (c *Conn) SelectContext(ctx context.Context, dest any, query string, args ...any) error

+ func (c *Conn) SetStrict(strict bool)

+ type DB struct

+ Mapper *reflectx.Mapper

+ func Connect(driverName, dataSourceName string, opts ...Opt) (*DB, error)

+ func ConnectContext(ctx context.Context, driverName, dataSourceName string, opts ...Opt) (*DB, error)

+ func MustConnect(driverName, dataSourceName string, opts ...Opt) *DB

+ func MustOpen(driverName, dataSourceName string, opts ...Opt) *DB

+ func NewDb(db *sql.DB, driverName string, opts ...Opt) *DB

+ func Open(driverName, dataSourceName string, opts ...Opt) (*DB, error)

+ func (db *DB) AddHook(hook Hook)

+ func (db *DB) BeginTxx(ctx context.Context, opts *sql.TxOptions) (*Tx, error)

+ func (db *DB) Beginx() (*Tx, error)

+ func (db *DB) BindNamed(query string, arg any) (string, []any, error)

+ func (db *DB) Connx(ctx context.Context) (*Conn, error)

+ func (db *DB) DriverName() string

+ func (db *DB) Exec(query string, args ...any) (sql.Result, error)

+ func (db *DB) ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)

+ func (db *DB) Get(dest any, query string, args ...any) error

+ func (db *DB) GetContext(ctx context.Context, dest any, query string, args ...any) error

+ func (db *DB) GetMapper() *reflectx.Mapper

+ func (db *DB) IsStrict() bool

+ func (db *DB) MapperFunc(mf func(string) string)

+ func (db *DB) MustBegin() *Tx

+ func (db *DB) MustBeginTxx(ctx context.Context, opts *sql.TxOptions) *Tx

+ func (db *DB) MustExec(query string, args ...any) sql.Result

+ func (db *DB) MustExecContext(ctx context.Context, query string, args ...any) sql.Result

+ func (db *DB) NamedExec(query string, arg any) (sql.Result, error)

+ func (db *DB) NamedExecContext(ctx context.Context, query string, arg any) (sql.Result, error)

+ func (db *DB) NamedGet(dest any, query string, param any) error

+ func (db *DB) NamedGetContext(ctx context.Context, dest any, query string, param any) error

+ func (db *DB) NamedQuery(query string, arg any) (*Rows, error)

+ func (db *DB) NamedQueryContext(ctx context.Context, query string, arg any) (*Rows, error)

+ func (db *DB) NamedSelect(dest any, query string, param any) error

+ func (db *DB) NamedSelectContext(ctx context.Context, dest any, query string, param any) error

+ func (db *DB) PrepareNamed(query string) (*NamedStmt, error)

+ func (db *DB) PrepareNamedContext(ctx context.Context, query string) (*NamedStmt, error)

+ func (db *DB) Preparex(query string) (*Stmt, error)

+ func (db *DB) PreparexContext(ctx context.Context, query string) (*Stmt, error)

+ func (db *DB) QueryRowx(query string, args ...any) *Row

+ func (db *DB) QueryRowxContext(ctx context.Context, query string, args ...any) *Row

+ func (db *DB) Queryx(query string, args ...any) (*Rows, error)

+ func (db *DB) QueryxContext(ctx context.Context, query string, args ...any) (*Rows, error)

+ func (db *DB) Rebind(query string) string

+ func (db *DB) Select(dest any, query string, args ...any) error

+ func (db *DB) SelectContext(ctx context.Context, dest any, query string, args ...any) error

+ func (db *DB) SetStrict(strict bool)

+ type Execer interface

+ Exec func(query string, args ...any) (sql.Result, error)

+ type ExecerContext interface

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

+ type Ext interface

+ type ExtContext interface

+ type Hook interface

+ AfterQuery func(ctx context.Context, event *QueryEvent)

+ BeforeQuery func(ctx context.Context, event *QueryEvent) context.Context

+ type NamedExt interface

+ NamedExec func(query string, arg any) (sql.Result, error)

+ NamedExecContext func(ctx context.Context, query string, arg any) (sql.Result, error)

+ NamedGet func(dest any, query string, param any) error

+ NamedGetContext func(ctx context.Context, dest any, query string, param any) error

+ NamedQuery func(query string, arg any) (*Rows, error)

+ NamedQueryContext func(ctx context.Context, query string, arg any) (*Rows, error)

+ NamedSelect func(dest any, query string, param any) error

+ NamedSelectContext func(ctx context.Context, dest any, query string, param any) error

+ type NamedStmt struct

+ Params []string

+ QueryString string

+ Stmt *Stmt

+ func (n *NamedStmt) Close() error

+ func (n *NamedStmt) Exec(arg any) (sql.Result, error)

+ func (n *NamedStmt) ExecContext(ctx context.Context, arg any) (sql.Result, error)

+ func (n *NamedStmt) Get(dest any, arg any) error

+ func (n *NamedStmt) GetContext(ctx context.Context, dest any, arg any) error

+ func (n *NamedStmt) GetMapper() *reflectx.Mapper

+ func (n *NamedStmt) MustExec(arg any) sql.Result

+ func (n *NamedStmt) MustExecContext(ctx context.Context, arg any) sql.Result

+ func (n *NamedStmt) Query(arg any) (*sql.Rows, error)

+ func (n *NamedStmt) QueryContext(ctx context.Context, arg any) (*sql.Rows, error)

+ func (n *NamedStmt) QueryRow(arg any) *Row

+ func (n *NamedStmt) QueryRowContext(ctx context.Context, arg any) *Row

+ func (n *NamedStmt) QueryRowx(arg any) *Row

+ func (n *NamedStmt) QueryRowxContext(ctx context.Context, arg any) *Row

+ func (n *NamedStmt) Queryx(arg any) (*Rows, error)

+ func (n *NamedStmt) QueryxContext(ctx context.Context, arg any) (*Rows, error)

+ func (n *NamedStmt) Select(dest any, arg any) error

+ func (n *NamedStmt) SelectContext(ctx context.Context, dest any, arg any) error

+ type Opt func(db *DB)

+ func WithHooks(hooks ...Hook) Opt

+ func WithMapperFunc(mf func(string) string) Opt

+ type Preparer interface

+ Prepare func(query string) (*sql.Stmt, error)

+ type PreparerContext interface

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, error)

+ type QueryEvent struct

+ Args []any

+ Duration time.Duration

+ Error error

+ OperationType string

+ Query string

+ StartTime time.Time

+ type Queryer interface

+ Query func(query string, args ...any) (*sql.Rows, error)

+ QueryRowx func(query string, args ...any) *Row

+ Queryx func(query string, args ...any) (*Rows, error)

+ type QueryerContext interface

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

+ QueryRowxContext func(ctx context.Context, query string, args ...any) *Row

+ QueryxContext func(ctx context.Context, query string, args ...any) (*Rows, error)

+ type Row struct

+ Mapper *reflectx.Mapper

+ func (r *Row) ColumnTypes() ([]*sql.ColumnType, error)

+ func (r *Row) Columns() ([]string, error)

+ func (r *Row) Err() error

+ func (r *Row) GetMapper() *reflectx.Mapper

+ func (r *Row) MapScan(dest map[string]any) error

+ func (r *Row) Scan(dest ...any) error

+ func (r *Row) SliceScan() ([]any, error)

+ func (r *Row) StructScan(dest any) error

+ type Rows struct

+ Mapper *reflectx.Mapper

+ func NamedQuery(e Ext, query string, arg any) (*Rows, error)

+ func NamedQueryContext(ctx context.Context, e ExtContext, query string, arg any) (*Rows, error)

+ func (r *Rows) GetMapper() *reflectx.Mapper

+ func (r *Rows) MapScan(dest map[string]any) error

+ func (r *Rows) SliceScan() ([]any, error)

+ func (r *Rows) StructScan(dest any) error

+ type Stmt struct

+ Mapper *reflectx.Mapper

+ func Preparex(p Preparer, query string) (*Stmt, error)

+ func PreparexContext(ctx context.Context, p PreparerContext, query string) (*Stmt, error)

+ func (s *Stmt) Exec(args ...any) (sql.Result, error)

+ func (s *Stmt) ExecContext(ctx context.Context, args ...any) (sql.Result, error)

+ func (s *Stmt) Get(dest any, args ...any) error

+ func (s *Stmt) GetContext(ctx context.Context, dest any, args ...any) error

+ func (s *Stmt) GetMapper() *reflectx.Mapper

+ func (s *Stmt) MustExec(args ...any) sql.Result

+ func (s *Stmt) MustExecContext(ctx context.Context, args ...any) sql.Result

+ func (s *Stmt) Query(args ...any) (*sql.Rows, error)

+ func (s *Stmt) QueryContext(ctx context.Context, args ...any) (*sql.Rows, error)

+ func (s *Stmt) QueryRowx(args ...any) *Row

+ func (s *Stmt) QueryRowxContext(ctx context.Context, args ...any) *Row

+ func (s *Stmt) Queryx(args ...any) (*Rows, error)

+ func (s *Stmt) QueryxContext(ctx context.Context, args ...any) (*Rows, error)

+ func (s *Stmt) Select(dest any, args ...any) error

+ func (s *Stmt) SelectContext(ctx context.Context, dest any, args ...any) error

+ type Tx struct

+ Mapper *reflectx.Mapper

+ func (tx *Tx) BindNamed(query string, arg any) (string, []any, error)

+ func (tx *Tx) CloseWithErr(err error)

+ func (tx *Tx) DriverName() string

+ func (tx *Tx) Exec(query string, args ...any) (sql.Result, error)

+ func (tx *Tx) ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)

+ func (tx *Tx) ExecFunc(fn func(tx *Tx))

+ func (tx *Tx) Get(dest any, query string, args ...any) error

+ func (tx *Tx) GetContext(ctx context.Context, dest any, query string, args ...any) error

+ func (tx *Tx) GetMapper() *reflectx.Mapper

+ func (tx *Tx) IsStrict() bool

+ func (tx *Tx) MustExec(query string, args ...any) sql.Result

+ func (tx *Tx) MustExecContext(ctx context.Context, query string, args ...any) sql.Result

+ func (tx *Tx) NamedExec(query string, arg any) (sql.Result, error)

+ func (tx *Tx) NamedExecContext(ctx context.Context, query string, arg any) (sql.Result, error)

+ func (tx *Tx) NamedGet(dest any, query string, param any) error

+ func (tx *Tx) NamedGetContext(ctx context.Context, dest any, query string, param any) error

+ func (tx *Tx) NamedQuery(query string, arg any) (*Rows, error)

+ func (tx *Tx) NamedQueryContext(ctx context.Context, query string, arg any) (*Rows, error)

+ func (tx *Tx) NamedSelect(dest any, query string, param any) error

+ func (tx *Tx) NamedSelectContext(ctx context.Context, dest any, query string, param any) error

+ func (tx *Tx) NamedStmt(stmt *NamedStmt) *NamedStmt

+ func (tx *Tx) NamedStmtContext(ctx context.Context, stmt *NamedStmt) *NamedStmt

+ func (tx *Tx) PrepareNamed(query string) (*NamedStmt, error)

+ func (tx *Tx) PrepareNamedContext(ctx context.Context, query string) (*NamedStmt, error)

+ func (tx *Tx) Preparex(query string) (*Stmt, error)

+ func (tx *Tx) PreparexContext(ctx context.Context, query string) (*Stmt, error)

+ func (tx *Tx) QueryRowx(query string, args ...any) *Row

+ func (tx *Tx) QueryRowxContext(ctx context.Context, query string, args ...any) *Row

+ func (tx *Tx) Queryx(query string, args ...any) (*Rows, error)

+ func (tx *Tx) QueryxContext(ctx context.Context, query string, args ...any) (*Rows, error)

+ func (tx *Tx) Rebind(query string) string

+ func (tx *Tx) Select(dest any, query string, args ...any) error

+ func (tx *Tx) SelectContext(ctx context.Context, dest any, query string, args ...any) error

+ func (tx *Tx) SetStrict(strict bool)

+ func (tx *Tx) Stmtx(stmt any) *Stmt

+ func (tx *Tx) StmtxContext(ctx context.Context, stmt any) *Stmt

+ func (tx *Tx) TryStmtx(stmt any) (*Stmt, error)

+ func (tx *Tx) TryStmtxContext(ctx context.Context, stmt any) (*Stmt, error)

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL