sqlx

package module
v0.0.0-...-17c47d9 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 8, 2014 License: MIT Imports: 14 Imported by: 0

README

#sqlx

Build Status

sqlx is a library which provides a set of extensions on go's standard database/sql library. The sqlx versions of sql.DB, sql.TX, sql.Stmt, et al. all leave the underlying interfaces untouched, so that their interfaces are a superset on the standard ones. This makes it relatively painless to integrate existing codebases using database/sql with sqlx.

Major additional concepts are:

  • Marshal rows into structs (with embedded struct support), maps, and slices
  • Named parameter support including prepared statements
  • Get and Select to go quickly from query to struct/slice
  • Common error handling mnemonics (eg. Execf, Execp (MustExec), and Execl)
  • LoadFile for executing statements from a file

Read the usage below to see how sqlx might help you, or check out the API documentation on godoc.

install

go get github.com/jmoiron/sqlx

issues

Row headers can be ambiguous (SELECT 1 AS a, 2 AS a), and the result of Columns() can have duplicate names on queries like:

SELECT a.id, a.name, b.id, b.name FROM foos AS a JOIN foos AS b ON a.parent = b.id;

making a struct or map destination ambiguous. Use AS in your queries to give rows distinct names, rows.Scan to scan them manually, or SliceScan to get a slice of results.

usage

Below is an example which shows some common use cases for sqlx. Check sqlx_test.go for more usage.

package main

import (
    _ "github.com/lib/pq"
    "database/sql"
    "github.com/jmoiron/sqlx"
    "log"
)

var schema = `
CREATE TABLE person (
    first_name text,
    last_name text,
    email text
);

CREATE TABLE place (
    country text,
    city text NULL,
    telcode integer
)`

type Person struct {
    FirstName string `db:"first_name"`
    LastName  string `db:"last_name"`
    Email     string
}

type Place struct {
    Country string
    City    sql.NullString
    TelCode int
}

func main() {
    // this connects & tries a simple 'SELECT 1', panics on error
    // use sqlx.Open() for sql.Open() semantics
    db, err := sqlx.Connect("postgres", "user=foo dbname=bar sslmode=disable")
    if err != nil {
        log.Fatalln(err)
    }

    // exec the schema or fail; multi-statement Exec behavior varies between
    // database drivers;  pq will exec them all, sqlite3 won't, ymmv
    db.Execf(schema)
    
    tx := db.MustBegin()
    tx.Execl("INSERT INTO person (first_name, last_name, email) VALUES ($1, $2, $3)", "Jason", "Moiron", "jmoiron@jmoiron.net")
    tx.Execl("INSERT INTO person (first_name, last_name, email) VALUES ($1, $2, $3)", "John", "Doe", "johndoeDNE@gmail.net")
    tx.Execl("INSERT INTO place (country, city, telcode) VALUES ($1, $2, $3)", "United States", "New York", "1")
    tx.Execl("INSERT INTO place (country, telcode) VALUES ($1, $2)", "Hong Kong", "852")
    tx.Execl("INSERT INTO place (country, telcode) VALUES ($1, $2)", "Singapore", "65")
    // Named queries can use structs, so if you have an existing struct (i.e. person := &Person{}) that you have populated, you can pass it in as &person
    tx.NamedExec("INSERT INTO person (first_name, last_name, email) VALUES (:first_name, :last_name, :email)", &Person{"Jane", "Citizen", "jane.citzen@example.com"})
    tx.Commit()

    // Query the database, storing results in a []Person (wrapped in []interface{})
    people := []Person{}
    db.Select(&people, "SELECT * FROM person ORDER BY first_name ASC")
    jason, john := people[0], people[1]

    fmt.Printf("%#v\n%#v", jason, john)
    // Person{FirstName:"Jason", LastName:"Moiron", Email:"jmoiron@jmoiron.net"}
    // Person{FirstName:"John", LastName:"Doe", Email:"johndoeDNE@gmail.net"}

    // You can also get a single result, a la QueryRow
    jason = Person{}
    err = db.Get(&jason, "SELECT * FROM person WHERE first_name=$1", "Jason")
    fmt.Printf("%#v\n", jason)
    // Person{FirstName:"Jason", LastName:"Moiron", Email:"jmoiron@jmoiron.net"}

    // if you have null fields and use SELECT *, you must use sql.Null* in your struct
    places := []Place{}
    err := db.Select(&places, "SELECT * FROM place ORDER BY telcode ASC")
    if err != nil {
        fmt.Printf(err)
        return
    }
    usa, singsing, honkers = places[0], places[1], places[2]
    
    fmt.Printf("%#v\n%#v\n%#v\n", usa, singsing, honkers)
    // Place{Country:"United States", City:sql.NullString{String:"New York", Valid:true}, TelCode:1}
    // Place{Country:"Singapore", City:sql.NullString{String:"", Valid:false}, TelCode:65}
    // Place{Country:"Hong Kong", City:sql.NullString{String:"", Valid:false}, TelCode:852}

    // Loop through rows using only one struct
    place := Place{}
    rows, err := db.Queryx("SELECT * FROM place")
    for rows.Next() {
        err := rows.StructScan(&place)
        if err != nil {
            log.Fataln(err)
        } 
        fmt.Printf("%#v\n", place)
    }
    // Place{Country:"United States", City:sql.NullString{String:"New York", Valid:true}, TelCode:1}
    // Place{Country:"Hong Kong", City:sql.NullString{String:"", Valid:false}, TelCode:852}
    // Place{Country:"Singapore", City:sql.NullString{String:"", Valid:false}, TelCode:65}

    // Named queries, using `:name` as the bindvar.  Automatic bindvar support
    // which takes into account the dbtype based on the driverName on sqlx.Open/Connect
    _, err = db.NamedExec(`INSERT INTO person (first_name,last_name,email) VALUES (:first,:last,:email)`, 
        map[string]interface{}{
            "first": "Bin",
            "last": "Smuth",
            "email": "bensmith@allblacks.nz",
    })

    // Selects Mr. Smith from the database
    rows, err := db.NamedQuery(`SELECT * FROM person WHERE first_name=:fn`, map[string]interface{}{"fn": "Bin"})

    // Named queries can also use structs.  Their bind names follow the same rules
    // as the name -> db mapping, so struct fields are lowercased and the `db` tag
    // is taken into consideration.
    rows, err := db.NamedQuery(`SELECT * FROM person WHERE first_name=:first_name`, jason)
}

