db

package
v1.0.10 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Nov 25, 2019 License: Apache-2.0 Imports: 12 Imported by: 204

Documentation

Index

Constants

View Source 
const (
	// DriverMysql is a const value of mysql driver.
	DriverMysql = "mysql"
	// DriverSqlite is a const value of sqlite driver.
	DriverSqlite = "sqlite"
	// DriverPostgresql is a const value of postgresql driver.
	DriverPostgresql = "postgresql"
	// DriverMssql is a const value of mssql driver.
	DriverMssql = "mssql"
)

Variables

View Source 
var (
	// StringTypeList is a DatabaseType list of string.
	StringTypeList = []DatabaseType{Date, Time, Year, Datetime, Timestamptz, Timestamp,
		Varchar, Char, Mediumtext, Longtext, Tinytext,
		Text, JSON, Blob, Tinyblob, Mediumblob, Longblob,
		Interval, Point,
		Line, Lseg, Box, Path, Polygon, Circle, Cidr, Inet, Macaddr, Character, Varyingcharacter,
		Nchar, Nativecharacter, Nvarchar, Clob, Binary, Varbinary, Enum, Set, Geometry, Multilinestring,
		Multipolygon, Linestring, Multipoint, Geometrycollection, Name, UUID, Timestamptz,
		Name, UUID, Inet}

	// BoolTypeList is a DatabaseType list of bool.
	BoolTypeList = []DatabaseType{Bool, Boolean}

	// IntTypeList is a DatabaseType list of integer.
	IntTypeList = []DatabaseType{Int4,
		Int,
		Tinyint,
		Mediumint,
		Smallint,
		Numeric, Smallserial, Serial, Bigserial, Money,
		Integer,
		Bigint}

	// FloatTypeList is a DatabaseType list of float.
	FloatTypeList = []DatabaseType{Float, Double, Real, Doubleprecision}

	// UintTypeList is a DatabaseType list of uint.
	UintTypeList = []DatabaseType{Decimal, Bit}
)
View Source 
var DB = Sqlite{
	DbList: map[string]*sql.DB{},
}

DB is a global variable which handles the sqlite connection.

View Source 
var MssqlDB = Mssql{
	DbList: map[string]*sql.DB{},
}

MssqlDB is a global variable which handles the mssql connection.

View Source 
var MysqlDB = Mysql{
	DbList: map[string]*sql.DB{},
}

MysqlDB is a global variable which handles the mysql connection.

View Source 
var PostgresqlDB = Postgresql{
	DbList: map[string]*sql.DB{},
}

PostgresqlDB is a global variable which handles the postgresql connection.

View Source 
var SQLPool = sync.Pool{
	New: func() interface{} {
		return &SQL{
			SQLComponent: dialect.SQLComponent{
				Fields:     make([]string, 0),
				TableName:  "",
				Args:       make([]interface{}, 0),
				Wheres:     make([]dialect.Where, 0),
				Leftjoins:  make([]dialect.Join, 0),
				UpdateRaws: make([]dialect.RawUpdate, 0),
				WhereRaws:  "",
			},
			diver:   nil,
			dialect: nil,
		}
	},
}

SQLPool is a object pool of SQL.

Functions

func CommonExec 

func CommonExec(db *sql.DB, query string, args ...interface{}) (sql.Result, error)

CommonExec is a common method of exec.

func CommonQuery 

func CommonQuery(db *sql.DB, query string, args ...interface{}) ([]map[string]interface{}, error)

CommonQuery is a common method of query.

func Contains 

func Contains(v DatabaseType, a []DatabaseType) bool

Contains check the given DatabaseType is in the list or not.

func Exec 

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

Exec call the Exec method of default Connection.

func Query 

func Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query call the Query method of default Connection.

func RecycleSQL added in v1.0.8 

func RecycleSQL(sql *SQL)

RecycleSQL clear the SQL and put into the pool.

func SetColVarType 

func SetColVarType(colVar *[]interface{}, i int, typeName string)

SetColVarType set the column type.

func SetResultValue 

func SetResultValue(result *map[string]interface{}, index string, colVar interface{}, typeName string)

SetResultValue set the result value.

Types

type Connection 

