Method createTempTable

internal/commands/migrate.go:406–464

createTempTable creates a temporary table for migration

()

// createTempTable creates a temporary table for migration
func (cmd *MigrateKeysCommand) createTempTable() error {
	logrus.Info("Creating temporary migration table...")

	// Drop existing temp table if exists
	if err := cmd.db.Exec("DROP TABLE IF EXISTS temp_migration").Error; err != nil {
		logrus.WithError(err).Warn("Failed to drop existing temp table, continuing anyway")
	}

	dbType := cmd.db.Dialector.Name()
	var createTableSQL string

	// Use database-specific syntax for better compatibility
	switch dbType {
	case "mysql":
		createTableSQL = `
			CREATE TABLE temp_migration (
				id BIGINT PRIMARY KEY,
				key_value_new TEXT,
				key_hash_new VARCHAR(255)
			)
		`
	case "postgres":
		createTableSQL = `
			CREATE TABLE temp_migration (
				id BIGINT PRIMARY KEY,
				key_value_new TEXT,
				key_hash_new VARCHAR(255)
			)
		`
	case "sqlite":
		// SQLite uses INTEGER for primary key
		createTableSQL = `
			CREATE TABLE temp_migration (
				id INTEGER PRIMARY KEY,
				key_value_new TEXT,
				key_hash_new VARCHAR(255)
			)
		`
	default:
		// Fallback to generic syntax
		createTableSQL = `
			CREATE TABLE temp_migration (
				id INTEGER PRIMARY KEY,
				key_value_new TEXT,
				key_hash_new VARCHAR(255)
			)
		`
	}

	// Create temp table with minimal structure
	if err := cmd.db.Exec(createTableSQL).Error; err != nil {
		return fmt.Errorf("failed to create temp_migration table: %w", err)
	}

	// Create index for better UPDATE performance (not needed for PRIMARY KEY but helps with JOIN)
	// Skip index creation since id is already PRIMARY KEY which creates an implicit index

	return nil