query

package
v3.4.5 Latest Latest
Warning

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

 Go to latest Published: Mar 14, 2023 License: Apache-2.0 Imports: 22 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	BETWEEN      = "BETWEEN"
	NOTBETWEEN   = "NOT BETWEEN"
	IN           = "IN"
	NOTIN        = "NOT IN"
	AND          = "AND"
	OR           = "OR"
	ISNULL       = "IS NULL"
	ISNOTNULL    = "IS NOT NULL"
	EQUAL        = "="
	NOTEQUAL     = "!="
	GREATER      = ">"
	GREATEREQUAL = ">="
	LESS         = "<"
	LESSEQUAL    = "<="
	LIKE         = "LIKE"
	JOIN         = "JOIN"
	INNERJOIN    = "INNER JOIN"
	LEFTJOIN     = "LEFT JOIN"
	RIGHTJOIN    = "RIGHT JOIN"
	UNION        = "UNION"
	UNIONALL     = "UNION ALL"
	DESC         = "DESC"
	ASC          = "ASC"
)

BETWEEN ...

Variables

This section is empty.

Functions

func NewSQLConn added in v3.1.7 

func NewSQLConn(driverName, server string, opt *Opt) (*sql.DB, error)

NewSQLConn ...

Types

type Builder added in v3.1.9 

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

Builder 查询构造器

func (*Builder) Between added in v3.1.9 

func (builder *Builder) Between(column string, value1 any, value2 any) *Builder

Between 构造Between

func (*Builder) Count added in v3.1.9 

func (builder *Builder) Count() (int64, error)

Count ...

func (*Builder) Delete added in v3.1.9 

func (builder *Builder) Delete() (int64, error)

Delete .

func (*Builder) DeleteSQL added in v3.1.9 

func (builder *Builder) DeleteSQL() string

DeleteSQL .

func (*Builder) Distinct added in v3.1.9 

func (builder *Builder) Distinct() *Builder

Distinct .

func (*Builder) Equal added in v3.1.9 

func (builder *Builder) Equal(column string, value any) *Builder

Equal 构造等于

func (*Builder) Exec added in v3.1.9 

func (builder *Builder) Exec(sql string, args ...any) (int64, error)

Exec 原始SQl语句执行

func (*Builder) ExecSQL added in v3.1.9 

func (builder *Builder) ExecSQL(sql string, args ...any) string

ExecSQL 原始SQl语句执行

func (*Builder) Greater added in v3.2.8 

func (builder *Builder) Greater(column string, value any) *Builder

Greater 构造大于

func (*Builder) GreaterEqual added in v3.2.8 

func (builder *Builder) GreaterEqual(column string, value any) *Builder

Greater 构造大于等于

func (*Builder) GroupBy added in v3.1.9 

func (builder *Builder) GroupBy(groups ...string) *Builder

GroupBy .

func (*Builder) In added in v3.1.9 

func (builder *Builder) In(column string, value ...any) *Builder

In 构造 in语句

func (*Builder) InnerJoin added in v3.1.9 

func (builder *Builder) InnerJoin(tablename string, on string) *Builder

InnerJoin ...

func (*Builder) Insert added in v3.1.9 

func (builder *Builder) Insert(data any) (int64, error)

Insert 插入数据

func (*Builder) InsertSQL added in v3.1.9 

func (builder *Builder) InsertSQL(data any) string

InsertSQL 获取SQL语句

func (*Builder) InsertUpdate added in v3.1.9 

func (builder *Builder) InsertUpdate(insert any, update any) (int64, error)

InsertUpdate ...

func (*Builder) InsertUpdateSQL added in v3.1.9 

func (builder *Builder) InsertUpdateSQL(insert any, update any) string

InsertUpdateSQL ...

func (*Builder) IsNULL added in v3.1.9 

func (builder *Builder) IsNULL(column string) *Builder

IsNULL .

func (*Builder) IsNotNULL added in v3.1.9 

func (builder *Builder) IsNotNULL(column string) *Builder

IsNotNULL .

func (*Builder) IsZero added in v3.1.9 

func (builder *Builder) IsZero(v reflect.Value) bool

