暫無描述

xormplus 7da3ad70b2 bug fixed for sync2		10 年之前
.gitignore	9962f563c4 Initial commit	10 年之前
LICENSE	9962f563c4 Initial commit	10 年之前
README.md	a2e615076f 初始化	10 年之前
benchmark.sh	a2e615076f 初始化	10 年之前
cache.go	a2e615076f 初始化	10 年之前
column.go	a2e615076f 初始化	10 年之前
config	a2e615076f 初始化	10 年之前
converstion.go	a2e615076f 初始化	10 年之前
db.go	a2e615076f 初始化	10 年之前
db_test.go	a2e615076f 初始化	10 年之前
description	a2e615076f 初始化	10 年之前
dialect.go	7da3ad70b2 bug fixed for sync2	10 年之前
driver.go	a2e615076f 初始化	10 年之前
error.go	a2e615076f 初始化	10 年之前
filter.go	a2e615076f 初始化	10 年之前
ilogger.go	a2e615076f 初始化	10 年之前
index.go	a2e615076f 初始化	10 年之前
mapper.go	a2e615076f 初始化	10 年之前
mapper_test.go	a2e615076f 初始化	10 年之前
pk.go	a2e615076f 初始化	10 年之前
pk_test.go	a2e615076f 初始化	10 年之前
table.go	a2e615076f 初始化	10 年之前
type.go	7da3ad70b2 bug fixed for sync2	10 年之前

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