Нема описа

xormplus a2e615076f 初始化 пре 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 a2e615076f 初始化 пре 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 a2e615076f 初始化 пре 10 година

README.md

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)