sqlchemy

package module

Go to main page

Versions in this module

v1

v1.1.5

Dec 29, 2023

v1.1.4

Dec 29, 2023

v1.1.3

Dec 29, 2023

Changes in this version

+ const ClickhouseBackend

+ const DefaultDB

+ const ErrUnionAcrossDatabases

+ const IndexLimit

+ const MySQLBackend

+ const SQL_OP_REGEXP

+ const SQLiteBackend

+ func DiffCols(tableName string, cols1 []IColumnSpec, cols2 []IColumnSpec) ([]IColumnSpec, []SUpdateColumnSpec, []IColumnSpec)

+ func FetchColumns(match string) []string

+ func GetStringValue(dat interface{}) string

+ func RegisterBackend(drv IBackend)

+ func ResetTableID()

+ func SetDBWithNameBackend(db *sql.DB, name DBName, backend DBBackendName)

+ func SetDefaultDB(db *sql.DB)

+ func SetupMockDatabaseBackend()

+ func VarConditionWhereClause(v interface{}) string

+ type DBBackendName string

+ type DBName string

+ type IBackend interface

+ AND_Val func(name string, field IQueryField, v interface{}) IQueryField

+ CAST func(field IQueryField, typeStr string, fieldname string) IQueryField

+ CONCAT func(name string, fields ...IQueryField) IQueryField

+ COUNT func(name string, field ...IQueryField) IQueryField

+ CanInsert func() bool

+ CanInsertOrUpdate func() bool

+ CanSupportRowAffected func() bool

+ CanUpdate func() bool

+ CaseInsensitiveLikeString func() string

+ CommitTableChangeSQL func(ts ITableSpec, changes STableChanges) []string

+ CurrentTimeStampString func() string

+ CurrentUTCTimeStampString func() string

+ DATEDIFF func(unit string, field1, field2 IQueryField) IQueryField

+ DATE_FORMAT func(name string, field IQueryField, format string) IQueryField

+ DISTINCT func(name string, field IQueryField) IQueryField

+ DropTableSQL func(table string) string

+ FetchIndexesAndConstraints func(ts ITableSpec) ([]STableIndex, []STableConstraint, error)

+ FetchTableColumnSpecs func(ts ITableSpec) ([]IColumnSpec, error)

+ GROUP_CONCAT2 func(name string, sep string, field IQueryField) IQueryField

+ GetColumnSpecByFieldType func(table *STableSpec, fieldType reflect.Type, fieldname string, ...) IColumnSpec

+ GetCreateSQLs func(ts ITableSpec) []string

+ GetTableSQL func() string

+ INET_ATON func(field IQueryField) IQueryField

+ InsertOrUpdateSQLTemplate func() string

+ InsertSQLTemplate func() string

+ IsSupportIndexAndContraints func() bool

+ LENGTH func(name string, field IQueryField) IQueryField

+ LOWER func(name string, field IQueryField) IQueryField

+ MAX func(name string, field IQueryField) IQueryField

+ MIN func(name string, field IQueryField) IQueryField

+ Name func() DBBackendName

+ OR_Val func(name string, field IQueryField, v interface{}) IQueryField

+ REPLACE func(name string, field IQueryField, old string, new string) IQueryField

+ RegexpWhereClause func(cond *SRegexpConition) string

+ SUBSTR func(name string, field IQueryField, pos, length int) IQueryField

+ SUM func(name string, field IQueryField) IQueryField

+ SupportMixedInsertVariables func() bool

+ TIMESTAMPADD func(name string, field IQueryField, offsetSeconds int) IQueryField

+ UPPER func(name string, field IQueryField) IQueryField

+ UnionAllString func() string

+ UnionDistinctString func() string

+ UpdateSQLTemplate func() string

type IColumnSpec

+ AutoIncrementOffset func() int64

+ GetColIndex func() int

+ IsAutoIncrement func() bool

+ IsAutoVersion func() bool

+ IsCreatedAt func() bool

+ IsDateTime func() bool

+ IsString func() bool

+ IsUpdatedAt func() bool

+ SetAutoIncrement func(val bool)

+ SetAutoIncrementOffset func(offset int64)

+ SetColIndex func(idx int)

+ SetPrimary func(on bool)

type ICondition

+ func Noop() ICondition

+ func Regexp(f IQueryField, v string) ICondition

type IQueryField

+ func ABS(name string, field IQueryField) IQueryField

+ func CAST(field IQueryField, typeStr string, fieldname string) IQueryField

+ func DATEDIFF(unit string, field1, field2 IQueryField) IQueryField

+ func DATE_FORMAT(name string, field IQueryField, format string) IQueryField

+ func GROUP_CONCAT2(name string, sep string, field IQueryField) IQueryField

+ func LENGTH(name string, field IQueryField) IQueryField

+ func LOWER(name string, field IQueryField) IQueryField

+ func SUBSTR(name string, field IQueryField, pos, length int) IQueryField

+ func TIMESTAMPADD(name string, field IQueryField, offsetSeconds int) IQueryField

