Keine Beschreibung

xormplus 99d20b5b6b small refactor		vor 8 Jahren
.gitignore	9962f563c4 Initial commit	vor 10 Jahren
LICENSE	9962f563c4 Initial commit	vor 10 Jahren
README.md	a2e615076f 初始化	vor 10 Jahren
benchmark.sh	a2e615076f 初始化	vor 10 Jahren
cache.go	99d20b5b6b small refactor	vor 8 Jahren
column.go	0f69a142b3 fix: oracle default key in xorm tag error	vor 8 Jahren
config	a2e615076f 初始化	vor 10 Jahren
converstion.go	a2e615076f 初始化	vor 10 Jahren
db.go	2750e9842a add ToMapString method for rows and row	vor 9 Jahren
db_test.go	c5b6cd8dd2 fix Scan NullTime type failed at sqlite3	vor 8 Jahren
description	a2e615076f 初始化	vor 10 Jahren
dialect.go	b5e3f16634 add comment create support for mysql	vor 8 Jahren
driver.go	a2e615076f 初始化	vor 10 Jahren
error.go	0911afc633 serious extends bug fixed & correct logger file path	vor 9 Jahren
filter.go	a2e615076f 初始化	vor 10 Jahren
ilogger.go	0911afc633 serious extends bug fixed & correct logger file path	vor 9 Jahren
index.go	a2e615076f 初始化	vor 10 Jahren
mapper.go	a2e615076f 初始化	vor 10 Jahren
mapper_test.go	a2e615076f 初始化	vor 10 Jahren
pk.go	a2e615076f 初始化	vor 10 Jahren
pk_test.go	c5b6cd8dd2 fix Scan NullTime type failed at sqlite3	vor 8 Jahren
rows.go	cf101d54ca 1.add ErrorRow function	vor 8 Jahren
scan.go	c5b6cd8dd2 fix Scan NullTime type failed at sqlite3	vor 8 Jahren
table.go	1c7322c734 column,table实体添加注释属性	vor 8 Jahren
type.go	2226ed5618 add boolean type	vor 8 Jahren

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