Requirement Detail

Functional Requirements

CLI Functions

The system shall expose and reliably execute core CLI functions (version, mask, eval, text, regexp, vsv, lines).

Execution Engine

The eval function shall execute raw SQL and correctly return string representations, supporting complex joins of multiple rows/values.

Shell execution runs must produce equivalent parsing and execution outcomes against the internal engine.

Ingestion and Administration

The database initialization (init), state merging (merge), and credential definitions must be secure and reliable.

The ingestion engine shall support robust data loading, including CSV transformations, dry-run validations, stats reporting, and multi-tenant ingestion bounds.

Orchestration & Mail

The system shall handle structured data transformations (HTML/XML processing) accurately.

IMAP integrations must faithfully download, filter, and attachment-map emails to the surveillance targets.

Acceptance Criteria

Core SQL shell and CLI functions execute without runtime errors and produce matching reference outputs.

Ingestion dry-runs correctly predict the ingestion impact without altering the active state.

Execution pipelines correctly extract and transform the specified XML/HTML values.