sql

Documentation

Index

• type Conn
  • func (c *Conn) BeginTx(ctx context.Context, opts *sql.TxOptions) (*Tx, error)
  • func (c *Conn) Close(ctx context.Context) error
  • func (c *Conn) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)
  • func (c *Conn) Ping(ctx context.Context) error
  • func (c *Conn) Prepare(ctx context.Context, query string) (*Stmt, error)
  • func (c *Conn) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
  • func (c *Conn) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row
• type DB
  • func FromDB(db *sql.DB) *DB
  • func Open(driverName, dataSourceName string) (*DB, error)
  • func OpenDB(c driver.Connector) *DB
  • func (db *DB) BeginTx(ctx context.Context, opts *sql.TxOptions) (*Tx, error)
  • func (db *DB) Close(ctx context.Context) error
  • func (db *DB) Conn(ctx context.Context) (*Conn, error)
  • func (db *DB) DB() *sql.DB
  • func (db *DB) Driver(ctx context.Context) driver.Driver
  • func (db *DB) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)
  • func (db *DB) Ping(ctx context.Context) error
  • func (db *DB) Prepare(ctx context.Context, query string) (*Stmt, error)
  • func (db *DB) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
  • func (db *DB) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row
  • func (db *DB) SetConnMaxLifetime(d time.Duration)
  • func (db *DB) SetMaxIdleConns(n int)
  • func (db *DB) SetMaxOpenConns(n int)
  • func (db *DB) Stats(ctx context.Context) sql.DBStats
• type DSNInfo
• type Stmt
  • func (s *Stmt) Close(ctx context.Context) error
  • func (s *Stmt) Exec(ctx context.Context, args ...interface{}) (sql.Result, error)
  • func (s *Stmt) Query(ctx context.Context, args ...interface{}) (*sql.Rows, error)
  • func (s *Stmt) QueryRow(ctx context.Context, args ...interface{}) *sql.Row
• type Tx
  • func (tx *Tx) Commit(ctx context.Context) error
  • func (tx *Tx) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)
  • func (tx *Tx) Prepare(ctx context.Context, query string) (*Stmt, error)
  • func (tx *Tx) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
  • func (tx *Tx) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row
  • func (tx *Tx) Rollback(ctx context.Context) error
  • func (tx *Tx) Stmt(ctx context.Context, stmt *Stmt) *Stmt

Types

type Conn

type Conn struct {
	// contains filtered or unexported fields
}

Conn represents a single database connection.

func (*Conn) BeginTx

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

BeginTx starts a transaction.

func (*Conn) Close

func (c *Conn) Close(ctx context.Context) error

Close returns the connection to the connection pool.

func (*Conn) Exec

func (c *Conn) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

Exec executes a query without returning any rows.

func (*Conn) Ping

func (c *Conn) Ping(ctx context.Context) error

Ping verifies the connection to the database is still alive.

func (*Conn) Prepare

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

Prepare creates a prepared statement for later queries or executions.

func (*Conn) Query

func (c *Conn) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

Query executes a query that returns rows.

func (*Conn) QueryRow

func (c *Conn) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

QueryRow executes a query that is expected to return at most one row.

type DB

type DB struct {
	// contains filtered or unexported fields
}

DB contains the underlying db to be traced.

func FromDB

func FromDB(db *sql.DB) *DB

FromDB wraps an opened db. This allows to support libraries that provide *sql.DB like sqlmock.

func Open

func Open(driverName, dataSourceName string) (*DB, error)

Open opens a database.

func OpenDB

func OpenDB(c driver.Connector) *DB

OpenDB opens a database.

func (*DB) BeginTx

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

BeginTx starts a transaction.

func (*DB) Close

func (db *DB) Close(ctx context.Context) error

Close closes the database, releasing any open resources.

func (*DB) Conn

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

Conn returns a connection.

func (*DB) DB

func (db *DB) DB() *sql.DB

DB returns the underlying db. This is useful for SQL code that does not require tracing.

func (*DB) Driver

func (db *DB) Driver(ctx context.Context) driver.Driver

Driver returns the database's underlying driver.

func (*DB) Exec

func (db *DB) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

Exec executes a query without returning any rows.

func (*DB) Ping

func (db *DB) Ping(ctx context.Context) error

Ping verifies a connection to the database is still alive, establishing a connection if necessary.

func (*DB) Prepare

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

Prepare creates a prepared statement for later queries or executions.

func (*DB) Query

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

Query executes a query that returns rows.

func (*DB) QueryRow

func (db *DB) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

QueryRow executes a query that is expected to return at most one row.

func (*DB) SetConnMaxLifetime

func (db *DB) SetConnMaxLifetime(d time.Duration)

SetConnMaxLifetime sets the maximum amount of time a connection may be reused.

func (*DB) SetMaxIdleConns

func (db *DB) SetMaxIdleConns(n int)

SetMaxIdleConns sets the maximum number of connections in the idle connection pool.

func (*DB) SetMaxOpenConns

func (db *DB) SetMaxOpenConns(n int)

SetMaxOpenConns sets the maximum number of open connections to the database.

func (*DB) Stats

func (db *DB) Stats(ctx context.Context) sql.DBStats

Stats returns database statistics.

type DSNInfo

type DSNInfo struct {
	Driver   string
	DBName   string
	Address  string
	User     string
	Protocol string
}

DSNInfo contains information extracted from a valid connection string. Additional parameters provided are discarded.

type Stmt

type Stmt struct {
	// contains filtered or unexported fields
}

Stmt is a prepared statement.

func (*Stmt) Close

func (s *Stmt) Close(ctx context.Context) error

Close closes the statement.

func (*Stmt) Exec

func (s *Stmt) Exec(ctx context.Context, args ...interface{}) (sql.Result, error)

Exec executes a prepared statement.

func (*Stmt) Query

func (s *Stmt) Query(ctx context.Context, args ...interface{}) (*sql.Rows, error)

Query executes a prepared query statement.

func (*Stmt) QueryRow

func (s *Stmt) QueryRow(ctx context.Context, args ...interface{}) *sql.Row

QueryRow executes a prepared query statement.

type Tx

type Tx struct {
	// contains filtered or unexported fields
}

Tx is an in-progress database transaction.

func (*Tx) Commit

func (tx *Tx) Commit(ctx context.Context) error

Commit commits the transaction.

func (*Tx) Exec

func (tx *Tx) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

Exec executes a query that doesn't return rows.

func (*Tx) Prepare

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

Prepare creates a prepared statement for use within a transaction.

func (*Tx) Query

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

Query executes a query that returns rows.

func (*Tx) QueryRow

func (tx *Tx) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

QueryRow executes a query that is expected to return at most one row.

func (*Tx) Rollback

func (tx *Tx) Rollback(ctx context.Context) error

Rollback aborts the transaction.

func (*Tx) Stmt

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

Stmt returns a transaction-specific prepared statement from an existing statement.