gosql

package module

Go to main page

Versions in this module

v2

v2.1.4

Jun 29, 2022

Changes in this version

+ type Option func(*Options)

+ func WithMaxIdleConns(i int) Option

+ func WithMaxLifetimes(i int) Option

+ func WithMaxOpenConns(i int) Option

+ type Options struct

v2.1.3

Aug 24, 2021

Changes in this version

type Dialect

+ Placeholder func() string

v2.1.2

Jun 30, 2021

v2.1.1

Jun 10, 2021

Changes in this version

+ func JsonObject(value interface{}) (json.RawMessage, error)

+ func NamedExec(query string, args interface{}) (sql.Result, error)

type DB

+ func (w *DB) NamedExec(query string, args interface{}) (result sql.Result, err error)

type ISqlx

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

+ type JSONText json.RawMessage

+ func (j *JSONText) Scan(src interface{}) error

+ func (j *JSONText) Unmarshal(v interface{}) error

+ func (j *JSONText) UnmarshalBinary(data []byte) error

+ func (j *JSONText) UnmarshalJSON(data []byte) error

+ func (j JSONText) MarshalBinary() ([]byte, error)

+ func (j JSONText) MarshalJSON() ([]byte, error)

+ func (j JSONText) String() string

+ func (j JSONText) Value() (driver.Value, error)

+ type ModelWrapper struct

+ func NewModelWrapper(dbList map[string]*DB, model interface{}) *ModelWrapper

+ func (m *ModelWrapper) GetRelationDB(connect string) *DB

+ func (m *ModelWrapper) UnWrap() interface{}

+ type ModelWrapperFactory func(m interface{}) *ModelWrapper

v2.1.0

Jan 4, 2021

Changes in this version

type Builder

+ func WithContext(ctx context.Context) *Builder

+ func (b *Builder) Model(model interface{}) *Builder

type DB

+ func (w *DB) WithContext(ctx context.Context) *Builder

v2.0.5

Aug 7, 2020

Changes in this version

type DB

+ func (w *DB) Preparex(query string) (*sqlx.Stmt, error)

+ func (w *DB) ShowSql() *DB

type ISqlx

+ Preparex func(query string) (*sqlx.Stmt, error)

v2.0.4

Jul 14, 2020

Changes in this version

type DB

+ func Open(driver, dbSource string) (*DB, error)

+ func OpenWithDB(driver string, db *sql.DB) *DB

v2.0.3

Apr 2, 2020

v2.0.2

Jan 9, 2020

Changes in this version

type DB

+ func Begin() (*DB, error)

+ func (w *DB) Begin() (*DB, error)

+ func (w *DB) Commit() error

+ func (w *DB) Rollback() error

v2.0.1

Oct 16, 2019

Changes in this version

+ func RegisterDialect(name string, dialect Dialect)

+ func Sqlx(name ...string) *sqlx.DB

type DB

+ RelationMap map[string]BuilderChainFunc

+ func (w *DB) DriverName() string

+ func (w *DB) Exec(query string, args ...interface{}) (result sql.Result, err error)

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

+ func (w *DB) Import(f string) ([]sql.Result, error)

+ func (w *DB) Model(m interface{}) *ModelStruct

+ func (w *DB) QueryRowx(query string, args ...interface{}) (rows *sqlx.Row)

+ func (w *DB) Queryx(query string, args ...interface{}) (rows *sqlx.Rows, err error)

+ func (w *DB) Rebind(query string) string

+ func (w *DB) Relation(name string, fn BuilderChainFunc) *DB

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

+ func (w *DB) Table(t string) *Mapper

+ func (w *DB) Tx(fn func(w *DB) error) (err error)

+ func (w *DB) Txx(ctx context.Context, fn func(ctx context.Context, tx *DB) error) (err error)

+ type Dialect interface

+ GetName func() string

+ Quote func(key string) string

+ func GetDialect(name string) (dialect Dialect, ok bool)

type ISqlx

+ DriverName func() string

+ type ModelStruct struct

+ func (b *ModelStruct) All() (err error)

+ func (b *ModelStruct) Count(zeroValues ...string) (num int64, err error)

+ func (b *ModelStruct) Create() (lastInsertId int64, err error)

+ func (b *ModelStruct) Delete(zeroValues ...string) (affected int64, err error)

+ func (b *ModelStruct) ForceIndex(i string) *ModelStruct

+ func (b *ModelStruct) Get(zeroValues ...string) (err error)

+ func (b *ModelStruct) Hint(hint string) *ModelStruct

+ func (b *ModelStruct) Limit(i int) *ModelStruct

+ func (b *ModelStruct) Offset(i int) *ModelStruct

+ func (b *ModelStruct) OrderBy(str string) *ModelStruct

+ func (b *ModelStruct) Relation(fieldName string, fn BuilderChainFunc) *ModelStruct

+ func (b *ModelStruct) Select(fields string) *ModelStruct

+ func (b *ModelStruct) ShowSQL() *ModelStruct

+ func (b *ModelStruct) Update(zeroValues ...string) (affected int64, err error)

+ func (b *ModelStruct) Where(str string, args ...interface{}) *ModelStruct

v2.0.0

Sep 12, 2019

Changes in this version

+ var AUTO_CREATE_TIME_FIELDS = []string

+ var AUTO_UPDATE_TIME_FIELDS = []string

+ var FatalExit = true

+ func Connect(configs map[string]*Config) (err error)

+ func DB(name ...string) *sqlx.DB