type Connection interface {
	// Query is the query method of sql.
	Query(query string, args ...interface{}) ([]map[string]interface{}, error)

	// Exec is the exec method of sql.
	Exec(query string, args ...interface{}) (sql.Result, error)

	// QueryWithConnection is the query method with given connection of sql.
	QueryWithConnection(conn, query string, args ...interface{}) ([]map[string]interface{}, error)

	// ExecWithConnection is the exec method with given connection of sql.
	ExecWithConnection(conn, query string, args ...interface{}) (sql.Result, error)

	// InitDB initialize the database connections.
	InitDB(cfg map[string]config.Database)

	// GetName get the connection name.
	GetName() string

	// GetDelimiter get the default delimiter.
	GetDelimiter() string
}

Connection is a connection handler of database.

func GetConnection 

func GetConnection() Connection

GetConnection return the default Connection.

func GetConnectionByDriver 

func GetConnectionByDriver(driver string) Connection

GetConnectionByDriver return the Connection by given driver name.

type DatabaseType 

type DatabaseType string

DatabaseType is the database field type. 

const (
	Int       DatabaseType = "INT"
	Tinyint   DatabaseType = "TINYINT"
	Mediumint DatabaseType = "MEDIUMINT"
	Smallint  DatabaseType = "SMALLINT"
	Bigint    DatabaseType = "BIGINT"
	Bit       DatabaseType = "BIT"
	Int4      DatabaseType = "INT4"

	Integer     DatabaseType = "INTEGER"
	Numeric     DatabaseType = "NUMERIC"
	Smallserial DatabaseType = "SMALLSERIAL"
	Serial      DatabaseType = "SERIAL"
	Bigserial   DatabaseType = "BIGSERIAL"
	Money       DatabaseType = "MONEY"

	Real    DatabaseType = "REAL"
	Float   DatabaseType = "FLOAT"
	Double  DatabaseType = "DOUBLE"
	Decimal DatabaseType = "DECIMAL"

	Doubleprecision DatabaseType = "DOUBLEPRECISION"

	Date      DatabaseType = "DATE"
	Time      DatabaseType = "TIME"
	Year      DatabaseType = "YEAR"
	Datetime  DatabaseType = "DATETIME"
	Timestamp DatabaseType = "TIMESTAMP"

	Text       DatabaseType = "TEXT"
	Longtext   DatabaseType = "LONGTEXT"
	Mediumtext DatabaseType = "MEDIUMTEXT"
	Tinytext   DatabaseType = "TINYTEXT"

	Varchar DatabaseType = "VARCHAR"
	Char    DatabaseType = "CHAR"
	JSON    DatabaseType = "JSON"

	Blob       DatabaseType = "BLOB"
	Tinyblob   DatabaseType = "TINYBLOB"
	Mediumblob DatabaseType = "MEDIUMBLOB"
	Longblob   DatabaseType = "LONGBLOB"

	Interval DatabaseType = "INTERVAL"
	Boolean  DatabaseType = "BOOLEAN"
	Bool     DatabaseType = "Bool"

	Point   DatabaseType = "POINT"
	Line    DatabaseType = "LINE"
	Lseg    DatabaseType = "LSEG"
	Box     DatabaseType = "BOX"
	Path    DatabaseType = "PATH"
	Polygon DatabaseType = "POLYGON"
	Circle  DatabaseType = "CIRCLE"

	Cidr    DatabaseType = "CIDR"
	Inet    DatabaseType = "INET"
	Macaddr DatabaseType = "MACADDR"

	Character        DatabaseType = "CHARACTER"
	Varyingcharacter DatabaseType = "VARYINGCHARACTER"
	Nchar            DatabaseType = "NCHAR"
	Nativecharacter  DatabaseType = "NATIVECHARACTER"
	Nvarchar         DatabaseType = "NVARCHAR"
	Clob             DatabaseType = "CLOB"

	Binary    DatabaseType = "BINARY"
	Varbinary DatabaseType = "VARBINARY"
	Enum      DatabaseType = "ENUM"
	Set       DatabaseType = "SET"

	Geometry DatabaseType = "GEOMETRY"

	Multilinestring    DatabaseType = "MULTILINESTRING"
	Multipolygon       DatabaseType = "MULTIPOLYGON"
	Linestring         DatabaseType = "LINESTRING"
	Multipoint         DatabaseType = "MULTIPOINT"
	Geometrycollection DatabaseType = "GEOMETRYCOLLECTION"

	Name DatabaseType = "NAME"
	UUID DatabaseType = "UUID"

	Timestamptz DatabaseType = "TIMESTAMPTZ"
)

