hey

package module

Go to main page

Versions in this module

v3

v3.2.6

Jul 30, 2025

v3.2.5

Jul 23, 2025

Changes in this version

+ const SqlCase

+ const SqlElse

+ const SqlEnd

+ const SqlThen

+ const SqlWhen

type Del

+ func (s *Del) Filters(filters ...Filter) *Del

+ func (s *Del) SQLTable(sqlTable SQLTable) *Del

type Get

+ func (s *Get) Filters(filters ...Filter) *Get

+ func (s *Get) GroupBy(fc func(g SQLGroupBy)) *Get

+ func (s *Get) OrderBy(fc func(o SQLOrderBy)) *Get

type Mod

+ func (s *Mod) Filters(filters ...Filter) *Mod

+ type SQLCase interface

+ Alias func(alias string) SQLCase

+ Case func(values ...any) SQLCase

+ Else func(values ...any) SQLCase

+ String func(value string) string

+ When func(fc func(w SQLWhenThen)) SQLCase

+ func NewSQLCase(way *Way) SQLCase

+ type SQLGroupBy interface

+ Column func(columns ...string) SQLGroupBy

+ Group func(prepare string, args ...any) SQLGroupBy

+ GroupCmder func(cmder Cmder) SQLGroupBy

+ Having func(having func(having Filter)) SQLGroupBy

+ func NewSQLGroupBy(way *Way) SQLGroupBy

+ type SQLInsertValue interface

+ Del func(indexes ...int) SQLInsertValue

+ GetValues func() [][]any

+ LenValues func() int

+ Set func(index int, value any) SQLInsertValue

+ SetSubquery func(subquery Cmder) SQLInsertValue

+ SetValues func(values ...[]any) SQLInsertValue

+ func NewSQLInsertValue() SQLInsertValue

+ type SQLJoin interface

+ GetMaster func() SQLTable

+ InnerJoin func(leftTable SQLTable, rightTable SQLTable, on SQLJoinAssoc) SQLJoin

+ Join func(joinTypeString string, leftTable SQLTable, rightTable SQLTable, ...) SQLJoin

+ LeftJoin func(leftTable SQLTable, rightTable SQLTable, on SQLJoinAssoc) SQLJoin

+ NewSubquery func(subquery Cmder, alias string) SQLTable

+ NewTable func(table string, alias string, args ...any) SQLTable

+ On func(onList ...func(o SQLJoinOn, leftAlias string, rightAlias string)) SQLJoinAssoc

+ OnEqual func(leftColumn string, rightColumn string) SQLJoinAssoc

+ Queries func() SQLSelect

+ RightJoin func(leftTable SQLTable, rightTable SQLTable, on SQLJoinAssoc) SQLJoin

+ SelectGroupsColumns func(columns ...[]string) SQLJoin

+ SelectTableColumnAlias func(table SQLTable, columnAndColumnAlias ...string) SQLJoin

+ SetMaster func(master SQLTable) SQLJoin

+ TableColumn func(table SQLTable) *TableColumn

+ TableSelect func(table SQLTable, columns ...string) []string

+ TableSelectAliases func(table SQLTable, aliases map[string]string, columns ...string) []string

+ Using func(columns ...string) SQLJoinAssoc

+ func NewSQLJoin(way *Way) SQLJoin

+ type SQLJoinAssoc func(leftAlias string, rightAlias string) SQLJoinOn

+ type SQLJoinOn interface

+ Equal func(leftAlias string, leftColumn string, rightAlias string, rightColumn string) SQLJoinOn

+ Filter func(fc func(f Filter)) SQLJoinOn

+ Using func(using ...string) SQLJoinOn

+ type SQLLimit interface

+ Limit func(limit int64) SQLLimit

+ Offset func(offset int64) SQLLimit

+ Page func(page int64, limit ...int64) SQLLimit

+ func NewSQLLimit() SQLLimit

+ type SQLOrderBy interface

+ Asc func(columns ...string) SQLOrderBy

+ Desc func(columns ...string) SQLOrderBy

+ Use func(columns ...string) SQLOrderBy

+ func NewSQLOrderBy(way *Way) SQLOrderBy

+ type SQLSelect interface

+ Add func(column string, args ...any) SQLSelect

+ AddAll func(columns ...string) SQLSelect

+ AddCmder func(cmder Cmder) SQLSelect

+ DelAll func(columns ...string) SQLSelect

+ Exists func(column string) bool

+ Get func() ([]string, map[int][]any)

+ Index func(column string) int

+ Len func() int

+ Queried func(excepts ...string) []string

+ Set func(columns []string, columnsArgs map[int][]any) SQLSelect

+ Use func(sqlSelect ...SQLSelect) SQLSelect

+ func NewSQLSelect(way *Way) SQLSelect

+ type SQLTable interface

+ Alias func(alias string) SQLTable

+ GetAlias func() string

+ func NewSQLTable(prepare string, args []any) SQLTable

+ func NewSQLTableGet(alias string, get *Get) SQLTable

+ type SQLUpdateSet interface

+ Decr func(column string, decr any) SQLUpdateSet

+ GetUpdate func() (updates []string, args [][]any)

+ Incr func(column string, incr any) SQLUpdateSet

+ Len func() int

+ Set func(column string, value any) SQLUpdateSet

+ SetMap func(columnValue map[string]any) SQLUpdateSet

+ SetSlice func(columns []string, values []any) SQLUpdateSet

+ Update func(update string, args ...any) SQLUpdateSet

+ UpdateExists func(prepare string) bool

+ UpdateIndex func(prepare string) int

+ func NewSQLUpdateSet(way *Way) SQLUpdateSet

+ type SQLUpsertColumn interface

+ Add func(columns ...string) SQLUpsertColumn

+ ColumnExists func(column string) bool

+ ColumnIndex func(column string) int

+ Del func(columns ...string) SQLUpsertColumn

+ DelUseIndex func(indexes ...int) SQLUpsertColumn

+ GetColumns func() []string

+ GetColumnsMap func() map[string]*struct{}

+ Len func() int

+ SetColumns func(columns []string) SQLUpsertColumn

+ func NewSQLUpsertColumn(way *Way) SQLUpsertColumn

+ type SQLWhenThen interface

+ String func(value string) string

+ Then func(values ...any) SQLWhenThen

+ When func(values ...any) SQLWhenThen

+ type SQLWith interface

+ Del func(alias string) SQLWith

+ Recursive func() SQLWith

+ Set func(alias string, cmder Cmder, columns ...string) SQLWith

+ func NewSQLWith() SQLWith

v3.2.4

Jul 17, 2025

Changes in this version

type QueryJoin

+ TableSelectAliases func(table TableCmder, aliases map[string]string, columns ...string) []string

v3.2.3

Jul 15, 2025

Changes in this version

type QueryWith

+ Recursive func() QueryWith

v3.2.2

Jul 15, 2025

v3.2.1

Jul 15, 2025

Changes in this version

type QueryWith

+ Set func(alias string, cmder Cmder, columns ...string) QueryWith

v3.2.0

Jul 7, 2025

Changes in this version

+ const ErrNoRows

+ const ErrNoRowsAffected

+ func ArrayDiscard[V any](values []V, discard func(k int, v V) bool) []V

+ func AssocDiscard[K comparable, V any](values map[K]V, discard func(k K, v V) bool) map[K]V

+ func AssocToAssoc[K comparable, V any, X comparable, Y any](values map[K]V, fc func(k K, v V) (X, Y)) map[X]Y

+ func RowsScan(rows *sql.Rows, result any, tag string) error

+ type Cache struct

+ func NewCache(cacher Cacher) *Cache

+ func (s *Cache) Del(key string) error

+ func (s *Cache) DurationRange(duration time.Duration, minValue int, maxValue int) time.Duration

+ func (s *Cache) Exists(key string) (exists bool, err error)

+ func (s *Cache) Get(key string) (value []byte, exists bool, err error)

+ func (s *Cache) GetBool(key string) (value bool, exists bool, err error)

+ func (s *Cache) GetCacher() Cacher

+ func (s *Cache) GetFloat(key string) (value float64, exists bool, err error)

+ func (s *Cache) GetInt(key string) (value int64, exists bool, err error)

+ func (s *Cache) GetString(key string) (value string, exists bool, err error)

+ func (s *Cache) GetUnmarshal(key string, value any) (exists bool, err error)

+ func (s *Cache) MarshalSet(key string, value any, duration ...time.Duration) error

+ func (s *Cache) Set(key string, value []byte, duration ...time.Duration) error

+ func (s *Cache) SetBool(key string, value bool, duration ...time.Duration) error

+ func (s *Cache) SetCacher(cacher Cacher) *Cache

+ func (s *Cache) SetFloat(key string, value float64, duration ...time.Duration) error

+ func (s *Cache) SetInt(key string, value int64, duration ...time.Duration) error

+ func (s *Cache) SetString(key string, value string, duration ...time.Duration) error

+ type CacheCmder interface

+ Del func() error

+ Exists func() (exists bool, err error)

+ Get func() (value []byte, exists bool, err error)

+ GetBool func() (bool, bool, error)

+ GetCacheKey func() (string, error)

+ GetFloat func() (float64, bool, error)

+ GetInt func() (int64, bool, error)

+ GetString func() (string, bool, error)

+ GetUnmarshal func(value any) (exists bool, err error)

+ MarshalSet func(value any, duration ...time.Duration) error

+ Reset func(cmder ...Cmder) CacheCmder

+ Set func(value []byte, duration ...time.Duration) error

+ SetBool func(value bool, duration ...time.Duration) error

+ SetFloat func(value float64, duration ...time.Duration) error

+ SetInt func(value int64, duration ...time.Duration) error

+ SetString func(value string, duration ...time.Duration) error

+ UseCacheKey func(cacheKey func(cmder Cmder) (string, error)) CacheCmder

+ func NewCacheCmder(cache *Cache, cmder Cmder) CacheCmder

+ type Cacher interface

+ Del func(key string) error

+ Exists func(key string) (exists bool, err error)

+ Get func(key string) (value []byte, exists bool, err error)

+ Key func(key string) string

+ Marshal func(v any) ([]byte, error)

+ Set func(key string, value []byte, duration ...time.Duration) error

+ Unmarshal func(data []byte, v any) error

type Debugger

+ func NewDebugger() Debugger

+ Debug func(cmder Cmder) Debugger

+ GetLogger func() *logger.Logger

+ SetLogger func(log *logger.Logger) Debugger

+ type StringMutex struct

+ func NewStringMutex(length int) *StringMutex

+ func (s *StringMutex) Get(key string) *sync.Mutex

+ func (s *StringMutex) Len() int

type Way

+ func (s *Way) Debug(cmder Cmder) *Way

v3.1.0

Jun 4, 2025

Changes in this version

+ const RowsScanStructAllMakeSliceLength

+ const SqlBetween

+ const SqlConflict

+ const SqlDelete

+ const SqlDo

+ const SqlExcluded

+ const SqlExists

+ const SqlFrom

+ const SqlGroupBy

+ const SqlHaving

+ const SqlIn

+ const SqlInsert

+ const SqlInto

+ const SqlIs

+ const SqlLike

+ const SqlLimit

+ const SqlNothing

+ const SqlOffset

+ const SqlOn

+ const SqlOrderBy

+ const SqlOver

+ const SqlPartitionBy

+ const SqlSelect

+ const SqlSet

+ const SqlUpdate

+ const SqlUsing

+ const SqlValues

+ const SqlWhere

+ const SqlWith

+ func DiscardDuplicate[T comparable](discard func(tmp T) bool, dynamic ...T) (result []T)

+ type JoinFunc func(leftAlias string, rightAlias string) JoinOn

+ type JoinOn interface

+ Equal func(leftAlias string, leftColumn string, rightAlias string, rightColumn string) JoinOn

+ Filter func() Filter

+ On func(on func(on Filter)) JoinOn

+ Using func(using ...string) JoinOn

type QueryJoin

+ SelectGroupsColumns func(columns ...[]string) QueryJoin

+ SelectTableColumnAlias func(table TableCmder, columnAndColumnAlias ...string) QueryJoin

+ TableColumn func(table TableCmder) *TableColumn

+ TableSelect func(table TableCmder, columns ...string) []string

v3.0.1

May 21, 2025

Changes in this version

type Add

+ func (s *Add) SetWay(way *Way) *Add

type Del

+ func (s *Del) SetWay(way *Way) *Del

type Get

+ func (s *Get) SetWay(way *Way) *Get

type Mod

+ func (s *Mod) SetWay(way *Way) *Mod

v3.0.0

May 1, 2025

Changes in this version

+ const AliasA

+ const AliasB

+ const AliasC

+ const AliasD

+ const AliasE

+ const AliasF

+ const AliasG

+ const DefaultAliasNameCount

+ const DefaultTag

+ const EmptyString

+ const NoRowsAffected

+ const RecordDoesNotExists

+ const SqlAll

+ const SqlAnd

+ const SqlAny

+ const SqlAs

+ const SqlAsc

+ const SqlCoalesce

+ const SqlConcat

+ const SqlDesc

+ const SqlDistinct

+ const SqlEqual

+ const SqlExpect

+ const SqlGreaterThan

+ const SqlGreaterThanEqual

+ const SqlIntersect

+ const SqlJoinCross

+ const SqlJoinFull

+ const SqlJoinInner

+ const SqlJoinLeft

+ const SqlJoinRight

+ const SqlLeftSmallBracket

+ const SqlLessThan

+ const SqlLessThanEqual

+ const SqlNot

+ const SqlNotEqual

+ const SqlNull

+ const SqlOr

+ const SqlPlaceholder

+ const SqlPoint

+ const SqlRightSmallBracket

+ const SqlSome

+ const SqlSpace

+ const SqlStar

+ const SqlUnion

+ const SqlUnionAll

+ const State0

+ const State1

+ const StateN

+ const StateNo

+ const StateOff

+ const StateOn

+ const StateY

+ const StateYes

+ const TransactionNotStarted

+ func ArrayRemoveIndex[V interface{}](values []V, indexes []int) []V

+ func ArrayToArray[V interface{}, W interface{}](values []V, fc func(v V) W) []W

+ func ArrayToAssoc[V interface{}, K comparable, W interface{}](values []V, fc func(v V) (K, W)) map[K]W

+ func AssocToArray[K comparable, V interface{}, W interface{}](values map[K]V, fc func(k K, v V) W) []W

+ func CmderGet(ctx context.Context, way *Way, cmder Cmder, result interface{}) error

+ func CmderGetCmd(s *Get) (prepare string, args []interface{})

+ func CmderGetCount(s *Get, countColumns ...string) (prepare string, args []interface{})

+ func CmderGetOrderLimitOffset(s *Get) (prepare string, args []interface{})

+ func CmderGetTable(s *Get) (prepare string, args []interface{})

+ func CmderQuery(ctx context.Context, way *Way, cmder Cmder, ...) error

+ func CmderScanAll(ctx context.Context, way *Way, cmder Cmder, custom func(rows *sql.Rows) error) error

+ func CmderScanOne(ctx context.Context, way *Way, cmder Cmder, dest ...interface{}) error

+ func CmderViewMap(ctx context.Context, way *Way, cmder Cmder) (result []map[string]interface{}, err error)

+ func ColumnInValues[T interface{}](values []T, fc func(tmp T) interface{}) []interface

+ func ColumnsInValues[T interface{}](values []T, fc func(tmp T) []interface{}) [][]interface

+ func ConcatString(sss ...string) string

+ func GetCount(get *Get, countColumns ...string) (count int64, err error)

+ func GetCountGet(get *Get, result interface{}, countColumn ...string) (int64, error)

+ func GetCountQuery(get *Get, query func(rows *sql.Rows) (err error), countColumn ...string) (int64, error)

+ func GetExists(get *Get) (exists bool, err error)

+ func GetGet(get *Get, result interface{}) error

+ func GetQuery(get *Get, query func(rows *sql.Rows) (err error)) error

+ func GetScanAll(get *Get, fc func(rows *sql.Rows) error) error

+ func GetScanOne(get *Get, dest ...interface{}) error

+ func GetViewMap(get *Get) (result []map[string]interface{}, err error)

+ func IsEmptyCmder(cmder Cmder) bool

+ func LastNotEmptyString(sss []string) string

+ func MergeArray[V interface{}](values ...[]V) []V