+ func UPPER(name string, field IQueryField) IQueryField

type ITableSpec

+ Database func() *SDatabase

+ Drop func() error

+ GetExtraOptions func() TableExtraOptions

+ Indexes func() []STableIndex

+ SetExtraOptions func(opts TableExtraOptions)

+ Sync func() error

+ type InsertSqlResult struct

+ Primaries map[string]interface{}

+ Sql string

+ Values []interface{}

+ type SBaseBackend struct

+ func (bb *SBaseBackend) AND_Val(name string, field IQueryField, v interface{}) IQueryField

+ func (bb *SBaseBackend) CAST(field IQueryField, typeStr string, fieldname string) IQueryField

+ func (bb *SBaseBackend) CONCAT(name string, fields ...IQueryField) IQueryField

+ func (bb *SBaseBackend) COUNT(name string, field ...IQueryField) IQueryField

+ func (bb *SBaseBackend) CanInsert() bool

+ func (bb *SBaseBackend) CanInsertOrUpdate() bool

+ func (bb *SBaseBackend) CanSupportRowAffected() bool

+ func (bb *SBaseBackend) CanUpdate() bool

+ func (bb *SBaseBackend) CaseInsensitiveLikeString() string

+ func (bb *SBaseBackend) CommitTableChangeSQL(ts ITableSpec, changes STableChanges) []string

+ func (bb *SBaseBackend) CurrentTimeStampString() string

+ func (bb *SBaseBackend) CurrentUTCTimeStampString() string

+ func (bb *SBaseBackend) DATEDIFF(unit string, field1, field2 IQueryField) IQueryField

+ func (bb *SBaseBackend) DATE_FORMAT(name string, field IQueryField, format string) IQueryField

+ func (bb *SBaseBackend) DISTINCT(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) DropIndexSQLTemplate() string

+ func (bb *SBaseBackend) DropTableSQL(table string) string

+ func (bb *SBaseBackend) FetchIndexesAndConstraints(ts ITableSpec) ([]STableIndex, []STableConstraint, error)

+ func (bb *SBaseBackend) FetchTableColumnSpecs(ts ITableSpec) ([]IColumnSpec, error)

+ func (bb *SBaseBackend) GROUP_CONCAT2(name string, sep string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) GetColumnSpecByFieldType(table *STableSpec, fieldType reflect.Type, fieldname string, ...) IColumnSpec

+ func (bb *SBaseBackend) GetCreateSQLs(ts ITableSpec) []string

+ func (bb *SBaseBackend) GetTableSQL() string

+ func (bb *SBaseBackend) INET_ATON(field IQueryField) IQueryField

+ func (bb *SBaseBackend) InsertOrUpdateSQLTemplate() string

+ func (bb *SBaseBackend) InsertSQLTemplate() string

+ func (bb *SBaseBackend) IsSupportIndexAndContraints() bool

+ func (bb *SBaseBackend) LENGTH(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) LOWER(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) MAX(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) MIN(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) Name() DBBackendName

+ func (bb *SBaseBackend) OR_Val(name string, field IQueryField, v interface{}) IQueryField

+ func (bb *SBaseBackend) REPLACE(name string, field IQueryField, old string, new string) IQueryField

+ func (bb *SBaseBackend) RegexpWhereClause(cond *SRegexpConition) string

+ func (bb *SBaseBackend) SUBSTR(name string, field IQueryField, pos, length int) IQueryField

+ func (bb *SBaseBackend) SUM(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) SupportMixedInsertVariables() bool

+ func (bb *SBaseBackend) TIMESTAMPADD(name string, field IQueryField, offsetSeconds int) IQueryField

+ func (bb *SBaseBackend) UPPER(name string, field IQueryField) IQueryField

+ func (bb *SBaseBackend) UnionAllString() string

+ func (bb *SBaseBackend) UnionDistinctString() string

+ func (bb *SBaseBackend) UpdateSQLTemplate() string

type SBaseColumn

+ func (c *SBaseColumn) AutoIncrementOffset() int64

+ func (c *SBaseColumn) GetColIndex() int

+ func (c *SBaseColumn) IsAutoIncrement() bool

+ func (c *SBaseColumn) IsAutoVersion() bool

+ func (c *SBaseColumn) IsCreatedAt() bool

+ func (c *SBaseColumn) IsDateTime() bool

+ func (c *SBaseColumn) IsString() bool

+ func (c *SBaseColumn) IsUpdatedAt() bool

+ func (c *SBaseColumn) SetAutoIncrement(val bool)

+ func (c *SBaseColumn) SetAutoIncrementOffset(offset int64)

+ func (c *SBaseColumn) SetColIndex(idx int)

+ func (c *SBaseColumn) SetPrimary(on bool)

+ type SBaseCompoundColumn struct

+ func (c *SBaseCompoundColumn) ConvertFromString(str string) interface{}

+ func (c *SBaseCompoundColumn) ConvertFromValue(val interface{}) interface{}

+ type SDatabase struct

+ func GetDBWithName(name DBName) *SDatabase

