db

package module
v1.0.0 Latest Latest
Warning

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

Go to latest
Published: Aug 16, 2020 License: MIT Imports: 10 Imported by: 1

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Connection

type Connection struct {
	Hostname string
	Port     int
	Username string
	Password string
	Name     string
	// contains filtered or unexported fields
}

Connection ...

func NewConnection

func NewConnection(host string, port int, username, password, name string) (*Connection, error)

NewConnection ...

func (*Connection) Begin

func (c *Connection) Begin() (*Tx, error)

Begin ...

func (*Connection) Close

func (c *Connection) Close() error

Close ...

func (*Connection) Exec

func (c *Connection) Exec(query string, params ...interface{}) (*Result, error)

Exec ...

func (*Connection) Get

func (c *Connection) Get(query string, params ...interface{}) (Resultset, error)

Get ...

func (*Connection) GetEnumValues

func (c *Connection) GetEnumValues(field string) ([]string, error)

GetEnumValues ...

func (*Connection) GetStruct

func (c *Connection) GetStruct(dest interface{}, query string, params ...interface{}) error

GetStruct ...

func (*Connection) Insert

func (c *Connection) Insert(tableName string, dataMap map[string]interface{}) (*Result, error)

Insert ...

func (*Connection) MustBegin

func (c *Connection) MustBegin() *Tx

MustBegin ...

func (*Connection) MustExec

func (c *Connection) MustExec(query string, params ...interface{}) *Result

MustExec ...

func (*Connection) MustGet

func (c *Connection) MustGet(query string, params ...interface{}) Resultset

MustGet ...

func (*Connection) MustInsert

func (c *Connection) MustInsert(tableName string, dataMap map[string]interface{}) *Result

MustInsert ...

func (*Connection) MustSelect

func (c *Connection) MustSelect(query string, params ...interface{}) []Resultset

MustSelect ...

func (*Connection) Ping

func (c *Connection) Ping() error

Ping ...

func (*Connection) Select

func (c *Connection) Select(query string, params ...interface{}) ([]Resultset, error)

Select ...

func (*Connection) SelectStruct

func (c *Connection) SelectStruct(dest interface{}, query string, params ...interface{}) error

SelectStruct ...

func (*Connection) SetConnMaxLifetime

func (c *Connection) SetConnMaxLifetime(duration time.Duration)

SetConnMaxLifetime ...

func (*Connection) SetMaxIdleConns

func (c *Connection) SetMaxIdleConns(max int)

SetMaxIdleConns ...

func (*Connection) SetMaxOpenConns

func (c *Connection) SetMaxOpenConns(max int)

SetMaxOpenConns ...

func (*Connection) Tx

func (c *Connection) Tx(tx *Tx) *Tx

Tx create new Tx when parameter tx is nil and the new Tx will have autocommit enabled. If parameter tx is not null then return tx from parameter

type Model

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

Model ...

func (*Model) GetTx

func (m *Model) GetTx() (*Tx, error)

GetTx ...

func (*Model) SetTx

func (m *Model) SetTx(tx *Tx)

SetTx ...

type QueryBuilder

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

QueryBuilder ...

func Parse

func Parse(query string) *QueryBuilder

Parse ...

func ParseQuery

func ParseQuery(query string) *QueryBuilder

ParseQuery ...

func (*QueryBuilder) GetField

func (q *QueryBuilder) GetField(name string) string

GetField ...

func (*QueryBuilder) Limit

func (q *QueryBuilder) Limit(start int, length int)

Limit ...

func (*QueryBuilder) LimitLength

func (q *QueryBuilder) LimitLength() int

LimitLength ...

func (*QueryBuilder) LimitStart

func (q *QueryBuilder) LimitStart() int

LimitStart ...

func (*QueryBuilder) Order

func (q *QueryBuilder) Order(field string, order string)

Order ...

func (*QueryBuilder) ToConditionSQL

func (q *QueryBuilder) ToConditionSQL() string

ToConditionSQL ...

