package migrate

import (
	wsmod "github.com/tidbcloud/aisupport/services/ticket-manager/models/workspace"

	"gorm.io/gorm"
)

var _ = addRecord("202608171100", migrateWorkspaceLastTimelineSyncAt)

func migrateWorkspaceLastTimelineSyncAt(db *gorm.DB) error {
	if err := db.AutoMigrate(&wsmod.Workspace{}); err != nil {
		return err
	}

	return db.Exec(`
		UPDATE workspace_workspaces
		SET last_timeline_sync_at = CURRENT_TIMESTAMP
		WHERE last_timeline_sync_at IS NULL
	`).Error
}