README
¶
go-x-sql
Improved sql package for go
TODO
- Abstract out mysql/cockroachdb/pg differences
- X Setting to replace
?, ?, ?with$1, $2, $3for postgres/cockroachdb - Use RETURNING Id to get Id from cockroachdb: https://www.cockroachlabs.com/docs/insert.html#go
- Improve error handling: see http://go-database-sql.org/errors.html#identifying-specific-database-errors (and use https://github.com/VividCortex/mysqlerr for mysql errors, and pg for pg errors)
- Allow for
INSERT INTO SET col1=?, col2=? in pg/cockroachdb - Fix go-x-sql_test.go to share more code for pg and mysql tests
- X Setting to replace
No prepared statements?
No. They cause more problems than they're worth. See http://go-database-sql.org/prepared.html#avoiding-prepared-statements and http://go-database-sql.org/prepared.html#prepared-statements-in-transactions for details.
Documentation
¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
View Source
var ( ErrNoRows = sql.ErrNoRows ErrRowsAffected = errors.New("Affected unexpected number of rows") )
View Source
var ( Must = must MustInt = mustInt MustBool = mustBool CheckDest = checkDest )
View Source
var ( DbNameConventionCamelCase_Capitalized = func(str string) string { return str } DbNameConventionCamelCase_uncapitalized = func(str string) string { return uncapitalize(str) } DbNameConvention_under_score = func(str string) string { return camelCaseTo_under_score(str) } DbNameConventionUPPERCASE = func(str string) string { return toUPPERCASE(str) } DbNameConventionUPPER_CASE_UNDER_SCORE = func(str string) string { return toUPPERCASE(camelCaseTo_under_score(str)) } )
Functions ¶
func IsDuplicateEntryError ¶
Types ¶
type API ¶
type API interface {
Select(dest interface{}, query string, args ...interface{}) error
SelectOne(dest interface{}, query string, args ...interface{}) error
SelectOneMaybe(dest interface{}, query string, args ...interface{}) (bool, error)
InsertAndGetId(query string, args ...interface{}) (id int64, err error)
InsertIgnoreId(query string, args ...interface{}) error
InsertIgnoreDuplicate(query string, args ...interface{}) (bool, error)
Update(query string, args ...interface{}) (rowsAffected int64, err error)
UpdateOne(query string, args ...interface{}) error
UpdateNum(expectedRowsAffected int64, query string, args ...interface{}) error
Exec(query string, args ...interface{}) error
MustExec(query string, args ...interface{})
}
type Db ¶
func Connect ¶
func Connect(driverName, dataSourceString string, dbNamesMapper DbNameConventionMapper) (Db, error)
func MustConnect ¶
func MustConnect(driverName, dataSourceString string, dbNamesMapper DbNameConventionMapper) Db
type DbNameConventionMapper ¶
DbNameConventionMapper is a function that takes a go struct field name and returns its corresponding database column name.
Source Files
Directories
Click to show internal directories.
Click to hide internal directories.