Documentation ¶
Index ¶
- Constants
- type Connection
- type DB
- func (db *DB) Begin() (*sql.Tx, error)
- func (db *DB) BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)
- func (db *DB) BeginTxx(ctx context.Context, opts *sql.TxOptions) (*sqlx.Tx, error)
- func (db *DB) Close() error
- func (db *DB) DatabaseMaster() *sql.DB
- func (db *DB) DatabaseSlave(i int) *sql.DB
- func (db *DB) Exec(query string, args ...interface{}) (sql.Result, error)
- func (db *DB) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)
- func (db *DB) Get(des interface{}, query string, args ...interface{}) error
- func (db *DB) GetContext(ctx context.Context, des interface{}, query string, args ...interface{}) error
- func (db *DB) InGetContext(ctx context.Context, des interface{}, inQuery string, inArgs ...interface{}) error
- func (db *DB) InSelectContext(ctx context.Context, des interface{}, inQuery string, inArgs ...interface{}) error
- func (db *DB) Master() *sqlx.DB
- func (db *DB) Ping() error
- func (db *DB) PingContext(ctx context.Context) error
- func (db *DB) Query(query string, args ...interface{}) (*sql.Rows, error)
- func (db *DB) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
- func (db *DB) QueryRow(query string, args ...interface{}) *sql.Row
- func (db *DB) QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row
- func (db *DB) QueryRowx(query string, args ...interface{}) *sqlx.Row
- func (db *DB) QueryRowxContext(ctx context.Context, query string, args ...interface{}) *sqlx.Row
- func (db *DB) Queryx(query string, args ...interface{}) (*sqlx.Rows, error)
- func (db *DB) QueryxContext(ctx context.Context, query string, args ...interface{}) (*sqlx.Rows, error)
- func (db *DB) Select(des interface{}, query string, args ...interface{}) error
- func (db *DB) SelectContext(ctx context.Context, des interface{}, query string, args ...interface{}) error
- func (db *DB) SetConnMaxLifetime(d time.Duration)
- func (db *DB) SetMaxIdleConns(n int)
- func (db *DB) SetMaxOpenConns(n int)
- func (db *DB) Slave() *sqlx.DB
- type TLSConfig
Constants ¶
const ( // Master read / write database Master = "master" // Slave or read only database Slave = "slave" )
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type Connection ¶
type Connection struct { Username string Password string DatabaseName string Host string Port int Type string // master or slave TLS TLSConfig }
Connection connection details
type DB ¶
type DB struct {
// contains filtered or unexported fields
}
DB database connection
func (*DB) Begin ¶
Begin starts a transaction on the master. The isolation level is dependent on the driver.
func (*DB) DatabaseMaster ¶
DatabaseMaster relates sql package master database connection
func (*DB) DatabaseSlave ¶
DatabaseSlave relates sql package slave database connection
func (*DB) ExecContext ¶
func (db *DB) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)
ExecContext executes a query without returning any rows.
func (*DB) GetContext ¶
func (db *DB) GetContext(ctx context.Context, des interface{}, query string, args ...interface{}) error
GetContext gets a single row query into an interface
func (*DB) InGetContext ¶
func (db *DB) InGetContext(ctx context.Context, des interface{}, inQuery string, inArgs ...interface{}) error
In Get Context
func (*DB) InSelectContext ¶
func (db *DB) InSelectContext(ctx context.Context, des interface{}, inQuery string, inArgs ...interface{}) error
In Select Context
func (*DB) PingContext ¶
PingContext verifies if a connection to each physical database is still alive
func (*DB) QueryContext ¶
func (db *DB) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
QueryContext executes a query that returns rows, typically a SELECT.
func (*DB) QueryRowContext ¶
QueryRowContext executes a query that is expected to return at most one row.
func (*DB) QueryRowxContext ¶
QueryRowxContext
func (*DB) QueryxContext ¶
func (db *DB) QueryxContext(ctx context.Context, query string, args ...interface{}) (*sqlx.Rows, error)
QueryxContext returns the query x with context
func (*DB) SelectContext ¶
func (db *DB) SelectContext(ctx context.Context, des interface{}, query string, args ...interface{}) error
SelectContext executes a query that is expected to return at most one row if not more
func (*DB) SetConnMaxLifetime ¶
SetConnMaxLifetime sets the maximum amount of time a connection may be reused.
func (*DB) SetMaxIdleConns ¶
SetMaxIdleConns sets the maximum number of connections in the idle
func (*DB) SetMaxOpenConns ¶
SetMaxOpenConns sets the maximum number of open connections