aboutsummaryrefslogtreecommitdiff
path: root/vendor/github.com/go-xorm/xorm/session_get.go
diff options
context:
space:
mode:
authorUnknwon <u@gogs.io>2018-03-09 00:26:47 -0500
committerUnknwon <u@gogs.io>2018-03-09 00:26:47 -0500
commit28f74cf1c67cde80ae453a799d76752114fd5e18 (patch)
tree72b160aef0810492e257c2707884bb3052e1ba51 /vendor/github.com/go-xorm/xorm/session_get.go
parent83655d5c00110044a4ac9bf46ec039379eded5dd (diff)
vendor: update github.com/go-xorm/xorm (#4913)
Diffstat (limited to 'vendor/github.com/go-xorm/xorm/session_get.go')
-rw-r--r--vendor/github.com/go-xorm/xorm/session_get.go138
1 files changed, 79 insertions, 59 deletions
diff --git a/vendor/github.com/go-xorm/xorm/session_get.go b/vendor/github.com/go-xorm/xorm/session_get.go
index c7c03d90..68b37af7 100644
--- a/vendor/github.com/go-xorm/xorm/session_get.go
+++ b/vendor/github.com/go-xorm/xorm/session_get.go
@@ -5,6 +5,7 @@
package xorm
import (
+ "database/sql"
"errors"
"reflect"
"strconv"
@@ -15,39 +16,49 @@ import (
// Get retrieve one record from database, bean's non-empty fields
// will be as conditions
func (session *Session) Get(bean interface{}) (bool, error) {
- defer session.resetStatement()
- if session.IsAutoClose {
+ if session.isAutoClose {
defer session.Close()
}
+ return session.get(bean)
+}
+func (session *Session) get(bean interface{}) (bool, error) {
beanValue := reflect.ValueOf(bean)
if beanValue.Kind() != reflect.Ptr {
- return false, errors.New("needs a pointer")
+ return false, errors.New("needs a pointer to a value")
+ } else if beanValue.Elem().Kind() == reflect.Ptr {
+ return false, errors.New("a pointer to a pointer is not allowed")
}
if beanValue.Elem().Kind() == reflect.Struct {
- if err := session.Statement.setRefValue(beanValue.Elem()); err != nil {
+ if err := session.statement.setRefValue(beanValue.Elem()); err != nil {
return false, err
}
}
var sqlStr string
var args []interface{}
+ var err error
- if session.Statement.RawSQL == "" {
- if len(session.Statement.TableName()) <= 0 {
+ if session.statement.RawSQL == "" {
+ if len(session.statement.TableName()) <= 0 {
return false, ErrTableNotFound
}
- session.Statement.Limit(1)
- sqlStr, args = session.Statement.genGetSQL(bean)
+ session.statement.Limit(1)
+ sqlStr, args, err = session.statement.genGetSQL(bean)
+ if err != nil {
+ return false, err
+ }
} else {
- sqlStr = session.Statement.RawSQL
- args = session.Statement.RawParams
+ sqlStr = session.statement.RawSQL
+ args = session.statement.RawParams
}
+ table := session.statement.RefTable
+
if session.canCache() && beanValue.Elem().Kind() == reflect.Struct {
- if cacher := session.Engine.getCacher2(session.Statement.RefTable); cacher != nil &&
- !session.Statement.unscoped {
+ if cacher := session.engine.getCacher2(table); cacher != nil &&
+ !session.statement.unscoped {
has, err := session.cacheGet(bean, sqlStr, args...)
if err != ErrCacheFailed {
return has, err
@@ -55,49 +66,58 @@ func (session *Session) Get(bean interface{}) (bool, error) {
}
}
- return session.nocacheGet(beanValue.Elem().Kind(), bean, sqlStr, args...)
+ return session.nocacheGet(beanValue.Elem().Kind(), table, bean, sqlStr, args...)
}
-func (session *Session) nocacheGet(beanKind reflect.Kind, bean interface{}, sqlStr string, args ...interface{}) (bool, error) {
- session.queryPreprocess(&sqlStr, args...)
-
- var rawRows *core.Rows
- var err error
- if session.IsAutoCommit {
- _, rawRows, err = session.innerQuery(sqlStr, args...)
- } else {
- rawRows, err = session.Tx.Query(sqlStr, args...)
- }
+func (session *Session) nocacheGet(beanKind reflect.Kind, table *core.Table, bean interface{}, sqlStr string, args ...interface{}) (bool, error) {
+ rows, err := session.queryRows(sqlStr, args...)
if err != nil {
return false, err
}
+ defer rows.Close()
- defer rawRows.Close()
+ if !rows.Next() {
+ return false, nil
+ }
- if rawRows.Next() {
- switch beanKind {
- case reflect.Struct:
- fields, err := rawRows.Columns()
- if err != nil {
- // WARN: Alougth rawRows return true, but get fields failed
- return true, err
- }
- dataStruct := rValue(bean)
- if err := session.Statement.setRefValue(dataStruct); err != nil {
- return false, err
- }
- _, err = session.row2Bean(rawRows, fields, len(fields), bean, &dataStruct, session.Statement.RefTable)
- case reflect.Slice:
- err = rawRows.ScanSlice(bean)
- case reflect.Map:
- err = rawRows.ScanMap(bean)
- default:
- err = rawRows.Scan(bean)
+ switch bean.(type) {
+ case sql.NullInt64, sql.NullBool, sql.NullFloat64, sql.NullString:
+ return true, rows.Scan(&bean)
+ case *sql.NullInt64, *sql.NullBool, *sql.NullFloat64, *sql.NullString:
+ return true, rows.Scan(bean)
+ }
+
+ switch beanKind {
+ case reflect.Struct:
+ fields, err := rows.Columns()
+ if err != nil {
+ // WARN: Alougth rows return true, but get fields failed
+ return true, err
}
- return true, err
+ scanResults, err := session.row2Slice(rows, fields, bean)
+ if err != nil {
+ return false, err
+ }
+ // close it before covert data
+ rows.Close()
+
+ dataStruct := rValue(bean)
+ _, err = session.slice2Bean(scanResults, fields, bean, &dataStruct, table)
+ if err != nil {
+ return true, err
+ }
+
+ return true, session.executeProcessors()
+ case reflect.Slice:
+ err = rows.ScanSlice(bean)
+ case reflect.Map:
+ err = rows.ScanMap(bean)
+ default:
+ err = rows.Scan(bean)
}
- return false, nil
+
+ return true, err
}
func (session *Session) cacheGet(bean interface{}, sqlStr string, args ...interface{}) (has bool, err error) {
@@ -106,22 +126,22 @@ func (session *Session) cacheGet(bean interface{}, sqlStr string, args ...interf
return false, ErrCacheFailed
}
- for _, filter := range session.Engine.dialect.Filters() {
- sqlStr = filter.Do(sqlStr, session.Engine.dialect, session.Statement.RefTable)
+ for _, filter := range session.engine.dialect.Filters() {
+ sqlStr = filter.Do(sqlStr, session.engine.dialect, session.statement.RefTable)
}
- newsql := session.Statement.convertIDSQL(sqlStr)
+ newsql := session.statement.convertIDSQL(sqlStr)
if newsql == "" {
return false, ErrCacheFailed
}
- cacher := session.Engine.getCacher2(session.Statement.RefTable)
- tableName := session.Statement.TableName()
- session.Engine.logger.Debug("[cacheGet] find sql:", newsql, args)
+ cacher := session.engine.getCacher2(session.statement.RefTable)
+ tableName := session.statement.TableName()
+ session.engine.logger.Debug("[cacheGet] find sql:", newsql, args)
+ table := session.statement.RefTable
ids, err := core.GetCacheSql(cacher, tableName, newsql, args)
- table := session.Statement.RefTable
if err != nil {
var res = make([]string, len(table.PrimaryKeys))
- rows, err := session.DB().Query(newsql, args...)
+ rows, err := session.NoCache().queryRows(newsql, args...)
if err != nil {
return false, err
}
@@ -152,19 +172,19 @@ func (session *Session) cacheGet(bean interface{}, sqlStr string, args ...interf
}
ids = []core.PK{pk}
- session.Engine.logger.Debug("[cacheGet] cache ids:", newsql, ids)
+ session.engine.logger.Debug("[cacheGet] cache ids:", newsql, ids)
err = core.PutCacheSql(cacher, ids, tableName, newsql, args)
if err != nil {
return false, err
}
} else {
- session.Engine.logger.Debug("[cacheGet] cache hit sql:", newsql)
+ session.engine.logger.Debug("[cacheGet] cache hit sql:", newsql, ids)
}
if len(ids) > 0 {
structValue := reflect.Indirect(reflect.ValueOf(bean))
id := ids[0]
- session.Engine.logger.Debug("[cacheGet] get bean:", tableName, id)
+ session.engine.logger.Debug("[cacheGet] get bean:", tableName, id)
sid, err := id.ToString()
if err != nil {
return false, err
@@ -172,15 +192,15 @@ func (session *Session) cacheGet(bean interface{}, sqlStr string, args ...interf
cacheBean := cacher.GetBean(tableName, sid)
if cacheBean == nil {
cacheBean = bean
- has, err = session.nocacheGet(reflect.Struct, cacheBean, sqlStr, args...)
+ has, err = session.nocacheGet(reflect.Struct, table, cacheBean, sqlStr, args...)
if err != nil || !has {
return has, err
}
- session.Engine.logger.Debug("[cacheGet] cache bean:", tableName, id, cacheBean)
+ session.engine.logger.Debug("[cacheGet] cache bean:", tableName, id, cacheBean)
cacher.PutBean(tableName, sid, cacheBean)
} else {
- session.Engine.logger.Debug("[cacheGet] cache hit bean:", tableName, id, cacheBean)
+ session.engine.logger.Debug("[cacheGet] cache hit bean:", tableName, id, cacheBean)
has = true
}
structValue.Set(reflect.Indirect(reflect.ValueOf(cacheBean)))