Açıklama Yok

xormplus 44ee0d00dc fix scanmap 7 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 99d20b5b6b small refactor 8 yıl önce
column.go 0f69a142b3 fix: oracle default key in xorm tag error 8 yıl önce
config a2e615076f 初始化 10 yıl önce
converstion.go a2e615076f 初始化 10 yıl önce
db.go 44ee0d00dc fix scanmap 7 yıl önce
db_test.go c5b6cd8dd2 fix Scan NullTime type failed at sqlite3 8 yıl önce
description a2e615076f 初始化 10 yıl önce
dialect.go 8b546e4ead Add SetArguments(args) method for dialect_xxxxx.go support. 7 yıl önce
driver.go a2e615076f 初始化 10 yıl önce
error.go 0911afc633 serious extends bug fixed & correct logger file path 9 yıl önce
filter.go a2e615076f 初始化 10 yıl önce
ilogger.go 0911afc633 serious extends bug fixed & correct logger file path 9 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 c5b6cd8dd2 fix Scan NullTime type failed at sqlite3 8 yıl önce
rows.go 44ee0d00dc fix scanmap 7 yıl önce
scan.go c5b6cd8dd2 fix Scan NullTime type failed at sqlite3 8 yıl önce
table.go 1c7322c734 column,table实体添加注释属性 8 yıl önce
type.go de46191760 add SYSNAME type for supporting mssql's in-built sysdiagrams 7 yıl önce

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)