sql

package

Go to main page

Versions in this module

v3

v3.7.20

May 15, 2024

v3.7.19

May 14, 2024

v3.7.18

May 8, 2024

v3.7.17

May 3, 2024

v3.7.16

Apr 26, 2024

v3.7.15

Apr 24, 2024

v3.7.14

Apr 16, 2024

v3.7.13

Apr 9, 2024

v3.7.12

Apr 5, 2024

v3.7.11

Mar 31, 2024

v3.7.10

Mar 27, 2024

v3.7.9

Mar 22, 2024

v3.7.8

Mar 16, 2024

v3.7.7

Mar 10, 2024

v3.7.6

Mar 1, 2024

v3.7.5

Feb 29, 2024

v3.7.4

Feb 19, 2024

v3.7.3

Feb 19, 2024

v3.7.2

Feb 7, 2024

v3.7.1

Jan 15, 2024

v3.7.0

Jan 8, 2024

v3.6.20

Jan 5, 2024

v3.6.19

Dec 12, 2023

v3.6.18

Nov 9, 2023

Changes in this version

type Session

+ func NewSessionFromTx(tx *sql.Tx) Session

v3.6.17

Oct 31, 2023

v3.6.16

Oct 25, 2023

v3.6.15

Oct 13, 2023

v3.6.14

Sep 26, 2023

v3.6.13

Sep 25, 2023

v3.6.12

Sep 24, 2023

v3.6.11

Sep 10, 2023

v3.6.10

Sep 5, 2023

v3.6.9

Aug 29, 2023

v3.6.8

Aug 22, 2023

v3.6.7

Aug 9, 2023

Changes in this version

+ const JsonContainsObject

+ const JsonExtract

type Builder

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

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

v3.6.6

Aug 7, 2023

Changes in this version

+ const JsonContainsMany

+ const JsonContainsOne

type Builder

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

+ func (builder *Builder) JsonContainsOne(column string, value any) *Builder

v3.6.5

Jul 12, 2023

Changes in this version

+ const And

+ const LeftBracket

+ const RightBracket

type Builder

+ func (builder *Builder) And() *Builder

+ func (builder *Builder) FirstLike(column string, value any) *Builder

+ func (builder *Builder) LeftBracket() *Builder

+ func (builder *Builder) RightBracket() *Builder

v3.6.4

Jun 9, 2023

v3.6.2

May 9, 2023

v3.6.1

May 4, 2023

v3.6.0

Apr 20, 2023

v3.5.9

Apr 14, 2023

v3.5.8

Apr 13, 2023

v3.5.7

Apr 13, 2023

v3.5.6

Apr 13, 2023

Changes in this version

+ func ResultAccept(err error) error

v3.5.5

Apr 11, 2023

v3.5.4

Apr 3, 2023

v3.5.3

Mar 22, 2023

v3.5.2

Mar 17, 2023

v3.5.1

Mar 15, 2023

v3.5.0

Mar 15, 2023

v3.4.9

Mar 14, 2023

v3.4.8

Mar 14, 2023

v3.4.7

Mar 14, 2023

v3.4.6

Mar 14, 2023

Changes in this version

type Session

+ Count func(ctx context.Context, query string, args ...any) (int64, error)

v3.4.5

Mar 14, 2023

v3.4.4

Mar 14, 2023

Changes in this version

+ const AND

+ const ASC

+ const BETWEEN

+ const DESC

+ const EQUAL

+ const GREATER

+ const GREATEREQUAL

+ const IN

+ const INNERJOIN

+ const ISNOTNULL

+ const ISNULL

+ const JOIN

+ const LEFTJOIN

+ const LESS

+ const LESSEQUAL

+ const LIKE

+ const NOTBETWEEN

+ const NOTEQUAL

+ const NOTIN

+ const OR

+ const RIGHTJOIN

+ const UNION

+ const UNIONALL

+ func Caller(skip int) map[string]string

+ func Format(query string, args ...any) (string, error)

+ type Builder struct

+ func NewBuilder() *Builder

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

+ func (builder *Builder) Count() (sql string, args []any, err error)

+ func (builder *Builder) Delete() (sql string, args []any, err error)

+ func (builder *Builder) Distinct() *Builder

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

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

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

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

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

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

+ func (builder *Builder) Insert(data any) (sql string, args []any, err error)

