go-xorm / core Goto Github PK

Lightweight & Compitable wrapper of database/sql, move to https://gitea.com/xorm/core

License: BSD 3-Clause "New" or "Revised" License

Shell 0.04% Go 99.96%

core's Introduction

Core is a lightweight wrapper of sql.DB.

Open

db, _ := core.Open(db, connstr)

SetMapper

db.SetMapper(SameMapper())

Scan usage

Scan

rows, _ := db.Query()
for rows.Next() {
    rows.Scan()
}

ScanMap

rows, _ := db.Query()
for rows.Next() {
    rows.ScanMap()

ScanSlice

You can use []string, [][]byte, []interface{}, []*string, []sql.NullString to ScanSclice. Notice, slice's length should be equal or less than select columns.

rows, _ := db.Query()
cols, _ := rows.Columns()
for rows.Next() {
    var s = make([]string, len(cols))
    rows.ScanSlice(&s)
}

rows, _ := db.Query()
cols, _ := rows.Columns()
for rows.Next() {
    var s = make([]*string, len(cols))
    rows.ScanSlice(&s)
}

ScanStruct

rows, _ := db.Query()
for rows.Next() {
    rows.ScanStructByName()
    rows.ScanStructByIndex()
}

Query usage

rows, err := db.Query("select * from table where name = ?", name)

user = User{
    Name:"lunny",
}
rows, err := db.QueryStruct("select * from table where name = ?Name",
            &user)

var user = map[string]interface{}{
    "name": "lunny",
}
rows, err = db.QueryMap("select * from table where name = ?name",
            &user)

QueryRow usage

row := db.QueryRow("select * from table where name = ?", name)

user = User{
    Name:"lunny",
}
row := db.QueryRowStruct("select * from table where name = ?Name",
            &user)

var user = map[string]interface{}{
    "name": "lunny",
}
row = db.QueryRowMap("select * from table where name = ?name",
            &user)

Exec usage

db.Exec("insert into user (`name`, title, age, alias, nick_name,created) values (?,?,?,?,?,?)", name, title, age, alias...)

user = User{
    Name:"lunny",
    Title:"test",
    Age: 18,
}
result, err = db.ExecStruct("insert into user (`name`, title, age, alias, nick_name,created) values (?Name,?Title,?Age,?Alias,?NickName,?Created)",
            &user)

var user = map[string]interface{}{
    "Name": "lunny",
    "Title": "test",
    "Age": 18,
}
result, err = db.ExecMap("insert into user (`name`, title, age, alias, nick_name,created) values (?Name,?Title,?Age,?Alias,?NickName,?Created)",
            &user)

core's People

Contributors

Stargazers

Watchers

core's Issues

does xorm support golang big.Rat to mysql decimal?

does xorm support golang big.Rat to mysql decimal? or like json package, provide a interface which
user can customize type mapping between mysql and golang?

bug: in oracle (11g) create table error: ORA-00907: missing right parenthesis

In oracle database, when default keyword in the last position at xorm tag in table struct, error will happened.

Oracle database error message return: create table error: ORA-00907: missing right parenthesis

Env:

Oracle database (version 11g) in docker: https://github.com/wnameless/docker-oracle-xe-11g
mac osx
golang 1.9
go-xorm/core version: da1adaf

Code:

Run result snapshot:

need the method to check whether the database is exist

need the method to check whether the database exists!

Any Plan to support context.Context parameter?

rows.go的ReflectNew当大数据量时，并发多个请求出现out of range错误

func ReflectNew(typ reflect.Type) reflect.Value {
	reflectCacheMutex.RLock()
	cs, ok := reflectCache[typ]
	reflectCacheMutex.RUnlock()

	const newSize = 200

	if !ok || cs.idx+1 > newSize-1 {
		cs = &cacheStruct{reflect.MakeSlice(reflect.SliceOf(typ), newSize, newSize), 0}
		reflectCacheMutex.Lock()
		reflectCache[typ] = cs
		reflectCacheMutex.Unlock()
	} else {
		reflectCacheMutex.Lock()
		cs.idx = cs.idx + 1
		reflectCacheMutex.Unlock()
	}
	//todo 当大数据量时，并发多个请求出现out of range错误
	return cs.value.Index(cs.idx).Addr()
}

failing tests

Hello,

I am getting the following test failures:

=== RUN   TestExecMap
-- {1 xlw tester 1.2 lunny lunny xiao {0 0 <nil>}}
--- FAIL: TestExecMap (0.13s)
    db_test.go:580: sql: Scan error on column index 6: unsupported driver -> Scan pair: time.Time -> *core.NullTime
=== RUN   TestExecStruct
1-- {1 xlw tester 1.2 lunny lunny xiao {0 0 <nil>}}
--- FAIL: TestExecStruct (0.13s)
    db_test.go:622: sql: Scan error on column index 6: unsupported driver -> Scan pair: time.Time -> *core.NullTime

any idea how to fix this?

Thanks

Add db.InsertStruct(Table, *interface{}) support

This package is extremely helpful when you want to simplify sql usage in your app without requiring the fullness of xorm so thank you for writing it.

One thing that would make this library a lot more useful is a new func on core.DB, It should allow users to specify the table and provide the struct and automatically generate the required sql for it.

For example

user = User{
    Name:"lunny",
    Title:"test",
    Age: 18,
}
result, err = db.ExecStruct("insert into user (`name`, title, age, alias, nick_name,created) values (?Name,?Title,?Age,?Alias,?NickName,?Created)",
            &user)

would become

user = User{
    Name:"lunny",
    Title:"test",
    Age: 18,
}
result, err = db.InsertStruct("user", &user)

What do you think?

License

Hello!

I would like to package go-xorm/core for Debian

However, I cound not find a license.

Can you please add one?

*sql.DB

Hey guys,

Is where an easy way to get the *sql.DB object from the *core.DB? I want to pass it into mysql store instead of creating another connection.

Support YEAR type for mysql

Please consider add YEAR type, thanks.

core QueryMap paramaters Error

sql=delete from t1 where id=?id delete from t2 where id=?id
QueryMap(sql,[id]value)
but sql change to
' delete from t1 where id=value
delete from t2 where id=?
'

benchmark test error

after execute go test -v -bench=., got this error message.

goos: darwin
goarch: amd64
pkg: github.com/go-xorm/core
BenchmarkOriQuery-8                  	    1000	   1266147 ns/op
BenchmarkStructQuery-8               	    1000	   1921657 ns/op
BenchmarkStruct2Query-8              	     500	   2829271 ns/op
panic: interface conversion: interface {} is []uint8, not *string

goroutine 2903 [running]:
github.com/go-xorm/core.BenchmarkSliceInterfaceQuery(0xc42055b980)
	/Users/carllhw/Projects/go/src/github.com/go-xorm/core/db_test.go:232 +0x7b2
testing.(*B).runN(0xc42055b980, 0x1)
	/usr/local/Cellar/go/1.10.2/libexec/src/testing/benchmark.go:141 +0xb2
testing.(*B).run1.func1(0xc42055b980)
	/usr/local/Cellar/go/1.10.2/libexec/src/testing/benchmark.go:214 +0x5a
created by testing.(*B).run1
	/usr/local/Cellar/go/1.10.2/libexec/src/testing/benchmark.go:207 +0x80
exit status 2
FAIL	github.com/go-xorm/core	5.919s

Please tag xorm and core together