IsZero ...

func (*Builder) Join added in v3.1.9 

func (builder *Builder) Join(tablename string, on string) *Builder

Join .

func (*Builder) LeftJoin added in v3.1.9 

func (builder *Builder) LeftJoin(tablename string, on string) *Builder

LeftJoin .

func (*Builder) Less added in v3.2.8 

func (builder *Builder) Less(column string, value any) *Builder

Greater 构造小于

func (*Builder) LessEqual added in v3.2.8 

func (builder *Builder) LessEqual(column string, value any) *Builder

Greater 构造小于等于

func (*Builder) Like added in v3.1.9 

func (builder *Builder) Like(column string, value any) *Builder

Like .

func (*Builder) Limit added in v3.1.9 

func (builder *Builder) Limit(limit int64) *Builder

Limit .

func (*Builder) MultiInsert added in v3.1.9 

func (builder *Builder) MultiInsert(datas ...any) (int64, error)

MultiInsert 批量插入

func (*Builder) MultiInsertSQL added in v3.1.9 

func (builder *Builder) MultiInsertSQL(datas ...any) string

MultiInsertSQL 批量插入

func (*Builder) NotBetween added in v3.1.9 

func (builder *Builder) NotBetween(column string, value1 any, value2 any) *Builder

NotBetween 构造不Not Between

func (*Builder) NotEqual added in v3.1.9 

func (builder *Builder) NotEqual(column string, value any) *Builder

NotEqual 构造不等于

func (*Builder) NotIn added in v3.1.9 

func (builder *Builder) NotIn(column string, value ...any) *Builder

NotIn .

func (*Builder) NotOrBetween added in v3.1.9 

func (builder *Builder) NotOrBetween(column string, value1 any, value2 any) *Builder

NotOrBetween 构造 Not Between OR Not Between

func (*Builder) Offset added in v3.1.9 

func (builder *Builder) Offset(offset int64) *Builder

Offset .

func (*Builder) OrBetween added in v3.1.9 

func (builder *Builder) OrBetween(column string, value1 any, value2 any) *Builder

OrBetween 构造 或者 Between

func (*Builder) OrEqual added in v3.1.9 

func (builder *Builder) OrEqual(column string, value any) *Builder

OrEqual 构造或者等于

func (*Builder) OrIn added in v3.1.9 

func (builder *Builder) OrIn(column string, value ...any) *Builder

OrIn orin语句

func (*Builder) OrIsNULL added in v3.1.9 

func (builder *Builder) OrIsNULL(column string) *Builder

OrIsNULL .

func (*Builder) OrIsNotNULL added in v3.1.9 

func (builder *Builder) OrIsNotNULL(column string) *Builder

OrIsNotNULL .

func (*Builder) OrLike added in v3.1.9 

func (builder *Builder) OrLike(column string, value any) *Builder

OrLike .

func (*Builder) OrNotEqual added in v3.1.9 

func (builder *Builder) OrNotEqual(column string, value any) *Builder

OrNotEqual 构造或者不等于

func (*Builder) OrNotIn added in v3.1.9 

func (builder *Builder) OrNotIn(column string, value ...any) *Builder

OrNotIn .

func (*Builder) OrWhere added in v3.1.9 

func (builder *Builder) OrWhere(column string, value ...any) *Builder

OrWhere 构造OR条件

func (*Builder) OrderBy added in v3.1.9 

func (builder *Builder) OrderBy(column string, direction string) *Builder

OrderBy .

func (*Builder) QueryRow added in v3.1.9 

func (builder *Builder) QueryRow(sql string, args ...any) *Row

QueryRow ...

func (*Builder) QueryRowSQL added in v3.1.9 

func (builder *Builder) QueryRowSQL(sql string, args ...any) string

QueryRowSQL ...

func (*Builder) QueryRows added in v3.1.9 

func (builder *Builder) QueryRows(sql string, args ...any) *Rows

QueryRows ...

func (*Builder) QueryRowsSQL added in v3.1.9 

func (builder *Builder) QueryRowsSQL(sql string, args ...any) string

QueryRowsSQL ...

func (*Builder) Replace added in v3.1.9 

