momsse/octant
1
0
Fork 0
Code Issues 9 Pull requests 2 Projects Releases Packages Wiki Activity Actions 2

Banking : infrastructure Postgres + projections #33

New issue
Closed
opened 2026-07-04 12:11:17 +00:00 by momsse · 2 comments
momsse commented 2026-07-04 12:11:17 +00:00
Owner
Copy link

Migré depuis viziertronic/octant#82 — ouvert le 2026-06-26 par @momsse.

Infrastructure Postgres + projections du contexte Banking (@octant/postgres-banking).

Périmètre / livrables

  • Câblage event store / snapshot store Postgres pour les agrégats Banking.
  • Projecteurs (SqlProjector) : SupportedBanks, AccountingPeriods, BankAccounts, BankTransactions, SupportingDocuments.
  • Migrations DDL ; lecture/écriture pilotées par schéma (SqlSchema.findAll/void, sql.insert, ON CONFLICT).
  • Schema.DateTimeUtcFromString pour les instants en JSONB ; DateTimeUtcFromDate pour les colonnes timestamptz.

Dépendances

  • #31
  • @octant/postgres-event-store, @octant/postgres-projection, @octant/postgres-snapshot-store.

Référence : docs/event-storming/transaction-matcher.md + le modèle transaction-matcher.estorm.

> _Migré depuis [viziertronic/octant#82](https://github.com/viziertronic/octant/issues/82) — ouvert le 2026-06-26 par @momsse._ Infrastructure Postgres + projections du contexte **Banking** (`@octant/postgres-banking`). ## Périmètre / livrables - Câblage event store / snapshot store Postgres pour les agrégats Banking. - Projecteurs (`SqlProjector`) : `SupportedBanks`, `AccountingPeriods`, `BankAccounts`, `BankTransactions`, `SupportingDocuments`. - Migrations DDL ; lecture/écriture pilotées par schéma (`SqlSchema.findAll/void`, `sql.insert`, `ON CONFLICT`). - `Schema.DateTimeUtcFromString` pour les instants en JSONB ; `DateTimeUtcFromDate` pour les colonnes `timestamptz`. ## Dépendances - #31 - `@octant/postgres-event-store`, `@octant/postgres-projection`, `@octant/postgres-snapshot-store`. Référence : [`docs/event-storming/transaction-matcher.md`](../blob/main/docs/event-storming/transaction-matcher.md) + le modèle [`transaction-matcher.estorm`](../blob/main/docs/event-storming/transaction-matcher.estorm).
momsse commented 2026-07-04 12:11:18 +00:00
Author
Owner
Copy link

@momsse — 2026-06-26 (commentaire migré) :

Livré et mergé via #97 (review locale traitée avant la PR, puis review distante traitée ; CI verte). @octant/postgres-banking : 4 event-store repos + 5 projecteurs inline + 5 query adapters + 6 migrations, row-schema unique par table, 8 tests pglite. Reste hors-périmètre : intégration BankApi (#32).

> _@momsse — 2026-06-26 (commentaire migré) :_ Livré et mergé via #97 (review locale traitée avant la PR, puis review distante traitée ; CI verte). @octant/postgres-banking : 4 event-store repos + 5 projecteurs inline + 5 query adapters + 6 migrations, row-schema unique par table, 8 tests pglite. Reste hors-périmètre : intégration BankApi (#32).
momsse commented 2026-07-04 12:11:18 +00:00
Author
Owner
Copy link

@momsse — 2026-07-02 (commentaire migré) :

Livré par #97 (mergée) — @octant/postgres-banking : event store, projections, query adapters, migrations.

> _@momsse — 2026-07-02 (commentaire migré) :_ Livré par #97 (mergée) — @octant/postgres-banking : event store, projections, query adapters, migrations.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
renovate/catalog-pnpm.catalog.testing
renovate/catalog-pnpm.catalog.ui
harden/145-email-change-verification
perf/bound-banking-list-rpcs
perf/bound-list-reconciliations
harden/supersede-all-established
perf/targeted-match-queries
fix/exact-match-sign-normalization
refactor/extract-rpc-guarded
fix/bank-account-sync-dedup
fix/reconciliation-document-supersession
feat/transaction-matcher-documents
feat/transaction-matcher-banking
feat/transaction-matcher-presentation
feat/compose-matcher-backend
feat/scheduling-clock-signals
feat/documents-sources-analysis
feat/banking-bank-api-sync
feat/transaction-matching
feat/postgres-reconciliation
feat/postgres-documents
feat/postgres-banking
feat/reconciliation-domain
feat/documents-domain
feat/banking-domain
worktree-glistening-hopping-tiger
split/13-backoffice
chore/treat-issue-skill
split/12-api
refacto/schema-driven-projector-writes
split/11-postgres-authorization
split/10-postgres-authentication
feat/oxlint-no-redundant-return-type
feat/observability-spans
split/09-authorization-permissions
split/08-authorization-relations
split/07-authorization-roles-groups
split/06-oauth-adapters
refactor/46-unrepresentable-errors-auth-use-cases
test/45-standardized-test-service-factories
split/05-authentication-use-cases-rpc
test/38-aggregate-state-fixtures
split/04b-user-status-value-object
crypto/37-envelope-key-id
refactor/event-sourcing-stream-cursor
feat/authentication
feat/event-sourcing-package
feat/auth-domain
auth
No results found.
Labels
Clear labels   
bug
Something isn't working

  
enhancement
New feature or request

  
pr-split
Découpage de feat/authentication en PRs reviewables

  
question
Further information is requested

  
security

   
transaction-matcher
Domaine Transaction Matcher (banking / documents / reconciliation)

No labels
bug
enhancement
pr-split
question
security
transaction-matcher
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
momsse/octant#33
No description provided.