import type { MigrationContext, ReversibleMigration } from '../migration-types';

export class CreateDeploymentKeyTable1777000000000 implements ReversibleMigration {
	async up({ schemaBuilder: { createTable, column, createIndex } }: MigrationContext) {
		await createTable('deployment_key').withColumns(
			column('id').varchar(36).primary.notNull,
			column('type').varchar(64).notNull,
			column('value').text.notNull,
			column('algorithm').varchar(20),
			column('status').varchar(20).notNull,
		).withTimestamps;

		await createIndex(
			'deployment_key',
			['type'],
			true,
			'IDX_deployment_key_data_encryption_active',
			"status = 'active' AND type = 'data_encryption'",
		);

		await createIndex(
			'deployment_key',
			['type'],
			true,
			'IDX_deployment_key_instance_id_active',
			"status = 'active' AND type = 'instance.id'",
		);

		await createIndex(
			'deployment_key',
			['type'],
			true,
			'IDX_deployment_key_signing_jwt_active',
			"status = 'active' AND type = 'signing.jwt'",
		);

		await createIndex(
			'deployment_key',
			['type'],
			true,
			'IDX_deployment_key_signing_hmac_active',
			"status = 'active' AND type = 'signing.hmac'",
		);

		await createIndex(
			'deployment_key',
			['type'],
			true,
			'IDX_deployment_key_signing_binary_data_active',
			"status = 'active' AND type = 'signing.binary_data'",
		);
	}

	async down({ schemaBuilder: { dropTable } }: MigrationContext) {
		await dropTable('deployment_key');
	}
}