+ func GetDefaultDB() *SDatabase

+ func (db *SDatabase) DB() *sql.DB

+ func (db *SDatabase) Exec(sql string, args ...interface{}) (sql.Result, error)

+ func (db *SDatabase) GetTables() []string

+ func (db *SDatabase) NewRawQuery(sqlStr string, fields ...string) *SQuery

+ func (db *SDatabase) TxBatchExec(sqlstr string, varsList [][]interface{}) ([]SSqlResult, error)

+ func (db *SDatabase) TxExec(sqlstr string, vars ...interface{}) (sql.Result, error)

type SQuery

+ func (self *SQuery) Copy() *SQuery

+ func (tq *SQuery) CountQuery() *SQuery

+ func (tq *SQuery) HasField(f IQueryField) bool

+ func (tq *SQuery) IsGroupBy() bool

+ func (tq *SQuery) Regexp(f string, v string) *SQuery

+ func (tq *SQuery) ResetFields() *SQuery

+ type SRegexpConition struct

+ func (t *SRegexpConition) WhereClause() string

+ type SSqlResult struct

+ Error error

+ Result sql.Result

+ type STableChanges struct

+ AddColumns []IColumnSpec

+ AddIndexes []STableIndex

+ OldColumns []IColumnSpec

+ RemoveColumns []IColumnSpec

+ RemoveIndexes []STableIndex

+ UpdatedColumns []SUpdateColumnSpec

+ type STableConstraint struct

+ func NewTableConstraint(name string, cols []string, foreignTable string, fcols []string) STableConstraint

+ type STableIndex struct

+ func NewTableIndex(ts ITableSpec, name string, cols []string, unique bool) STableIndex

+ func (index *STableIndex) IsIdentical(cols ...string) bool

+ func (index *STableIndex) Name() string

+ func (index *STableIndex) QuotedColumns() []string

type STableSpec

+ func NewTableSpecFromISpecWithDBName(spec ITableSpec, name string, dbName DBName, extraOpts TableExtraOptions) *STableSpec

+ func NewTableSpecFromStructWithDBName(s interface{}, name string, dbName DBName) *STableSpec

+ func (r *STableSpec) DBName() DBName

+ func (r *STableSpec) Database() *SDatabase

+ func (t *STableSpec) InsertBatch(dataList []interface{}) error

+ func (t *STableSpec) InsertSqlPrep(data interface{}, update bool) (*InsertSqlResult, error)

+ func (ts *STableSpec) CloneWithSyncColumnOrder(name string, autoIncOffset int64, syncColOrder bool) (*STableSpec, error)

+ func (ts *STableSpec) CreateSQLs() []string

+ func (ts *STableSpec) DeleteFrom(filters map[string]interface{}) error

+ func (ts *STableSpec) Drop() error

+ func (ts *STableSpec) GetExtraOptions() TableExtraOptions

+ func (ts *STableSpec) Indexes() []STableIndex

+ func (ts *STableSpec) PrepareUpdate(dt interface{}) (*SUpdateSession, error)

+ func (ts *STableSpec) SetExtraOptions(opts TableExtraOptions)

+ func (ts *STableSpec) SyncColumnIndexes() error

+ func (ts *STableSpec) UpdateBatch(data map[string]interface{}, filter map[string]interface{}) error

type STupleCondition

+ func (t *STupleCondition) GetLeft() IQueryField

+ func (t *STupleCondition) GetRight() interface{}

type SUnion

+ func UnionAllWithError(query ...IQuery) (*SUnion, error)

+ type SUpdateColumnSpec struct

+ NewCol IColumnSpec

+ OldCol IColumnSpec

+ type SUpdateSQLResult struct

+ Sql string

+ Vars []interface{}

type SUpdateSession

+ func (us *SUpdateSession) SaveUpdateSql(dt interface{}) (*SUpdateSQLResult, error)

+ type TColumnNames []string

+ func (cols TColumnNames) Len() int

+ func (cols TColumnNames) Less(i, j int) bool

+ func (cols TColumnNames) Swap(i, j int)

+ type TableExtraOptions map[string]string

+ func (opts TableExtraOptions) Contains(key string) bool

+ func (opts TableExtraOptions) Get(key string) string

+ func (opts TableExtraOptions) Set(key string, val string) TableExtraOptions

v1.0.2

Apr 13, 2022

Changes in this version

type IQueryField

+ func ADD(name string, fields ...IQueryField) IQueryField

+ func DIV(name string, fields ...IQueryField) IQueryField

+ func MUL(name string, fields ...IQueryField) IQueryField

+ func SUB(name string, fields ...IQueryField) IQueryField

v1.0.1

Jan 19, 2022

Changes in this version

+ const ErrDuplicateEntry

+ const ErrEmptyPrimaryKey

+ const ErrEmptyQuery

+ const ErrNeedsArray

+ const ErrNeedsPointer

+ const ErrNoDataToUpdate

+ const ErrNotSupported

+ const ErrReadOnly

+ const ErrTableNotExists

+ const ErrUnexpectRowCount

