mssql

type Aliaser interface {
	Join(tableName string) Joiner
	LeftJoin(tableName string) Joiner
	RightJoin(tableName string) Joiner
	Union(model Modeler) Unioner
	Where(field string, value interface{}) Wherer
	WhereRaw(where string) Wherer
	WhereSymbol(field, symbol string, value interface{}) Wherer
	WhereIn(field string, value interface{}) Wherer
	WhereNotIn(field string, value interface{}) Wherer
	GroupBy(field ...string) GroupByer
	Count() int64
	Get() lib.SqlRows
	Find() lib.SqlRow
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
	Update(data lib.SqlIn) int64
}

type CreateConnectFunc func(*DB) []MsSqlConnect

type DB struct {
	// contains filtered or unexported fields
}

type DBConfig struct {
	Name         string `json:"name"`
	DatabaseName string `json:"databaseName"`
	UserName     string `json:"userName"`
	Password     string `json:"password"`
	Host         string `json:"host"`
	Port         string `json:"port"`
	Charset      string `json:"charset"`
	MaxOpenConns int    `json:"maxOpenConns"`
	MaxIdleConns int    `json:"maxIdleConns"`
	MaxLifetime  int    `json:"maxLifetime"`
	Prefix       string `json:"prefix"`
	Suffix       string `json:"suffix"`
}

type DBPool interface {
	SetDB(connectName, databaseName string) DBer
}

type DBer interface {
	BeginTransaction()
	Commit()
	Rollback()
	Exec(sql string) int64
	Query(sql string, whereParams ...interface{}) lib.SqlRows
	Desc(tableName string) lib.Columns
	IsExist(tableName string) bool
	ShowTables() []string
	ShowDatabases() []string
}

type Fielder interface {
	Alias(name string) Aliaser
	Join(tableName string) Joiner
	LeftJoin(tableName string) Joiner
	RightJoin(tableName string) Joiner
	Union(model Modeler) Unioner
	Where(field string, value interface{}) Wherer
	WhereRaw(where string) Wherer
	WhereSymbol(field, symbol string, value interface{}) Wherer
	WhereIn(field string, value interface{}) Wherer
	WhereNotIn(field string, value interface{}) Wherer
	GroupBy(field ...string) GroupByer
	Count() int64
	Get() lib.SqlRows
	Find() lib.SqlRow
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
}

type GroupByer interface {
	Having(field string, value interface{}) Havinger
	HavingRaw(having string) Havinger
	HavingSymbol(field, symbol string, value interface{}) Havinger
	HavingIn(field string, value interface{}) Havinger
	HavingNotIn(field string, value interface{}) Havinger
	Get() lib.SqlRows
	Find() lib.SqlRow
	Count() int64
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Union(model Modeler) Unioner
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
}

type Havinger interface {
	AndHaving(field string, value interface{}) Havinger
	AndHavingRaw(having string) Havinger
	AndHavingSymbol(field, symbol string, value interface{}) Havinger
	AndHavingIn(field string, value interface{}) Havinger
	AndHavingNotIn(field string, value interface{}) Havinger
	OrHaving(field string, value interface{}) Havinger
	OrHavingRaw(having string) Havinger
	OrHavingSymbol(field, symbol string, value interface{}) Havinger
	OrHavingIn(field string, value interface{}) Havinger
	OrHavingNotIn(field string, value interface{}) Havinger
	Get() lib.SqlRows
	Find() lib.SqlRow
	Count() int64
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Union(model Modeler) Unioner
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
}

type Joiner interface {
	On(field string, value interface{}) Oner
	OnRaw(on string) Oner
	OnSymbol(field, symbol string, value interface{}) Oner
	OnIn(field string, value interface{}) Oner
	OnNotIn(field string, value interface{}) Oner
}

type Limit struct {
	// contains filtered or unexported fields
}

type Limiter interface {
	Get() lib.SqlRows
	Find() lib.SqlRow
}

type Model struct {
	PriKey string

	SoftDelete bool
	DeleteName string
	// contains filtered or unexported fields
}

