sqlca

package module

Go to main page

Versions in this module

v2

v2.8.2

May 21, 2024

v2.8.1

Apr 18, 2024

v2.8.0

Mar 20, 2024

Changes in this version

type Engine

+ func (e *Engine) JsonContainArray(strColumn string, value interface{}) *Engine

v2.7.10

Mar 11, 2024

v2.7.9

Mar 7, 2024

v2.7.8

Mar 7, 2024

v2.7.7

Jan 30, 2024

v2.7.6

Jan 22, 2024

v2.7.5

Jan 19, 2024

v2.7.4

Jan 19, 2024

Changes in this version

type Options

+ PageOffset bool

v2.7.3

Jan 11, 2024

Changes in this version

+ func Url2MySql(strUrl string) (string, error)

v2.7.2

Nov 4, 2023

v2.7.1

Nov 4, 2023

v2.7.0

Nov 4, 2023

Changes in this version

type Engine

+ func (e *Engine) From(exprs ...string) *Engine

v2.6.3

Jul 18, 2023

v2.6.2

Jun 30, 2023

Changes in this version

type Engine

+ func (e *Engine) NotIn(strColumn string, args ...interface{}) *Engine

v2.6.1

Jun 30, 2023

Changes in this version

type Engine

+ func (e *Engine) Ne(strColumn string, value interface{}) *Engine

v2.6.0

Jun 28, 2023

Changes in this version

type Engine

+ func (e *Engine) NewID() ID

+ type ID = snowflake.ID

type Options

+ SnowFlake *SnowFlake

+ type SnowFlake struct

+ NodeId int64

v2.5.1

Jun 15, 2023

Changes in this version

+ const SQLCA_TAG_VALUE_IS_NULL

type Engine

+ func (e *Engine) IsNULL(strColumn string) *Engine

+ func (e *Engine) NotNULL(strColumn string) *Engine

v2.5.0

May 24, 2023

Changes in this version

type Engine

+ func (e *Engine) Eq(strColumn string, value interface{}) *Engine

+ func (e *Engine) Gt(strColumn string, value interface{}) *Engine

+ func (e *Engine) Gte(strColumn string, value interface{}) *Engine

+ func (e *Engine) GteLte(strColumn string, value1, value2 interface{}) *Engine

+ func (e *Engine) Lt(strColumn string, value interface{}) *Engine

+ func (e *Engine) Lte(strColumn string, value interface{}) *Engine

v2.4.0

May 12, 2023

Changes in this version

type Decimal

+ func (d *Decimal) Unmarshal(data []byte) error

+ func (d *Decimal) UnmarshalBSON(data []byte) error

+ func (d *Decimal) UnmarshalBSONValue(bt bsontype.Type, data []byte) error

+ func (d Decimal) Marshal() ([]byte, error)

+ func (d Decimal) MarshalBSON() ([]byte, error)

+ func (d Decimal) MarshalBSONValue() (bsontype.Type, []byte, error)

type Engine

+ func (e *Engine) Close() *Engine

+ func (e *Engine) Use(strDatabaseName string) (*Engine, error)

type UrlInfo

+ func (ui *UrlInfo) Url() string

v2.3.2

Mar 21, 2023

Changes in this version

+ const DefaultConnIdle

+ const DefaultConnMax

v2.3.1

Mar 17, 2023

v2.3.0

Dec 8, 2022

v2.2.9

Dec 5, 2022

Changes in this version

type Decimal

+ func (d Decimal) Amount2FIL() Decimal

+ func (d Decimal) FIL2Amount() Decimal

v2.2.8

Nov 29, 2022

v2.2.7

Nov 29, 2022

v2.2.6

Sep 29, 2022

v2.2.5

Sep 22, 2022

Changes in this version

type Engine

+ func (e *Engine) GreaterEqual(strColumn string, value interface{}) *Engine

+ func (e *Engine) GreaterThan(strColumn string, value interface{}) *Engine

+ func (e *Engine) JsonEqual(strColumn, strPath string, value interface{}) *Engine

+ func (e *Engine) JsonGreater(strColumn, strPath string, value interface{}) *Engine