+ const ErrUnionFieldsNotMatch

+ const SQL_OP_AND

+ const SQL_OP_BETWEEN

+ const SQL_OP_EQUAL

+ const SQL_OP_GE

+ const SQL_OP_GT

+ const SQL_OP_IN

+ const SQL_OP_LE

+ const SQL_OP_LIKE

+ const SQL_OP_LT

+ const SQL_OP_NOT

+ const SQL_OP_NOTEQUAL

+ const SQL_OP_NOTIN

+ const SQL_OP_OR

+ const TAG_ALLOW_ZERO

+ const TAG_AUTOINCREMENT

+ const TAG_AUTOVERSION

+ const TAG_CHARSET

+ const TAG_CREATE_TIMESTAMP

+ const TAG_DEFAULT

+ const TAG_IGNORE

+ const TAG_INDEX

+ const TAG_NAME

+ const TAG_NULLABLE

+ const TAG_PRECISION

+ const TAG_PRIMARY

+ const TAG_TEXT_LENGTH

+ const TAG_UNIQUE

+ const TAG_UPDATE_TIMESTAMP

+ const TAG_WIDTH

+ var DEBUG_SQLCHEMY = false

+ var INT_WIDTH_DEFAULT = map[string]int

+ var UNSIGNED_INT_WIDTH_DEFAULT = map[string]int

+ func CloseDB()

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

+ func GetDB() *sql.DB

+ func GetTables() []string

+ func SetDB(db *sql.DB)

+ type CompoundColumn struct

+ func NewCompoundColumn(name string, tagmap map[string]string, isPointer bool) CompoundColumn

+ func (c *CompoundColumn) ConvertFromValue(val interface{}) interface{}

+ func (c *CompoundColumn) DefinitionString() string

+ func (c *CompoundColumn) IsZero(val interface{}) bool

+ type IColumnSpec interface

+ AllowZero func() bool

+ ColType func() string

+ ConvertFromString func(str string) string

+ ConvertFromValue func(val interface{}) interface{}

+ Default func() string

+ DefinitionString func() string

+ ExtraDefs func() string

+ IsAscii func() bool

+ IsIndex func() bool

+ IsNullable func() bool

+ IsNumeric func() bool

+ IsPointer func() bool

+ IsPrimary func() bool

+ IsSearchable func() bool

+ IsSupportDefault func() bool

+ IsText func() bool

+ IsUnique func() bool

+ IsZero func(val interface{}) bool

+ Name func() string

+ SetDefault func(defStr string)

+ SetNullable func(on bool)

+ Tags func() map[string]string

+ type ICondition interface

+ Variables func() []interface{}

+ WhereClause func() string

+ func AND(cond ...ICondition) ICondition

+ func Between(f IQueryField, r1, r2 interface{}) ICondition

+ func Contains(f IQueryField, v string) ICondition

+ func ContainsAny(f IQueryField, v []string) ICondition

+ func Endswith(f IQueryField, v string) ICondition

+ func Equals(f IQueryField, v interface{}) ICondition

+ func GE(f IQueryField, v interface{}) ICondition

+ func GT(f IQueryField, v interface{}) ICondition

+ func In(f IQueryField, v interface{}) ICondition

+ func IsEmpty(f IQueryField) ICondition

+ func IsFalse(f IQueryField) ICondition

+ func IsNotEmpty(f IQueryField) ICondition

+ func IsNotNull(f IQueryField) ICondition

+ func IsNull(f IQueryField) ICondition

+ func IsNullOrEmpty(f IQueryField) ICondition

+ func IsTrue(f IQueryField) ICondition

+ func LE(f IQueryField, v interface{}) ICondition

+ func LT(f IQueryField, v interface{}) ICondition

+ func Like(f IQueryField, v string) ICondition

+ func NOT(cond ICondition) ICondition

+ func NoEarlierThan(f IQueryField) ICondition

+ func NoLaterThan(f IQueryField) ICondition

+ func NotEquals(f IQueryField, v interface{}) ICondition

+ func NotIn(f IQueryField, v interface{}) ICondition

+ func OR(cond ...ICondition) ICondition

+ func Startswith(f IQueryField, v string) ICondition

+ type IFunction interface

+ type IQuery interface

+ Field func(name string) IQueryField

+ QueryFields func() []IQueryField

+ String func(fields ...IQueryField) string

+ SubQuery func() *SSubQuery

+ Variables func() []interface{}

+ type IQueryField interface

+ Expression func() string

+ Label func(label string) IQueryField

+ Name func() string

+ Reference func() string

+ Variables func() []interface{}

+ func AND_Val(name string, field IQueryField, v interface{}) IQueryField

+ func CONCAT(name string, fields ...IQueryField) IQueryField

+ func COUNT(name string, field ...IQueryField) IQueryField

+ func DISTINCT(name string, field IQueryField) IQueryField

+ func GROUP_CONCAT(name string, field IQueryField) IQueryField

+ func INET_ATON(field IQueryField) IQueryField

+ func MAX(name string, field IQueryField) IQueryField

