import { describe, expect, it } from 'vitest';
import { databaseMigrations } from '../../server/postgres/migration-catalog';

describe('PostgreSQL scoped risk acceptance migration', () => {
  it('registers one project-owned indexed target-snapshot table', () => {
    const migration = databaseMigrations.find(item => item.version === '028');
    expect(migration).toMatchObject({ version: '028', name: 'scoped-risk-acceptances' });
    expect(migration?.sql).toContain('CREATE TABLE assessor_scoped_risk_acceptances');
    expect(migration?.sql).toContain('REFERENCES assessor_projects(id) ON DELETE CASCADE');
    expect(migration?.sql).toContain("scope_kind IN ('device-finding', 'device-snapshot')");
    expect(migration?.sql).toContain('(project_id, device_key, updated_at DESC, id)');
    expect(migration?.sql).toContain('data jsonb NOT NULL');
  });
});