func DT 

func DT(s string) DatabaseType

DT turn the string value into DatabaseType.

func GetDTAndCheck 

func GetDTAndCheck(s string) DatabaseType

GetDTAndCheck check the DatabaseType.

type H 

type H map[string]interface{}

H is a shorthand of map.

type Mssql 

type Mssql struct {
	DbList map[string]*sql.DB
	Once   sync.Once
}

Mssql is a Connection of mssql.

func GetMssqlDB 

func GetMssqlDB() *Mssql

GetMssqlDB return the global mssql connection.

func (*Mssql) Exec 

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

Exec implements the method Connection.Exec.

func (*Mssql) ExecWithConnection 

func (db *Mssql) ExecWithConnection(con string, query string, args ...interface{}) (sql.Result, error)

ExecWithConnection implements the method Connection.ExecWithConnection.

func (*Mssql) GetDelimiter 

func (db *Mssql) GetDelimiter() string

GetDelimiter implements the method Connection.GetDelimiter.

func (*Mssql) GetName 

func (db *Mssql) GetName() string

GetName implements the method Connection.GetName.

func (*Mssql) InitDB 

func (db *Mssql) InitDB(cfglist map[string]config.Database)

InitDB implements the method Connection.InitDB.

func (*Mssql) Query 

func (db *Mssql) Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query implements the method Connection.Query.

func (*Mssql) QueryWithConnection 

func (db *Mssql) QueryWithConnection(con string, query string, args ...interface{}) ([]map[string]interface{}, error)

QueryWithConnection implements the method Connection.QueryWithConnection.

type Mysql 

type Mysql struct {
	DbList map[string]*sql.DB
	Once   sync.Once
}

Mysql is a Connection of mssql.

func GetMysqlDB 

func GetMysqlDB() *Mysql

GetMysqlDB return the global mssql connection.

func (*Mysql) BeginTransactions 

func (db *Mysql) BeginTransactions() *SQLTx

BeginTransactions starts a transaction with level LevelDefault.

func (*Mysql) BeginTransactionsWithLevel 

func (db *Mysql) BeginTransactionsWithLevel(level sql.IsolationLevel) *SQLTx

BeginTransactionsWithLevel starts a transaction with given transaction isolation level.

func (*Mysql) BeginTransactionsWithReadCommitted 

func (db *Mysql) BeginTransactionsWithReadCommitted() *SQLTx

BeginTransactionsWithReadCommitted starts a transaction with level LevelReadCommitted.

func (*Mysql) BeginTransactionsWithReadUncommitted 

func (db *Mysql) BeginTransactionsWithReadUncommitted() *SQLTx

BeginTransactionsWithReadUncommitted starts a transaction with level LevelReadUncommitted.

func (*Mysql) BeginTransactionsWithRepeatableRead 

func (db *Mysql) BeginTransactionsWithRepeatableRead() *SQLTx

BeginTransactionsWithRepeatableRead starts a transaction with level LevelRepeatableRead.

func (*Mysql) Exec 

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

Exec implements the method Connection.Exec.

func (*Mysql) ExecWithConnection 

func (db *Mysql) ExecWithConnection(con string, query string, args ...interface{}) (sql.Result, error)

ExecWithConnection implements the method Connection.ExecWithConnection.

func (*Mysql) GetDelimiter 

func (db *Mysql) GetDelimiter() string

GetDelimiter implements the method Connection.GetDelimiter.

func (*Mysql) GetName 

func (db *Mysql) GetName() string

GetName implements the method Connection.GetName.

func (*Mysql) InitDB 

func (db *Mysql) InitDB(cfgs map[string]config.Database)

InitDB implements the method Connection.InitDB.

func (*Mysql) Query 

func (db *Mysql) Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query implements the method Connection.Query.

func (*Mysql) QueryWithConnection 

