123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177 |
- // Copyright 2014 beego Author. All Rights Reserved.
- //
- // Licensed under the Apache License, Version 2.0 (the "License");
- // you may not use this file except in compliance with the License.
- // You may obtain a copy of the License at
- //
- // http://www.apache.org/licenses/LICENSE-2.0
- //
- // Unless required by applicable law or agreed to in writing, software
- // distributed under the License is distributed on an "AS IS" BASIS,
- // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- // See the License for the specific language governing permissions and
- // limitations under the License.
- package orm
- import (
- "fmt"
- "reflect"
- "time"
- )
- // get table alias.
- func getDbAlias(name string) *alias {
- if al, ok := dataBaseCache.get(name); ok {
- return al
- }
- panic(fmt.Errorf("unknown DataBase alias name %s", name))
- }
- // get pk column info.
- func getExistPk(mi *modelInfo, ind reflect.Value) (column string, value interface{}, exist bool) {
- fi := mi.fields.pk
- v := ind.FieldByIndex(fi.fieldIndex)
- if fi.fieldType&IsPositiveIntegerField > 0 {
- vu := v.Uint()
- exist = vu > 0
- value = vu
- } else if fi.fieldType&IsIntegerField > 0 {
- vu := v.Int()
- exist = true
- value = vu
- } else if fi.fieldType&IsRelField > 0 {
- _, value, exist = getExistPk(fi.relModelInfo, reflect.Indirect(v))
- } else {
- vu := v.String()
- exist = vu != ""
- value = vu
- }
- column = fi.column
- return
- }
- // get fields description as flatted string.
- func getFlatParams(fi *fieldInfo, args []interface{}, tz *time.Location) (params []interface{}) {
- outFor:
- for _, arg := range args {
- val := reflect.ValueOf(arg)
- if arg == nil {
- params = append(params, arg)
- continue
- }
- kind := val.Kind()
- if kind == reflect.Ptr {
- val = val.Elem()
- kind = val.Kind()
- arg = val.Interface()
- }
- switch kind {
- case reflect.String:
- v := val.String()
- if fi != nil {
- if fi.fieldType == TypeTimeField || fi.fieldType == TypeDateField || fi.fieldType == TypeDateTimeField {
- var t time.Time
- var err error
- if len(v) >= 19 {
- s := v[:19]
- t, err = time.ParseInLocation(formatDateTime, s, DefaultTimeLoc)
- } else if len(v) >= 10 {
- s := v
- if len(v) > 10 {
- s = v[:10]
- }
- t, err = time.ParseInLocation(formatDate, s, tz)
- } else {
- s := v
- if len(s) > 8 {
- s = v[:8]
- }
- t, err = time.ParseInLocation(formatTime, s, tz)
- }
- if err == nil {
- if fi.fieldType == TypeDateField {
- v = t.In(tz).Format(formatDate)
- } else if fi.fieldType == TypeDateTimeField {
- v = t.In(tz).Format(formatDateTime)
- } else {
- v = t.In(tz).Format(formatTime)
- }
- }
- }
- }
- arg = v
- case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
- arg = val.Int()
- case reflect.Uint, reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64:
- arg = val.Uint()
- case reflect.Float32:
- arg, _ = StrTo(ToStr(arg)).Float64()
- case reflect.Float64:
- arg = val.Float()
- case reflect.Bool:
- arg = val.Bool()
- case reflect.Slice, reflect.Array:
- if _, ok := arg.([]byte); ok {
- continue outFor
- }
- var args []interface{}
- for i := 0; i < val.Len(); i++ {
- v := val.Index(i)
- var vu interface{}
- if v.CanInterface() {
- vu = v.Interface()
- }
- if vu == nil {
- continue
- }
- args = append(args, vu)
- }
- if len(args) > 0 {
- p := getFlatParams(fi, args, tz)
- params = append(params, p...)
- }
- continue outFor
- case reflect.Struct:
- if v, ok := arg.(time.Time); ok {
- if fi != nil && fi.fieldType == TypeDateField {
- arg = v.In(tz).Format(formatDate)
- } else if fi != nil && fi.fieldType == TypeDateTimeField {
- arg = v.In(tz).Format(formatDateTime)
- } else if fi != nil && fi.fieldType == TypeTimeField {
- arg = v.In(tz).Format(formatTime)
- } else {
- arg = v.In(tz).Format(formatDateTime)
- }
- } else {
- typ := val.Type()
- name := getFullName(typ)
- var value interface{}
- if mmi, ok := modelCache.getByFullName(name); ok {
- if _, vu, exist := getExistPk(mmi, val); exist {
- value = vu
- }
- }
- arg = value
- if arg == nil {
- panic(fmt.Errorf("need a valid args value, unknown table or value `%s`", name))
- }
- }
- }
- params = append(params, arg)
- }
- return
- }
|