embedded structs

Structs which do not implement the sql.Scanner interface will be inspected and their fields used as possible targets for a scan. This includes embedded and non-embedded structs.

Go makes 'ambiguous selectors' a compile time error, but does not make structs with possible ambiguous selectors errors. Sqlx will decide which field to use on a struct based on a breadth first search of the struct and any structs it contains or embeds, as specified by the order of the fields as accessible by reflect, which generally means in source-order.

Documentation

Overview

Package sqlx provides general purpose extensions to database/sql.

sqlx is intended to seamlessly wrap database/sql and provide convenience methods which are useful in the development of database driven applications. None of the underlying database/sql methods are changed, instead all extended behavior is implemented through new methods defined on wrapper types.

sqlx adds struct scanning, named queries, query rebinding between drivers, convenient shorthand for common error handling, from-file query execution, and more.

Index

Constants

View Source
const (
	UNKNOWN = iota
	QUESTION
	DOLLAR
	NAMED
)

Bindvar types supported by sqlx's Rebind & BindMap/Struct functions.

Variables

View Source
var NameMapper = strings.ToLower

NameMapper is used to map column names to struct field names. By default, it uses strings.ToLower to lowercase struct field names. It can be set to whatever you want, but it is encouraged to be set before sqlx is used as field-to-name mappings are cached after first use on a type.

Functions

func BaseSliceType

func BaseSliceType(t reflect.Type) (reflect.Type, error)

BaseSliceType returns the type for a slice, dereferencing it if it is a pointer. Returns an error if the destination is not a slice or a pointer to a slice.

func BaseStructType

func BaseStructType(t reflect.Type) (reflect.Type, error)

BaseStructType returns the type of a struct, dereferencing it if it is a pointer. Returns an error if the destination is not a struct or a pointer to a struct.

func BindMap

func BindMap(bindType int, query string, args map[string]interface{}) (string, []interface{}, error)

BindMap binds a named parameter query with a map of arguments.

