Нема описа

xormplus f99dc01f0c correct spelling mistake		пре 8 година
.gitignore	9962f563c4 Initial commit	пре 10 година
LICENSE	9962f563c4 Initial commit	пре 10 година
README.md	a2e615076f 初始化	пре 10 година
benchmark.sh	a2e615076f 初始化	пре 10 година
cache.go	a2e615076f 初始化	пре 10 година
column.go	62fdae93b7 add IsJSON on Column	пре 8 година
config	a2e615076f 初始化	пре 10 година
converstion.go	a2e615076f 初始化	пре 10 година
db.go	2750e9842a add ToMapString method for rows and row	пре 9 година
db_test.go	0911afc633 serious extends bug fixed & correct logger file path	пре 9 година
description	a2e615076f 初始化	пре 10 година
dialect.go	b5e3f16634 add comment create support for mysql	пре 8 година
driver.go	a2e615076f 初始化	пре 10 година
error.go	0911afc633 serious extends bug fixed & correct logger file path	пре 9 година
filter.go	a2e615076f 初始化	пре 10 година
ilogger.go	0911afc633 serious extends bug fixed & correct logger file path	пре 9 година
index.go	a2e615076f 初始化	пре 10 година
mapper.go	a2e615076f 初始化	пре 10 година
mapper_test.go	a2e615076f 初始化	пре 10 година
pk.go	a2e615076f 初始化	пре 10 година
pk_test.go	a2e615076f 初始化	пре 10 година
rows.go	cf101d54ca 1.add ErrorRow function	пре 8 година
table.go	1c7322c734 column,table实体添加注释属性	пре 8 година
type.go	f99dc01f0c correct spelling mistake	пре 8 година

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)

README.md