import { readFileSync } from 'fs';
import { join } from 'path';

const sql = readFileSync(join(__dirname, '../../prisma/migrations/20261104100000_tes_extracto_saldos_opcionales/migration.sql'), 'utf8');
const sinComentarios = sql.replace(/--.*$/gm, '');

describe('migración 20261104100000_tes_extracto_saldos_opcionales (D5)', () => {
  it('solo altera tes_extracto_bancario', () => {
    const alteradas = [...sinComentarios.matchAll(/ALTER TABLE\s+"?(\w+)"?/gi)].map((m) => m[1]);
    expect(alteradas.length).toBeGreaterThan(0);
    expect(new Set(alteradas)).toEqual(new Set(['tes_extracto_bancario']));
  });
  it.each(['saldo_inicial', 'saldo_final'])('%s: DROP NOT NULL y DROP DEFAULT', (col) => {
    expect(sinComentarios).toMatch(new RegExp(`ALTER COLUMN "${col}" DROP NOT NULL`));
    expect(sinComentarios).toMatch(new RegExp(`ALTER COLUMN "${col}" DROP DEFAULT`));
  });
  it('no toca datos: sin UPDATE, DELETE, DROP TABLE ni INSERT', () => {
    expect(sinComentarios).not.toMatch(/\b(UPDATE|DELETE|INSERT)\b/i);
    expect(sinComentarios).not.toMatch(/DROP\s+TABLE/i);
  });
});
