KamoCRM

The loader, its eight org-bounded queries, the 60 s cache, the change event, the wire codec and the department head mapping (KamoCollab CP02 T4)

Featurekamo-shared-library
Shipped
October 5, 2026 at 5:10 AM UTC
Author
Kamo
Commit
4fe8fff

- OrgGraphFactsRepository (donotmodify.dao.repos): eight native queries, each bounded by org_id through an index; users and CP01's team tables are pinned onto their keys (EXPLAIN-verified). - OrgGraphRows.fromSql: the lower-case maps to rows, leniently (unknown enums read as the entity defaults, ChatPolicySnapshotLoader's number and boolean rules). - OrgGraphLoader: one read-only transaction per load; TransientDbRetry outside a transaction, one attempt inside one. - OrgGraphCache: Caffeine, 60 s after write, at most 1,000 orgs, one load per org; fresh() bypasses it. - OrgGraphEvents: **************** its body, and a dispatcher subscription that drops malformed subjects and contains handler failures. - OrgGraphWire: the internal snapshot's maps (ids as strings) and back, refused on a stamp mismatch. - Department.headMemberId (read-only mapping), DepartmentDTO head fields, the TEAM share Javadoc and the waterfall's leaf-only comment.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing