dbservice

Documentation

Index

• func CallRead(db *sql.DB, name string, args ...interface{}) ([]interface{}, messagehandle.ErrorMsg)
• func CallReadOutMap(db *sql.DB, name string, args ...interface{}) ([]map[string]interface{}, messagehandle.ErrorMsg)
• func CallReadOutMultipleMap(db *sql.DB, name string, args ...interface{}) ([][]map[string]interface{}, messagehandle.ErrorMsg)
• func CallWrite(db *sql.DB, name string, args ...interface{}) (sql.Result, messagehandle.ErrorMsg)
• func Exec(db *sql.DB, query string, args ...interface{}) (sql.Result, messagehandle.ErrorMsg)
• func MakeProcedureQueryStr(name string, args int) string
• func MakeScanArray(rows *sql.Rows) []interface{}
• func MakeScanMap(rows *sql.Rows) []map[string]interface{}
• func Query(db *sql.DB, query string, args ...interface{}) ([]interface{}, messagehandle.ErrorMsg)
• func QueryMultipleResult(db *sql.DB, query string, args ...interface{}) ([][]map[string]interface{}, messagehandle.ErrorMsg)
• func QueryOutMap(db *sql.DB, query string, args ...interface{}) ([]map[string]interface{}, messagehandle.ErrorMsg)
• type ConnSetting
• type DB
  • func (db *DB) ConnectDB(dbName string, setting ConnSetting) error
  • func (db *DB) GetDB() *sql.DB
  • func (db *DB) SetSetting(setting ConnSetting)

Functions

func CallRead

func CallRead(db *sql.DB, name string, args ...interface{}) ([]interface{}, messagehandle.ErrorMsg)

CallRead call stored procedure

func CallReadOutMap

func CallReadOutMap(db *sql.DB, name string, args ...interface{}) ([]map[string]interface{}, messagehandle.ErrorMsg)

CallReadOutMap call stored procedure

func CallReadOutMultipleMap

func CallReadOutMultipleMap(db *sql.DB, name string, args ...interface{}) ([][]map[string]interface{}, messagehandle.ErrorMsg)

CallReadOutMultipleMap call stored procedure

func CallWrite

func CallWrite(db *sql.DB, name string, args ...interface{}) (sql.Result, messagehandle.ErrorMsg)

CallWrite ...

func Exec

func Exec(db *sql.DB, query string, args ...interface{}) (sql.Result, messagehandle.ErrorMsg)

Exec Use to INSTER, UPDATE, DELETE

func MakeProcedureQueryStr

func MakeProcedureQueryStr(name string, args int) string

MakeProcedureQueryStr ...

func MakeScanArray

func MakeScanArray(rows *sql.Rows) []interface{}

MakeScanArray ...

func MakeScanMap

func MakeScanMap(rows *sql.Rows) []map[string]interface{}

MakeScanMap ...

func Query

func Query(db *sql.DB, query string, args ...interface{}) ([]interface{}, messagehandle.ErrorMsg)

Query Use to SELECT return array, first is Keys

func QueryMultipleResult

func QueryMultipleResult(db *sql.DB, query string, args ...interface{}) ([][]map[string]interface{}, messagehandle.ErrorMsg)

QueryMultipleResult ...

func QueryOutMap

func QueryOutMap(db *sql.DB, query string, args ...interface{}) ([]map[string]interface{}, messagehandle.ErrorMsg)

QueryOutMap Use to SELECT return array map

Types

type ConnSetting

type ConnSetting struct {
	DBUser, DBPassword, DBIP, DBPORT string
}

ConnSetting ...

type DB

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

DB ...

func (*DB) ConnectDB

func (db *DB) ConnectDB(dbName string, setting ConnSetting) error

ConnectDB ...

func (*DB) GetDB

func (db *DB) GetDB() *sql.DB

GetDB ...

func (*DB) SetSetting

func (db *DB) SetSetting(setting ConnSetting)

SetSetting ...