Tidak Ada Deskripsi

0 Rilis

xormplus 483f98cee7 MapToSlice: return error instead of panic		9 tahun lalu
.gitignore	9962f563c4 Initial commit	10 tahun lalu
LICENSE	9962f563c4 Initial commit	10 tahun lalu
README.md	a2e615076f 初始化	10 tahun lalu
benchmark.sh	a2e615076f 初始化	10 tahun lalu
cache.go	a2e615076f 初始化	10 tahun lalu
column.go	e925ba9ce1 added bytes type	9 tahun lalu
config	a2e615076f 初始化	10 tahun lalu
converstion.go	a2e615076f 初始化	10 tahun lalu
db.go	483f98cee7 MapToSlice: return error instead of panic	9 tahun lalu
db_test.go	0911afc633 serious extends bug fixed & correct logger file path	10 tahun lalu
description	a2e615076f 初始化	10 tahun lalu
dialect.go	0911afc633 serious extends bug fixed & correct logger file path	10 tahun lalu
driver.go	a2e615076f 初始化	10 tahun lalu
error.go	0911afc633 serious extends bug fixed & correct logger file path	10 tahun lalu
filter.go	a2e615076f 初始化	10 tahun lalu
ilogger.go	0911afc633 serious extends bug fixed & correct logger file path	10 tahun lalu
index.go	a2e615076f 初始化	10 tahun lalu
mapper.go	a2e615076f 初始化	10 tahun lalu
mapper_test.go	a2e615076f 初始化	10 tahun lalu
pk.go	a2e615076f 初始化	10 tahun lalu
pk_test.go	a2e615076f 初始化	10 tahun lalu
table.go	a2e615076f 初始化	10 tahun lalu
type.go	e925ba9ce1 added bytes type	9 tahun lalu

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