func (*QueryBuilder) ToFromSQL

func (q *QueryBuilder) ToFromSQL() string

ToFromSQL ...

func (*QueryBuilder) ToSQL

func (q *QueryBuilder) ToSQL() string

ToSQL ...

func (*QueryBuilder) Where

func (q *QueryBuilder) Where(name string)

Where ...

func (*QueryBuilder) WhereOp

func (q *QueryBuilder) WhereOp(name string, operator string)

WhereOp ...

type Result

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

Result ...

func (*Result) LastInsertID

func (r *Result) LastInsertID() (ID int, e error)

LastInsertID ...

func (*Result) MustLastInsertID

func (r *Result) MustLastInsertID() int

MustLastInsertID ...

func (*Result) MustRowsAffected

func (r *Result) MustRowsAffected() int

MustRowsAffected ...

func (*Result) RowsAffected

func (r *Result) RowsAffected() (int, error)

RowsAffected ...

type Resultset

type Resultset map[string]interface{}

Resultset ...

func (Resultset) Bytes

func (r Resultset) Bytes(name string) []byte

Bytes ...

func (Resultset) Float

func (r Resultset) Float(name string) float64

Float ...

func (Resultset) FloatNil

func (r Resultset) FloatNil(name string) *float64

FloatNil ...

func (Resultset) FloatOr

func (r Resultset) FloatOr(name string, defValue float64) float64

FloatOr ...

func (Resultset) Int

func (r Resultset) Int(name string) int

Int ...

func (Resultset) IntNil

func (r Resultset) IntNil(name string) *int

IntNil ...

func (Resultset) IntOr

func (r Resultset) IntOr(name string, defValue int) int

IntOr ...

func (Resultset) Interface

func (r Resultset) Interface(name string) interface{}

Interface ...

func (Resultset) String

func (r Resultset) String(name string) string

String ...

func (Resultset) StringNil

func (r Resultset) StringNil(name string) *string

StringNil ...

func (Resultset) StringOr

func (r Resultset) StringOr(name string, defValue string) string

StringOr ...

func (Resultset) Time

func (r Resultset) Time(name string) time.Time

Time ...

func (Resultset) TimeNil

func (r Resultset) TimeNil(name string) *time.Time

TimeNil ...

type Tx

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

Tx ...

func (*Tx) Commit

func (t *Tx) Commit() error

Commit ...

func (*Tx) Exec

func (t *Tx) Exec(query string, params ...interface{}) (*Result, error)

Exec ...

func (*Tx) Get

func (t *Tx) Get(query string, params ...interface{}) (Resultset, error)

Get ...

func (*Tx) GetStruct

func (t *Tx) GetStruct(dest interface{}, query string, params ...interface{}) error

GetStruct ...

func (*Tx) Insert

func (t *Tx) Insert(tableName string, dataMap map[string]interface{}) (*Result, error)

Insert ...

func (*Tx) MustExec

func (t *Tx) MustExec(query string, params ...interface{}) *Result

MustExec ...

func (*Tx) MustGet

func (t *Tx) MustGet(query string, params ...interface{}) Resultset

MustGet ...

func (*Tx) MustInsert

func (t *Tx) MustInsert(tableName string, dataMap map[string]interface{}) *Result

MustInsert ...

func (*Tx) MustRecover

func (t *Tx) MustRecover()

MustRecover ...

func (*Tx) MustSelect

func (t *Tx) MustSelect(query string, params ...interface{}) []Resultset

MustSelect ...

func (*Tx) Recover

func (t *Tx) Recover()

Recover ...

func (*Tx) Rollback

func (t *Tx) Rollback() error

Rollback ...

func (*Tx) Select

func (t *Tx) Select(query string, params ...interface{}) ([]Resultset, error)

Select ...

func (*Tx) SelectStruct

func (t *Tx) SelectStruct(dest interface{}, query string, params ...interface{}) error

SelectStruct ...

Jump to

Keyboard shortcuts

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