error-redis.Scan(unsupported time.Time)

[leoantony72]

Error :

cannot scan redis.result 2023-01-31T17:08:37.0314813+05:30 into struct field User.Date_created of type time.Time, error-redis.Scan(unsupported time.Time)</b>

Version : github.com/redis/go-redis/v9 v9.0.0-rc.4

type User struct {
	Id           string    `json:"id" gorm:"primaryKey;type:text" redis:"id"`
	Username     string    `json:"username" gorm:"type:varchar(25);uniqueIndex;not null" redis:"username"`
	Email        string    `json:"email" gorm:"type:varchar(40);uniqueIndex;not null" redis:"email"`
	Password     string    `json:"password,omitempty" gorm:"type:varchar(50);not null" redis:"-"`
	Date_created time.Time `json:"data_created" gorm:"type:timestamp" redis:"date_created"`
}

func (u *UserPostgresRepo) Create(user model.User) error {
	result := u.db.Create(&user)
	if result.Error != nil {
		return result.Error
	}

	redis_key := "users:" + user.Username + ":metadata"
	err := u.redis.HSet(
		ctx, redis_key,
		"id", user.Id,
		"username", user.Username,
		"email", user.Email,
		"date_created", time.Now(),
	)
	if err.Err() != nil {
		return err.Err()
	}
	return nil
}

[SoulPancake]

@leoantony72 You can convert the time.Time value to a string representation using the "time.Time.Format" method before storing it in Redis. The string format "2006-01-02 15:04:05" is a commonly used format for timestamps and can be easily converted back to a time.Time value if needed.

[leoantony72]

@leoantony72 You can convert the time.Time value to a string representation using the "time.Time.Format" method before storing it in Redis. The string format "2006-01-02 15:04:05" is a commonly used format for timestamps and can be easily converted back to a time.Time value if needed.

this doesn't work, tried

[monkey92t]

u.redis.HSet(ctx, key, &user{....})

go-redis HSet support struct.

See:

func ExampleClient_HSet() {
	// Set "redis" tag for hash key
	type ExampleUser struct {
		Name string `redis:"name"`
		Age  int    `redis:"age"`
	}

	items := ExampleUser{"jane", 22}

	err := rdb.HSet(ctx, "user:1", items).Err()
	if err != nil {
		panic(err)
	}
}

[monkey92t]

Oh... Scan does not handle the default time.Time, only use Scanner to parse, for Time.Time, Scan should scan RFC3339Nano format by default

[monkey92t]

We should submit a PR

[leoantony72]

We should submit a PR

Yep

[monkey92t]

See #2413