+ func MIN(name string, field IQueryField) IQueryField

+ func NewFunction(ifunc IFunction, name string) IQueryField

+ func NewFunctionField(name string, funcexp string, fields ...IQueryField) IQueryField

+ func OR_Val(name string, field IQueryField, v interface{}) IQueryField

+ func REPLACE(name string, field IQueryField, old string, new string) IQueryField

+ func SUM(name string, field IQueryField) IQueryField

+ func SubStr(name string, field IQueryField, pos, length int) IQueryField

+ func TimestampAdd(name string, field IQueryField, offsetSeconds int) IQueryField

+ type IQuerySource interface

+ Alias func() string

+ Expression func() string

+ Field func(id string, alias ...string) IQueryField

+ Fields func() []IQueryField

+ Variables func() []interface{}

+ type IRowScanner interface

+ Scan func(desc ...interface{}) error

+ type ITableSpec interface

+ AddIndex func(unique bool, cols ...string) bool

+ ColumnSpec func(name string) IColumnSpec

+ Columns func() []IColumnSpec

+ DataType func() reflect.Type

+ Decrement func(diff, target interface{}) error

+ DropForeignKeySQL func() []string

+ Expression func() string

+ Fetch func(dt interface{}) error

+ Increment func(diff, target interface{}) error

+ Insert func(dt interface{}) error

+ InsertOrUpdate func(dt interface{}) error

+ Instance func() *STable

+ Name func() string

+ PrimaryColumns func() []IColumnSpec

+ SyncSQL func() []string

+ Update func(dt interface{}, onUpdate func() error) (UpdateDiffs, error)

+ type QueryJoinType string

+ const INNERJOIN

+ const LEFTJOIN

+ const RIGHTJOIN

+ type QueryOrderType string

+ const SQL_ORDER_ASC

+ const SQL_ORDER_DESC

+ func (qot QueryOrderType) Equals(orderType string) bool

+ type SAndConditions struct

+ func (c *SAndConditions) WhereClause() string

+ type SBaseColumn struct

+ func NewBaseColumn(name string, sqltype string, tagmap map[string]string, isPointer bool) SBaseColumn

+ func (c *SBaseColumn) AllowZero() bool

+ func (c *SBaseColumn) ColType() string

+ func (c *SBaseColumn) ConvertFromString(str string) string

+ func (c *SBaseColumn) ConvertFromValue(val interface{}) interface{}

+ func (c *SBaseColumn) Default() string

+ func (c *SBaseColumn) ExtraDefs() string

+ func (c *SBaseColumn) IsAscii() bool

+ func (c *SBaseColumn) IsIndex() bool

+ func (c *SBaseColumn) IsNullable() bool

+ func (c *SBaseColumn) IsNumeric() bool

+ func (c *SBaseColumn) IsPointer() bool

+ func (c *SBaseColumn) IsPrimary() bool

+ func (c *SBaseColumn) IsSearchable() bool

+ func (c *SBaseColumn) IsSupportDefault() bool

+ func (c *SBaseColumn) IsText() bool

+ func (c *SBaseColumn) IsUnique() bool

+ func (c *SBaseColumn) Name() string

+ func (c *SBaseColumn) SetDefault(defStr string)

+ func (c *SBaseColumn) SetNullable(on bool)

+ func (c *SBaseColumn) Tags() map[string]string

+ type SBaseWidthColumn struct

+ func NewBaseWidthColumn(name string, sqltype string, tagmap map[string]string, isPointer bool) SBaseWidthColumn

+ func (c *SBaseWidthColumn) ColType() string

+ type SBetweenCondition struct

+ func (t *SBetweenCondition) WhereClause() string

+ type SBooleanColumn struct

+ func NewBooleanColumn(name string, tagmap map[string]string, isPointer bool) SBooleanColumn

+ func (c *SBooleanColumn) ConvertFromString(str string) string

+ func (c *SBooleanColumn) DefinitionString() string

+ func (c *SBooleanColumn) IsZero(val interface{}) bool

+ type SCaseFunction struct

+ func NewCase() *SCaseFunction

+ func (cf *SCaseFunction) Else(field IQueryField) *SCaseFunction

+ func (cf *SCaseFunction) When(when ICondition, then IQueryField) *SCaseFunction

+ type SCompoundConditions struct

+ func (c *SCompoundConditions) Variables() []interface{}

+ func (c *SCompoundConditions) WhereClause() string

+ type SConstField struct

+ func NewConstField(variable interface{}) *SConstField

+ func (s *SConstField) Expression() string

+ func (s *SConstField) Label(label string) IQueryField

+ func (s *SConstField) Name() string

+ func (s *SConstField) Reference() string

+ func (s *SConstField) Variables() []interface{}

+ type SDateTimeColumn struct

+ IsCreatedAt bool

+ IsUpdatedAt bool

+ func NewDateTimeColumn(name string, tagmap map[string]string, isPointer bool) SDateTimeColumn

+ type SDecimalColumn struct

+ Precision int