func BindStruct

func BindStruct(bindType int, query string, arg interface{}) (string, []interface{}, error)

BindStruct binds a named parameter query with fields from a struct argument. The rules for binding field names to parameter names follow the same conventions as for StructScan, including obeying the `db` struct tags.

func BindType

func BindType(driverName string) int

BindType returns the bindtype for a given database given a drivername

func Execf

func Execf(e Execer, query string, args ...interface{}) sql.Result

Execf (fatal) runs Exec on the query and args and uses log.Fatal to print the query, result, and error in the event of an error.

func Execl

func Execl(e Execer, query string, args ...interface{}) sql.Result

Execl (log) runs Exec on the query and args and ses log.Println to print the query, result, and error in the event of an error. Unlike Execv, Execl does not return the error, and can be used in single-value contexts.

Do not abuse Execl; it is convenient for experimentation but generally not for production use.

func Execp

func Execp(e Execer, query string, args ...interface{}) sql.Result

Execp (panic) runs Exec on the query and args and panics on error.

func Execv

func Execv(e Execer, query string, args ...interface{}) (sql.Result, error)

Execv (verbose) Exec's the query using the Execer and uses log.Println to print the query, result, and error in the event of an error.

func Get

func Get(q Queryer, dest interface{}, query string, args ...interface{}) error

Get does a QueryRow using the provided Queryer, and StructScan the resulting row into dest, which must be a pointer to a struct. If there was no row, Get will return sql.ErrNoRows like row.Scan would.

func LoadFile

func LoadFile(e Execer, path string) (*sql.Result, error)

LoadFile exec's every statement in a file (as a single call to Exec). LoadFile may return a nil *sql.Result if errors are encountered locating or reading the file at path. LoadFile reads the entire file into memory, so it is not suitable for loading large data dumps, but can be useful for initializing schemas or loading indexes. FIXME: this does not really work with multi-statement files for mattn/go-sqlite3 or the go-mysql-driver/mysql drivers; pq seems to be an exception here. Detecting this by requiring something with DriverName() and then attempting to split the queries will be difficult to get right, and its current driver-specific behavior is deemed at least not complex in its incorrectness.

func MapScan

func MapScan(r ColScanner, dest map[string]interface{}) error

