package migrate

import (
	jiramod "github.com/tidbcloud/devops/models/jira"

	"gorm.io/gorm"
)

// migration for issue tables to add StoredAt field
var _ = AddMigrateRecord(
	"202510281400",
	func(db *gorm.DB) error {
		err := db.AutoMigrate(&jiramod.Issue{})
		if err != nil {
			return err
		}

		err = db.Exec("UPDATE jira_issues SET stored_at = created_at").Error
		if err != nil {
			return err
		}

		err = db.Exec("UPDATE jira_issues SET created_at = (SELECT created_at FROM jira_issue_snapshots WHERE jira_issue_snapshots.key = jira_issues.key)").Error
		if err != nil {
			return err
		}

		return nil
	},
)