+ func MergeAssoc[K comparable, V interface{}](values ...map[K]V) map[K]V

+ func MustAffectedRows(affectedRows int64, err error) error

+ func NullDefaultValue(prepare string, defaultValue string) string

+ func ParcelCancelPrepare(prepare string) string

+ func ParcelPrepare(prepare string) string

+ func PutFilter(f Filter)

+ func RemoveDuplicate(dynamic ...interface{}) (result []interface{})

+ func RemoveDuplicates[T comparable](dynamic ...T) (result []T)

+ func RowsScanStructAllCmder[V interface{}](ctx context.Context, way *Way, scan func(rows *sql.Rows, v *V) error, ...) ([]*V, error)

+ func RowsScanStructAll[V interface{}](ctx context.Context, way *Way, scan func(rows *sql.Rows, v *V) error, ...) ([]*V, error)

+ func RowsScanStructOneCmder[V interface{}](ctx context.Context, way *Way, scan func(rows *sql.Rows, v *V) error, ...) (*V, error)

+ func RowsScanStructOne[V interface{}](ctx context.Context, way *Way, scan func(rows *sql.Rows, v *V) error, ...) (*V, error)

+ func ScanAll(rows *sql.Rows, fc func(rows *sql.Rows) error) (err error)

+ func ScanOne(rows *sql.Rows, dest ...interface{}) error

+ func ScanSliceStruct(rows *sql.Rows, result interface{}, tag string) error

+ func ScanViewMap(rows *sql.Rows) ([]map[string]interface{}, error)

+ func SqlAlias(name string, alias string) string

+ func SqlPrefix(prefix string, name string) string

+ func StructInsert(object interface{}, tag string, except []string, allow []string) (fields []string, values [][]interface{})

+ func StructModify(object interface{}, tag string, except ...string) (fields []string, values []interface{})

+ func StructObtain(object interface{}, tag string, except ...string) (fields []string, values []interface{})

+ func StructUpdate(origin interface{}, latest interface{}, tag string, except ...string) (fields []string, values []interface{})

+ type Add struct

+ func NewAdd(way *Way) *Add

+ func (s *Add) Add() (int64, error)

+ func (s *Add) AddOne(custom func(add AddOneReturnSequenceValue)) (int64, error)

+ func (s *Add) Cmd() (prepare string, args []interface{})

+ func (s *Add) CmderValues(cmdValues Cmder, columns []string) *Add

+ func (s *Add) ColumnValue(column string, value interface{}) *Add

+ func (s *Add) ColumnsValues(columns []string, values [][]interface{}) *Add

+ func (s *Add) Comment(comment string) *Add

+ func (s *Add) Context(ctx context.Context) *Add

+ func (s *Add) Create(create interface{}) *Add

+ func (s *Add) Default(add func(add *Add)) *Add

+ func (s *Add) ExceptPermit(custom func(except UpsertColumns, permit UpsertColumns)) *Add

+ func (s *Add) GetColumns() []string

+ func (s *Add) GetContext() context.Context

+ func (s *Add) GetValues() [][]interface{}

+ func (s *Add) GetWay() *Way

+ func (s *Add) Table(table string) *Add

+ type AddOneReturnSequenceValue interface

+ AddOne func() (int64, error)

+ Adjust func(adjust func(prepare string, args []interface{}) (string, []interface{})) AddOneReturnSequenceValue

+ Context func(ctx context.Context) AddOneReturnSequenceValue

+ Execute func(...) AddOneReturnSequenceValue

+ type Caller interface

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ type Cfg struct

+ Debugger Debugger

+ DeleteMustUseWhere bool

+ Manual *Manual

+ Scan func(rows *sql.Rows, result interface{}, tag string) error

+ ScanTag string

+ TransactionMaxDuration time.Duration

+ TransactionOptions *sql.TxOptions

+ UpdateMustUseWhere bool

+ WarnDuration time.Duration

+ func DefaultCfg() Cfg

+ type Cmder interface

+ Cmd func() (prepare string, args []interface{})

+ func ConcatCmder(concat string, custom func(index int, cmder Cmder) Cmder, items ...Cmder) Cmder

+ func ExceptCmder(items ...Cmder) Cmder

+ func IntersectCmder(items ...Cmder) Cmder

+ func NewCmder(prepare string, args []interface{}) Cmder

+ func ParcelCancelCmder(cmder Cmder) Cmder

+ func ParcelCmder(cmder Cmder) Cmder

+ func UnionAllCmder(items ...Cmder) Cmder

+ func UnionCmder(items ...Cmder) Cmder

+ type Debugger interface

+ Debugger func(cmder Cmder) Debugger

+ GetLog func() *logger.Logger

+ SetLog func(log *logger.Logger) Debugger

+ SetWay func(way *Way) Debugger

+ type Del struct

+ func NewDel(way *Way) *Del

+ func (s *Del) Cmd() (prepare string, args []interface{})

+ func (s *Del) Comment(comment string) *Del

+ func (s *Del) Context(ctx context.Context) *Del

+ func (s *Del) Del() (int64, error)

+ func (s *Del) GetContext() context.Context

+ func (s *Del) GetWay() *Way

+ func (s *Del) Table(table string, args ...interface{}) *Del

+ func (s *Del) TableCmder(cmder TableCmder) *Del

+ func (s *Del) Where(where func(f Filter)) *Del

+ type ErrorNoRowsAffected string

+ func (s ErrorNoRowsAffected) Error() string

+ type ErrorRecordDoesNotExists string

+ func (s ErrorRecordDoesNotExists) Error() string

+ type ErrorTransactionNotStarted string

+ func (s ErrorTransactionNotStarted) Error() string

+ type Filter interface

+ AllQuantifier func(fc func(tmp Quantifier)) Filter

+ And func(prepare string, args ...interface{}) Filter

+ AnyQuantifier func(fc func(tmp Quantifier)) Filter

+ Between func(column string, start interface{}, end interface{}) Filter

+ Clean func() Filter

+ Compare func(column1 string, compare string, column2 string, args ...interface{}) Filter

+ CompareEqual func(column1 string, column2 string, args ...interface{}) Filter

+ CompareGreaterThan func(column1 string, column2 string, args ...interface{}) Filter

+ CompareGreaterThanEqual func(column1 string, column2 string, args ...interface{}) Filter

+ CompareLessThan func(column1 string, column2 string, args ...interface{}) Filter

+ CompareLessThanEqual func(column1 string, column2 string, args ...interface{}) Filter

+ CompareNotEqual func(column1 string, column2 string, args ...interface{}) Filter

+ Equal func(column string, value interface{}, useNull ...bool) Filter

+ Exists func(prepare string, args ...interface{}) Filter

+ ExistsQuery func(subquery Cmder) Filter

+ GetWay func() *Way

+ GreaterThan func(column string, value interface{}) Filter

+ GreaterThanEqual func(column string, value interface{}) Filter

+ Group func(group func(g Filter)) Filter

+ In func(column string, values ...interface{}) Filter

+ InCols func(columns []string, values ...[]interface{}) Filter

+ InColsQuery func(columns []string, subquery Cmder) Filter

+ InColsSql func(columns []string, prepare string, args ...interface{}) Filter

+ InQuery func(column string, subquery Cmder) Filter

+ InSql func(column string, prepare string, args ...interface{}) Filter

+ IsEmpty func() bool

+ IsNotNull func(column string) Filter

+ IsNull func(column string) Filter

+ LessThan func(column string, value interface{}) Filter

+ LessThanEqual func(column string, value interface{}) Filter

+ Like func(column string, value interface{}) Filter

+ New func(fs ...Filter) Filter

+ Not func() Filter

+ NotBetween func(column string, start interface{}, end interface{}) Filter

+ NotEqual func(column string, value interface{}, useNotNull ...bool) Filter

+ NotIn func(column string, values ...interface{}) Filter

+ NotInCols func(columns []string, values ...[]interface{}) Filter

+ NotLike func(column string, value interface{}) Filter

+ Num func() int

+ Or func(prepare string, args ...interface{}) Filter

+ OrGroup func(group func(g Filter)) Filter

+ SetWay func(way *Way) Filter

+ SomeQuantifier func(fc func(tmp Quantifier)) Filter

+ Use func(fs ...Filter) Filter

+ func F() Filter

+ func GetFilter() Filter

+ func ParcelFilter(tmp Filter) Filter

+ type Get struct

+ func NewGet(way *Way) *Get

+ func (s *Get) Alias(alias string) *Get

+ func (s *Get) Asc(column string) *Get

+ func (s *Get) Cmd() (prepare string, args []interface{})

+ func (s *Get) Comment(comment string) *Get

+ func (s *Get) Context(ctx context.Context) *Get

+ func (s *Get) Count(column ...string) (int64, error)

+ func (s *Get) CountCmd(columns ...string) (string, []interface{})

+ func (s *Get) CountGet(result interface{}, countColumn ...string) (int64, error)

+ func (s *Get) CountQuery(query func(rows *sql.Rows) (err error), countColumn ...string) (int64, error)

+ func (s *Get) Desc(column string) *Get

+ func (s *Get) Exists() (bool, error)

+ func (s *Get) Get(result interface{}) error

+ func (s *Get) GetContext() context.Context

+ func (s *Get) GetSelect() QueryColumns

+ func (s *Get) GetWay() *Way

+ func (s *Get) Group(group ...string) *Get

+ func (s *Get) Having(having func(f Filter)) *Get

+ func (s *Get) Join(custom func(join QueryJoin)) *Get

+ func (s *Get) Limit(limit int64) *Get

+ func (s *Get) Limiter(limiter Limiter) *Get

+ func (s *Get) Offset(offset int64) *Get

+ func (s *Get) Order(order string, orderMap ...map[string]string) *Get

+ func (s *Get) Query(query func(rows *sql.Rows) (err error)) error

+ func (s *Get) ScanAll(fc func(rows *sql.Rows) error) error

+ func (s *Get) ScanOne(dest ...interface{}) error

+ func (s *Get) Select(columns ...string) *Get

+ func (s *Get) SetSelect(queryColumns QueryColumns) *Get

+ func (s *Get) Subquery(subquery Cmder, alias string) *Get

+ func (s *Get) Table(table string) *Get

+ func (s *Get) ViewMap() ([]map[string]interface{}, error)

+ func (s *Get) Where(where func(f Filter)) *Get

+ func (s *Get) With(alias string, script Cmder) *Get

+ type InsertOnConflict interface

+ Cmd func() (prepare string, args []interface{})

+ Do func(prepare string, args ...interface{}) InsertOnConflict

+ DoUpdateSet func(fc func(u InsertOnConflictUpdateSet)) InsertOnConflict

+ InsertOnConflict func() (int64, error)

+ OnConflict func(onConflicts ...string) InsertOnConflict

+ func NewInsertOnConflict(way *Way, insertPrepare string, insertArgs []interface{}) InsertOnConflict

+ type InsertOnConflictUpdateSet interface

+ Excluded func(columns ...string) InsertOnConflictUpdateSet