+ func (e *Engine) JsonGreaterEqual(strColumn, strPath string, value interface{}) *Engine

+ func (e *Engine) JsonLess(strColumn, strPath string, value interface{}) *Engine

+ func (e *Engine) JsonLessEqual(strColumn, strPath string, value interface{}) *Engine

v2.2.4

Aug 3, 2022

v2.2.3

Aug 3, 2022

Changes in this version

+ const DRIVER_NAME_SQLITE3

v2.2.2

Jun 14, 2022

v2.2.1

Jun 11, 2022

v2.2.0

Jun 10, 2022

Changes in this version

type Decimal

+ func (d Decimal) Amount2Btc() Decimal

+ func (d Decimal) Amount2Coin(prec string) Decimal

+ func (d Decimal) Amount2Ether() Decimal

+ func (d Decimal) BigInt() (b *big.Int, ok bool)

+ func (d Decimal) Btc2Amount() Decimal

+ func (d Decimal) Coin2Amount(prec string) Decimal

+ func (d Decimal) Ether2Amount() Decimal

v2.1.1

May 16, 2022

v2.1.0

May 12, 2022

v2.0.15

Apr 2, 2022

v2.0.14

Feb 25, 2022

Changes in this version

type Engine

+ func (e *Engine) Equal(strColumn string, value interface{}) *Engine

+ func (e *Engine) GraterEqual(strColumn string, value interface{}) *Engine

+ func (e *Engine) GraterThan(strColumn string, value interface{}) *Engine

+ func (e *Engine) LessEqual(strColumn string, value interface{}) *Engine

+ func (e *Engine) LessThan(strColumn string, value interface{}) *Engine

+ func (e *Engine) Like(strColumn, strSub string) *Engine

v2.0.13

Jan 27, 2022

Changes in this version

+ const DATABASE_KEY_NAME_ROUND

type Engine

+ func (e *Engine) Round(strColumn string, round int, strAS ...string) *Engine

v2.0.12

Jan 12, 2022

v2.0.11

Jan 8, 2022

v2.0.10

Dec 3, 2021

v2.0.9

Dec 3, 2021

v2.0.8

Dec 2, 2021

Changes in this version

type Engine

+ func (e *Engine) NoVerbose() *Engine

v2.0.7

Dec 1, 2021

v2.0.6

Dec 1, 2021

v2.0.5

Nov 29, 2021

v2.0.4

Sep 28, 2021

v2.0.3

Sep 24, 2021

v2.0.2

Sep 2, 2021

Changes in this version

+ const DATABASE_KEY_NAME_AND

+ const DATABASE_KEY_NAME_ASC

+ const DATABASE_KEY_NAME_AVG

+ const DATABASE_KEY_NAME_CASE

+ const DATABASE_KEY_NAME_COUNT

+ const DATABASE_KEY_NAME_DELETE

+ const DATABASE_KEY_NAME_DESC

+ const DATABASE_KEY_NAME_DISTINCT

+ const DATABASE_KEY_NAME_ELSE

+ const DATABASE_KEY_NAME_END

+ const DATABASE_KEY_NAME_FOR_UPDATE

+ const DATABASE_KEY_NAME_FROM

+ const DATABASE_KEY_NAME_FULL_JOIN

+ const DATABASE_KEY_NAME_HAVING

+ const DATABASE_KEY_NAME_IN

+ const DATABASE_KEY_NAME_INNER_JOIN

+ const DATABASE_KEY_NAME_INSERT

+ const DATABASE_KEY_NAME_LEFT_JOIN

+ const DATABASE_KEY_NAME_MAX

+ const DATABASE_KEY_NAME_MIN

+ const DATABASE_KEY_NAME_NOT_IN

+ const DATABASE_KEY_NAME_ON

+ const DATABASE_KEY_NAME_OR

+ const DATABASE_KEY_NAME_ORDER_BY

+ const DATABASE_KEY_NAME_RIGHT_JOIN

+ const DATABASE_KEY_NAME_SELECT

+ const DATABASE_KEY_NAME_SET

