spellsql

Nov 26, 2023

Changes in this version

+ const NULL

+ func ConvStruct(src interface{}, dest interface{}) error

+ func InsertsHasDefaultForObjCtx(ctx context.Context, db DBer, tableName string, ...) (sql.Result, error)

+ type ConvStructObj struct

+ func NewConvStruct(tagName ...string) *ConvStructObj

+ func (c *ConvStructObj) Convert() error

+ func (c *ConvStructObj) Exclude(tagVals ...string) *ConvStructObj

+ func (c *ConvStructObj) Init(src, dest interface{}) error

+ func (c *ConvStructObj) SrcMarshal(fn marshalFn, tagVal ...string) *ConvStructObj

+ func (c *ConvStructObj) SrcUnmarshal(fn unmarshalFn, tagVal ...string) *ConvStructObj

Oct 17, 2023

Changes in this version

+ func CountCtx(ctx context.Context, db DBer, tableName string, dest interface{}, where string, ...) error

+ func DeleteWhereCtx(ctx context.Context, db DBer, tableName string, where string, ...) (sql.Result, error)

+ func ExecForSqlCtx(ctx context.Context, db DBer, sql interface{}) (sql.Result, error)

+ func FindAllCtx(ctx context.Context, db DBer, sql interface{}, dest interface{}, ...) error

+ func FindOneCtx(ctx context.Context, db DBer, sql interface{}, dest ...interface{}) error

+ func FindOneFnCtx(ctx context.Context, db DBer, sql interface{}, dest interface{}, ...) error

+ func FindWhereCtx(ctx context.Context, db DBer, tableName string, dest interface{}, where string, ...) error

+ func GetSqlStrCtx(ctx context.Context, sqlStr string, args ...interface{}) string

+ func InsertForObjCtx(ctx context.Context, db DBer, tableName string, src ...interface{}) (sql.Result, error)

+ func InsertHasDefaultForObjCtx(ctx context.Context, db DBer, tableName string, ...) (sql.Result, error)

+ func InsertIgForObjCtx(ctx context.Context, db DBer, tableName string, src interface{}) (sql.Result, error)

+ func InsertODKUForObjCtx(ctx context.Context, db DBer, tableName string, src interface{}, ...) (sql.Result, error)

+ func SelectFindAllCtx(ctx context.Context, db DBer, fields interface{}, tableName string, ...) error

+ func SelectFindOneCtx(ctx context.Context, db DBer, fields interface{}, tableName string, ...) error

+ func SelectFindOneFnCtx(ctx context.Context, db DBer, fields interface{}, tableName string, ...) error

+ func SelectFindOneIgnoreResultCtx(cxt context.Context, db DBer, fields interface{}, tableName string, ...) error

+ func SelectFindWhereCtx(ctx context.Context, db DBer, fields interface{}, tableName string, ...) error

+ func UpdateForObjCtx(ctx context.Context, db DBer, tableName string, src interface{}, where string, ...) (sql.Result, error)

type CommonTable

+ func (c *CommonTable) SetCtx(ctx context.Context)

type DBer

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

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

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

type MysqlTable

+ func (m *MysqlTable) SetCtx(ctx context.Context)

type PgTable

+ func (p *PgTable) SetCtx(ctx context.Context)

type SqlStrObj

+ func (s *SqlStrObj) SetCtx(ctx context.Context) *SqlStrObj

type Table

+ func (t *Table) Ctx(ctx context.Context) *Table

type TableMetaer

+ SetCtx func(ctx context.Context)

Sep 10, 2023

Changes in this version

+ func Escape(val []byte, escapeMap map[byte][]byte) []byte

+ func GetValueEscapeMap() map[byte][]byte

type CommonTable

+ func (c *CommonTable) GetValueEscapeMap() map[byte][]byte

+ func (c *CommonTable) GetValueStrSymbol() byte

type PgTable

+ func (p *PgTable) GetValueEscapeMap() map[byte][]byte

+ func (p *PgTable) GetValueStrSymbol() byte

type SqlStrObj

+ func (s *SqlStrObj) SetEscapeMap(escapeMap map[byte][]byte) *SqlStrObj

type Table

+ func (t *Table) AppendSql(sqlStr string, args ...interface{}) *Table

+ func (t *Table) GetParcelFieldArr(fields ...string) []string

+ func (t *Table) InsertOfFields(cols []string, insertObjs ...interface{}) *Table

type TableMetaer

+ GetValueEscapeMap func() map[byte][]byte

+ GetValueStrSymbol func() byte

Sep 1, 2023

Changes in this version

type CommonTable

+ func (c *CommonTable) GetParcelFieldSymbol() byte

type PgTable

+ func (p *PgTable) GetParcelFieldSymbol() byte

type Table

+ func (t *Table) GetParcelFields(fields ...string) string

