time_test.go

package datatypes_test

import (
	"testing"

	"gorm.io/datatypes"
	. "gorm.io/gorm/utils/tests"
)

func TestTime(t *testing.T) {
	if SupportedDriver("mysql", "postgres", "sqlite", "sqlserver") {
		type UserWithTime struct {
			ID   uint
			Name string
			Time datatypes.Time
		}

		DB.Migrator().DropTable(&UserWithTime{})
		if err := DB.Migrator().AutoMigrate(&UserWithTime{}); err != nil {
			t.Fatalf("failed to migrate, got error: %v", err)
		}

		user := UserWithTime{Name: "user1", Time: datatypes.NewTime(1, 2, 3, 0)}
		DB.Create(&user)

		result := UserWithTime{}
		if err := DB.First(&result, "name = ? AND time = ?", "user1", datatypes.NewTime(1, 2, 3, 0)).Error; err != nil {
			t.Fatalf("failed to find record with time, got error: %v", err)
		}

		AssertEqual(t, result.Time, datatypes.NewTime(1, 2, 3, 0))
	}
}