type Modeler interface {
	Fields(fields ...string) Fielder
	Count() int64
	GetLastSql() string
	GetSqlInfo() (string, []interface{})
	GetModelSql() (string, []interface{})
	Alias(name string) Aliaser
	Join(tableName string) Joiner
	LeftJoin(tableName string) Joiner
	RightJoin(tableName string) Joiner
	Union(model Modeler) Unioner
	Where(field string, value interface{}) Wherer
	WhereRaw(where string) Wherer
	WhereSymbol(field, symbol string, value interface{}) Wherer
	WhereIn(field string, value interface{}) Wherer
	WhereNotIn(field string, value interface{}) Wherer
	GroupBy(field ...string) GroupByer
	Get() lib.SqlRows
	Find() lib.SqlRow
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
	Update(data lib.SqlIn) int64
	Insert(row lib.SqlIn) int64
	Create(row lib.SqlIn) int64
	Drop() int64
	Truncate() int64
	Delete() int64
	DB() DBer
}

type MsSqlConnect struct {
	Master DBConfig   `json:"master"`
	Slave  []DBConfig `json:"slave"`
}

type MsSqlPool struct {
	// contains filtered or unexported fields
}

type MsSqlPooler interface {
	GetDB(connectName string) *sql.DB
	GetIncludeReadDB(connectName string) *sql.DB
	SetTx(connectName string, tx *sql.Tx)
	GetTx(connectName string) *sql.Tx
	BeginTx(connectName string)
	EndTx(connectName string)
	IsTransaction(connectName string) bool
	Close()
	Init(connect []MsSqlConnect)
	AddConnect(connect MsSqlConnect)
	AddConnects(connects []MsSqlConnect)
}

type Oner interface {
	OrOn(field string, value interface{}) Oner
	OrOnRaw(on string) Oner
	OrOnSymbol(field, symbol string, value interface{}) Oner
	OrOnIn(field string, value interface{}) Oner
	OrOnNotIn(field string, value interface{}) Oner
	AndOn(field string, value interface{}) Oner
	AndOnRaw(on string) Oner
	AndOnSymbol(field, symbol string, value interface{}) Oner
	AndOnIn(field string, value interface{}) Oner
	AndOnNotIn(field string, value interface{}) Oner
	Where(field string, value interface{}) Wherer
	WhereRaw(where string) Wherer
	WhereSymbol(field, symbol string, value interface{}) Wherer
	WhereIn(field string, value interface{}) Wherer
	WhereNotIn(field string, value interface{}) Wherer
	Join(tableName string) Joiner
	LeftJoin(tableName string) Joiner
	RightJoin(tableName string) Joiner
	GroupBy(field ...string) GroupByer
	Count() int64
	Get() lib.SqlRows
	Find() lib.SqlRow
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Union(model Modeler) Unioner
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
	Update(data lib.SqlIn) int64
}

type OrderByer interface {
	Get() lib.SqlRows
	Find() lib.SqlRow
	Limit(offset, count int) Limiter
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
}

type Table struct {
	// contains filtered or unexported fields
}

type Tabler interface {
	SetDB(db *DB)
	GetDB() *DB
	Insert(row lib.SqlIn) int64
	Drop() int64
	Truncate() int64
	Delete(onParams []interface{}, where string, whereParams ...interface{}) int64
	Update(row lib.SqlIn, onParams []interface{}, where string, whereParams ...interface{}) int64
	SelectByHasWhere(fields string, where string, hasWhere bool, page *Limit, whereParams ...interface{}) lib.SqlRows
	Select(fields string, where string, whereParams ...interface{}) lib.SqlRows
	GetLastSql() string
	GetSqlInfo() (string, []interface{})
}

type Unioner interface {
	Count() int64
	Get() lib.SqlRows
	Find() lib.SqlRow
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
}

type Wherer interface {
	AndWhere(field string, value interface{}) Wherer
	AndWhereRaw(where string) Wherer
	AndWhereSymbol(field, symbol string, value interface{}) Wherer
	AndWhereIn(field string, value interface{}) Wherer
	AndWhereNotIn(field string, value interface{}) Wherer
	OrWhere(field string, value interface{}) Wherer
	OrWhereRaw(where string) Wherer
	OrWhereSymbol(field, symbol string, value interface{}) Wherer
	OrWhereIn(field string, value interface{}) Wherer
	OrWhereNotIn(field string, value interface{}) Wherer
	GroupBy(field ...string) GroupByer
	Get() lib.SqlRows
	Find() lib.SqlRow
	Count() int64
	OrderBy(orderBy string) OrderByer
	Limit(offset, count int) Limiter
	Union(model Modeler) Unioner
	Pager(page, pageSize int) (lib.SqlRows, lib.SqlRow)
	Update(data lib.SqlIn) int64
	Delete() int64
}