+ const DATABASE_KEY_NAME_SUM

+ const DATABASE_KEY_NAME_THEN

+ const DATABASE_KEY_NAME_UPDATE

+ const DATABASE_KEY_NAME_VALUE

+ const DATABASE_KEY_NAME_VALUES

+ const DATABASE_KEY_NAME_WHEN

+ const DATABASE_KEY_NAME_WHERE

+ const DEFAULT_CAHCE_EXPIRE_SECONDS

+ const DEFAULT_PRIMARY_KEY_NAME

+ const DEFAULT_SLOW_QUERY_ALERT_TIME

+ const DRIVER_NAME_MSSQL

+ const DRIVER_NAME_MYSQL

+ const DRIVER_NAME_POSTGRES

+ const DRIVER_NAME_REDIS

+ const DRIVER_NAME_SQLITE

+ const JoinType_Inner

+ const JoinType_Left

+ const JoinType_Right

+ const ModelType_BaseType

+ const ModelType_Map

+ const ModelType_Slice

+ const ModelType_Struct

+ const ORDER_BY_ASC

+ const ORDER_BY_DESC

+ const PROTOBUF_VALUE_NAME

+ const SQLCA_CHAR_ASTERISK

+ const SQLCA_TAG_VALUE_AUTO_INCR

+ const SQLCA_TAG_VALUE_IGNORE

+ const SQLCA_TAG_VALUE_READ_ONLY

+ const SSH_TUNNEL_PORT

+ const TAG_NAME_DB

+ const TAG_NAME_JSON

+ const TAG_NAME_PROTOBUF

+ const TAG_NAME_SQLCA

+ const URL_QUERY_CHARSET

+ const URL_QUERY_IDLE

+ const URL_QUERY_MAX

+ const URL_QUERY_SLAVE

+ const URL_SCHEME_SEP

+ const WINDOWS_DSN_DATA_SOURCE

+ const WINDOWS_DSN_INITIAL_CATALOG

+ const WINDOWS_DSN_INTEGRATED_SECURITY_SSPI

+ const WINDOWS_DSN_PASSWORD

+ const WINDOWS_DSN_PORT

+ const WINDOWS_DSN_PROVIDER_SQLOLEDB

+ const WINDOWS_DSN_USER_ID

+ type AdapterType int

+ const AdapterCache_Redis

+ const AdapterSqlx_Mssql

+ const AdapterSqlx_MySQL

+ const AdapterSqlx_Postgres

+ const AdapterSqlx_Sqlite

+ func (a AdapterType) DriverName() string

+ func (a AdapterType) GoString() string

+ func (a AdapterType) String() string

+ type CaseWhen struct

+ func (c *CaseWhen) Case(strThen string, strWhen string, args ...interface{}) *CaseWhen

+ func (c *CaseWhen) Else(strElse string) *CaseWhen

+ func (c *CaseWhen) End(strName string) *Engine

+ type Decimal struct

+ func NewDecimal(v interface{}) (d Decimal)

+ func (d *Decimal) FromFloat(v float64)

+ func (d *Decimal) FromInt(v int64)

+ func (d *Decimal) FromString(v string)

+ func (d *Decimal) Scan(src interface{}) error

+ func (d *Decimal) UnmarshalBinary(data []byte) error

+ func (d *Decimal) UnmarshalJSON(decimalBytes []byte) error

+ func (d *Decimal) UnmarshalText(text []byte) error

+ func (d Decimal) Abs() Decimal

+ func (d Decimal) Add(d2 Decimal) Decimal

+ func (d Decimal) Cmp(d2 Decimal) int

+ func (d Decimal) Cos() Decimal

+ func (d Decimal) Div(d2 Decimal) Decimal

+ func (d Decimal) Equal(d2 Decimal) bool

+ func (d Decimal) Float64() (f float64)

+ func (d Decimal) GreaterThan(d2 Decimal) bool

+ func (d Decimal) GreaterThanOrEqual(d2 Decimal) bool

+ func (d Decimal) IntPart() int64

+ func (d Decimal) IsNegative() bool

+ func (d Decimal) IsPositive() bool