+ func NewDecimalColumn(name string, tagmap map[string]string, isPointer bool) SDecimalColumn

+ func (c *SDecimalColumn) ColType() string

+ func (c *SDecimalColumn) DefinitionString() string

+ func (c *SDecimalColumn) IsNumeric() bool

+ func (c *SDecimalColumn) IsZero(val interface{}) bool

+ type SEqualsCondition struct

+ func (t *SEqualsCondition) WhereClause() string

+ type SFalseCondition struct

+ func (t *SFalseCondition) Variables() []interface{}

+ func (t *SFalseCondition) WhereClause() string

+ type SFloatColumn struct

+ func NewFloatColumn(name string, sqlType string, tagmap map[string]string, isPointer bool) SFloatColumn

+ func (c *SFloatColumn) DefinitionString() string

+ func (c *SFloatColumn) IsNumeric() bool

+ func (c *SFloatColumn) IsZero(val interface{}) bool

+ type SFunctionFieldBase struct

+ func (ff *SFunctionFieldBase) Expression() string

+ func (ff *SFunctionFieldBase) Label(label string) IQueryField

+ func (ff *SFunctionFieldBase) Name() string

+ func (ff *SFunctionFieldBase) Reference() string

+ func (ff *SFunctionFieldBase) Variables() []interface{}

+ type SGreatEqualCondition struct

+ func (t *SGreatEqualCondition) WhereClause() string

+ type SGreatThanCondition struct

+ func (t *SGreatThanCondition) WhereClause() string

+ type SInCondition struct

+ func (t *SInCondition) WhereClause() string

+ type SIntegerColumn struct

+ AutoIncrementOffset int64

+ IsAutoIncrement bool

+ IsAutoVersion bool

+ IsUnsigned bool

+ func NewIntegerColumn(name string, sqltype string, unsigned bool, tagmap map[string]string, ...) SIntegerColumn

+ func (c *SIntegerColumn) ColType() string

+ func (c *SIntegerColumn) DefinitionString() string

+ func (c *SIntegerColumn) ExtraDefs() string

+ func (c *SIntegerColumn) IsNumeric() bool

+ func (c *SIntegerColumn) IsZero(val interface{}) bool

+ type SIsEmptyCondition struct

+ func (c *SIsEmptyCondition) WhereClause() string

+ type SIsFalseCondition struct

+ func (c *SIsFalseCondition) WhereClause() string

+ type SIsNotEmptyCondition struct

+ func (c *SIsNotEmptyCondition) WhereClause() string

+ type SIsNotNullCondition struct

+ func (c *SIsNotNullCondition) WhereClause() string

+ type SIsNullCondition struct

+ func (c *SIsNullCondition) WhereClause() string

+ type SIsNullOrEmptyCondition struct

+ func (c *SIsNullOrEmptyCondition) WhereClause() string

+ type SIsTrueCondition struct

+ func (c *SIsTrueCondition) WhereClause() string

+ type SLessEqualCondition struct

+ func (t *SLessEqualCondition) WhereClause() string

+ type SLessThanCondition struct

+ func (t *SLessThanCondition) WhereClause() string

+ type SLikeCondition struct

+ func (t *SLikeCondition) WhereClause() string

+ type SNoEarlierThanCondition struct

+ func (c *SNoEarlierThanCondition) WhereClause() string

+ type SNoLaterThanCondition struct

+ func (c *SNoLaterThanCondition) WhereClause() string

+ type SNotCondition struct

+ func (c *SNotCondition) Variables() []interface{}

+ func (c *SNotCondition) WhereClause() string

+ type SNotEqualsCondition struct

+ func (t *SNotEqualsCondition) WhereClause() string

+ type SOrConditions struct

+ func (c *SOrConditions) WhereClause() string

+ type SQuery struct

+ func DoQuery(from IQuerySource, f ...IQueryField) *SQuery

+ func NewRawQuery(sqlStr string, fields ...string) *SQuery

+ func (tq *SQuery) All(dest interface{}) error

+ func (tq *SQuery) AllStringMap() ([]map[string]string, error)

+ func (tq *SQuery) AppendField(f ...IQueryField) *SQuery

+ func (tq *SQuery) Asc(fields ...interface{}) *SQuery

+ func (tq *SQuery) Between(f string, v1, v2 interface{}) *SQuery

+ func (tq *SQuery) Contains(f string, v string) *SQuery

+ func (tq *SQuery) Count() int

+ func (tq *SQuery) CountWithError() (int, error)

+ func (tq *SQuery) DebugQuery()

+ func (tq *SQuery) Desc(fields ...interface{}) *SQuery

+ func (tq *SQuery) Distinct() *SQuery

+ func (tq *SQuery) Endswith(f string, v string) *SQuery

+ func (tq *SQuery) Equals(f string, v interface{}) *SQuery

+ func (tq *SQuery) Field(name string) IQueryField

+ func (tq *SQuery) Filter(cond ICondition) *SQuery

+ func (tq *SQuery) FilterByFalse() *SQuery

