R4.4: Ingestion FK pre-resolution

Short answer: Upsert or verify parent workspace before child rows. A child row inserted before its parent exists fails, or points at nothing.

Group: Database and migrations. Status: stable. Generated from the rule definitions; do not edit by hand.

Playground: https://brevio.pro/tools/agent-guard-playground?rule=R4.4

What it catches

Ingestion FK pre-resolution: upsert or verify parent workspace before child rows.

Why

A child row inserted before its parent exists fails, or points at nothing.

A bad example

await db.insert(event);

A good example

await upsertWorkspace(event.workspaceId);
await db.insert(event);

How it is checked

A one-line card in the prompt of a slice that touches matching files (dev_rules.slice_micro_rules).

How to silence it

A person can silence one finding with brevio-core: ignore R4.4 -- reason on the line or the line above. Without the reason it does not count. An agent cannot silence it: the agent hook and the MCP tools never honour the comment, and a pull request that adds one is reported until a reviewer allows it. Fixing the code is still the better answer.

To change what the rule flags, edit its definition in dev_rules.py or code_rules/__init__.py. That is a code change and is reviewed like one.

R4.5 Bounded pagination
R4.1 Expand-contract migrations
R4.2 Foreign-key & tenant composite indexing
R4.3 N+1 query prevention
Every rule