session.go 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808
  1. // Copyright 2015 The Xorm Authors. All rights reserved.
  2. // Use of this source code is governed by a BSD-style
  3. // license that can be found in the LICENSE file.
  4. package xorm
  5. import (
  6. "database/sql"
  7. "encoding/json"
  8. "errors"
  9. "fmt"
  10. "hash/crc32"
  11. "reflect"
  12. "strings"
  13. "time"
  14. "github.com/xormplus/core"
  15. )
  16. // Session keep a pointer to sql.DB and provides all execution of all
  17. // kind of database operations.
  18. type Session struct {
  19. db *core.DB
  20. Engine *Engine
  21. Tx *core.Tx
  22. Statement Statement
  23. currentTransaction *Transaction
  24. IsAutoCommit bool
  25. IsCommitedOrRollbacked bool
  26. IsSqlFunc bool
  27. IsAutoClose bool
  28. // Automatically reset the statement after operations that execute a SQL
  29. // query such as Count(), Find(), Get(), ...
  30. AutoResetStatement bool
  31. // !nashtsai! storing these beans due to yet committed tx
  32. afterInsertBeans map[interface{}]*[]func(interface{})
  33. afterUpdateBeans map[interface{}]*[]func(interface{})
  34. afterDeleteBeans map[interface{}]*[]func(interface{})
  35. // --
  36. beforeClosures []func(interface{})
  37. afterClosures []func(interface{})
  38. prepareStmt bool
  39. stmtCache map[uint32]*core.Stmt //key: hash.Hash32 of (queryStr, len(queryStr))
  40. // !evalphobia! stored the last executed query on this session
  41. //beforeSQLExec func(string, ...interface{})
  42. lastSQL string
  43. lastSQLArgs []interface{}
  44. rollbackSavePointID string
  45. err error
  46. }
  47. // Clone copy all the session's content and return a new session.
  48. func (session *Session) Clone() *Session {
  49. var sess = *session
  50. return &sess
  51. }
  52. // Init reset the session as the init status.
  53. func (session *Session) Init() {
  54. session.Statement.Init()
  55. session.Statement.Engine = session.Engine
  56. session.IsAutoCommit = true
  57. session.IsCommitedOrRollbacked = false
  58. session.IsAutoClose = false
  59. session.IsSqlFunc = false
  60. session.AutoResetStatement = true
  61. session.prepareStmt = false
  62. // !nashtsai! is lazy init better?
  63. session.afterInsertBeans = make(map[interface{}]*[]func(interface{}), 0)
  64. session.afterUpdateBeans = make(map[interface{}]*[]func(interface{}), 0)
  65. session.afterDeleteBeans = make(map[interface{}]*[]func(interface{}), 0)
  66. session.beforeClosures = make([]func(interface{}), 0)
  67. session.afterClosures = make([]func(interface{}), 0)
  68. session.lastSQL = ""
  69. session.lastSQLArgs = []interface{}{}
  70. }
  71. // Close release the connection from pool
  72. func (session *Session) Close() {
  73. for _, v := range session.stmtCache {
  74. v.Close()
  75. }
  76. if session.db != nil {
  77. // When Close be called, if session is a transaction and do not call
  78. // Commit or Rollback, then call Rollback.
  79. if session.Tx != nil && !session.IsCommitedOrRollbacked {
  80. session.Rollback()
  81. }
  82. session.Tx = nil
  83. session.stmtCache = nil
  84. session.Init()
  85. session.db = nil
  86. }
  87. }
  88. func (session *Session) resetStatement() {
  89. if session.AutoResetStatement {
  90. session.Statement.Init()
  91. }
  92. session.IsSqlFunc = false
  93. }
  94. // Prepare set a flag to session that should be prepare statment before execute query
  95. func (session *Session) Prepare() *Session {
  96. session.prepareStmt = true
  97. return session
  98. }
  99. // Before Apply before Processor, affected bean is passed to closure arg
  100. func (session *Session) Before(closures func(interface{})) *Session {
  101. if closures != nil {
  102. session.beforeClosures = append(session.beforeClosures, closures)
  103. }
  104. return session
  105. }
  106. // After Apply after Processor, affected bean is passed to closure arg
  107. func (session *Session) After(closures func(interface{})) *Session {
  108. if closures != nil {
  109. session.afterClosures = append(session.afterClosures, closures)
  110. }
  111. return session
  112. }
  113. // Table can input a string or pointer to struct for special a table to operate.
  114. func (session *Session) Table(tableNameOrBean interface{}) *Session {
  115. session.Statement.Table(tableNameOrBean)
  116. return session
  117. }
  118. // Alias set the table alias
  119. func (session *Session) Alias(alias string) *Session {
  120. session.Statement.Alias(alias)
  121. return session
  122. }
  123. // NoCascade indicate that no cascade load child object
  124. func (session *Session) NoCascade() *Session {
  125. session.Statement.UseCascade = false
  126. return session
  127. }
  128. // ForUpdate Set Read/Write locking for UPDATE
  129. func (session *Session) ForUpdate() *Session {
  130. session.Statement.IsForUpdate = true
  131. return session
  132. }
  133. // NoAutoCondition disable generate SQL condition from beans
  134. func (session *Session) NoAutoCondition(no ...bool) *Session {
  135. session.Statement.NoAutoCondition(no...)
  136. return session
  137. }
  138. // Limit provide limit and offset query condition
  139. func (session *Session) Limit(limit int, start ...int) *Session {
  140. session.Statement.Limit(limit, start...)
  141. return session
  142. }
  143. // OrderBy provide order by query condition, the input parameter is the content
  144. // after order by on a sql statement.
  145. func (session *Session) OrderBy(order string) *Session {
  146. session.Statement.OrderBy(order)
  147. return session
  148. }
  149. // Desc provide desc order by query condition, the input parameters are columns.
  150. func (session *Session) Desc(colNames ...string) *Session {
  151. session.Statement.Desc(colNames...)
  152. return session
  153. }
  154. // Asc provide asc order by query condition, the input parameters are columns.
  155. func (session *Session) Asc(colNames ...string) *Session {
  156. session.Statement.Asc(colNames...)
  157. return session
  158. }
  159. // StoreEngine is only avialble mysql dialect currently
  160. func (session *Session) StoreEngine(storeEngine string) *Session {
  161. session.Statement.StoreEngine = storeEngine
  162. return session
  163. }
  164. // Charset is only avialble mysql dialect currently
  165. func (session *Session) Charset(charset string) *Session {
  166. session.Statement.Charset = charset
  167. return session
  168. }
  169. // Cascade indicates if loading sub Struct
  170. func (session *Session) Cascade(trueOrFalse ...bool) *Session {
  171. if len(trueOrFalse) >= 1 {
  172. session.Statement.UseCascade = trueOrFalse[0]
  173. }
  174. return session
  175. }
  176. // NoCache ask this session do not retrieve data from cache system and
  177. // get data from database directly.
  178. func (session *Session) NoCache() *Session {
  179. session.Statement.UseCache = false
  180. return session
  181. }
  182. // Join join_operator should be one of INNER, LEFT OUTER, CROSS etc - this will be prepended to JOIN
  183. func (session *Session) Join(joinOperator string, tablename interface{}, condition string, args ...interface{}) *Session {
  184. session.Statement.Join(joinOperator, tablename, condition, args...)
  185. return session
  186. }
  187. // GroupBy Generate Group By statement
  188. func (session *Session) GroupBy(keys string) *Session {
  189. session.Statement.GroupBy(keys)
  190. return session
  191. }
  192. // Having Generate Having statement
  193. func (session *Session) Having(conditions string) *Session {
  194. session.Statement.Having(conditions)
  195. return session
  196. }
  197. // DB db return the wrapper of sql.DB
  198. func (session *Session) DB() *core.DB {
  199. if session.db == nil {
  200. session.db = session.Engine.db
  201. session.stmtCache = make(map[uint32]*core.Stmt, 0)
  202. }
  203. return session.db
  204. }
  205. func cleanupProcessorsClosures(slices *[]func(interface{})) {
  206. if len(*slices) > 0 {
  207. *slices = make([]func(interface{}), 0)
  208. }
  209. }
  210. func (session *Session) canCache() bool {
  211. if session.Statement.RefTable == nil ||
  212. session.Statement.JoinStr != "" ||
  213. session.Statement.RawSQL != "" ||
  214. !session.Statement.UseCache ||
  215. session.Statement.IsForUpdate ||
  216. session.Tx != nil ||
  217. len(session.Statement.selectStr) > 0 {
  218. return false
  219. }
  220. return true
  221. }
  222. func (session *Session) doPrepare(sqlStr string) (stmt *core.Stmt, err error) {
  223. crc := crc32.ChecksumIEEE([]byte(sqlStr))
  224. // TODO try hash(sqlStr+len(sqlStr))
  225. var has bool
  226. stmt, has = session.stmtCache[crc]
  227. if !has {
  228. stmt, err = session.DB().Prepare(sqlStr)
  229. if err != nil {
  230. return nil, err
  231. }
  232. session.stmtCache[crc] = stmt
  233. }
  234. return
  235. }
  236. func (session *Session) getField(dataStruct *reflect.Value, key string, table *core.Table, idx int) *reflect.Value {
  237. var col *core.Column
  238. if col = table.GetColumnIdx(key, idx); col == nil {
  239. //session.Engine.logger.Warnf("table %v has no column %v. %v", table.Name, key, table.ColumnsSeq())
  240. return nil
  241. }
  242. fieldValue, err := col.ValueOfV(dataStruct)
  243. if err != nil {
  244. session.Engine.logger.Error(err)
  245. return nil
  246. }
  247. if !fieldValue.IsValid() || !fieldValue.CanSet() {
  248. session.Engine.logger.Warnf("table %v's column %v is not valid or cannot set", table.Name, key)
  249. return nil
  250. }
  251. return fieldValue
  252. }
  253. // Cell cell is a result of one column field
  254. type Cell *interface{}
  255. func (session *Session) rows2Beans(rows *core.Rows, fields []string, fieldsCount int,
  256. table *core.Table, newElemFunc func([]string) reflect.Value,
  257. sliceValueSetFunc func(*reflect.Value, core.PK) error) error {
  258. for rows.Next() {
  259. var newValue = newElemFunc(fields)
  260. bean := newValue.Interface()
  261. dataStruct := rValue(bean)
  262. pk, err := session.row2Bean(rows, fields, fieldsCount, bean, &dataStruct, table)
  263. if err != nil {
  264. return err
  265. }
  266. err = sliceValueSetFunc(&newValue, pk)
  267. if err != nil {
  268. return err
  269. }
  270. }
  271. return nil
  272. }
  273. func (session *Session) row2Bean(rows *core.Rows, fields []string, fieldsCount int, bean interface{}, dataStruct *reflect.Value, table *core.Table) (core.PK, error) {
  274. // handle beforeClosures
  275. for _, closure := range session.beforeClosures {
  276. closure(bean)
  277. }
  278. scanResults := make([]interface{}, fieldsCount)
  279. for i := 0; i < len(fields); i++ {
  280. var cell interface{}
  281. scanResults[i] = &cell
  282. }
  283. if err := rows.Scan(scanResults...); err != nil {
  284. return nil, err
  285. }
  286. if b, hasBeforeSet := bean.(BeforeSetProcessor); hasBeforeSet {
  287. for ii, key := range fields {
  288. b.BeforeSet(key, Cell(scanResults[ii].(*interface{})))
  289. }
  290. }
  291. defer func() {
  292. if b, hasAfterSet := bean.(AfterSetProcessor); hasAfterSet {
  293. for ii, key := range fields {
  294. b.AfterSet(key, Cell(scanResults[ii].(*interface{})))
  295. }
  296. }
  297. // handle afterClosures
  298. for _, closure := range session.afterClosures {
  299. closure(bean)
  300. }
  301. }()
  302. var tempMap = make(map[string]int)
  303. var pk core.PK
  304. for ii, key := range fields {
  305. var idx int
  306. var ok bool
  307. var lKey = strings.ToLower(key)
  308. if idx, ok = tempMap[lKey]; !ok {
  309. idx = 0
  310. } else {
  311. idx = idx + 1
  312. }
  313. tempMap[lKey] = idx
  314. if fieldValue := session.getField(dataStruct, key, table, idx); fieldValue != nil {
  315. rawValue := reflect.Indirect(reflect.ValueOf(scanResults[ii]))
  316. // if row is null then ignore
  317. if rawValue.Interface() == nil {
  318. continue
  319. }
  320. if fieldValue.CanAddr() {
  321. if structConvert, ok := fieldValue.Addr().Interface().(core.Conversion); ok {
  322. if data, err := value2Bytes(&rawValue); err == nil {
  323. if err := structConvert.FromDB(data); err != nil {
  324. return nil, err
  325. }
  326. } else {
  327. return nil, err
  328. }
  329. continue
  330. }
  331. }
  332. if _, ok := fieldValue.Interface().(core.Conversion); ok {
  333. if data, err := value2Bytes(&rawValue); err == nil {
  334. if fieldValue.Kind() == reflect.Ptr && fieldValue.IsNil() {
  335. fieldValue.Set(reflect.New(fieldValue.Type().Elem()))
  336. }
  337. fieldValue.Interface().(core.Conversion).FromDB(data)
  338. } else {
  339. return nil, err
  340. }
  341. continue
  342. }
  343. rawValueType := reflect.TypeOf(rawValue.Interface())
  344. vv := reflect.ValueOf(rawValue.Interface())
  345. col := table.GetColumnIdx(key, idx)
  346. if col.IsPrimaryKey {
  347. pk = append(pk, rawValue.Interface())
  348. }
  349. fieldType := fieldValue.Type()
  350. hasAssigned := false
  351. if col.SQLType.IsJson() {
  352. var bs []byte
  353. if rawValueType.Kind() == reflect.String {
  354. bs = []byte(vv.String())
  355. } else if rawValueType.ConvertibleTo(core.BytesType) {
  356. bs = vv.Bytes()
  357. } else {
  358. return nil, fmt.Errorf("unsupported database data type: %s %v", key, rawValueType.Kind())
  359. }
  360. hasAssigned = true
  361. if len(bs) > 0 {
  362. if fieldValue.CanAddr() {
  363. err := json.Unmarshal(bs, fieldValue.Addr().Interface())
  364. if err != nil {
  365. return nil, err
  366. }
  367. } else {
  368. x := reflect.New(fieldType)
  369. err := json.Unmarshal(bs, x.Interface())
  370. if err != nil {
  371. return nil, err
  372. }
  373. fieldValue.Set(x.Elem())
  374. }
  375. }
  376. continue
  377. }
  378. switch fieldType.Kind() {
  379. case reflect.Complex64, reflect.Complex128:
  380. // TODO: reimplement this
  381. var bs []byte
  382. if rawValueType.Kind() == reflect.String {
  383. bs = []byte(vv.String())
  384. } else if rawValueType.ConvertibleTo(core.BytesType) {
  385. bs = vv.Bytes()
  386. }
  387. hasAssigned = true
  388. if len(bs) > 0 {
  389. if fieldValue.CanAddr() {
  390. err := json.Unmarshal(bs, fieldValue.Addr().Interface())
  391. if err != nil {
  392. return nil, err
  393. }
  394. } else {
  395. x := reflect.New(fieldType)
  396. err := json.Unmarshal(bs, x.Interface())
  397. if err != nil {
  398. return nil, err
  399. }
  400. fieldValue.Set(x.Elem())
  401. }
  402. }
  403. case reflect.Slice, reflect.Array:
  404. switch rawValueType.Kind() {
  405. case reflect.Slice, reflect.Array:
  406. switch rawValueType.Elem().Kind() {
  407. case reflect.Uint8:
  408. if fieldType.Elem().Kind() == reflect.Uint8 {
  409. hasAssigned = true
  410. if col.SQLType.IsText() {
  411. x := reflect.New(fieldType)
  412. err := json.Unmarshal(vv.Bytes(), x.Interface())
  413. if err != nil {
  414. return nil, err
  415. }
  416. fieldValue.Set(x.Elem())
  417. } else {
  418. if fieldValue.Len() > 0 {
  419. for i := 0; i < fieldValue.Len(); i++ {
  420. if i < vv.Len() {
  421. fieldValue.Index(i).Set(vv.Index(i))
  422. }
  423. }
  424. } else {
  425. for i := 0; i < vv.Len(); i++ {
  426. fieldValue.Set(reflect.Append(*fieldValue, vv.Index(i)))
  427. }
  428. }
  429. }
  430. }
  431. }
  432. }
  433. case reflect.String:
  434. if rawValueType.Kind() == reflect.String {
  435. hasAssigned = true
  436. fieldValue.SetString(vv.String())
  437. }
  438. case reflect.Bool:
  439. if rawValueType.Kind() == reflect.Bool {
  440. hasAssigned = true
  441. fieldValue.SetBool(vv.Bool())
  442. }
  443. case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
  444. switch rawValueType.Kind() {
  445. case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
  446. hasAssigned = true
  447. fieldValue.SetInt(vv.Int())
  448. }
  449. case reflect.Float32, reflect.Float64:
  450. switch rawValueType.Kind() {
  451. case reflect.Float32, reflect.Float64:
  452. hasAssigned = true
  453. fieldValue.SetFloat(vv.Float())
  454. }
  455. case reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64, reflect.Uint:
  456. switch rawValueType.Kind() {
  457. case reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64, reflect.Uint:
  458. hasAssigned = true
  459. fieldValue.SetUint(vv.Uint())
  460. case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
  461. hasAssigned = true
  462. fieldValue.SetUint(uint64(vv.Int()))
  463. }
  464. case reflect.Struct:
  465. if fieldType.ConvertibleTo(core.TimeType) {
  466. dbTZ := session.Engine.DatabaseTZ
  467. if col.TimeZone != nil {
  468. dbTZ = col.TimeZone
  469. }
  470. if rawValueType == core.TimeType {
  471. hasAssigned = true
  472. t := vv.Convert(core.TimeType).Interface().(time.Time)
  473. z, _ := t.Zone()
  474. // set new location if database don't save timezone or give an incorrect timezone
  475. if len(z) == 0 || t.Year() == 0 || t.Location().String() != dbTZ.String() { // !nashtsai! HACK tmp work around for lib/pq doesn't properly time with location
  476. session.Engine.logger.Debugf("empty zone key[%v] : %v | zone: %v | location: %+v\n", key, t, z, *t.Location())
  477. t = time.Date(t.Year(), t.Month(), t.Day(), t.Hour(),
  478. t.Minute(), t.Second(), t.Nanosecond(), dbTZ)
  479. }
  480. t = t.In(session.Engine.TZLocation)
  481. fieldValue.Set(reflect.ValueOf(t).Convert(fieldType))
  482. } else if rawValueType == core.IntType || rawValueType == core.Int64Type ||
  483. rawValueType == core.Int32Type {
  484. hasAssigned = true
  485. t := time.Unix(vv.Int(), 0).In(session.Engine.TZLocation)
  486. fieldValue.Set(reflect.ValueOf(t).Convert(fieldType))
  487. } else {
  488. if d, ok := vv.Interface().([]uint8); ok {
  489. hasAssigned = true
  490. t, err := session.byte2Time(col, d)
  491. if err != nil {
  492. session.Engine.logger.Error("byte2Time error:", err.Error())
  493. hasAssigned = false
  494. } else {
  495. fieldValue.Set(reflect.ValueOf(t).Convert(fieldType))
  496. }
  497. } else if d, ok := vv.Interface().(string); ok {
  498. hasAssigned = true
  499. t, err := session.str2Time(col, d)
  500. if err != nil {
  501. session.Engine.logger.Error("byte2Time error:", err.Error())
  502. hasAssigned = false
  503. } else {
  504. fieldValue.Set(reflect.ValueOf(t).Convert(fieldType))
  505. }
  506. } else {
  507. return nil, fmt.Errorf("rawValueType is %v, value is %v", rawValueType, vv.Interface())
  508. }
  509. }
  510. } else if nulVal, ok := fieldValue.Addr().Interface().(sql.Scanner); ok {
  511. // !<winxxp>! 增加支持sql.Scanner接口的结构,如sql.NullString
  512. hasAssigned = true
  513. if err := nulVal.Scan(vv.Interface()); err != nil {
  514. session.Engine.logger.Error("sql.Sanner error:", err.Error())
  515. hasAssigned = false
  516. }
  517. } else if col.SQLType.IsJson() {
  518. if rawValueType.Kind() == reflect.String {
  519. hasAssigned = true
  520. x := reflect.New(fieldType)
  521. if len([]byte(vv.String())) > 0 {
  522. err := json.Unmarshal([]byte(vv.String()), x.Interface())
  523. if err != nil {
  524. return nil, err
  525. }
  526. fieldValue.Set(x.Elem())
  527. }
  528. } else if rawValueType.Kind() == reflect.Slice {
  529. hasAssigned = true
  530. x := reflect.New(fieldType)
  531. if len(vv.Bytes()) > 0 {
  532. err := json.Unmarshal(vv.Bytes(), x.Interface())
  533. if err != nil {
  534. return nil, err
  535. }
  536. fieldValue.Set(x.Elem())
  537. }
  538. }
  539. } else if session.Statement.UseCascade {
  540. table, err := session.Engine.autoMapType(*fieldValue)
  541. if err != nil {
  542. return nil, err
  543. }
  544. hasAssigned = true
  545. if len(table.PrimaryKeys) != 1 {
  546. return nil, errors.New("unsupported non or composited primary key cascade")
  547. }
  548. var pk = make(core.PK, len(table.PrimaryKeys))
  549. pk[0], err = asKind(vv, rawValueType)
  550. if err != nil {
  551. return nil, err
  552. }
  553. if !isPKZero(pk) {
  554. // !nashtsai! TODO for hasOne relationship, it's preferred to use join query for eager fetch
  555. // however, also need to consider adding a 'lazy' attribute to xorm tag which allow hasOne
  556. // property to be fetched lazily
  557. structInter := reflect.New(fieldValue.Type())
  558. newsession := session.Engine.NewSession()
  559. defer newsession.Close()
  560. has, err := newsession.ID(pk).NoCascade().Get(structInter.Interface())
  561. if err != nil {
  562. return nil, err
  563. }
  564. if has {
  565. fieldValue.Set(structInter.Elem())
  566. } else {
  567. return nil, errors.New("cascade obj is not exist")
  568. }
  569. }
  570. }
  571. case reflect.Ptr:
  572. // !nashtsai! TODO merge duplicated codes above
  573. switch fieldType {
  574. // following types case matching ptr's native type, therefore assign ptr directly
  575. case core.PtrStringType:
  576. if rawValueType.Kind() == reflect.String {
  577. x := vv.String()
  578. hasAssigned = true
  579. fieldValue.Set(reflect.ValueOf(&x))
  580. }
  581. case core.PtrBoolType:
  582. if rawValueType.Kind() == reflect.Bool {
  583. x := vv.Bool()
  584. hasAssigned = true
  585. fieldValue.Set(reflect.ValueOf(&x))
  586. }
  587. case core.PtrTimeType:
  588. if rawValueType == core.PtrTimeType {
  589. hasAssigned = true
  590. var x = rawValue.Interface().(time.Time)
  591. fieldValue.Set(reflect.ValueOf(&x))
  592. }
  593. case core.PtrFloat64Type:
  594. if rawValueType.Kind() == reflect.Float64 {
  595. x := vv.Float()
  596. hasAssigned = true
  597. fieldValue.Set(reflect.ValueOf(&x))
  598. }
  599. case core.PtrUint64Type:
  600. if rawValueType.Kind() == reflect.Int64 {
  601. var x = uint64(vv.Int())
  602. hasAssigned = true
  603. fieldValue.Set(reflect.ValueOf(&x))
  604. }
  605. case core.PtrInt64Type:
  606. if rawValueType.Kind() == reflect.Int64 {
  607. x := vv.Int()
  608. hasAssigned = true
  609. fieldValue.Set(reflect.ValueOf(&x))
  610. }
  611. case core.PtrFloat32Type:
  612. if rawValueType.Kind() == reflect.Float64 {
  613. var x = float32(vv.Float())
  614. hasAssigned = true
  615. fieldValue.Set(reflect.ValueOf(&x))
  616. }
  617. case core.PtrIntType:
  618. if rawValueType.Kind() == reflect.Int64 {
  619. var x = int(vv.Int())
  620. hasAssigned = true
  621. fieldValue.Set(reflect.ValueOf(&x))
  622. }
  623. case core.PtrInt32Type:
  624. if rawValueType.Kind() == reflect.Int64 {
  625. var x = int32(vv.Int())
  626. hasAssigned = true
  627. fieldValue.Set(reflect.ValueOf(&x))
  628. }
  629. case core.PtrInt8Type:
  630. if rawValueType.Kind() == reflect.Int64 {
  631. var x = int8(vv.Int())
  632. hasAssigned = true
  633. fieldValue.Set(reflect.ValueOf(&x))
  634. }
  635. case core.PtrInt16Type:
  636. if rawValueType.Kind() == reflect.Int64 {
  637. var x = int16(vv.Int())
  638. hasAssigned = true
  639. fieldValue.Set(reflect.ValueOf(&x))
  640. }
  641. case core.PtrUintType:
  642. if rawValueType.Kind() == reflect.Int64 {
  643. var x = uint(vv.Int())
  644. hasAssigned = true
  645. fieldValue.Set(reflect.ValueOf(&x))
  646. }
  647. case core.PtrUint32Type:
  648. if rawValueType.Kind() == reflect.Int64 {
  649. var x = uint32(vv.Int())
  650. hasAssigned = true
  651. fieldValue.Set(reflect.ValueOf(&x))
  652. }
  653. case core.Uint8Type:
  654. if rawValueType.Kind() == reflect.Int64 {
  655. var x = uint8(vv.Int())
  656. hasAssigned = true
  657. fieldValue.Set(reflect.ValueOf(&x))
  658. }
  659. case core.Uint16Type:
  660. if rawValueType.Kind() == reflect.Int64 {
  661. var x = uint16(vv.Int())
  662. hasAssigned = true
  663. fieldValue.Set(reflect.ValueOf(&x))
  664. }
  665. case core.Complex64Type:
  666. var x complex64
  667. if len([]byte(vv.String())) > 0 {
  668. err := json.Unmarshal([]byte(vv.String()), &x)
  669. if err != nil {
  670. return nil, err
  671. }
  672. fieldValue.Set(reflect.ValueOf(&x))
  673. }
  674. hasAssigned = true
  675. case core.Complex128Type:
  676. var x complex128
  677. if len([]byte(vv.String())) > 0 {
  678. err := json.Unmarshal([]byte(vv.String()), &x)
  679. if err != nil {
  680. return nil, err
  681. }
  682. fieldValue.Set(reflect.ValueOf(&x))
  683. }
  684. hasAssigned = true
  685. } // switch fieldType
  686. } // switch fieldType.Kind()
  687. // !nashtsai! for value can't be assigned directly fallback to convert to []byte then back to value
  688. if !hasAssigned {
  689. data, err := value2Bytes(&rawValue)
  690. if err != nil {
  691. return nil, err
  692. }
  693. if err = session.bytes2Value(col, fieldValue, data); err != nil {
  694. return nil, err
  695. }
  696. }
  697. }
  698. }
  699. return pk, nil
  700. }
  701. func (session *Session) queryPreprocess(sqlStr *string, paramStr ...interface{}) {
  702. for _, filter := range session.Engine.dialect.Filters() {
  703. *sqlStr = filter.Do(*sqlStr, session.Engine.dialect, session.Statement.RefTable)
  704. }
  705. session.saveLastSQL(*sqlStr, paramStr...)
  706. }
  707. // saveLastSQL stores executed query information
  708. func (session *Session) saveLastSQL(sql string, args ...interface{}) {
  709. session.lastSQL = sql
  710. session.lastSQLArgs = args
  711. session.Engine.logSQL(sql, args...)
  712. }
  713. // LastSQL returns last query information
  714. func (session *Session) LastSQL() (string, []interface{}) {
  715. return session.lastSQL, session.lastSQLArgs
  716. }
  717. // tbName get some table's table name
  718. func (session *Session) tbNameNoSchema(table *core.Table) string {
  719. if len(session.Statement.AltTableName) > 0 {
  720. return session.Statement.AltTableName
  721. }
  722. return table.Name
  723. }
  724. // Unscoped always disable struct tag "deleted"
  725. func (session *Session) Unscoped() *Session {
  726. session.Statement.Unscoped()
  727. return session
  728. }