db

package
v0.0.0-...-f013270 Latest Latest
Warning

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

Go to latest
Published: May 27, 2017 License: Apache-2.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

View Source
const (
	MYSQL      = "mysql"
	POSTGRESQL = "postgres"
	SQLITE3    = "sqlite3"
)

Variables

This section is empty.

Functions

func DefaultEngine

func DefaultEngine() string

func IsErrNoRows

func IsErrNoRows(err error) bool

func IsErrTxDone

func IsErrTxDone(err error) bool

func Open

func Open(engine, source string, opts ...Option) error

func RegisterDialect

func RegisterDialect(engine string, d dbr.Dialect)

func SetDefaultEngine

func SetDefaultEngine(engine string)

Types

type Builder

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

func (Builder) And

func (Builder) And(cond ...dbr.Builder) dbr.Builder

func (*Builder) Build

func (this *Builder) Build(stmt dbr.Builder) (string, error)

func (Builder) DeleteBySQL

func (Builder) DeleteBySQL(query string, value ...interface{}) *dbr.DeleteStmt

func (Builder) DeleteFrom

func (Builder) DeleteFrom(table string) *dbr.DeleteStmt

func (Builder) Eq

func (Builder) Eq(column string, value interface{}) dbr.Builder

func (Builder) Expr

func (Builder) Expr(query string, value ...interface{}) dbr.Builder

func (Builder) Gt

func (Builder) Gt(column string, value interface{}) dbr.Builder

func (Builder) Gte

func (Builder) Gte(column string, value interface{}) dbr.Builder

func (Builder) I

func (Builder) I(s string) dbr.I

func (Builder) InsertBySQL

func (Builder) InsertBySQL(query string, value ...interface{}) *dbr.InsertStmt

func (Builder) InsertInto

func (Builder) InsertInto(table string) *dbr.InsertStmt

func (Builder) Lt

func (Builder) Lt(column string, value interface{}) dbr.Builder

func (Builder) Lte

func (Builder) Lte(column string, value interface{}) dbr.Builder

func (*Builder) MustBuild

func (this *Builder) MustBuild(stmt dbr.Builder) string

func (Builder) Neq

func (Builder) Neq(column string, value interface{}) dbr.Builder

func (Builder) Or

func (Builder) Or(cond ...dbr.Builder) dbr.Builder

func (Builder) Order

func (Builder) Order(col string, desc bool) Order

func (*Builder) Select

func (this *Builder) Select(colunm ...string) *dbr.SelectStmt

func (Builder) SelectBySQL

func (Builder) SelectBySQL(query string, value ...interface{}) *dbr.SelectStmt

func (Builder) SelectEx

func (Builder) SelectEx(colunm ...interface{}) *dbr.SelectStmt

func (Builder) Update

func (Builder) Update(table string) *dbr.UpdateStmt

func (Builder) UpdateBySQL

func (Builder) UpdateBySQL(query string, value ...interface{}) *dbr.UpdateStmt

func (Builder) Where

func (Builder) Where(where dbr.Builder) Where

type Conn

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

func Get

func Get(engine string) (*Conn, error)

func MustGet

func MustGet(engine string) *Conn

func New

func New(engine, source string, opts ...Option) (*Conn, error)

func (*Conn) BeginTx

func (this *Conn) BeginTx() (*Tx, error)

func (*Conn) ExecStmt

func (this *Conn) ExecStmt(stmt dbr.Builder, args ...interface{}) (sql.Result, error)

func (*Conn) QueryRowStmt

func (this *Conn) QueryRowStmt(stmt dbr.Builder, args ...interface{}) *sql.Row

func (*Conn) QueryStmt

func (this *Conn) QueryStmt(stmt dbr.Builder, args ...interface{}) (*sql.Rows, error)

func (*Conn) SQL

func (this *Conn) SQL() *Builder

type Executor

type Executor interface {
	ExecStmt(stmt dbr.Builder, args ...interface{}) (sql.Result, error)
	QueryStmt(stmt dbr.Builder, args ...interface{}) (*sql.Rows, error)
	QueryRowStmt(stms dbr.Builder, args ...interface{}) *sql.Row
	SQL() *Builder
}

type Option

type Option func(*Conn)

func ConnMaxLifeTime

func ConnMaxLifeTime(d time.Duration) Option

func MaxIdleConns

func MaxIdleConns(n int) Option

func MaxOpenConns

func MaxOpenConns(n int) Option

type Order

type Order struct {
	Column string
	DESC   bool
}

type RowScanner

type RowScanner interface {
	Scan(...interface{}) error
}

type Tx

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

func (*Tx) ExecStmt

func (this *Tx) ExecStmt(stmt dbr.Builder, args ...interface{}) (sql.Result, error)

func (*Tx) QueryRowStmt

func (this *Tx) QueryRowStmt(stmt dbr.Builder, args ...interface{}) *sql.Row

func (*Tx) QueryStmt

func (this *Tx) QueryStmt(stmt dbr.Builder, args ...interface{}) (*sql.Rows, error)

func (*Tx) SQL

func (this *Tx) SQL() *Builder

type Where

type Where struct {
	Where dbr.Builder
	Query string
	Conds []interface{}
}

func (*Where) Builder

func (w *Where) Builder() dbr.Builder

Jump to

Keyboard shortcuts

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