+ func (t *Table) InsertsIg(insertObj ...interface{}) *Table

+ func (t *Table) InsertsODKU(insertObjs []interface{}, keys ...string) *Table

type TableMetaer

+ GetParcelFieldSymbol func() byte

Jul 9, 2023

Changes in this version

+ func NewLogger() *defaultLogger

+ type SortByTableColInfo []*TableColInfo

+ func (a SortByTableColInfo) Len() int

+ func (a SortByTableColInfo) Less(i, j int) bool

+ func (a SortByTableColInfo) Swap(i, j int)

type Table

+ func (t *Table) GetCols(skipCols ...string) []string

type TableColInfo

+ Index int

Jun 19, 2023

Changes in this version

type Table

+ func (t *Table) ParseCol2Val(src interface{}, op ...uint8) ([]string, []interface{}, error)

May 7, 2023

Changes in this version

+ type CommonTable struct

+ func (c *CommonTable) EscapeBytes(b []byte) []byte

+ func (c *CommonTable) GetAdapterName() string

+ func (c *CommonTable) GetField2ColInfoMap(db DBer) (map[string]*TableColInfo, error)

+ func (c *CommonTable) GetStrSymbol() byte

+ func (c *CommonTable) SetTableName(tableName string)

type MysqlTable

+ func (m *MysqlTable) EscapeBytes(b []byte) []byte

type TableMetaer

+ EscapeBytes func(b []byte) []byte

Apr 18, 2023

Changes in this version

+ func FreeTmerFlag(is bool)

Apr 17, 2023

Changes in this version

+ const NotNullFlag

+ const PriFlag

+ func GlobalTmer(obj TableMetaer)

+ func Int64(num interface{}) int64

+ type MysqlTable struct

+ func Mysql() *MysqlTable

+ func (m *MysqlTable) GetAdapterName() string

+ func (m *MysqlTable) GetField2ColInfoMap(db DBer) (map[string]*TableColInfo, error)

+ func (m *MysqlTable) GetStrSymbol() byte

+ func (m *MysqlTable) SetTableName(name string)

+ type PgTable struct

+ func Pg(initArgs ...string) *PgTable

+ func (p *PgTable) GetAdapterName() string

+ func (p *PgTable) GetField2ColInfoMap(db DBer) (map[string]*TableColInfo, error)

+ func (p *PgTable) GetStrSymbol() byte

+ func (p *PgTable) SetTableName(name string)

type SqlStrObj

+ func (s *SqlStrObj) GetOffset(page, size interface{}) (int64, int64)

+ func (s *SqlStrObj) SetLeftJoin(tableName string, on string) *SqlStrObj

+ func (s *SqlStrObj) SetRightJoin(tableName string, on string) *SqlStrObj

+ func (s *SqlStrObj) SetStrSymbol(strSymbol byte) *SqlStrObj

type Table

+ func (t *Table) AllLike(filedName, value string) *Table

+ func (t *Table) LefJoin(joinTable, on string) *Table

+ func (t *Table) LeftLike(filedName, value string) *Table

+ func (t *Table) RightJoin(joinTable, on string) *Table

+ func (t *Table) RightLike(filedName, value string) *Table

+ func (t *Table) Tmer(obj TableMetaer) *Table

type TableColInfo

+ func (t *TableColInfo) IsPri() bool

+ func (t *TableColInfo) NotNull() bool

+ type TableMetaer interface

+ GetAdapterName func() string

+ GetField2ColInfoMap func(db DBer) (map[string]*TableColInfo, error)

+ GetStrSymbol func() byte

+ SetTableName func(tableName string)

Mar 30, 2023

Changes in this version

+ func InsertHasDefaultForObj(db DBer, tableName string, tag2DefaultMap map[string]interface{}, ...) (sql.Result, error)

type Table

+ func (t *Table) TagDefault(tag2DefaultMap map[string]interface{}) *Table

Feb 15, 2023

Changes in this version

type Table

+ func (t *Table) Clone() *Table

Feb 6, 2023

Changes in this version

+ func InsertIgForObj(db DBer, tableName string, src interface{}) (sql.Result, error)

+ func InsertODKUForObj(db DBer, tableName string, src interface{}, keys ...string) (sql.Result, error)

type Table

+ func (t *Table) InsertIg(insertObj interface{}) *Table

+ func (t *Table) InsertODKU(insertObj interface{}, keys ...string) *Table

Dec 30, 2022

Changes in this version

type LRUCache

+ func (l *LRUCache) Delete(key interface{})

+ func (l *LRUCache) SetDelCallBackFn(f func(key, value interface{}))

Dec 23, 2022

Changes in this version

+ type LRUCache struct

+ func NewLRU(max int) *LRUCache

+ func (l *LRUCache) Dump() string

+ func (l *LRUCache) Len() int