+ func (builder *Builder) InsertUpdate(insert any, update any) (sql string, args []any, err error)

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

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

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

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

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

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

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

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

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

+ func (builder *Builder) MultiInsert(data ...any) (sql string, args []any, err error)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ func (builder *Builder) Replace(data ...any) (sql string, args []any, err error)

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

+ func (builder *Builder) Row() (sql string, args []any, err error)

+ func (builder *Builder) Rows() (sql string, args []any, err error)

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

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

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

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

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

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

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

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

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

+ func (builder *Builder) Update(data any) (sql string, args []any, err error)

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

+ type Client struct

+ Addr []string

+ Charset string

+ Compress bool

+ Database string

+ DialTimeout string

+ DisableDebug bool

+ DisableMetric bool

+ DisablePrepare bool

+ DisableTrace bool

+ DriverName string

+ Host string

+ MaxExecutionTime string

+ MaxIdleConns int

+ MaxIdleTime time.Duration

+ MaxLifetime time.Duration

+ MaxOpenConns int

+ OpenStrategy string

+ ParseTime bool

+ Password string

+ Port string

+ TimeZone string

+ Username string

+ func NewClient(opts ...Option) (*Client, error)

+ func (c *Client) NewClickhouse(opts ...SqlOption) SqlConn

+ func (c *Client) NewMysql(opts ...SqlOption) SqlConn

+ func (c *Client) NewPostgres(opts ...SqlOption) SqlConn

+ func (c *Client) NewSqlClient(opts ...SqlOption) SqlConn

+ type Epr struct

+ func NewEpr(value string) Epr

+ func (e Epr) ToString() string

+ type Grammar struct

+ func (g Grammar) Delete() string

+ func (g Grammar) Insert() string

+ func (g Grammar) InsertUpdate() string

+ func (g Grammar) Replace() string

+ func (g Grammar) Select() string

+ func (g Grammar) ToSQL() string

+ func (g Grammar) Update() string

+ type Option func(r *Client)

+ func WithAddr(addr []string) Option

+ func WithCharset(charset string) Option

+ func WithCompress(compress bool) Option

+ func WithDatabase(database string) Option

+ func WithDialTimeout(dialTimeout string) Option

+ func WithDisableDebug(disableDebug bool) Option

+ func WithDisableMetric(disableMetric bool) Option

+ func WithDisablePrepare(disablePrepare bool) Option

+ func WithDisableTrace(disableTrace bool) Option

+ func WithDriverName(driverName string) Option

+ func WithHost(host string) Option

+ func WithMaxExecutionTime(maxExecutionTime string) Option

+ func WithMaxIdleConns(maxIdleConns int) Option

+ func WithMaxIdleTime(maxIdleTime time.Duration) Option

+ func WithMaxLifetime(maxLifetime time.Duration) Option

+ func WithMaxOpenConns(maxOpenConns int) Option

+ func WithOpenStrategy(openStrategy string) Option

+ func WithParseTime(parseTime bool) Option

+ func WithPassword(password string) Option

+ func WithPort(port string) Option

+ func WithTimeZone(timeZone string) Option

+ func WithUsername(username string) Option

+ type Row struct

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

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

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

+ type Rows struct

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

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

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

+ type Session interface

+ Delete func(ctx context.Context, query string, args ...any) (int64, error)

+ Exec func(ctx context.Context, query string, args ...any) (int64, error)

+ ExecCtx func(ctx context.Context, query string, args ...any) (sql.Result, error)

+ Insert func(ctx context.Context, query string, args ...any) (int64, error)

+ InsertUpdate func(ctx context.Context, query string, args ...any) (int64, error)

+ MultiInsert func(ctx context.Context, query string, args ...any) (int64, error)

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

+ QueryRow func(ctx context.Context, query string, args ...any) *Row

+ QueryRows func(ctx context.Context, query string, args ...any) *Rows

+ Replace func(ctx context.Context, query string, args ...any) (int64, error)

+ Update func(ctx context.Context, query string, args ...any) (int64, error)

+ type SqlConn interface

+ Transact func(ctx context.Context, fn func(context.Context, Session) error) error

+ func NewSqlConn(driverName, dns string, pool *pool, opts ...SqlOption) SqlConn

+ type SqlOption func(*commonSqlConn)

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