package database

import (
	"testing"

	"github.com/stretchr/testify/require"
)

func TestEncryptedSecretMigrationUpgradeDownUp(t *testing.T) {
	db, dbURL := openUploadMigrationPostgres(t)
	migrations := productionMigrationsPath(t)
	require.NoError(t, MigrateSteps(dbURL, migrations, 83))
	require.False(t, db.Migrator().HasColumn("channel_whatsapps", "provider_config"))

	require.NoError(t, MigrateSteps(dbURL, migrations, 1))
	require.True(t, db.Migrator().HasColumn("channel_whatsapps", "provider_config"))
	require.True(t, db.Migrator().HasColumn("channel_whatsapps", "webhook_verify_token_digest"))

	require.NoError(t, MigrateSteps(dbURL, migrations, -1))
	require.True(t, db.Migrator().HasColumn("channel_whatsapps", "provider_config"))
	require.False(t, db.Migrator().HasColumn("channel_whatsapps", "webhook_verify_token_digest"))

	require.NoError(t, MigrateSteps(dbURL, migrations, 1))
	require.True(t, db.Migrator().HasColumn("channel_whatsapps", "webhook_verify_token_digest"))
}