+ func Exec(query string, args ...interface{}) (sql.Result, error)

+ func Expr(expression string, args ...interface{}) *expr

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

+ func Import(f string) ([]sql.Result, error)

+ func IsZero(val reflect.Value) bool

+ func List() map[string]*sqlx.DB

+ func QueryRowx(query string, args ...interface{}) *sqlx.Row

+ func Queryx(query string, args ...interface{}) (*sqlx.Rows, error)

+ func RelationAll(data interface{}, chains map[string]BuilderChainFunc) error

+ func RelationOne(data interface{}, chains map[string]BuilderChainFunc) error

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

+ func SetDefaultLink(db string)

+ func SetLogger(l Logger)

+ func SetLogging(logging bool)

+ func Tx(fn func(tx *sqlx.Tx) error) error

+ func Txx(ctx context.Context, fn func(ctx context.Context, tx *sqlx.Tx) error) error

+ type Builder struct

+ func Model(model interface{}) *Builder

+ func (b *Builder) All() (err error)

+ func (b *Builder) Count(zeroValues ...string) (num int64, err error)

+ func (b *Builder) Create() (lastInsertId int64, err error)

+ func (b *Builder) Delete(zeroValues ...string) (affected int64, err error)

+ func (b *Builder) ForceIndex(i string) *Builder

+ func (b *Builder) Get(zeroValues ...string) (err error)

+ func (b *Builder) Hint(hint string) *Builder

+ func (b *Builder) Limit(i int) *Builder

+ func (b *Builder) Offset(i int) *Builder

+ func (b *Builder) OrderBy(str string) *Builder

+ func (b *Builder) Relation(fieldName string, fn BuilderChainFunc) *Builder

+ func (b *Builder) Select(fields string) *Builder

+ func (b *Builder) ShowSQL() *Builder

+ func (b *Builder) Update(zeroValues ...string) (affected int64, err error)

+ func (b *Builder) Where(str string, args ...interface{}) *Builder

+ func (b *Builder) WithTx(tx *sqlx.Tx) *Builder

+ type BuilderChainFunc func(b *Builder)

+ type Config struct

+ Driver string

+ Dsn string

+ Enable bool

+ MaxIdleConns int

+ MaxLifetime int

+ MaxOpenConns int

+ ShowSql bool

+ type Hook struct

+ Errs []error

+ func NewHook(wrapper *Wrapper) *Hook

+ func (h *Hook) Err(err error) error

+ func (h *Hook) Error() error

+ func (h *Hook) HasError() int

+ type IModel interface

+ PK func() string

+ TableName func() string

+ type ISqlx interface

+ Exec func(query string, args ...interface{}) (sql.Result, error)

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

+ QueryRowx func(query string, args ...interface{}) *sqlx.Row

+ Queryx func(query string, args ...interface{}) (*sqlx.Rows, error)

+ Rebind func(query string) string

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

+ type Logger interface

+ Printf func(format string, v ...interface{})

+ type Mapper struct

+ func Table(t string) *Mapper

+ func (m *Mapper) Count() (num int64, err error)

+ func (m *Mapper) Create(data map[string]interface{}) (lastInsertId int64, err error)

+ func (m *Mapper) Delete() (affected int64, err error)

+ func (m *Mapper) ShowSQL() *Mapper

+ func (m *Mapper) Update(data map[string]interface{}) (affected int64, err error)

+ func (m *Mapper) Where(str string, args ...interface{}) *Mapper

+ type QueryStatus struct

+ Args interface{}

+ End time.Time

+ Err error

+ Query string

+ Start time.Time

+ func (q *QueryStatus) String() string

+ type ReflectMapper struct

+ func NewReflectMapper(tagName string) *ReflectMapper

+ func (r *ReflectMapper) FieldByName(v reflect.Value, name string) reflect.Value

+ func (r *ReflectMapper) FieldMap(v reflect.Value) map[string]reflect.Value

+ type SQLBuilder struct

+ func (s *SQLBuilder) Where(str string, args ...interface{})

+ type Wrapper struct

+ RelationMap map[string]BuilderChainFunc

+ func Relation(name string, fn BuilderChainFunc) *Wrapper

+ func ShowSql() *Wrapper

+ func Use(db string) *Wrapper

+ func WithTx(tx *sqlx.Tx) *Wrapper

+ func (w *Wrapper) Exec(query string, args ...interface{}) (result sql.Result, err error)

+ func (w *Wrapper) Get(dest interface{}, query string, args ...interface{}) (err error)

+ func (w *Wrapper) Import(f string) ([]sql.Result, error)

+ func (w *Wrapper) Model(m interface{}) *Builder

+ func (w *Wrapper) QueryRowx(query string, args ...interface{}) (rows *sqlx.Row)

+ func (w *Wrapper) Queryx(query string, args ...interface{}) (rows *sqlx.Rows, err error)

+ func (w *Wrapper) Rebind(query string) string

+ func (w *Wrapper) Relation(name string, fn BuilderChainFunc) *Wrapper

+ func (w *Wrapper) Select(dest interface{}, query string, args ...interface{}) (err error)

+ func (w *Wrapper) Table(t string) *Mapper

+ func (w *Wrapper) Tx(fn func(tx *sqlx.Tx) error) (err error)

+ func (w *Wrapper) Txx(ctx context.Context, fn func(ctx context.Context, tx *sqlx.Tx) error) (err error)

Other modules containing this package

github.com/ilibs/gosql

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