Žiadny popis

1 Vetvy

xormplus 6c9027d91e fix schema for postgres		7 rokov pred
.gitignore	9962f563c4 Initial commit	10 rokov pred
LICENSE	9962f563c4 Initial commit	10 rokov pred
README.md	a2e615076f 初始化	10 rokov pred
benchmark.sh	a2e615076f 初始化	10 rokov pred
cache.go	99d20b5b6b small refactor	8 rokov pred
column.go	0f69a142b3 fix: oracle default key in xorm tag error	8 rokov pred
config	a2e615076f 初始化	10 rokov pred
converstion.go	a2e615076f 初始化	10 rokov pred
db.go	44ee0d00dc fix scanmap	7 rokov pred
db_test.go	c5b6cd8dd2 fix Scan NullTime type failed at sqlite3	8 rokov pred
description	a2e615076f 初始化	10 rokov pred
dialect.go	6c9027d91e fix schema for postgres	7 rokov pred
driver.go	a2e615076f 初始化	10 rokov pred
error.go	0911afc633 serious extends bug fixed & correct logger file path	9 rokov pred
filter.go	6c9027d91e fix schema for postgres	7 rokov pred
ilogger.go	0911afc633 serious extends bug fixed & correct logger file path	9 rokov pred
index.go	6c9027d91e fix schema for postgres	7 rokov pred
mapper.go	a2e615076f 初始化	10 rokov pred
mapper_test.go	a2e615076f 初始化	10 rokov pred
pk.go	a2e615076f 初始化	10 rokov pred
pk_test.go	c5b6cd8dd2 fix Scan NullTime type failed at sqlite3	8 rokov pred
rows.go	44ee0d00dc fix scanmap	7 rokov pred
scan.go	c5b6cd8dd2 fix Scan NullTime type failed at sqlite3	8 rokov pred
table.go	1c7322c734 column,table实体添加注释属性	8 rokov pred
type.go	de46191760 add SYSNAME type for supporting mssql's in-built sysdiagrams	8 rokov pred

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