package migrate

import (
	"fmt"

	mod "github.com/tidbcloud/devops/models"

	"gorm.io/gorm"
)

var _ = AddMigrateRecord(
	"202605181700",
	func(db *gorm.DB) error {
		if err := db.AutoMigrate(&mod.IncidentPostMortemToDoAction{}); err != nil {
			return err
		}

		table := mod.IncidentPostMortemToDoAction{}.TableName()
		sql := fmt.Sprintf("ALTER TABLE %s MODIFY COLUMN priority varchar(200) DEFAULT NULL", table)
		if err := db.Exec(sql).Error; err != nil {
			return fmt.Errorf("execute sql [%s] failed: %w", sql, err)
		}
		return nil
	},
)