+ func NewInsertOnConflictUpdateSet(way *Way) InsertOnConflictUpdateSet

+ type InsertValue interface

+ Del func(indexes ...int) InsertValue

+ GetValues func() [][]interface{}

+ LenValues func() int

+ Set func(index int, value interface{}) InsertValue

+ SetSubquery func(subquery Cmder) InsertValue

+ SetValues func(values ...[]interface{}) InsertValue

+ func NewInsertValue() InsertValue

+ type IsEmpty interface

+ IsEmpty func() bool

+ type JoinCondition func(leftAlias string, rightAlias string) Cmder

+ type Limiter interface

+ GetLimit func() int64

+ GetOffset func() int64

+ type Manual struct

+ Prepare func(prepare string) string

+ Replace Replace

+ func Mysql() *Manual

+ func Postgresql() *Manual

+ func Sqlite() *Manual

+ type Mod struct

+ func NewMod(way *Way) *Mod

+ func (s *Mod) Cmd() (prepare string, args []interface{})

+ func (s *Mod) ColumnsValues(columns []string, values []interface{}) *Mod

+ func (s *Mod) Comment(comment string) *Mod

+ func (s *Mod) Compare(old, new interface{}, except ...string) *Mod

+ func (s *Mod) Context(ctx context.Context) *Mod

+ func (s *Mod) Decr(column string, value interface{}) *Mod

+ func (s *Mod) Default(custom func(mod *Mod)) *Mod

+ func (s *Mod) ExceptPermit(custom func(except UpsertColumns, permit UpsertColumns)) *Mod

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

+ func (s *Mod) GetContext() context.Context

+ func (s *Mod) GetUpdateSet() (prepare string, args []interface{})

+ func (s *Mod) GetWay() *Way

+ func (s *Mod) Incr(column string, value interface{}) *Mod

+ func (s *Mod) Mod() (int64, error)

+ func (s *Mod) Set(column string, value interface{}) *Mod

+ func (s *Mod) Table(table string, args ...interface{}) *Mod

+ func (s *Mod) Update(update interface{}) *Mod

+ func (s *Mod) Where(where func(f Filter)) *Mod

+ type Quantifier interface

+ Equal func(column string, subquery Cmder) Quantifier

+ GetQuantifier func() string

+ GreaterThan func(column string, subquery Cmder) Quantifier

+ GreaterThanEqual func(column string, subquery Cmder) Quantifier

+ LessThan func(column string, subquery Cmder) Quantifier

+ LessThanEqual func(column string, subquery Cmder) Quantifier

+ NotEqual func(column string, subquery Cmder) Quantifier

+ SetQuantifier func(quantifierString string) Quantifier

+ type QueryColumns interface

+ Add func(column string, args ...interface{}) QueryColumns

+ AddAll func(columns ...string) QueryColumns

+ DelAll func(columns ...string) QueryColumns

+ Exists func(column string) bool

+ Get func() ([]string, map[int][]interface{})

+ Index func(column string) int

+ Len func() int

+ Queried func(excepts ...string) []string

+ Set func(columns []string, columnsArgs map[int][]interface{}) QueryColumns

+ Use func(queryColumns ...QueryColumns) QueryColumns

+ func NewQueryColumns(way *Way) QueryColumns

+ type QueryGroup interface

+ Group func(columns ...string) QueryGroup

+ Having func(having func(having Filter)) QueryGroup

+ func NewQueryGroup(way *Way) QueryGroup

+ type QueryJoin interface

+ GetMaster func() TableCmder

+ InnerJoin func(leftTable TableCmder, rightTable TableCmder, condition JoinCondition) QueryJoin

+ Join func(joinTypeString string, leftTable TableCmder, rightTable TableCmder, ...) QueryJoin

+ LeftJoin func(leftTable TableCmder, rightTable TableCmder, condition JoinCondition) QueryJoin

+ NewSubquery func(subquery Cmder, alias string) TableCmder

+ NewTable func(table string, alias string, args ...interface{}) TableCmder

+ On func(conditions ...func(leftAlias string, rightAlias string) Cmder) JoinCondition

+ OnEqual func(leftColumn string, rightColumn string, ...) JoinCondition

+ Queries func() QueryColumns

+ RightJoin func(leftTable TableCmder, rightTable TableCmder, condition JoinCondition) QueryJoin

+ SetMaster func(master TableCmder) QueryJoin

+ Using func(columns ...string) JoinCondition

+ Where func(where func(where Filter)) QueryJoin

+ func NewQueryJoin(way *Way) QueryJoin

+ type QueryLimit interface

+ Limit func(limit int64) QueryLimit

+ Offset func(offset int64) QueryLimit

+ Page func(page int64, limit ...int64) QueryLimit

+ func NewQueryLimit() QueryLimit

+ type QueryOrder interface

+ Asc func(columns ...string) QueryOrder

+ Desc func(columns ...string) QueryOrder

+ func NewQueryOrder(way *Way) QueryOrder

+ type QueryWith interface

+ Add func(alias string, cmder Cmder) QueryWith

+ Del func(alias string) QueryWith

+ func NewQueryWith() QueryWith

+ type Reader interface

+ Read func() *Way

+ func NewReader(choose func(n int) int, reads []*Way) Reader

+ type Replace interface

+ Del func(key string) Replace

+ Get func(key string) string

+ Gets func(keys []string) []string

+ Map func() map[string]string

+ Set func(key string, value string) Replace

+ Sets func(mapping map[string]string) Replace

+ Use func(mapping map[string]string) Replace

