README
¶
Sqlp
Sqlp is a library which provides several features for database/sql and only depend on the stdlib database/sql.
Compatibility
- Compatible with go 1.16+
Features
- Use raw sql via custom handlers when needed
- Make object-relational mapping easier to use
Installing
go mod:
go get github.com/valord577/sqlp
Example
- See example
Changes
See the CHANGES for changes.
License
See the LICENSE for Rights and Limitations (MIT).
Documentation
¶
Index ¶
- Variables
- type DBSession
- func (s *DBSession) BeginTx() (*TxSession, error)
- func (s *DBSession) DisablePrepStmtAtDBSession()
- func (s *DBSession) DisablePrepStmtAtTxSession()
- func (s *DBSession) EnablePrepStmtAtDBSession()
- func (s *DBSession) EnablePrepStmtAtTxSession()
- func (s *DBSession) ExecSql(sql string, args ...interface{}) (goSql.Result, error)
- func (s *DBSession) ExecSqlDirect(sql string, args ...interface{}) (goSql.Result, error)
- func (s *DBSession) QuerySql(dest interface{}, sql string, args ...interface{}) error
- func (s *DBSession) QuerySqlDirect(dest interface{}, sql string, args ...interface{}) error
- func (s *DBSession) UseRawSqlHandler(h RawSqlHandler)
- type RawSqlHandler
- type TxSession
- func (t *TxSession) Commit() error
- func (t *TxSession) ExecSql(sql string, args ...interface{}) (goSql.Result, error)
- func (t *TxSession) ExecSqlDirect(sql string, args ...interface{}) (goSql.Result, error)
- func (t *TxSession) QuerySql(dest interface{}, sql string, args ...interface{}) error
- func (t *TxSession) QuerySqlDirect(dest interface{}, sql string, args ...interface{}) error
- func (t *TxSession) Rollback() error
Constants ¶
This section is empty.
Variables ¶
var ErrTooManyResults = errors.New("expected one result (or nil), but found multiple")
ErrTooManyResults triggered when sql result rows more than one and no more variable to scan
Functions ¶
This section is empty.
Types ¶
type DBSession ¶
type DBSession struct {
// contains filtered or unexported fields
}
DBSession provides a set of extensions on database/sql
func (*DBSession) DisablePrepStmtAtDBSession ¶
func (s *DBSession) DisablePrepStmtAtDBSession()
DisablePrepStmtAtDBSession disable prepared statement at DBSession
func (*DBSession) DisablePrepStmtAtTxSession ¶
func (s *DBSession) DisablePrepStmtAtTxSession()
DisablePrepStmtAtTxSession disable prepared statement at TxSession
func (*DBSession) EnablePrepStmtAtDBSession ¶
func (s *DBSession) EnablePrepStmtAtDBSession()
EnablePrepStmtAtDBSession enable prepared statement at DBSession
func (*DBSession) EnablePrepStmtAtTxSession ¶
func (s *DBSession) EnablePrepStmtAtTxSession()
EnablePrepStmtAtTxSession enable prepared statement at TxSession
func (*DBSession) ExecSqlDirect ¶ added in v0.2.20210914
ExecSql execute sql at DBSession without JIT
func (*DBSession) QuerySqlDirect ¶ added in v0.2.20210914
QuerySql execute query sql at DBSession without JIT
func (*DBSession) UseRawSqlHandler ¶
func (s *DBSession) UseRawSqlHandler(h RawSqlHandler)
UseRawSqlHandler formats prepared statement to raw sql
type RawSqlHandler ¶
RawSqlHandler formats stmt as raw sql,
more info: http://go-database-sql.org/prepared.html
type TxSession ¶
type TxSession struct {
// contains filtered or unexported fields
}
TxSession provides a set of extensions on database/sql
func (*TxSession) ExecSqlDirect ¶ added in v0.2.20210914
ExecSql execute sql at TxSession without JIT
func (*TxSession) QuerySqlDirect ¶ added in v0.2.20210914
QuerySql execute query sql at TxSession without JIT
Source Files