session.go 23 KB

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