14 lines
799 B
TypeScript
14 lines
799 B
TypeScript
import { readFile } from 'node:fs/promises';
|
|
import { resolve } from 'node:path';
|
|
import { describe, expect, it } from 'vitest';
|
|
|
|
describe('Microsoft Security Baseline classification schema', () => {
|
|
it('stores immutable detector revisions separately from baseline originals', async () => {
|
|
const sql = await readFile(resolve(import.meta.dirname, '..', '..', 'server', 'postgres', 'migrations', '012_microsoft_security_baseline_classifications.sql'), 'utf8');
|
|
expect(sql).toMatch(/CREATE TABLE assessor_microsoft_security_baseline_classifications/);
|
|
expect(sql).toMatch(/baseline_id text NOT NULL REFERENCES assessor_microsoft_security_baselines/);
|
|
expect(sql).toMatch(/UNIQUE \(baseline_id, detector_version\)/);
|
|
expect(sql).toMatch(/supersedes_classification_id/);
|
|
});
|
|
});
|