+ func (d Decimal) IsZero() bool

+ func (d Decimal) LessThan(d2 Decimal) bool

+ func (d Decimal) LessThanOrEqual(d2 Decimal) bool

+ func (d Decimal) MarshalBinary() (data []byte, err error)

+ func (d Decimal) MarshalJSON() ([]byte, error)

+ func (d Decimal) MarshalText() (text []byte, err error)

+ func (d Decimal) Max(rest ...Decimal) Decimal

+ func (d Decimal) Min(rest ...Decimal) Decimal

+ func (d Decimal) Mod(d2 Decimal) Decimal

+ func (d Decimal) Mul(d2 Decimal) Decimal

+ func (d Decimal) Neg() Decimal

+ func (d Decimal) Pow(d2 Decimal) Decimal

+ func (d Decimal) Round(places int32) Decimal

+ func (d Decimal) Sign() int

+ func (d Decimal) Sin() Decimal

+ func (d Decimal) String() string

+ func (d Decimal) StringFixed(places int32) string

+ func (d Decimal) StringScaled(exp int32) string

+ func (d Decimal) Sub(d2 Decimal) Decimal

+ func (d Decimal) Sum(rest ...Decimal) Decimal

+ func (d Decimal) Tan() Decimal

+ func (d Decimal) Truncate(precision int32) Decimal

+ func (d Decimal) Value() (driver.Value, error)

+ type Engine struct

+ func NewEngine(args ...interface{}) *Engine

+ func (e *Engine) And(strFmt string, args ...interface{}) *Engine

+ func (e *Engine) Asc(strColumns ...string) *Engine

+ func (e *Engine) Attach(strDatabaseName string, db *sqlx.DB) *Engine

+ func (e *Engine) AutoRollback() *Engine

+ func (e *Engine) Avg(strColumn string, strAS ...string) *Engine

+ func (e *Engine) Case(strThen string, strWhen string, args ...interface{}) *CaseWhen

+ func (e *Engine) Count(strColumn string, strAS ...string) *Engine

+ func (e *Engine) Counter() *counter

+ func (e *Engine) Debug(ok bool)

+ func (e *Engine) Delete() (rowsAffected int64, err error)

+ func (e *Engine) Desc(strColumns ...string) *Engine

+ func (e *Engine) Distinct() *Engine

+ func (e *Engine) Exclude(strColumns ...string) *Engine

+ func (e *Engine) ExecRaw(strQuery string, args ...interface{}) (rowsAffected, lastInsertId int64, err error)

+ func (e *Engine) Find(conditions map[string]interface{}) (rowsAffected int64, err error)

+ func (e *Engine) Force() *Engine

+ func (e *Engine) GeoHash(lng, lat float64, precision int) (strGeoHash string, strNeighbors []string)

+ func (e *Engine) GetAdapter() AdapterType

+ func (e *Engine) GetPkName() string

+ func (e *Engine) GroupBy(strColumns ...string) *Engine

+ func (e *Engine) Having(strFmt string, args ...interface{}) *Engine

+ func (e *Engine) Id(value interface{}) *Engine

+ func (e *Engine) In(strColumn string, args ...interface{}) *Engine

+ func (e *Engine) InnerJoin(strTableName string) *Join

+ func (e *Engine) Insert() (lastInsertId int64, err error)

+ func (e *Engine) JsonMarshal(v interface{}) (strJson string)

+ func (e *Engine) JsonUnmarshal(strJson string, v interface{}) (err error)

+ func (e *Engine) LeftJoin(strTableName string) *Join

+ func (e *Engine) Limit(args ...int) *Engine

+ func (e *Engine) Max(strColumn string, strAS ...string) *Engine

+ func (e *Engine) Min(strColumn string, strAS ...string) *Engine

+ func (e *Engine) Model(args ...interface{}) *Engine

+ func (e *Engine) NearBy(strLngCol, strLatCol, strAS string, lng, lat, distance float64) *Engine

+ func (e *Engine) Not(strColumn string, args ...interface{}) *Engine

+ func (e *Engine) Offset(offset int) *Engine

