Iris Documentation Home

File notes

On this page

Database files

SQL adapters and projections. Low-level review-store reads need an authorized caller; list stores apply scope.

System explanation · Choosing checks

Source files

File	Responsibility / entry points
`src/lib/db/catalog-store.ts`	Scoped folder/page queries and personal flag writes. catalogScope, queryCatalog, flagReview
`src/lib/db/export-store.ts`	Month eligibility counts and scoped current snapshots for selected-month downloads. queryExportMonths, exportReviews
`src/lib/db/inbox-events.ts`	Pure event-kind detection and recipient/event-row construction for appends. InboxEventKind, eventKinds, eventsForSave
`src/lib/db/inbox-query.ts`	Validated inbox page/window parameters and role-specific awaiting states. inboxQuerySchema, InboxQuery, awaitingStates
`src/lib/db/scope.ts`	SQL form of canAccessReview; every list, count and export query filters with it. reviewScope
`src/lib/db/inbox-store.ts`	Touches, visits, event read/clear, notifications and inbox queries. touchReview, inboxSeen, readEvent, enabledEventKinds, clearEvents …
`src/lib/db/index.ts`	Database driver selection and local transactional batch adapter. getDb
`src/lib/db/policy-schema.ts`	Drizzle definition of published policy-table rows. snapPolicyTables
`src/lib/db/policy-store.ts`	Lists tables and publishes new effective months under a transaction lock. listPolicies, publishPolicy
`src/lib/db/report-store.ts`	Scoped report projection reads, legacy null-report fallback and aggregation inputs. reportInputs, queryReport
`src/lib/db/review-projection.ts`	Derives the sender shown in catalog projections from saved activity/actor. reviewSender
`src/lib/db/review-store.ts`	SQL implementation: UUID/business/request reads, append projection transaction and document access lookup. queryReviewVersions, findReviewForDocument, reviewStore
`src/lib/db/schema.ts`	Current snapshot/index/inbox/touch schema and list-column selection. reviewSnapshots, reviewIndex, inboxEvents, inboxVisits, reviewTouches
`src/lib/db/search-store.ts`	Search request validation, SQL predicates, current-snapshot extraction and paged counts. searchSchema, SearchFilters, escapeLike, searchWhere, querySearch, querySearchPage

Tests

File	Responsibility / entry points
`src/lib/db/catalog.integration.test.ts`	Checks catalog database integration.
`src/lib/db/export-store.integration.test.ts`	Checks export store database integration.
`src/lib/db/find-work.test.ts`	Checks find work. Example: “stacked filters keep independent terms and literal wildcard match modes”.
`src/lib/db/inbox-events.test.ts`	Checks inbox events. Example: “inbox event changes”.
`src/lib/db/inbox-query.test.ts`	Checks inbox query. Example: “inbox pagination bounds each independent page and accepts browser query strings”.
`src/lib/db/inbox.integration.test.ts`	Checks inbox database integration.
`src/lib/db/migrations.integration.test.ts`	Checks migrations database integration.
`src/lib/db/migrations.test.ts`	Checks migrations. Example: “database targets are explicit and production never falls back to development”.
`src/lib/db/perf.integration.test.ts`	Checks perf database integration.
`src/lib/db/report-store.integration.test.ts`	Checks report store database integration.
`src/lib/db/review-identity.integration.test.ts`	Checks review identity database integration.
`src/lib/db/search.integration.test.ts`	Checks search database integration.