+ func NewReplace() Replace

+ type Stmt struct

+ func (s *Stmt) Close() (err error)

+ func (s *Stmt) Exec(args ...interface{}) (int64, error)

+ func (s *Stmt) ExecContext(ctx context.Context, args ...interface{}) (int64, error)

+ func (s *Stmt) Execute(args ...interface{}) (sql.Result, error)

+ func (s *Stmt) ExecuteContext(ctx context.Context, args ...interface{}) (sql.Result, error)

+ func (s *Stmt) Query(query func(rows *sql.Rows) error, args ...interface{}) error

+ func (s *Stmt) QueryContext(ctx context.Context, query func(rows *sql.Rows) error, args ...interface{}) error

+ func (s *Stmt) QueryRow(query func(rows *sql.Row) error, args ...interface{}) (err error)

+ func (s *Stmt) QueryRowContext(ctx context.Context, query func(rows *sql.Row) error, args ...interface{}) error

+ func (s *Stmt) TakeAll(result interface{}, args ...interface{}) error

+ func (s *Stmt) TakeAllContext(ctx context.Context, result interface{}, args ...interface{}) error

+ type TableCmder interface

+ Alias func(alias string) TableCmder

+ GetAlias func() string

+ func NewCmderGet(alias string, get *Get) TableCmder

+ func NewTableCmder(prepare string, args []interface{}) TableCmder

+ type TableColumn struct

+ func NewTableColumn(way *Way, aliases ...string) *TableColumn

+ func (s *TableColumn) AVG(column string, aliases ...string) string

+ func (s *TableColumn) Adjust(adjust func(column string) string, columns ...string) []string

+ func (s *TableColumn) Alias() string

+ func (s *TableColumn) Avg(column string, aliases ...string) string

+ func (s *TableColumn) Column(column string, aliases ...string) string

+ func (s *TableColumn) ColumnAll(columns ...string) []string

+ func (s *TableColumn) Count(counts ...string) string

+ func (s *TableColumn) MAX(column string, aliases ...string) string

+ func (s *TableColumn) MIN(column string, aliases ...string) string

+ func (s *TableColumn) Max(column string, aliases ...string) string

+ func (s *TableColumn) Min(column string, aliases ...string) string

+ func (s *TableColumn) SUM(column string, aliases ...string) string

+ func (s *TableColumn) SetAlias(alias string) *TableColumn

+ func (s *TableColumn) Sum(column string, aliases ...string) string

+ type UpdateSet interface

+ Decr func(column string, decr interface{}) UpdateSet

+ GetUpdate func() (updates []string, args [][]interface{})

+ Incr func(column string, incr interface{}) UpdateSet

+ Len func() int

+ Set func(column string, value interface{}) UpdateSet

+ SetMap func(columnValue map[string]interface{}) UpdateSet

+ SetSlice func(columns []string, values []interface{}) UpdateSet

+ Update func(update string, args ...interface{}) UpdateSet

+ UpdateExists func(prepare string) bool

+ UpdateIndex func(prepare string) int

+ func NewUpdateSet(way *Way) UpdateSet

+ type UpsertColumns interface

+ Add func(columns ...string) UpsertColumns

+ ColumnExists func(column string) bool

+ ColumnIndex func(column string) int

+ Del func(columns ...string) UpsertColumns

+ DelUseIndex func(indexes ...int) UpsertColumns

+ GetColumns func() []string

+ GetColumnsMap func() map[string]*struct{}

+ Len func() int

+ SetColumns func(columns []string) UpsertColumns

+ func NewUpsertColumns(way *Way) UpsertColumns

+ type Way struct

+ func NewWay(db *sql.DB) *Way

+ func (s *Way) Add(table string) *Add

+ func (s *Way) BatchUpdate(prepare string, argsList [][]interface{}) (affectedRows int64, err error)

+ func (s *Way) BatchUpdateContext(ctx context.Context, prepare string, argsList [][]interface{}) (affectedRows int64, err error)

+ func (s *Way) Begin(ctx context.Context, opts ...*sql.TxOptions) (*Way, error)

+ func (s *Way) BeginConn(ctx context.Context, conn *sql.Conn, opts ...*sql.TxOptions) (*Way, error)

+ func (s *Way) CmderExec(cmder Cmder) (int64, error)

+ func (s *Way) CmderExecContext(ctx context.Context, cmder Cmder) (int64, error)

+ func (s *Way) CmderExecute(cmder Cmder) (sql.Result, error)

+ func (s *Way) CmderExecuteContext(ctx context.Context, cmder Cmder) (sql.Result, error)

+ func (s *Way) CmderQuery(cmder Cmder, query func(rows *sql.Rows) error) error

+ func (s *Way) CmderQueryContext(ctx context.Context, cmder Cmder, query func(rows *sql.Rows) error) error

+ func (s *Way) CmderQueryRow(cmder Cmder, query func(row *sql.Row) error) error

+ func (s *Way) CmderQueryRowContext(ctx context.Context, cmder Cmder, query func(row *sql.Row) error) error

+ func (s *Way) CmderTakeAll(cmder Cmder, result interface{}) error

+ func (s *Way) CmderTakeAllContext(ctx context.Context, cmder Cmder, result interface{}) error

+ func (s *Way) Commit() error

+ func (s *Way) Debugger(cmder Cmder) *Way

+ func (s *Way) Del(table string) *Del

+ func (s *Way) Exec(prepare string, args ...interface{}) (int64, error)

+ func (s *Way) ExecContext(ctx context.Context, prepare string, args ...interface{}) (int64, error)