MapScan scans a single Row into the dest map[string]interface{}. Use this to get results for SQL that might not be under your control (for instance, if you're building an interface for an SQL server that executes SQL from input). Please do not use this as a primary interface! This will modify the map sent to it in place, so do not reuse the same one on different queries or you may end up with something odd! Columns which occur more than once in the result will overwrite eachother!

The resultant map values will be string representations of the various SQL datatypes for existing values and a nil for null values.

func MustExec

func MustExec(e Execer, query string, args ...interface{}) sql.Result

MustExec (panic) is an alias for Execp.

func NamedExec

func NamedExec(e Ext, query string, arg interface{}) (sql.Result, error)

NamedExec uses BindStruct to get a query executable by the driver and then runs Exec on the result. Returns an error from the binding or the query excution itself.

func NamedExecMap

func NamedExecMap(e Ext, query string, argmap map[string]interface{}) (sql.Result, error)

NamedExecMap executes a named query using a map instead of a struct. DEPRECATED: Use NamedExec instead, which also supports maps.

func Rebind

func Rebind(bindType int, query string) string

Rebind a query from the default bindtype (QUESTION) to the target bindtype

func Select

func Select(q Queryer, dest interface{}, query string, args ...interface{}) error

Select executes a query using the provided Queryer, and StructScans each row into dest, which must be a slice of structs. The *sql.Rows are closed automatically.

func Selectf

func Selectf(q Queryer, dest interface{}, query string, args ...interface{})

Selectf (fatal) will Select using a Queryer and use log.Fatal to print the query and the error in the event of an error.

func Selectv

func Selectv(q Queryer, dest interface{}, query string, args ...interface{}) error

Selectv (verbose) will Select using a Queryer and use log.Println to print the query and the error in the event of an error.

func SliceScan

func SliceScan(r ColScanner) ([]interface{}, error)

SliceScan a row, returning a []interface{} with values similar to MapScan. This function is primarly intended for use where the number of columns is not known. Because you can pass an []interface{} directly to Scan, it's recommended that you do that as it will not have to allocate new slices per row.

func StructScan

func StructScan(rows *sql.Rows, dest interface{}) error

StructScan all rows from a sql.Rows into the dest slice. StructScan destinations MUST have fields that map to every column in the result, and they MAY have fields in addition to those. Fields are mapped to column names by lowercasing the field names by default: use the struct tag `db` to specify exact column names for each field.

StructScan will scan in the entire rows result, so if you need do not want to allocate structs for the entire result, use Queryx and see sqlx.Rows.StructScan.

Types

type Binder

type Binder interface {
	DriverName() string
	Rebind(string) string
	BindMap(string, map[string]interface{}) (string, []interface{}, error)
	BindStruct(string, interface{}) (string, []interface{}, error)
}

Binder is an interface for something which can bind queries (Tx, DB)

type ColScanner

type ColScanner interface {
	Columns() ([]string, error)
	Scan(dest ...interface{}) error
	Err() error
}

ColScanner is an interface for something which can Scan and return a list of columns (Row, Rows)

type DB

type DB struct {
	*sql.DB
	// contains filtered or unexported fields
}

DB is a wrapper around sql.DB which keeps track of the driverName upon Open, used mostly to automatically bind named queries using the right bindvars.

func Connect

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

Connect to a database and verify with a ping.

func MustConnect

func MustConnect(driverName, dataSourceName string) *DB

MustConnect connects to a database and panics on error.

func NewDb

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

NewDb returns a new sqlx DB wrapper for a pre-existing *sql.DB. The driverName of the original database is required for named query support.

func Open

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

Open is the same as database/sql's Open, but returns an *sqlx.DB instead.

func (*DB) Beginx

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

Beginx begins a transaction and returns an *sqlx.Tx instead of an *sql.Tx.

func (*DB) BindMap

func (db *DB) BindMap(query string, argmap map[string]interface{}) (string, []interface{}, error)

BindMap binds a query using the DB driver's bindvar type.

func (*DB) BindStruct

func (db *DB) BindStruct(query string, arg interface{}) (string, []interface{}, error)

BindStruct binds a query using the DB driver's bindvar type.

func (*DB) DriverName

func (db *DB) DriverName() string

DriverName returns the driverName passed to the Open function for this DB.

func (*DB) Execf

func (db *DB) Execf(query string, args ...interface{}) sql.Result

Execf (fatal) runs Execf using this database.

func (*DB) Execl

func (db *DB) Execl(query string, args ...interface{}) sql.Result

Execl (log) runs Execl using this database.

func (*DB) Execp

func (db *DB) Execp(query string, args ...interface{}) sql.Result

Execp (panic) runs Execp using this database.

func (*DB) Execv

func (db *DB) Execv(query string, args ...interface{}) (sql.Result, error)

Execv (verbose) runs Execv using this database.

func (*DB) Get

func (db *DB) Get(dest interface{}, query string, args ...interface{}) error

Get using this DB.

func (*DB) LoadFile

func (db *DB) LoadFile(path string) (*sql.Result, error)

LoadFile using this DB.

func (*DB) MustBegin

func (db *DB) MustBegin() *Tx

MustBegin starts a transaction, and panics on error. Returns an *sqlx.Tx instead of an *sql.Tx.

func (*DB) MustExec

func (db *DB) MustExec(query string, args ...interface{}) sql.Result

MustExec (panic) runs MustExec using this database.

func (*DB) NamedExec

func (db *DB) NamedExec(query string, arg interface{}) (sql.Result, error)

NamedExec using this DB.

func (*DB) NamedExecMap

func (db *DB) NamedExecMap(query string, argmap map[string]interface{}) (sql.Result, error)

NamedExecMap using this DB. DEPRECATED: use NamedExec instead

func (*DB) NamedQuery

func (db *DB) NamedQuery(query string, arg interface{}) (*Rows, error)

NamedQuery using this DB.

func (*DB) NamedQueryMap

func (db *DB) NamedQueryMap(query string, argmap map[string]interface{}) (*Rows, error)

NamedQueryMap using this DB. DEPRECATED: use NamedQuery instead.

func (*DB) PrepareNamed

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

PrepareNamed returns an sqlx.NamedStmt

func (*DB) Preparex

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

Preparex returns an sqlx.Stmt instead of a sql.Stmt

func (*DB) QueryRowx

func (db *DB) QueryRowx(query string, args ...interface{}) *Row

QueryRowx queries the database and returns an *sqlx.Row.

func (*DB) Queryx

func (db *DB) Queryx(query string, args ...interface{}) (*Rows, error)

Queryx queries the database and returns an *sqlx.Rows.

func (*DB) Rebind

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

Rebind transforms a query from QUESTION to the DB driver's bindvar type.

func (*DB) Select

func (db *DB) Select(dest interface{}, query string, args ...interface{}) error

Select using this DB.

func (*DB) Selectf

func (db *DB) Selectf(dest interface{}, query string, args ...interface{})

Selectf using this DB.

func (*DB) Selectv

func (db *DB) Selectv(dest interface{}, query string, args ...interface{}) error

Selectv using this DB.

type Execer

type Execer interface {
	Exec(query string, args ...interface{}) (sql.Result, error)
}

Execer is an interface for something which can Exec (Tx, DB, Stmt)

type Ext

type Ext interface {
	Binder
	Queryer
	Execer
}

Ext is a union interface which can bind, query, and exec (Tx, DB), used for NamedQuery and NamedExec, which requires exec/query and BindMap/Struct

type NamedStmt

type NamedStmt struct {
	Params      []string
	QueryString string
	Stmt        *Stmt
}

NamedStmt is a prepared statement that executes named queries. Prepare it how you would execute a NamedQuery, but pass in a struct or map when executing.

func (*NamedStmt) Close

func (n *NamedStmt) Close() error

Close closes the named statement.

func (*NamedStmt) Exec

func (n *NamedStmt) Exec(arg interface{}) (sql.Result, error)

Exec executes a named statement using the struct passed.

func (*NamedStmt) Execf

func (n *NamedStmt) Execf(arg interface{}) sql.Result

Execf execs a NamedStmt, using log.fatal to print out errors

func (*NamedStmt) Execl

func (n *NamedStmt) Execl(arg interface{}) sql.Result

Execl execs a NamedStmt with the given arg, logging errors

func (*NamedStmt) Execp

func (n *NamedStmt) Execp(arg interface{}) sql.Result

Execp execs a NamedStmt, panicing on error

func (*NamedStmt) Execv

func (n *NamedStmt) Execv(arg interface{}) (sql.Result, error)

Execv execs a NamedStmt with the given arg, printing errors and returning them

func (*NamedStmt) Get

func (n *NamedStmt) Get(dest interface{}, arg interface{}) error

Get using this NamedStmt

func (*NamedStmt) MustExec

func (n *NamedStmt) MustExec(arg interface{}) sql.Result

MustExec execs a NamedStmt, panicing on error

func (*NamedStmt) Query

func (n *NamedStmt) Query(arg interface{}) (*sql.Rows, error)

Query executes a named statement using the struct argument, returning rows.

func (*NamedStmt) QueryRow

func (n *NamedStmt) QueryRow(arg interface{}) *Row

QueryRow executes a named statement against the database. Because sqlx cannot create a *sql.Row with an error condition pre-set for binding errors, sqlx returns a *sqlx.Row instead.

func (*NamedStmt) QueryRowx

func (n *NamedStmt) QueryRowx(arg interface{}) *Row

QueryRowx this NamedStmt. Because of limitations with QueryRow, this is an alias for QueryRow.

func (*NamedStmt) Queryx

func (n *NamedStmt) Queryx(arg interface{}) (*Rows, error)

Queryx using this NamedStmt

func (*NamedStmt) Select

func (n *NamedStmt) Select(dest interface{}, arg interface{}) error

Select using this NamedStmt

func (*NamedStmt) Selectf

func (n *NamedStmt) Selectf(dest interface{}, arg interface{})

Selectf using this NamedStmt

func (*NamedStmt) Selectv

func (n *NamedStmt) Selectv(dest interface{}, arg interface{}) error

Selectv using this NamedStmt

type Preparer

type Preparer interface {
	Prepare(query string) (*sql.Stmt, error)
}

Preparer is an interface for something which can prepare sql statements (Tx, DB)

type Queryer

type Queryer interface {
	Query(query string, args ...interface{}) (*sql.Rows, error)
	Queryx(query string, args ...interface{}) (*Rows, error)
	QueryRowx(query string, args ...interface{}) *Row
}

Queryer is an interface for something which can Query (Tx, DB, Stmt)

type Row

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

Row is a reimplementation of sql.Row in order to gain access to the underlying sql.Rows.Columns() data, necessary for StructScan.

func (*Row) Columns

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

Columns returns the underlying sql.Rows.Columns(), or the deferred error usually returned by Row.Scan()

func (*Row) Err

func (r *Row) Err() error

Err returns the error encountered while scanning.

func (*Row) MapScan

func (r *Row) MapScan(dest map[string]interface{}) error

MapScan using this Rows.

func (*Row) Scan

func (r *Row) Scan(dest ...interface{}) error

Scan is a fixed implementation of sql.Row.Scan, which does not discard the underlying error from the internal rows object if it exists.

func (*Row) SliceScan

func (r *Row) SliceScan() ([]interface{}, error)

SliceScan using this Rows.

func (*Row) StructScan

func (r *Row) StructScan(dest interface{}) error

StructScan a single Row into dest.

type Rows

type Rows struct {
	sql.Rows
	// contains filtered or unexported fields
}

Rows is a wrapper around sql.Rows which caches costly reflect operations during a looped StructScan

func NamedQuery

func NamedQuery(e Ext, query string, arg interface{}) (*Rows, error)

NamedQuery binds a named query and then runs Query on the result using the provided Ext (sqlx.Tx, sqlx.Db). It works with both structs and with map[string]interface{} types.

func NamedQueryMap

func NamedQueryMap(e Ext, query string, argmap map[string]interface{}) (*Rows, error)

NamedQueryMap runs a named query using a map instead of a struct. DEPRECATED: Use NamedQuery instead, which also supports maps.

func (*Rows) MapScan

func (r *Rows) MapScan(dest map[string]interface{}) error

MapScan using this Rows.

func (*Rows) SliceScan

func (r *Rows) SliceScan() ([]interface{}, error)

SliceScan using this Rows.

func (*Rows) StructScan

func (r *Rows) StructScan(dest interface{}) error

StructScan is like sql.Rows.Scan, but scans a single Row into a single Struct. Use this and iterate over Rows manually when the memory load of Select() might be prohibitive. *Rows.StructScan caches the reflect work of matching up column positions to fields to avoid that overhead per scan, which means it is not safe to run StructScan on the same Rows instance with different struct types.

type Stmt

type Stmt struct{ *sql.Stmt }

Stmt is an sqlx wrapper around database/sql's Stmt with extra functionality

func Preparex

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

Preparex prepares a statement.

func (*Stmt) Execf

func (s *Stmt) Execf(args ...interface{}) sql.Result

Execf (fatal) using this statement. Note that the query portion of the error output will be blank, as Stmt does not expose its query.

func (*Stmt) Execl

func (s *Stmt) Execl(args ...interface{}) sql.Result

Execl (log) using this statement. Note that the query portion of the error output will be blank, as Stmt does not expose its query.

func (*Stmt) Execp

func (s *Stmt) Execp(args ...interface{}) sql.Result

Execp (panic) using this statement. Note that the query portion of the error output will be blank, as Stmt does not expose its query.

func (*Stmt) Execv

func (s *Stmt) Execv(args ...interface{}) (sql.Result, error)

Execv (verbose) runs Execv using this statement. Note that the query portion of the error output will be blank, as Stmt does not expose its query.

func (*Stmt) Get

func (s *Stmt) Get(dest interface{}, args ...interface{}) error

Get using the prepared statement.

func (*Stmt) MustExec

func (s *Stmt) MustExec(args ...interface{}) sql.Result

MustExec (panic) using this statement. Note that the query portion of the error output will be blank, as Stmt does not expose its query.

func (*Stmt) QueryRowx

func (s *Stmt) QueryRowx(args ...interface{}) *Row

QueryRowx using this statement.

func (*Stmt) Queryx

func (s *Stmt) Queryx(args ...interface{}) (*Rows, error)

Queryx using this statement.

func (*Stmt) Select

func (s *Stmt) Select(dest interface{}, args ...interface{}) error

Select using the prepared statement.

func (*Stmt) Selectf

func (s *Stmt) Selectf(dest interface{}, args ...interface{})

Selectf (fatal) using the prepared statement.

func (*Stmt) Selectv

func (s *Stmt) Selectv(dest interface{}, args ...interface{}) error

Selectv (verbose) using the prepared statement.

type Tx

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

Tx is an sqlx wrapper around database/sql's Tx with extra functionality

func (*Tx) BindMap

func (tx *Tx) BindMap(query string, argmap map[string]interface{}) (string, []interface{}, error)

BindMap binds a query within a transaction's bindvar type.

func (*Tx) BindStruct

func (tx *Tx) BindStruct(query string, arg interface{}) (string, []interface{}, error)

BindStruct binds a query within a transaction's bindvar type.

func (*Tx) DriverName

func (tx *Tx) DriverName() string

DriverName returns the driverName used by the DB which began this transaction.

func (*Tx) Execf

func (tx *Tx) Execf(query string, args ...interface{}) sql.Result

Execf (fatal) runs Execf within a transaction.

func (*Tx) Execl

func (tx *Tx) Execl(query string, args ...interface{}) sql.Result

Execl (log) runs Execl within a transaction.

func (*Tx) Execp

func (tx *Tx) Execp(query string, args ...interface{}) sql.Result

Execp (panic) runs Execp within a transaction.

func (*Tx) Execv

func (tx *Tx) Execv(query string, args ...interface{}) (sql.Result, error)

Execv (verbose) runs Execv within a transaction.

func (*Tx) Get

func (tx *Tx) Get(dest interface{}, query string, args ...interface{}) error

Get within a transaction.

func (*Tx) LoadFile

func (tx *Tx) LoadFile(path string) (*sql.Result, error)

LoadFile within a transaction.

func (*Tx) MustExec

func (tx *Tx) MustExec(query string, args ...interface{}) sql.Result

MustExec runs MustExec within a transaction.

func (*Tx) NamedExec

func (tx *Tx) NamedExec(query string, arg interface{}) (sql.Result, error)

NamedExec a named query within a transaction.

func (*Tx) NamedExecMap

func (tx *Tx) NamedExecMap(query string, arg map[string]interface{}) (sql.Result, error)

NamedExecMap a named query within a transaction. DEPRECATED: Use NamedExec instead

func (*Tx) NamedQuery

func (tx *Tx) NamedQuery(query string, arg interface{}) (*Rows, error)

NamedQuery within a transaction.

func (*Tx) NamedQueryMap

func (tx *Tx) NamedQueryMap(query string, arg map[string]interface{}) (*Rows, error)

NamedQueryMap within a transaction. DEPRECATED: Use NamedQuery instead

func (*Tx) NamedStmt

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

NamedStmt returns a version of the prepared statement which runs within a transaction.

func (*Tx) PrepareNamed

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

PrepareNamed returns an sqlx.NamedStmt

func (*Tx) Preparex

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

Preparex a statement within a transaction.

func (*Tx) QueryRowx

func (tx *Tx) QueryRowx(query string, args ...interface{}) *Row

QueryRowx within a transaction.

func (*Tx) Queryx

func (tx *Tx) Queryx(query string, args ...interface{}) (*Rows, error)

Queryx within a transaction.

func (*Tx) Rebind

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

Rebind a query within a transaction's bindvar type.

func (*Tx) Select

func (tx *Tx) Select(dest interface{}, query string, args ...interface{}) error

Select within a transaction.

func (*Tx) Selectf

func (tx *Tx) Selectf(dest interface{}, query string, args ...interface{})

Selectf (fatal) within a transaction.

func (*Tx) Selectv

func (tx *Tx) Selectv(dest interface{}, query string, args ...interface{}) error

Selectv (verbose) within a transaction.

func (*Tx) Stmtx

func (tx *Tx) Stmtx(stmt interface{}) *Stmt

Stmtx returns a version of the prepared statement which runs within a transaction. Provided stmt can be either *sql.Stmt or *sqlx.Stmt.

Directories

Path Synopsis

Jump to

Keyboard shortcuts

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