func (builder *Builder) Replace(datas ...any) (int64, error)

Replace 替换

func (*Builder) ReplaceSQL added in v3.1.9 

func (builder *Builder) ReplaceSQL(datas ...any) string

ReplaceSQL 替换

func (*Builder) RightJoin added in v3.1.9 

func (builder *Builder) RightJoin(tablename string, on string) *Builder

RightJoin .

func (*Builder) Row added in v3.1.9 

func (builder *Builder) Row() *Row

Row 获取一条记录

func (*Builder) RowSQL added in v3.1.9 

func (builder *Builder) RowSQL() string

RowSQL ...

func (*Builder) Rows added in v3.1.9 

func (builder *Builder) Rows() *Rows

Rows 获取多条记录

func (*Builder) RowsSQL added in v3.1.9 

func (builder *Builder) RowsSQL() string

RowsSQL ...

func (*Builder) Select added in v3.1.9 

func (builder *Builder) Select(columns ...string) *Builder

Select 查询字段

func (*Builder) Skip added in v3.1.9 

func (builder *Builder) Skip(offset int64) *Builder

Skip .

func (*Builder) Table added in v3.1.9 

func (builder *Builder) Table(tableName ...string) *Builder

Table 设置操作的表名称

func (*Builder) ToSQL added in v3.1.9 

func (builder *Builder) ToSQL(method string) string

ToSQL 输出SQL语句

func (*Builder) Union added in v3.1.9 

func (builder *Builder) Union(unions ...Builder) *Builder

Union .

func (*Builder) UnionAll added in v3.1.9 

func (builder *Builder) UnionAll(unions ...Builder) *Builder

UnionAll .

func (*Builder) UnionLimit added in v3.1.9 

func (builder *Builder) UnionLimit(limit int64) *Builder

UnionLimit .

func (*Builder) UnionOffset added in v3.1.9 

func (builder *Builder) UnionOffset(offset int64) *Builder

UnionOffset .

func (*Builder) UnionOrderBy added in v3.1.9 

func (builder *Builder) UnionOrderBy(column string, direction string) *Builder

UnionOrderBy .

func (*Builder) Update added in v3.1.9 

func (builder *Builder) Update(data any) (int64, error)

Update 更新

func (*Builder) UpdateSQL added in v3.1.9 

func (builder *Builder) UpdateSQL(data any) string

UpdateSQL 更新

func (*Builder) Where added in v3.1.9 

func (builder *Builder) Where(column string, value ...any) *Builder

Where 构造条件语句

type Connection 

type Connection interface {
	Exec(ctx context.Context, querySQL string, args ...any) (sql.Result, error)
	Query(ctx context.Context, querySQL string, args ...any) (*sql.Rows, error)
	NewBuilder(ctx context.Context) *Builder
	SQLRaw() string
	LastSQL(querySQL string, args ...any)
}

Connection 链接

type Epr 

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

Epr ...

func NewEpr 

func NewEpr(value string) Epr

NewEpr ...

func (Epr) ToString 

func (e Epr) ToString() string

ToString ...

type Grammar 

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

Grammar sql 语法

func (Grammar) Delete 

func (g Grammar) Delete() string

Delete ...

func (Grammar) Insert 

func (g Grammar) Insert() string

Insert ...

func (Grammar) InsertUpdate 

func (g Grammar) InsertUpdate() string

InsertUpdate ...

func (Grammar) Replace 

func (g Grammar) Replace() string

Replace ...

func (Grammar) Select 

func (g Grammar) Select() string

Select 构造select

func (Grammar) ToSQL added in v3.1.8 

func (g Grammar) ToSQL() string

ToSQL ...

func (Grammar) Update 

func (g Grammar) Update() string

Update ...

type Opt 

type Opt struct {
	MaxLifetime  time.Duration //连接池里面的连接最大存活时长
	MaxIdleTime  time.Duration //连接池里面的连接最大空闲时长
	MaxOpenConns int           //连接池最多同时打开的连接数
	MaxIdleConns int           //连接池里最大空闲连接数。必须要比maxOpenConns小
}

Opt ...

type Query added in v3.1.8 