+ func (s *Way) Execute(prepare string, args ...interface{}) (sql.Result, error)

+ func (s *Way) ExecuteContext(ctx context.Context, prepare string, args ...interface{}) (sql.Result, error)

+ func (s *Way) F(fs ...Filter) Filter

+ func (s *Way) Get(table ...string) *Get

+ func (s *Way) GetCfg() *Cfg

+ func (s *Way) GetDatabase() *sql.DB

+ func (s *Way) GetLogger() *logger.Logger

+ func (s *Way) GetReader() Reader

+ func (s *Way) Getter(caller Caller, query func(rows *sql.Rows) error, prepare string, ...) error

+ func (s *Way) GetterContext(ctx context.Context, caller Caller, query func(rows *sql.Rows) error, ...) (err error)

+ func (s *Way) IsInTransaction() bool

+ func (s *Way) IsRead() bool

+ func (s *Way) Mod(table string) *Mod

+ func (s *Way) NewAddOne(prepare string, args []interface{}) AddOneReturnSequenceValue

+ func (s *Way) Now() time.Time

+ func (s *Way) Prepare(prepare string, caller ...Caller) (*Stmt, error)

+ func (s *Way) PrepareContext(ctx context.Context, prepare string, caller ...Caller) (stmt *Stmt, err error)

+ func (s *Way) Query(query func(rows *sql.Rows) error, prepare string, args ...interface{}) error

+ func (s *Way) QueryContext(ctx context.Context, query func(rows *sql.Rows) error, prepare string, ...) error

+ func (s *Way) QueryRow(query func(row *sql.Row) error, prepare string, args ...interface{}) error

+ func (s *Way) QueryRowContext(ctx context.Context, query func(row *sql.Row) error, prepare string, ...) error

+ func (s *Way) Read() *Way

+ func (s *Way) Replace(key string) string

+ func (s *Way) Replaces(keys []string) []string

+ func (s *Way) Rollback() error

+ func (s *Way) ScanAll(rows *sql.Rows, fc func(rows *sql.Rows) error) error

+ func (s *Way) ScanOne(rows *sql.Rows, dest ...interface{}) error

+ func (s *Way) SetCfg(cfg *Cfg) *Way

+ func (s *Way) SetDatabase(db *sql.DB) *Way

+ func (s *Way) SetLogger(l *logger.Logger) *Way

+ func (s *Way) SetReader(reader Reader) *Way

+ func (s *Way) Setter(caller Caller, prepare string, args ...interface{}) (int64, error)

+ func (s *Way) SetterContext(ctx context.Context, caller Caller, prepare string, args ...interface{}) (int64, error)

+ func (s *Way) T() *TableColumn

+ func (s *Way) TA() *TableColumn

+ func (s *Way) TB() *TableColumn

+ func (s *Way) TC() *TableColumn

+ func (s *Way) TD() *TableColumn

+ func (s *Way) TE() *TableColumn

+ func (s *Way) TF() *TableColumn

+ func (s *Way) TG() *TableColumn

+ func (s *Way) TakeAll(result interface{}, prepare string, args ...interface{}) error

+ func (s *Way) TakeAllContext(ctx context.Context, result interface{}, prepare string, args ...interface{}) error

+ func (s *Way) Transaction(ctx context.Context, fc func(tx *Way) error, opts ...*sql.TxOptions) error

+ func (s *Way) TransactionMessage(message string) *Way

+ func (s *Way) TransactionNew(ctx context.Context, fc func(tx *Way) error, opts ...*sql.TxOptions) error

+ func (s *Way) TransactionRetry(ctx context.Context, retries int, fc func(tx *Way) error, ...) (err error)

+ func (s *Way) WindowFunc(alias ...string) *WindowFunc

+ type WindowFunc struct

+ func NewWindowFunc(way *Way, aliases ...string) *WindowFunc

+ func (s *WindowFunc) Alias(alias string) *WindowFunc

+ func (s *WindowFunc) Asc(column string) *WindowFunc

+ func (s *WindowFunc) Avg(column string) *WindowFunc

+ func (s *WindowFunc) Count(column string) *WindowFunc

+ func (s *WindowFunc) DenseRank() *WindowFunc

+ func (s *WindowFunc) Desc(column string) *WindowFunc

+ func (s *WindowFunc) FirstValue(column string) *WindowFunc

+ func (s *WindowFunc) Lag(column string, offset int64, defaultValue any) *WindowFunc

+ func (s *WindowFunc) LastValue(column string) *WindowFunc

+ func (s *WindowFunc) Lead(column string, offset int64, defaultValue any) *WindowFunc

+ func (s *WindowFunc) Max(column string) *WindowFunc

+ func (s *WindowFunc) Min(column string) *WindowFunc

+ func (s *WindowFunc) NthValue(column string, LineNumber int64) *WindowFunc

+ func (s *WindowFunc) Ntile(buckets int64) *WindowFunc

+ func (s *WindowFunc) Partition(column ...string) *WindowFunc

+ func (s *WindowFunc) Rank() *WindowFunc

+ func (s *WindowFunc) Result() string

+ func (s *WindowFunc) RowNumber() *WindowFunc

+ func (s *WindowFunc) Sum(column string) *WindowFunc

+ func (s *WindowFunc) WindowFrame(windowFrame string) *WindowFunc

+ func (s *WindowFunc) WithFunc(withFunc string) *WindowFunc

Other modules containing this package

github.com/cd365/hey

github.com/cd365/hey/v2

github.com/cd365/hey/v5

github.com/cd365/hey/v6

github.com/cd365/hey/v7

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