+ func (l *LRUCache) Load(key interface{}) (data interface{}, ok bool)

+ func (l *LRUCache) Store(key, value interface{})

Dec 6, 2022

Changes in this version

type SqlStrObj

+ func (s *SqlStrObj) FmtSql() string

Nov 13, 2022

Changes in this version

+ func Str(src interface{}) string

type SqlStrObj

+ func (s *SqlStrObj) SetHaving(having string, args ...interface{}) *SqlStrObj

type Table

+ func (t *Table) Having(sqlStr string, args ...interface{}) *Table

Jun 5, 2022

Changes in this version

+ const LJI

+ const RJI

type SqlStrObj

+ func (s *SqlStrObj) SetJoin(tableName string, on string, joinType ...uint8) *SqlStrObj

type Table

+ func (t *Table) Join(joinTable, on string, joinType ...uint8) *Table

May 21, 2022

Changes in this version

type Table

+ func (t *Table) TagAlias(tag2AliasMap map[string]string) *Table

May 18, 2022

Changes in this version

type Table

+ func (t *Table) Between(filedName string, leftVal, rightVal interface{}) *Table

+ func (t *Table) Exclude(cols ...string) *Table

+ func (t *Table) From(tableName string) *Table

May 10, 2022

Changes in this version

+ func DistinctIds(ids []string) []string

+ func SelectFindOneIgnoreResult(db DBer, fields interface{}, tableName string, where string, dest interface{}, ...) error

type Table

+ func (t *Table) FindOneIgnoreResult(dest interface{}, fn ...SelectCallBackFn) error

+ func (t *Table) WhereLike(likeType uint8, filedName, value string) *Table

Apr 28, 2022

Changes in this version

+ func SelectFindAll(db DBer, fields interface{}, tableName string, where string, dest interface{}, ...) error

+ func SelectFindOneFn(db DBer, fields interface{}, tableName string, where string, dest interface{}, ...) error

+ type Marshal func(v interface{}) ([]byte, error)

type Table

+ func (t *Table) SetMarshalFn(fn Marshal, cols ...string) *Table

+ func (t *Table) SetUnmarshalFn(fn Unmarshal, cols ...string) *Table

+ type Unmarshal func(data []byte, v interface{}) error

Apr 20, 2022

Changes in this version

+ func SelectFindOne(db DBer, fields interface{}, tableName string, where string, ...) error

Apr 17, 2022

Changes in this version

+ func DeleteWhere(db DBer, tableName string, where string, args ...interface{}) (sql.Result, error)

+ func FindOneFn(db DBer, sql interface{}, dest interface{}, fn ...SelectCallBackFn) error

type Table

+ func (t *Table) FindOneFn(dest interface{}, fn ...SelectCallBackFn) error

+ func (t *Table) GroupBy(sqlStr string) *Table

+ func (t *Table) NeedSetSize(need bool) *Table

Apr 13, 2022

Changes in this version

+ func IsNullRow(err error) bool

type SqlStrObj

+ func (s *SqlStrObj) LimitIsEmpty() bool

Apr 13, 2022

Changes in this version

+ func ExecForSql(db DBer, sql interface{}) (sql.Result, error)

type Table

+ func (t *Table) PrintSqlCallSkip(skip uint8) *Table

+ func (t *Table) SelectAuto(src interface{}, tableName ...string) *Table

Apr 11, 2022

Changes in this version

+ func SelectFindWhere(db DBer, fields, tableName string, obj interface{}, where string, ...) error

type Logger

+ Panic func(v ...interface{})

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

Apr 5, 2022

Changes in this version

+ func FindWhere(db DBer, tableName string, obj interface{}, where string, args ...interface{}) error

Mar 31, 2022

Changes in this version

+ var NoDataErr = errors.New("result is null")

+ func Count(db DBer, tableName string, dest interface{}, where string, args ...interface{}) error

type Table

+ func (t *Table) SelectCount() *Table

Mar 30, 2022

Changes in this version

+ func DeleteForObj(db DBer, tableName string, obj interface{}) (sql.Result, error)

+ func DeleteForSql(db DBer, sql interface{}) (sql.Result, error)

+ func FindAll(db DBer, sql interface{}, dest interface{}, fn ...SelectCallBackFn) error

+ func FindOne(db DBer, sql interface{}, dest ...interface{}) error

+ func InsertForObj(db DBer, tableName string, obj ...interface{}) (sql.Result, error)

+ func InsertForSql(db DBer, sql interface{}) (sql.Result, error)

+ func UpdateForObj(db DBer, tableName string, obj interface{}) (sql.Result, error)

+ func UpdateForSql(db DBer, sql interface{}) (sql.Result, error)

type Logger

+ Warning func(v ...interface{})

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

type Table

+ func (t *Table) Name(tableName string) *Table

Mar 28, 2022

Changes in this version