type Query struct {
	DB            *sql.DB
	SQL           SQL
	DriverName    string
	DisableMetric bool // 关闭指标采集
	DisableTrace  bool // 关闭链路追踪
	Prepare       bool
	DBName        string
	Addr          string
	Func          string // 上个函数调用的函数名称
	Path          string // 上个函数调用的函数位置
}

Query 构造查询

func (*Query) Begin added in v3.1.9 

func (query *Query) Begin() (*Transaction, error)

Begin 开启一个事务

func (*Query) Exec added in v3.1.8 

func (query *Query) Exec(ctx context.Context, querySQL string, args ...any) (sql.Result, error)

Exec 复用执行语句

func (*Query) LastSQL added in v3.1.9 

func (query *Query) LastSQL(querySQL string, args ...any)

LastSQL ...

func (*Query) NewBuilder added in v3.1.9 

func (query *Query) NewBuilder(ctx context.Context) *Builder

NewBuilder 生成一个新的查询构造器

func (*Query) Query added in v3.1.9 

func (query *Query) Query(ctx context.Context, querySQL string, args ...any) (*sql.Rows, error)

Query 复用查询语句

func (*Query) SQLRaw added in v3.1.9 

func (query *Query) SQLRaw() string

SQLRaw ...

type Row 

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

Row 获取记录

func (*Row) ToArray 

func (r *Row) ToArray() (result []string, err error)

ToArray get Array

func (*Row) ToInterface 

func (r *Row) ToInterface() (result map[string]any, err error)

ToInterface ...

func (*Row) ToMap 

func (r *Row) ToMap() (result map[string]string, err error)

ToMap get Map

func (*Row) ToStruct 

func (r *Row) ToStruct(st any) error

ToStruct get Struct

type Rows 

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

Rows get data

func (*Rows) ToArray 

func (r *Rows) ToArray() (data [][]string, err error)

ToArray get Array

func (*Rows) ToInterface 

func (r *Rows) ToInterface() (data []map[string]any, err error)

ToInterface []map[any]any

func (*Rows) ToMap 

func (r *Rows) ToMap() (data []map[string]string, err error)

ToMap get Map

func (*Rows) ToStruct 

func (r *Rows) ToStruct(st any) error

ToStruct get Struct

type SQL added in v3.1.7 

type SQL struct {
	SQL      string
	Args     []any
	CostTime time.Duration
}

SQL sql语句

func (SQL) ToJSON added in v3.1.8 

func (sql SQL) ToJSON() string

ToJSON sql语句转出json

func (SQL) ToString added in v3.1.7 

func (SQLRaw SQL) ToString() string

ToString sql语句转出string

type Transaction added in v3.1.9 

type Transaction struct {
	Transaction   *sql.Tx
	SQL           SQL
	DriverName    string
	DisableMetric bool // 关闭指标采集
	DisableTrace  bool // 关闭链路追踪
	Prepare       bool
	DBName        string
	Addr          string
	Func          string // 上个函数调用的函数名称
	Path          string // 上个函数调用的函数位置
}

Transaction 事务

func (*Transaction) Commit added in v3.1.9 

func (query *Transaction) Commit() error

Commit 事务提交

func (*Transaction) Exec added in v3.1.9 

func (query *Transaction) Exec(ctx context.Context, querySQL string, args ...any) (sql.Result, error)

Exec 复用执行语句

func (*Transaction) LastSQL added in v3.1.9 

func (query *Transaction) LastSQL(querySQL string, args ...any)

LastSQL ...

func (*Transaction) NewBuilder added in v3.1.9 

func (query *Transaction) NewBuilder(ctx context.Context) *Builder

NewBuilder 生成一个新的查询构造器

func (*Transaction) Query added in v3.1.9 

func (query *Transaction) Query(ctx context.Context, querySQL string, args ...any) (*sql.Rows, error)

Query 复用查询语句

func (*Transaction) Rollback added in v3.1.9 

func (query *Transaction) Rollback() error

Rollback 事务回滚

func (*Transaction) SQLRaw added in v3.1.9 

func (query *Transaction) SQLRaw() string

SQLRaw ...

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.