123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469 |
- // Copyright 2015 The Xorm Authors. All rights reserved.
- // Use of this source code is governed by a BSD-style
- // license that can be found in the LICENSE file.
- package xorm
- import (
- "errors"
- "fmt"
- "reflect"
- "sort"
- "strconv"
- "strings"
- "time"
- "github.com/go-xorm/core"
- )
- // str2PK convert string value to primary key value according to tp
- func str2PKValue(s string, tp reflect.Type) (reflect.Value, error) {
- var err error
- var result interface{}
- var defReturn = reflect.Zero(tp)
- switch tp.Kind() {
- case reflect.Int:
- result, err = strconv.Atoi(s)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as int: %s", s, err.Error())
- }
- case reflect.Int8:
- x, err := strconv.Atoi(s)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as int8: %s", s, err.Error())
- }
- result = int8(x)
- case reflect.Int16:
- x, err := strconv.Atoi(s)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as int16: %s", s, err.Error())
- }
- result = int16(x)
- case reflect.Int32:
- x, err := strconv.Atoi(s)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as int32: %s", s, err.Error())
- }
- result = int32(x)
- case reflect.Int64:
- result, err = strconv.ParseInt(s, 10, 64)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as int64: %s", s, err.Error())
- }
- case reflect.Uint:
- x, err := strconv.ParseUint(s, 10, 64)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as uint: %s", s, err.Error())
- }
- result = uint(x)
- case reflect.Uint8:
- x, err := strconv.ParseUint(s, 10, 64)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as uint8: %s", s, err.Error())
- }
- result = uint8(x)
- case reflect.Uint16:
- x, err := strconv.ParseUint(s, 10, 64)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as uint16: %s", s, err.Error())
- }
- result = uint16(x)
- case reflect.Uint32:
- x, err := strconv.ParseUint(s, 10, 64)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as uint32: %s", s, err.Error())
- }
- result = uint32(x)
- case reflect.Uint64:
- result, err = strconv.ParseUint(s, 10, 64)
- if err != nil {
- return defReturn, fmt.Errorf("convert %s as uint64: %s", s, err.Error())
- }
- case reflect.String:
- result = s
- default:
- return defReturn, errors.New("unsupported convert type")
- }
- return reflect.ValueOf(result).Convert(tp), nil
- }
- func str2PK(s string, tp reflect.Type) (interface{}, error) {
- v, err := str2PKValue(s, tp)
- if err != nil {
- return nil, err
- }
- return v.Interface(), nil
- }
- func splitTag(tag string) (tags []string) {
- tag = strings.TrimSpace(tag)
- var hasQuote = false
- var lastIdx = 0
- for i, t := range tag {
- if t == '\'' {
- hasQuote = !hasQuote
- } else if t == ' ' {
- if lastIdx < i && !hasQuote {
- tags = append(tags, strings.TrimSpace(tag[lastIdx:i]))
- lastIdx = i + 1
- }
- }
- }
- if lastIdx < len(tag) {
- tags = append(tags, strings.TrimSpace(tag[lastIdx:]))
- }
- return
- }
- type zeroable interface {
- IsZero() bool
- }
- func isZero(k interface{}) bool {
- switch k.(type) {
- case int:
- return k.(int) == 0
- case int8:
- return k.(int8) == 0
- case int16:
- return k.(int16) == 0
- case int32:
- return k.(int32) == 0
- case int64:
- return k.(int64) == 0
- case uint:
- return k.(uint) == 0
- case uint8:
- return k.(uint8) == 0
- case uint16:
- return k.(uint16) == 0
- case uint32:
- return k.(uint32) == 0
- case uint64:
- return k.(uint64) == 0
- case float32:
- return k.(float32) == 0
- case float64:
- return k.(float64) == 0
- case bool:
- return k.(bool) == false
- case string:
- return k.(string) == ""
- case zeroable:
- return k.(zeroable).IsZero()
- }
- return false
- }
- func isStructZero(v reflect.Value) bool {
- if !v.IsValid() {
- return true
- }
- for i := 0; i < v.NumField(); i++ {
- field := v.Field(i)
- switch field.Kind() {
- case reflect.Ptr:
- field = field.Elem()
- fallthrough
- case reflect.Struct:
- if !isStructZero(field) {
- return false
- }
- default:
- if field.CanInterface() && !isZero(field.Interface()) {
- return false
- }
- }
- }
- return true
- }
- func isArrayValueZero(v reflect.Value) bool {
- if !v.IsValid() || v.Len() == 0 {
- return true
- }
- for i := 0; i < v.Len(); i++ {
- if !isZero(v.Index(i).Interface()) {
- return false
- }
- }
- return true
- }
- func int64ToIntValue(id int64, tp reflect.Type) reflect.Value {
- var v interface{}
- kind := tp.Kind()
- if kind == reflect.Ptr {
- kind = tp.Elem().Kind()
- }
- switch kind {
- case reflect.Int16:
- temp := int16(id)
- v = &temp
- case reflect.Int32:
- temp := int32(id)
- v = &temp
- case reflect.Int:
- temp := int(id)
- v = &temp
- case reflect.Int64:
- temp := id
- v = &temp
- case reflect.Uint16:
- temp := uint16(id)
- v = &temp
- case reflect.Uint32:
- temp := uint32(id)
- v = &temp
- case reflect.Uint64:
- temp := uint64(id)
- v = &temp
- case reflect.Uint:
- temp := uint(id)
- v = &temp
- }
- if tp.Kind() == reflect.Ptr {
- return reflect.ValueOf(v).Convert(tp)
- }
- return reflect.ValueOf(v).Elem().Convert(tp)
- }
- func int64ToInt(id int64, tp reflect.Type) interface{} {
- return int64ToIntValue(id, tp).Interface()
- }
- func isPKZero(pk core.PK) bool {
- for _, k := range pk {
- if isZero(k) {
- return true
- }
- }
- return false
- }
- func indexNoCase(s, sep string) int {
- return strings.Index(strings.ToLower(s), strings.ToLower(sep))
- }
- func splitNoCase(s, sep string) []string {
- idx := indexNoCase(s, sep)
- if idx < 0 {
- return []string{s}
- }
- return strings.Split(s, s[idx:idx+len(sep)])
- }
- func splitNNoCase(s, sep string, n int) []string {
- idx := indexNoCase(s, sep)
- if idx < 0 {
- return []string{s}
- }
- return strings.SplitN(s, s[idx:idx+len(sep)], n)
- }
- func makeArray(elem string, count int) []string {
- res := make([]string, count)
- for i := 0; i < count; i++ {
- res[i] = elem
- }
- return res
- }
- func rValue(bean interface{}) reflect.Value {
- return reflect.Indirect(reflect.ValueOf(bean))
- }
- func rType(bean interface{}) reflect.Type {
- sliceValue := reflect.Indirect(reflect.ValueOf(bean))
- //return reflect.TypeOf(sliceValue.Interface())
- return sliceValue.Type()
- }
- func structName(v reflect.Type) string {
- for v.Kind() == reflect.Ptr {
- v = v.Elem()
- }
- return v.Name()
- }
- func col2NewCols(columns ...string) []string {
- newColumns := make([]string, 0, len(columns))
- for _, col := range columns {
- col = strings.Replace(col, "`", "", -1)
- col = strings.Replace(col, `"`, "", -1)
- ccols := strings.Split(col, ",")
- for _, c := range ccols {
- newColumns = append(newColumns, strings.TrimSpace(c))
- }
- }
- return newColumns
- }
- func sliceEq(left, right []string) bool {
- if len(left) != len(right) {
- return false
- }
- sort.Sort(sort.StringSlice(left))
- sort.Sort(sort.StringSlice(right))
- for i := 0; i < len(left); i++ {
- if left[i] != right[i] {
- return false
- }
- }
- return true
- }
- func setColumnInt(bean interface{}, col *core.Column, t int64) {
- v, err := col.ValueOf(bean)
- if err != nil {
- return
- }
- if v.CanSet() {
- switch v.Type().Kind() {
- case reflect.Int, reflect.Int64, reflect.Int32:
- v.SetInt(t)
- case reflect.Uint, reflect.Uint64, reflect.Uint32:
- v.SetUint(uint64(t))
- }
- }
- }
- func setColumnTime(bean interface{}, col *core.Column, t time.Time) {
- v, err := col.ValueOf(bean)
- if err != nil {
- return
- }
- if v.CanSet() {
- switch v.Type().Kind() {
- case reflect.Struct:
- v.Set(reflect.ValueOf(t).Convert(v.Type()))
- case reflect.Int, reflect.Int64, reflect.Int32:
- v.SetInt(t.Unix())
- case reflect.Uint, reflect.Uint64, reflect.Uint32:
- v.SetUint(uint64(t.Unix()))
- }
- }
- }
- func genCols(table *core.Table, session *Session, bean interface{}, useCol bool, includeQuote bool) ([]string, []interface{}, error) {
- colNames := make([]string, 0, len(table.ColumnsSeq()))
- args := make([]interface{}, 0, len(table.ColumnsSeq()))
- for _, col := range table.Columns() {
- if useCol && !col.IsVersion && !col.IsCreated && !col.IsUpdated {
- if _, ok := getFlagForColumn(session.Statement.columnMap, col); !ok {
- continue
- }
- }
- if col.MapType == core.ONLYFROMDB {
- continue
- }
- fieldValuePtr, err := col.ValueOf(bean)
- if err != nil {
- return nil, nil, err
- }
- fieldValue := *fieldValuePtr
- if col.IsAutoIncrement {
- switch fieldValue.Type().Kind() {
- case reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int, reflect.Int64:
- if fieldValue.Int() == 0 {
- continue
- }
- case reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint, reflect.Uint64:
- if fieldValue.Uint() == 0 {
- continue
- }
- case reflect.String:
- if len(fieldValue.String()) == 0 {
- continue
- }
- case reflect.Ptr:
- if fieldValue.Pointer() == 0 {
- continue
- }
- }
- }
- if col.IsDeleted {
- continue
- }
- if session.Statement.ColumnStr != "" {
- if _, ok := getFlagForColumn(session.Statement.columnMap, col); !ok {
- continue
- }
- }
- if session.Statement.OmitStr != "" {
- if _, ok := getFlagForColumn(session.Statement.columnMap, col); ok {
- continue
- }
- }
- // !evalphobia! set fieldValue as nil when column is nullable and zero-value
- if _, ok := getFlagForColumn(session.Statement.nullableMap, col); ok {
- if col.Nullable && isZero(fieldValue.Interface()) {
- var nilValue *int
- fieldValue = reflect.ValueOf(nilValue)
- }
- }
- if (col.IsCreated || col.IsUpdated) && session.Statement.UseAutoTime /*&& isZero(fieldValue.Interface())*/ {
- // if time is non-empty, then set to auto time
- val, t := session.Engine.NowTime2(col.SQLType.Name)
- args = append(args, val)
- var colName = col.Name
- session.afterClosures = append(session.afterClosures, func(bean interface{}) {
- col := table.GetColumn(colName)
- setColumnTime(bean, col, t)
- })
- } else if col.IsVersion && session.Statement.checkVersion {
- args = append(args, 1)
- } else {
- arg, err := session.value2Interface(col, fieldValue)
- if err != nil {
- return colNames, args, err
- }
- args = append(args, arg)
- }
- if includeQuote {
- colNames = append(colNames, session.Engine.Quote(col.Name)+" = ?")
- } else {
- colNames = append(colNames, col.Name)
- }
- }
- return colNames, args, nil
- }
- func indexName(tableName, idxName string) string {
- return fmt.Sprintf("IDX_%v_%v", tableName, idxName)
- }
- func getFlagForColumn(m map[string]bool, col *core.Column) (val bool, has bool) {
- if len(m) == 0 {
- return false, false
- }
- n := len(col.Name)
- for mk := range m {
- if len(mk) != n {
- continue
- }
- if strings.EqualFold(mk, col.Name) {
- return m[mk], true
- }
- }
- return false, false
- }
|