123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336 |
- // Copyright 2017 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 (
- "database/sql/driver"
- "errors"
- "fmt"
- "reflect"
- "strconv"
- "time"
- )
- var errNilPtr = errors.New("destination pointer is nil") // embedded in descriptive error
- func strconvErr(err error) error {
- if ne, ok := err.(*strconv.NumError); ok {
- return ne.Err
- }
- return err
- }
- func cloneBytes(b []byte) []byte {
- if b == nil {
- return nil
- } else {
- c := make([]byte, len(b))
- copy(c, b)
- return c
- }
- }
- func asString(src interface{}) string {
- switch v := src.(type) {
- case string:
- return v
- case []byte:
- return string(v)
- }
- rv := reflect.ValueOf(src)
- switch rv.Kind() {
- case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
- return strconv.FormatInt(rv.Int(), 10)
- case reflect.Uint, reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64:
- return strconv.FormatUint(rv.Uint(), 10)
- case reflect.Float64:
- return strconv.FormatFloat(rv.Float(), 'g', -1, 64)
- case reflect.Float32:
- return strconv.FormatFloat(rv.Float(), 'g', -1, 32)
- case reflect.Bool:
- return strconv.FormatBool(rv.Bool())
- }
- return fmt.Sprintf("%v", src)
- }
- func asBytes(buf []byte, rv reflect.Value) (b []byte, ok bool) {
- switch rv.Kind() {
- case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
- return strconv.AppendInt(buf, rv.Int(), 10), true
- case reflect.Uint, reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64:
- return strconv.AppendUint(buf, rv.Uint(), 10), true
- case reflect.Float32:
- return strconv.AppendFloat(buf, rv.Float(), 'g', -1, 32), true
- case reflect.Float64:
- return strconv.AppendFloat(buf, rv.Float(), 'g', -1, 64), true
- case reflect.Bool:
- return strconv.AppendBool(buf, rv.Bool()), true
- case reflect.String:
- s := rv.String()
- return append(buf, s...), true
- }
- return
- }
- // convertAssign copies to dest the value in src, converting it if possible.
- // An error is returned if the copy would result in loss of information.
- // dest should be a pointer type.
- func convertAssign(dest, src interface{}) error {
- // Common cases, without reflect.
- switch s := src.(type) {
- case string:
- switch d := dest.(type) {
- case *string:
- if d == nil {
- return errNilPtr
- }
- *d = s
- return nil
- case *[]byte:
- if d == nil {
- return errNilPtr
- }
- *d = []byte(s)
- return nil
- }
- case []byte:
- switch d := dest.(type) {
- case *string:
- if d == nil {
- return errNilPtr
- }
- *d = string(s)
- return nil
- case *interface{}:
- if d == nil {
- return errNilPtr
- }
- *d = cloneBytes(s)
- return nil
- case *[]byte:
- if d == nil {
- return errNilPtr
- }
- *d = cloneBytes(s)
- return nil
- }
- case time.Time:
- switch d := dest.(type) {
- case *string:
- *d = s.Format(time.RFC3339Nano)
- return nil
- case *[]byte:
- if d == nil {
- return errNilPtr
- }
- *d = []byte(s.Format(time.RFC3339Nano))
- return nil
- }
- case nil:
- switch d := dest.(type) {
- case *interface{}:
- if d == nil {
- return errNilPtr
- }
- *d = nil
- return nil
- case *[]byte:
- if d == nil {
- return errNilPtr
- }
- *d = nil
- return nil
- }
- }
- var sv reflect.Value
- switch d := dest.(type) {
- case *string:
- sv = reflect.ValueOf(src)
- switch sv.Kind() {
- case reflect.Bool,
- reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64,
- reflect.Uint, reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64,
- reflect.Float32, reflect.Float64:
- *d = asString(src)
- return nil
- }
- case *[]byte:
- sv = reflect.ValueOf(src)
- if b, ok := asBytes(nil, sv); ok {
- *d = b
- return nil
- }
- case *bool:
- bv, err := driver.Bool.ConvertValue(src)
- if err == nil {
- *d = bv.(bool)
- }
- return err
- case *interface{}:
- *d = src
- return nil
- }
- dpv := reflect.ValueOf(dest)
- if dpv.Kind() != reflect.Ptr {
- return errors.New("destination not a pointer")
- }
- if dpv.IsNil() {
- return errNilPtr
- }
- if !sv.IsValid() {
- sv = reflect.ValueOf(src)
- }
- dv := reflect.Indirect(dpv)
- if sv.IsValid() && sv.Type().AssignableTo(dv.Type()) {
- switch b := src.(type) {
- case []byte:
- dv.Set(reflect.ValueOf(cloneBytes(b)))
- default:
- dv.Set(sv)
- }
- return nil
- }
- if dv.Kind() == sv.Kind() && sv.Type().ConvertibleTo(dv.Type()) {
- dv.Set(sv.Convert(dv.Type()))
- return nil
- }
- switch dv.Kind() {
- case reflect.Ptr:
- if src == nil {
- dv.Set(reflect.Zero(dv.Type()))
- return nil
- } else {
- dv.Set(reflect.New(dv.Type().Elem()))
- return convertAssign(dv.Interface(), src)
- }
- case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
- s := asString(src)
- i64, err := strconv.ParseInt(s, 10, dv.Type().Bits())
- if err != nil {
- err = strconvErr(err)
- return fmt.Errorf("converting driver.Value type %T (%q) to a %s: %v", src, s, dv.Kind(), err)
- }
- dv.SetInt(i64)
- return nil
- case reflect.Uint, reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64:
- s := asString(src)
- u64, err := strconv.ParseUint(s, 10, dv.Type().Bits())
- if err != nil {
- err = strconvErr(err)
- return fmt.Errorf("converting driver.Value type %T (%q) to a %s: %v", src, s, dv.Kind(), err)
- }
- dv.SetUint(u64)
- return nil
- case reflect.Float32, reflect.Float64:
- s := asString(src)
- f64, err := strconv.ParseFloat(s, dv.Type().Bits())
- if err != nil {
- err = strconvErr(err)
- return fmt.Errorf("converting driver.Value type %T (%q) to a %s: %v", src, s, dv.Kind(), err)
- }
- dv.SetFloat(f64)
- return nil
- case reflect.String:
- dv.SetString(asString(src))
- return nil
- }
- return fmt.Errorf("unsupported Scan, storing driver.Value type %T into type %T", src, dest)
- }
- func asKind(vv reflect.Value, tp reflect.Type) (interface{}, error) {
- switch tp.Kind() {
- case reflect.Int64:
- return vv.Int(), nil
- case reflect.Int:
- return int(vv.Int()), nil
- case reflect.Int32:
- return int32(vv.Int()), nil
- case reflect.Int16:
- return int16(vv.Int()), nil
- case reflect.Int8:
- return int8(vv.Int()), nil
- case reflect.Uint64:
- return vv.Uint(), nil
- case reflect.Uint:
- return uint(vv.Uint()), nil
- case reflect.Uint32:
- return uint32(vv.Uint()), nil
- case reflect.Uint16:
- return uint16(vv.Uint()), nil
- case reflect.Uint8:
- return uint8(vv.Uint()), nil
- case reflect.String:
- return vv.String(), nil
- case reflect.Slice:
- if tp.Elem().Kind() == reflect.Uint8 {
- v, err := strconv.ParseInt(string(vv.Interface().([]byte)), 10, 64)
- if err != nil {
- return nil, err
- }
- return v, nil
- }
- }
- return nil, fmt.Errorf("unsupported primary key type: %v, %v", tp, vv)
- }
- func convertFloat(v interface{}) (float64, error) {
- switch v.(type) {
- case float32:
- return float64(v.(float32)), nil
- case float64:
- return v.(float64), nil
- case string:
- i, err := strconv.ParseFloat(v.(string), 64)
- if err != nil {
- return 0, err
- }
- return i, nil
- case []byte:
- i, err := strconv.ParseFloat(string(v.([]byte)), 64)
- if err != nil {
- return 0, err
- }
- return i, nil
- }
- return 0, fmt.Errorf("unsupported type: %v", v)
- }
- func convertInt(v interface{}) (int64, error) {
- switch v.(type) {
- case int:
- return int64(v.(int)), nil
- case int8:
- return int64(v.(int8)), nil
- case int16:
- return int64(v.(int16)), nil
- case int32:
- return int64(v.(int32)), nil
- case int64:
- return v.(int64), nil
- case []byte:
- i, err := strconv.ParseInt(string(v.([]byte)), 10, 64)
- if err != nil {
- return 0, err
- }
- return i, nil
- case string:
- i, err := strconv.ParseInt(v.(string), 10, 64)
- if err != nil {
- return 0, err
- }
- return i, nil
- }
- return 0, fmt.Errorf("unsupported type: %v", v)
- }
|