import { parseStream, enforceSchema, type Dataset } from '@oomph/cleansheet';
const sanitizeLocalSpreadsheet = async (file: File): Promise<Dataset> => {
const rows = await parseStream(file, { delimiter: 'auto', clientOnly: true });
const validated = enforceSchema(rows, {
strictTypes: true,
escapeFormulae: true,
rules: { email: 'rfc5322', date: 'ISO_8601', amount: 'currency_cents' }
});
return validated;
};
import { AgentPipeline, QualityGate, ApprovalPolicy } from '@oomph/automation';
const pipeline = new AgentPipeline({ sandbox: 'confined_v2', maxSteps: 12 });
pipeline.registerGate(new QualityGate({
unitTests: 'PASS_REQUIRED',
typeCoverage: 1.0,
secretScanning: 'ZERO_TOLERANCE'
}));
await pipeline.requireApproval(ApprovalPolicy.HUMAN_OPERATOR_SIGN_OFF);
import { DocumentEngine, type RedactionBox } from '@oomph/documask';
export const permanentlyStripPII = (pdfBytes: Uint8Array, boxes: RedactionBox[]) => {
const engine = DocumentEngine.initSandbox(pdfBytes);
engine.purgeUnderlyingGlyphs(boxes);
engine.sanitizeRasterPixels(boxes);
engine.stripMetadataDictionaries();
return engine.exportCleanBinary();
};