+ func (e *Engine) OnConflict(strColumns ...string) *Engine

+ func (e *Engine) Open(strUrl string, options ...interface{}) *Engine

+ func (e *Engine) Or(strFmt string, args ...interface{}) *Engine

+ func (e *Engine) OrderBy(strColumns ...string) *Engine

+ func (e *Engine) Page(pageNo, pageSize int) *Engine

+ func (e *Engine) Ping() (err error)

+ func (e *Engine) Query() (rowsAffected int64, err error)

+ func (e *Engine) QueryEx() (rowsAffected, total int64, err error)

+ func (e *Engine) QueryJson() (s string, err error)

+ func (e *Engine) QueryMap(strQuery string, args ...interface{}) (rowsAffected int64, err error)

+ func (e *Engine) QueryRaw(strQuery string, args ...interface{}) (rowsAffected int64, err error)

+ func (e *Engine) RightJoin(strTableName string) *Join

+ func (e *Engine) Select(strColumns ...string) *Engine

+ func (e *Engine) SetCustomTag(tagNames ...string) *Engine

+ func (e *Engine) SetLogFile(strPath string)

+ func (e *Engine) SetPkName(strName string) *Engine

+ func (e *Engine) SetReadOnly(columns ...string)

+ func (e *Engine) Slave() *Engine

+ func (e *Engine) SlowQuery(on bool, ms int)

+ func (e *Engine) Sum(strColumn string, strAS ...string) *Engine

+ func (e *Engine) Table(strNames ...string) *Engine

+ func (e *Engine) ToSQL(operType OperType) (strSql string)

+ func (e *Engine) TxBegin() (*Engine, error)

+ func (e *Engine) TxCommit() error

+ func (e *Engine) TxExec(strQuery string, args ...interface{}) (lastInsertId, rowsAffected int64, err error)

+ func (e *Engine) TxFunc(fn func(tx *Engine) error) (err error)

+ func (e *Engine) TxFuncContext(ctx context.Context, fn func(ctx context.Context, tx *Engine) error) (err error)

+ func (e *Engine) TxGet(dest interface{}, strQuery string, args ...interface{}) (count int64, err error)

+ func (e *Engine) TxHandle(handler TxHandler) (err error)

+ func (e *Engine) TxRollback() error

+ func (e *Engine) Update() (rowsAffected int64, err error)

+ func (e *Engine) Upsert(strCustomizeUpdates ...string) (lastInsertId int64, err error)

+ func (e *Engine) Where(strWhere string, args ...interface{}) *Engine

+ type Fetcher struct

+ type Join struct

+ func (j *Join) On(strOn string, args ...interface{}) *Engine

+ type JoinType int

+ func (t JoinType) GoString() string

+ func (t JoinType) String() string

+ func (t JoinType) ToKeyWord() string

+ type ModelReflector struct

+ func (s *ModelReflector) ToMap(tagNames ...string) map[string]interface{}

+ type ModelType int

+ func (m ModelType) GoString() string

+ func (m ModelType) String() string

+ type OperType int

+ const OperType_Delete

+ const OperType_ExecRaw

+ const OperType_ForUpdate

+ const OperType_Insert

+ const OperType_Query

+ const OperType_QueryMap

+ const OperType_QueryRaw

+ const OperType_Tx

+ const OperType_Update

+ const OperType_Upsert

+ func (o OperType) GoString() string

+ func (o OperType) String() string

+ type Options struct

+ Debug bool

+ Idle int

+ Max int

+ SSH *SSH

+ Slave bool

+ type SSH struct

+ Host string

+ Password string

+ PrivateKey string

+ User string

+ func (s *SSH) GoString() string

+ func (s *SSH) String() string

+ type TxHandler interface

+ OnTransaction func(tx *Engine) error

+ type UrlInfo struct

+ ForceQuery bool

+ Fragment string

+ Host string

+ Opaque string

+ Password string

+ Path string

+ Queries map[string]string

+ Scheme string

+ User string

+ func ParseUrl(strUrl string) (ui *UrlInfo)

Other modules containing this package

github.com/civet148/sqlca

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