+ type SelectCallBackFn func(_rowModel interface{}) error

Mar 28, 2022

Changes in this version

+ type HandleSelectRowFn func(_rowModel interface{}) error

type Table

+ func (t *Table) FindWhere(dest interface{}, where string, args ...interface{}) error

+ func (t *Table) IsPrintSql(is bool) *Table

+ func (t *Table) SetName(tableName string) *Table

Mar 26, 2022

Changes in this version

+ const ALK

+ const DELETE

+ const INSERT

+ const LLK

+ const RLK

+ const SELECT

+ const UPDATE

+ func DistinctIdsStr(s string, split string) string

+ func FmtSqlStr(sqlStr string, args ...interface{}) string

+ func GetLikeSqlStr(likeType uint8, sqlStr, filedName, value string, printLog ...bool) string

+ func GetSqlStr(sqlStr string, args ...interface{}) string

+ func IndexForBF(isFont2End bool, s, substr string) int

+ func NewCjLogger() *defaultLogger

+ func SetLogger(logger Logger)

+ type DBer interface

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

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

+ QueryRow func(query string, args ...interface{}) *sql.Row

+ type Logger interface

+ Error func(v ...interface{})

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

+ Info func(v ...interface{})

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

+ type SqlStrObj struct

+ func NewCacheSql(sqlStr string, args ...interface{}) *SqlStrObj

+ func NewSql(sqlStr string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) Append(sqlStr string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) Clone() *SqlStrObj

+ func (s *SqlStrObj) GetSqlStr(title ...string) (sqlStr string)

+ func (s *SqlStrObj) GetTotalSqlStr(title ...string) (findSqlStr string)

+ func (s *SqlStrObj) Int2Str(num int64) string

+ func (s *SqlStrObj) SetAllLike(filedName string, val string)

+ func (s *SqlStrObj) SetBetween(filedName string, leftVal, rightVal interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetCallerSkip(skip uint8) *SqlStrObj

+ func (s *SqlStrObj) SetGroupByStr(groupByStr string) *SqlStrObj

+ func (s *SqlStrObj) SetInsertValues(args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetInsertValuesArgs(sqlStr string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetLeftLike(filedName string, val string)

+ func (s *SqlStrObj) SetLimit(page, size int32) *SqlStrObj

+ func (s *SqlStrObj) SetLimitStr(limitStr string) *SqlStrObj

+ func (s *SqlStrObj) SetOrWhere(filedName string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetOrWhereArgs(sqlStr string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetOrderByStr(orderByStr string) *SqlStrObj

+ func (s *SqlStrObj) SetPrintLog(isPrint bool) *SqlStrObj

+ func (s *SqlStrObj) SetRightLike(filedName string, val string)

+ func (s *SqlStrObj) SetUpdateValue(filedName string, arg interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetUpdateValueArgs(sqlStr string, arg ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetWhere(filedName string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SetWhereArgs(sqlStr string, args ...interface{}) *SqlStrObj

+ func (s *SqlStrObj) SqlIsEmpty() bool

+ func (s *SqlStrObj) SqlStrLen() int

+ func (s *SqlStrObj) UInt2Str(num uint64) string

+ func (s *SqlStrObj) ValueIsEmpty() bool

+ func (s *SqlStrObj) ValueStrLen() int

+ func (s *SqlStrObj) WhereIsEmpty() bool

+ func (s *SqlStrObj) WhereStrLen() int

+ type Table struct

+ func NewTable(db DBer, args ...string) *Table

+ func (t *Table) Count(total interface{}) error

+ func (t *Table) Delete(deleteObj ...interface{}) *Table

+ func (t *Table) Exec() (sql.Result, error)

+ func (t *Table) FindAll(dest interface{}) error

+ func (t *Table) FindOne(dest interface{}) error

+ func (t *Table) GetSqlObj() *SqlStrObj

+ func (t *Table) Group(groupSqlStr string) *Table

+ func (t *Table) Insert(insertObjs ...interface{}) (sql.Result, error)

+ func (t *Table) Limit(page int32, size int32) *Table

+ func (t *Table) OrWhere(sqlStr string, args ...interface{}) *Table

+ func (t *Table) OrderBy(sqlStr string) *Table

+ func (t *Table) PrintSql(is bool) *Table

+ func (t *Table) Query() (*sql.Rows, error)

+ func (t *Table) QueryRowScan(dest ...interface{}) error

+ func (t *Table) Raw(sql interface{}) *Table

+ func (t *Table) Select(fileds string) *Table

+ func (t *Table) SelectAll() *Table

+ func (t *Table) Update(updateObj interface{}) *Table

+ func (t *Table) Where(sqlStr string, args ...interface{}) *Table

+ type TableColInfo struct

+ Default sql.NullString

+ Extra string

+ Field string

+ Key string

+ Null string

+ Type string