Gorm : Error 1292 (22007): Incorrect datetime value: ‘0000-00-00‘ for column ‘login_time‘ at row 1

Gorm : Error 1292 (22007): Incorrect datetime value: ‘0000-00-00’ for column ‘login_time’ at row 1

当前版本的 mysql 不能设置为 ‘0000-00-00’

一、解决方案

1. 设置为当前时间（因为初始化用户时，用用户未登录，不恰当）
   models.go

user := &models.UserBasic{
		Name: "Allan",
		LoginTime: time.Now(),
	}

2. sql_mode 去掉 no_zero_date

set global sql_mode='strict_trans_tables,no_zero_in_date,error_for_division_by_zero,no_auto_create_user,no_engine_substitution';

3. UserBasic 重新定义 LoginTIme
   修改之前：

type UserBasic struct {
	gorm.Model
	Name          string
	Password      string
	LoginTime     time.Time `gorm:"column:login_time" json:"login_time"`
	HeartBeatTime time.Time `gorm:"column:heart_beat_time" json:"heart_beat_time"`
	LogoutTime    time.Time `gorm:"column:logout_time" json:"logout_time"`
	IsLogout      bool
	DeviceInfo    string
}

修改之后：

type UserBasic struct {
	gorm.Model
	Name          string
	Password      string
	LoginTime     *time.Time `gorm:"column:login_time" json:"login_time"`
	HeartBeatTime *time.Time `gorm:"column:heart_beat_time" json:"heart_beat_time"`
	LogoutTime    *time.Time `gorm:"column:logout_time" json:"logout_time"`
	IsLogout      bool
	DeviceInfo    string
}

或者

type UserBasic struct {
	gorm.Model
	Name          string
	Password      string
	LoginTime     sql.NullTime `gorm:"column:login_time" json:"login_time"`
	HeartBeatTime sql.NullTime `gorm:"column:heart_beat_time" json:"heart_beat_time"`
	LogoutTime    sql.NullTime `gorm:"column:logout_time" json:"logout_time"`
	IsLogout      bool
	DeviceInfo    string
}

二、结果

[258.179ms] [rows:0] CREATE TABLE `user_basic` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime(3) NULL,`updated_at` datetime(3) NULL,`deleted_at` datetime(3) NULL,`name` longtext,`password` longtext,`login_time` datetime(3) NULL,`heart_beat_time` datetime(3) NULL,`logout_time` datetime(3) NULL,`is_logout` boolean,`device_info` longtext,PRIMARY KEY (`id`),INDEX `idx_user_basic_deleted_at` (`deleted_at`))

代码007普通

打赏 收藏 海报 链接