func (db *Mysql) QueryWithConnection(con string, query string, args ...interface{}) ([]map[string]interface{}, error)

QueryWithConnection implements the method Connection.QueryWithConnection.

func (*Mysql) WithTransaction 

func (db *Mysql) WithTransaction(fn TxFn) (res map[string]interface{}, err error)

WithTransaction call the callback function within the transaction and catch the error.

func (*Mysql) WithTransactionByLevel 

func (db *Mysql) WithTransactionByLevel(level sql.IsolationLevel, fn TxFn) (res map[string]interface{}, err error)

WithTransactionByLevel call the callback function within the transaction of given transaction level and catch the error.

type Postgresql 

type Postgresql struct {
	DbList map[string]*sql.DB
	Once   sync.Once
}

Postgresql is a Connection of mssql.

func GetPostgresqlDB 

func GetPostgresqlDB() *Postgresql

GetPostgresqlDB return the global mssql connection.

func (*Postgresql) Exec 

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

Exec implements the method Connection.Exec.

func (*Postgresql) ExecWithConnection 

func (db *Postgresql) ExecWithConnection(con string, query string, args ...interface{}) (sql.Result, error)

ExecWithConnection implements the method Connection.ExecWithConnection.

func (*Postgresql) GetDelimiter 

func (db *Postgresql) GetDelimiter() string

GetDelimiter implements the method Connection.GetDelimiter.

func (*Postgresql) GetName 

func (db *Postgresql) GetName() string

GetName implements the method Connection.GetName.

func (*Postgresql) InitDB 

func (db *Postgresql) InitDB(cfgList map[string]config.Database)

InitDB implements the method Connection.InitDB.

func (*Postgresql) Query 

func (db *Postgresql) Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query implements the method Connection.Query.

func (*Postgresql) QueryWithConnection 

func (db *Postgresql) QueryWithConnection(con string, query string, args ...interface{}) ([]map[string]interface{}, error)

QueryWithConnection implements the method Connection.QueryWithConnection.

type SQL added in v1.0.8 

type SQL struct {
	dialect.SQLComponent
	// contains filtered or unexported fields
}

SQL wraps the Connection and driver dialect methods.

func Table 

func Table(table string) *SQL

Table return a SQL with given table and default connection.

func WithDriver 

func WithDriver(driver string) *SQL

WithDriver return a SQL with given driver.

func WithDriverAndConnection 

func WithDriverAndConnection(conn, driver string) *SQL

WithDriverAndConnection return a SQL with given driver and connection name.

func (*SQL) All added in v1.0.8 

func (sql *SQL) All() ([]map[string]interface{}, error)

All query all the result and return.

func (*SQL) Count added in v1.0.8 

func (sql *SQL) Count() (int64, error)

Count query the count of query results.

func (*SQL) Delete added in v1.0.8 

func (sql *SQL) Delete() error

Delete exec the delete method.

func (*SQL) Exec added in v1.0.8 

func (sql *SQL) Exec() (int64, error)

Exec exec the exec method.

func (*SQL) Find added in v1.0.8 

func (sql *SQL) Find(arg interface{}) (map[string]interface{}, error)

Find query the sql result with given id assuming that primary key name is "id".

func (*SQL) First added in v1.0.8 

func (sql *SQL) First() (map[string]interface{}, error)

First query the result and return the first row.

func (*SQL) Insert added in v1.0.8 

func (sql *SQL) Insert(values dialect.H) (int64, error)

Insert exec the insert method of given key/value pairs.

func (*SQL) LeftJoin added in v1.0.8 

func (sql *SQL) LeftJoin(table string, fieldA string, operation string, fieldB string) *SQL

LeftJoin add a left join info.

func (*SQL) OrderBy added in v1.0.8 

func (sql *SQL) OrderBy(fields ...string) *SQL

OrderBy set order fields.

func (*SQL) Select added in v1.0.8 

func (sql *SQL) Select(fields ...string) *SQL

Select set select fields.

func (*SQL) ShowColumns added in v1.0.8 

func (sql *SQL) ShowColumns() ([]map[string]interface{}, error)

ShowColumns show columns info.

func (*SQL) ShowTables added in v1.0.8 

