Açıklama Yok

xormplus b5e3f16634 add comment create support for mysql		8 yıl önce
.gitignore	9962f563c4 Initial commit	10 yıl önce
LICENSE	9962f563c4 Initial commit	10 yıl önce
README.md	a2e615076f 初始化	10 yıl önce
benchmark.sh	a2e615076f 初始化	10 yıl önce
cache.go	a2e615076f 初始化	10 yıl önce
column.go	1c7322c734 column,table实体添加注释属性	8 yıl önce
config	a2e615076f 初始化	10 yıl önce
converstion.go	a2e615076f 初始化	10 yıl önce
db.go	2750e9842a add ToMapString method for rows and row	9 yıl önce
db_test.go	0911afc633 serious extends bug fixed & correct logger file path	10 yıl önce
description	a2e615076f 初始化	10 yıl önce
dialect.go	b5e3f16634 add comment create support for mysql	8 yıl önce
driver.go	a2e615076f 初始化	10 yıl önce
error.go	0911afc633 serious extends bug fixed & correct logger file path	10 yıl önce
filter.go	a2e615076f 初始化	10 yıl önce
ilogger.go	0911afc633 serious extends bug fixed & correct logger file path	10 yıl önce
index.go	a2e615076f 初始化	10 yıl önce
mapper.go	a2e615076f 初始化	10 yıl önce
mapper_test.go	a2e615076f 初始化	10 yıl önce
pk.go	a2e615076f 初始化	10 yıl önce
pk_test.go	a2e615076f 初始化	10 yıl önce
rows.go	2750e9842a add ToMapString method for rows and row	9 yıl önce
table.go	1c7322c734 column,table实体添加注释属性	8 yıl önce
type.go	608c49847e Add support for jsonb	9 yıl önce

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