+ func (tq *SQuery) FilterByTrue() *SQuery

+ func (tq *SQuery) First(dest interface{}) error

+ func (tq *SQuery) FirstStringMap() (map[string]string, error)

+ func (tq *SQuery) GE(f string, v interface{}) *SQuery

+ func (tq *SQuery) GT(f string, v interface{}) *SQuery

+ func (tq *SQuery) GroupBy(f ...interface{}) *SQuery

+ func (tq *SQuery) In(f string, v interface{}) *SQuery

+ func (tq *SQuery) IsAltered() bool

+ func (tq *SQuery) IsEmpty(f string) *SQuery

+ func (tq *SQuery) IsFalse(f string) *SQuery

+ func (tq *SQuery) IsNotEmpty(f string) *SQuery

+ func (tq *SQuery) IsNotNull(f string) *SQuery

+ func (tq *SQuery) IsNull(f string) *SQuery

+ func (tq *SQuery) IsNullOrEmpty(f string) *SQuery

+ func (tq *SQuery) IsTrue(f string) *SQuery

+ func (tq *SQuery) Join(from IQuerySource, on ICondition) *SQuery

+ func (tq *SQuery) LE(f string, v interface{}) *SQuery

+ func (tq *SQuery) LT(f string, v interface{}) *SQuery

+ func (tq *SQuery) LeftJoin(from IQuerySource, on ICondition) *SQuery

+ func (tq *SQuery) Like(f string, v string) *SQuery

+ func (tq *SQuery) Limit(limit int) *SQuery

+ func (tq *SQuery) NotBetween(f string, v1, v2 interface{}) *SQuery

+ func (tq *SQuery) NotEquals(f string, v interface{}) *SQuery

+ func (tq *SQuery) NotIn(f string, v interface{}) *SQuery

+ func (tq *SQuery) NotLike(f string, v string) *SQuery

+ func (tq *SQuery) Offset(offset int) *SQuery

+ func (tq *SQuery) QueryFields() []IQueryField

+ func (tq *SQuery) RightJoin(from IQuerySource, on ICondition) *SQuery

+ func (tq *SQuery) Row() *sql.Row

+ func (tq *SQuery) Row2Map(row IRowScanner) (map[string]string, error)

+ func (tq *SQuery) Row2Struct(row IRowScanner, dest interface{}) error

+ func (tq *SQuery) RowMap2Struct(result map[string]string, dest interface{}) error

+ func (tq *SQuery) Rows() (*sql.Rows, error)

+ func (tq *SQuery) Snapshot() *SQuery

+ func (tq *SQuery) Startswith(f string, v string) *SQuery

+ func (tq *SQuery) String(fields ...IQueryField) string

+ func (tq *SQuery) SubQuery() *SSubQuery

+ func (tq *SQuery) Variables() []interface{}

+ type SRawQueryField struct

+ func (rqf *SRawQueryField) Expression() string

+ func (rqf *SRawQueryField) Label(label string) IQueryField

+ func (rqf *SRawQueryField) Name() string

+ func (rqf *SRawQueryField) Reference() string

+ func (rqf *SRawQueryField) Variables() []interface{}

+ type SSingleCondition struct

+ func NewSingleCondition(field IQueryField) SSingleCondition

+ func (c *SSingleCondition) Variables() []interface{}

+ type SStringField struct

+ func NewStringField(name string) *SStringField

+ func (s *SStringField) Expression() string

+ func (s *SStringField) Label(label string) IQueryField

+ func (s *SStringField) Name() string

+ func (s *SStringField) Reference() string

+ func (s *SStringField) Variables() []interface{}

+ type SSubQuery struct

+ func (sq *SSubQuery) Alias() string

+ func (sq *SSubQuery) Expression() string

+ func (sq *SSubQuery) Field(id string, alias ...string) IQueryField

+ func (sq *SSubQuery) Fields() []IQueryField

+ func (sq *SSubQuery) Query(f ...IQueryField) *SQuery

+ func (sq *SSubQuery) Variables() []interface{}

+ func (sqf *SSubQuery) DebugQuery()

+ type SSubQueryField struct

+ func (sqf *SSubQueryField) Expression() string

+ func (sqf *SSubQueryField) Label(label string) IQueryField

+ func (sqf *SSubQueryField) Name() string

+ func (sqf *SSubQueryField) Reference() string

+ func (sqf *SSubQueryField) Variables() []interface{}

+ type STable struct

+ func NewTableInstance(ts ITableSpec) *STable

+ func (tbl *STable) Alias() string

+ func (tbl *STable) Expression() string

+ func (tbl *STable) Field(name string, alias ...string) IQueryField

+ func (tbl *STable) Fields() []IQueryField

+ func (tbl *STable) Query(f ...IQueryField) *SQuery

+ func (tbl *STable) Variables() []interface{}

+ type STableField struct

+ func (c *STableField) Expression() string

+ func (c *STableField) Label(label string) IQueryField

+ func (c *STableField) Name() string

+ func (c *STableField) Reference() string

+ func (c *STableField) Variables() []interface{}

