定义类型反序列化失败 #2057

New Issue

CyJaySong · 2021-09-25T06:21:50Z

CyJaySong commented

2021-09-25 06:21:50 +00:00

type DATETIME time.Time

\\\ 已经实现 FromDB 和 ToDB 并在 xormplus 里测试过


type Goods struct {
	UpdatedAt   xtime.DATETIME
}

当我某结构体包含定义类型时，反序列化失败

cannot convert time.Date(2021, time.January, 10, 13, 16, 6, 0, time.Local) as bytes

``` type DATETIME time.Time \\\ 已经实现 FromDB 和 ToDB 并在 xormplus 里测试过 type Goods struct { UpdatedAt xtime.DATETIME } ``` 当我某结构体包含定义类型时，反序列化失败 cannot convert time.Date(2021, time.January, 10, 13, 16, 6, 0, time.Local) as bytes

lunny added the

need

test

label 2021-09-26 00:40:27 +00:00

CyJaySong commented

2022-04-09 02:27:39 +00:00

@lunny 还是不可以正常反序列化哎

CyJaySong commented

2023-03-06 03:39:25 +00:00

挖坟挖坟

lunny commented

2023-03-06 04:03:20 +00:00

挖坟挖坟

Please send a PR with your test code.

> 挖坟挖坟 Please send a PR with your test code.

CyJaySong commented

2023-03-06 06:11:11 +00:00

package main

import (
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"time"
	"xorm.io/xorm"
)

// DATETIME
type DATETIME time.Time

func (dt *DATETIME) FromDB(v []byte) (err error) {
	var xt time.Time
	if err = xt.UnmarshalText(v); err != nil {
		xt, err = time.ParseInLocation("2006-01-02 15:04:05", string(v), time.Local)
		return
	}
	*dt = DATETIME(xt)
	return
}

func (dt *DATETIME) ToDB() ([]byte, error) {
	if dt == nil {
		return nil, nil
	}
	b := make([]byte, 0, len("2006-01-02 15:04:05"))
	b = time.Time(*dt).AppendFormat(b, "2006-01-02 15:04:05")
	return b, nil
}

type User struct {
	Id        uint64   `xorm:"id pk autoincr"`
	CreatedAt DATETIME `xorm:"created_at created"`
}

func main() {
	db, err := xorm.NewEngine("mysql", "")
	var user User
	if _, err = db.Where("id = ?", 16).Get(&user); err != nil {
		fmt.Printf("查询出错：%s", err)
		return
	}
	fmt.Printf("用户%d创建时间：%v", user.Id, user.CreatedAt)
}

``` package main import ( "fmt" _ "github.com/go-sql-driver/mysql" "time" "xorm.io/xorm" ) // DATETIME type DATETIME time.Time func (dt *DATETIME) FromDB(v []byte) (err error) { var xt time.Time if err = xt.UnmarshalText(v); err != nil { xt, err = time.ParseInLocation("2006-01-02 15:04:05", string(v), time.Local) return } *dt = DATETIME(xt) return } func (dt *DATETIME) ToDB() ([]byte, error) { if dt == nil { return nil, nil } b := make([]byte, 0, len("2006-01-02 15:04:05")) b = time.Time(*dt).AppendFormat(b, "2006-01-02 15:04:05") return b, nil } type User struct { Id uint64 `xorm:"id pk autoincr"` CreatedAt DATETIME `xorm:"created_at created"` } func main() { db, err := xorm.NewEngine("mysql", "") var user User if _, err = db.Where("id = ?", 16).Get(&user); err != nil { fmt.Printf("查询出错：%s", err) return } fmt.Printf("用户%d创建时间：%v", user.Id, user.CreatedAt) } ```

CyJaySong commented

2023-03-07 09:16:06 +00:00

@lunny