package migrate

import (
	"fmt"

	ccmod "github.com/tidbcloud/devops/models/cloudconfig"
	"gorm.io/gorm"
)

// migration for cloud config to add `config_type` column.
var _ = AddMigrateRecord(
	"202406051400",
	func(db *gorm.DB) error {
		err := db.AutoMigrate(&ccmod.ConfigurationFileChange{})
		if err != nil {
			return err
		}

		// for now, all config_type are same as filename
		err = db.Exec(fmt.Sprintf("UPDATE `%s` SET config_type=filename WHERE config_type='';",
			ccmod.ConfigurationFileChange{}.TableName())).Error

		return err
	},
)