+ type STableSpec struct

+ func NewTableSpecFromStruct(s interface{}, name string) *STableSpec

+ func (t *STableSpec) DebugInsert(dt interface{}) error

+ func (t *STableSpec) DebugInsertOrUpdate(dt interface{}) error

+ func (t *STableSpec) DebugUpdateFields(dt interface{}, fields map[string]interface{}) error

+ func (t *STableSpec) Decrement(diff interface{}, target interface{}) error

+ func (t *STableSpec) Increment(diff interface{}, target interface{}) error

+ func (t *STableSpec) Insert(dt interface{}) error

+ func (t *STableSpec) InsertOrUpdate(dt interface{}) error

+ func (ts *STableSpec) AddIndex(unique bool, cols ...string) bool

+ func (ts *STableSpec) CheckSync() error

+ func (ts *STableSpec) Clone(name string, autoIncOffset int64) *STableSpec

+ func (ts *STableSpec) ColumnSpec(name string) IColumnSpec

+ func (ts *STableSpec) Columns() []IColumnSpec

+ func (ts *STableSpec) CreateSQL() string

+ func (ts *STableSpec) DataType() reflect.Type

+ func (ts *STableSpec) DropForeignKeySQL() []string

+ func (ts *STableSpec) Exists() bool

+ func (ts *STableSpec) Expression() string

+ func (ts *STableSpec) Fetch(dt interface{}) error

+ func (ts *STableSpec) FetchAll(dest interface{}) error

+ func (ts *STableSpec) Instance() *STable

+ func (ts *STableSpec) Name() string

+ func (ts *STableSpec) PrimaryColumns() []IColumnSpec

+ func (ts *STableSpec) Query(f ...IQueryField) *SQuery

+ func (ts *STableSpec) Sync() error

+ func (ts *STableSpec) SyncSQL() []string

+ func (ts *STableSpec) Update(dt interface{}, doUpdate func() error) (UpdateDiffs, error)

+ func (ts *STableSpec) UpdateFields(dt interface{}, fields map[string]interface{}) error

+ type STextColumn struct

+ Charset string

+ func NewTextColumn(name string, tagmap map[string]string, isPointer bool) STextColumn

+ func (c *STextColumn) ColType() string

+ func (c *STextColumn) DefinitionString() string

+ func (c *STextColumn) IsAscii() bool

+ func (c *STextColumn) IsSearchable() bool

+ func (c *STextColumn) IsSupportDefault() bool

+ func (c *STextColumn) IsText() bool

+ func (c *STextColumn) IsZero(val interface{}) bool

+ type STimeTypeColumn struct

+ func NewTimeTypeColumn(name string, typeStr string, tagmap map[string]string, isPointer bool) STimeTypeColumn

+ func (c *STimeTypeColumn) DefinitionString() string

+ func (c *STimeTypeColumn) IsText() bool

+ func (c *STimeTypeColumn) IsZero(val interface{}) bool

+ type STripleCondition struct

+ func NewTripleCondition(l IQueryField, r interface{}, r2 interface{}) STripleCondition

+ func (t *STripleCondition) Variables() []interface{}

+ type STristateColumn struct

+ func NewTristateColumn(name string, tagmap map[string]string, isPointer bool) STristateColumn

+ func (c *STristateColumn) ConvertFromString(str string) string

+ func (c *STristateColumn) ConvertFromValue(val interface{}) interface{}

+ func (c *STristateColumn) DefinitionString() string

+ func (c *STristateColumn) IsZero(val interface{}) bool

+ type STrueCondition struct

+ func (t *STrueCondition) Variables() []interface{}

+ func (t *STrueCondition) WhereClause() string

+ type STupleCondition struct

+ func NewTupleCondition(l IQueryField, r interface{}) STupleCondition

+ func (t *STupleCondition) Variables() []interface{}

+ type SUnion struct

+ func Union(query ...IQuery) *SUnion

+ func UnionWithError(query ...IQuery) (*SUnion, error)

+ func (uq *SUnion) Alias() string

+ func (uq *SUnion) Expression() string

+ func (uq *SUnion) Field(name string, alias ...string) IQueryField

+ func (uq *SUnion) Fields() []IQueryField

+ func (uq *SUnion) Limit(limit int) *SUnion

+ func (uq *SUnion) Offset(offset int) *SUnion

+ func (uq *SUnion) Query(f ...IQueryField) *SQuery

+ func (uq *SUnion) Variables() []interface{}

+ type SUnionQueryField struct

+ func (sqf *SUnionQueryField) Expression() string

+ func (sqf *SUnionQueryField) Label(label string) IQueryField

+ func (sqf *SUnionQueryField) Name() string

+ func (sqf *SUnionQueryField) Reference() string

+ func (sqf *SUnionQueryField) Variables() []interface{}

+ type SUpdateDiff struct

+ func (ud *SUpdateDiff) String() string

+ type SUpdateSession struct

+ type UpdateDiffs map[string]SUpdateDiff

+ func (uds UpdateDiffs) String() string

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