func (sql *SQL) ShowTables() ([]map[string]interface{}, error)

ShowTables show table info.

func (*SQL) Skip added in v1.0.8 

func (sql *SQL) Skip(offset int) *SQL

Skip set offset value.

func (*SQL) Table added in v1.0.8 

func (sql *SQL) Table(table string) *SQL

Table set table of SQL.

func (*SQL) Take added in v1.0.8 

func (sql *SQL) Take(take int) *SQL

Take set limit value.

func (*SQL) Update added in v1.0.8 

func (sql *SQL) Update(values dialect.H) (int64, error)

Update exec the update method of given key/value pairs.

func (*SQL) UpdateRaw added in v1.0.8 

func (sql *SQL) UpdateRaw(raw string, args ...interface{}) *SQL

UpdateRaw set UpdateRaw.

func (*SQL) Where added in v1.0.8 

func (sql *SQL) Where(field string, operation string, arg interface{}) *SQL

Where add the where operation and argument value.

func (*SQL) WhereIn added in v1.0.8 

func (sql *SQL) WhereIn(field string, arg []interface{}) *SQL

WhereIn add the where operation of "in" and argument values.

func (*SQL) WhereNotIn added in v1.0.8 

func (sql *SQL) WhereNotIn(field string, arg []interface{}) *SQL

WhereNotIn add the where operation of "not in" and argument values.

func (*SQL) WhereRaw added in v1.0.8 

func (sql *SQL) WhereRaw(raw string, args ...interface{}) *SQL

WhereRaw set WhereRaws and arguments.

func (*SQL) WithConnection added in v1.0.8 

func (sql *SQL) WithConnection(conn string) *SQL

WithConnection set the connection name of SQL.

type SQLTx added in v1.0.8 

type SQLTx struct {
	Tx *sql.Tx
}

SQLTx is an in-progress database transaction.

func (*SQLTx) Exec added in v1.0.8 

func (SqlTx *SQLTx) Exec(query string, args ...interface{}) (sql.Result, error)

Exec is exec method within the transaction.

func (*SQLTx) Query added in v1.0.8 

func (SqlTx *SQLTx) Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query is query method within the transaction.

type Sqlite 

type Sqlite struct {
	DbList map[string]*sql.DB
	Once   sync.Once
}

Sqlite is a Connection of mssql.

func GetSqliteDB 

func GetSqliteDB() *Sqlite

GetSqliteDB return the global mssql connection.

func (*Sqlite) Exec 

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

Exec implements the method Connection.Exec.

func (*Sqlite) ExecWithConnection 

func (db *Sqlite) ExecWithConnection(con string, query string, args ...interface{}) (sql.Result, error)

ExecWithConnection implements the method Connection.ExecWithConnection.

func (*Sqlite) GetDelimiter 

func (db *Sqlite) GetDelimiter() string

GetDelimiter implements the method Connection.GetDelimiter.

func (*Sqlite) GetName 

func (db *Sqlite) GetName() string

GetName implements the method Connection.GetName.

func (*Sqlite) InitDB 

func (db *Sqlite) InitDB(cfgList map[string]config.Database)

InitDB implements the method Connection.InitDB.

func (*Sqlite) Query 

func (db *Sqlite) Query(query string, args ...interface{}) ([]map[string]interface{}, error)

Query implements the method Connection.Query.

func (*Sqlite) QueryWithConnection 

func (db *Sqlite) QueryWithConnection(con string, query string, args ...interface{}) ([]map[string]interface{}, error)

QueryWithConnection implements the method Connection.QueryWithConnection.

type TxFn 

type TxFn func(*SQLTx) (error, map[string]interface{})

TxFn is the transaction callback function.

type Value 

type Value string

Value is a string.

func GetValueFromDatabaseType 

func GetValueFromDatabaseType(typ DatabaseType, value interface{}) Value

GetValueFromDatabaseType return Value of given DatabaseType and interface.

func (Value) String 

func (v Value) String() string

String return the string value.

func (Value) ToInt64 

func (v Value) ToInt64() int64

ToInt64 turn the string to a int64.

Source Files

View all Source files

Directories

Path Synopsis
drivers
mssql
mysql
postgres
sqlite

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.