Platform Evolution
Assessment run-2026-07-27-1 · 213 of 213 repos assessed
Repos / phenix-booking-commission-rate-api

phenix-booking-commission-rate-api

API for getting and storing commission rates against a booking for a team, acting as a middle man between consuming applications and the teams service with a history-tracking database.

91 · greenlowlooseOn-premZDD: ready with guardrailsapi

Health score

91

0 to 100 across seven weighted factors; nothing is hidden. Green is 75 and above, amber 50 to 74, red below 50. How scoring works.


Runtime currency / 25
25
Runs on supported modern .NET
Legacy transport / 15
15
No legacy WCF or SOAP surface
Test posture / 15
8
Some tests, coverage is thin
Security hygiene / 15
15
No credentials found in source
Dangerous coupling / 15
15
No dangerous coupling detected
Activity / 10
8
Last commit six to twelve months ago
Deployment hygiene / 5
5
CI in place
Health over time
2026-07-24 (run-2026-07-24-1): 912026-07-27 (run-2026-07-27-1): 91
No change since 2026-07-24 (91 to 91).

Facts

Languagescsharp, sql
FrameworksASP.NET Core 8, MediatR 12, Dapper 2
Runtimes.NET 8
Tests / CIsome / CI in place
Last commit2025-08-01
OwnerOwner unknown (mapping to be curated)
DomainPayments and finance (system generated; curate in repo-owners.json to override)
Product areaPhenix
HostedOn-prem Deployed to our own machines
  • Release "\finance\commission\booking-commission-rate Database": QA: deployment-group phase (agents on our own machines)
  • Release "\finance\commission\booking-commission-rate Database": Staging: deployment-group phase (agents on our own machines)
  • Release "\finance\commission\booking-commission-rate Database": Production: deployment-group phase (agents on our own machines)
  • Release "\finance\commission\booking-commission-rate Database": Training: deployment-group phase (agents on our own machines)
  • Release "\finance\commission\phenix-booking-commission-rate-api": QA: deployment-group phase (agents on our own machines)
Releases3 release pipeline(s): \finance\commission\booking-commission-rate Database; \finance\commission\phenix-booking-commission-rate-api; \finance\commission\phenix-booking-commission-rate-api - Stealth
Integrationrest, redis-streams
SourceOpen in Azure DevOps

Risk flags

Each flag links to its glossary definition.

Dependencies in context

Laying out the graph…
greenamberreddata store (square, dashed link)Node size follows fan-in. Click any node to open it.

Entanglement

loose No binding mechanisms apply: this system needs no untangling work.

    Depends on / used by

    Depends on (1)
    Used by (0)
    No internal dependents.

    Data stores
    sqlserver:BookingCommissionRatemongodb:bookingCommissionRate_logsredis:streams

    Migration playbooks

    Generated from this repo's assessment data: what is feasible, what blocks it, and the steps in order. Ratings: green means actionable now, amber means sequence other work first, red means blocked, grey means not applicable.

    ZDD adoption

    Ready with guardrails

    Close: the deployment path exists, but specific checks are needed first, typically raising tests, auditing serialized data, or respecting a shared schema with expand and contract. Test coverage is thin; ZDD shifts the safety net onto automation.

    Dependencies and gotchas
    • Serialized state or messages in flight (Redis or queues): new code must deserialize objects written by the previous version
    Steps
    1. Adopt the four-stage discipline from the ZDD engineering standard: pre-deployment compatibility, deployment, feature activation behind a flag, post-release cleanup.
    2. Raise automated test coverage first: ZDD trades the end-of-sprint manual gate for continuous automated confidence, so the tests are the entry ticket.
    3. Make every change dual-version safe: backwards-compatible APIs (new major version for breaking wire changes), expand and contract for any schema change, and consumers tolerant of unknown fields.
    4. Audit serialized data: anything in Redis, queues or shared caches must deserialize cleanly across adjacent versions.
    5. Wrap behaviour changes in feature flags so code deploys dark and release becomes a business decision, not a deployment event.
    6. Route deployments through the Workflow Engine's automated drain, deploy, health-check, return cycle (the path proven by the first automated production run in mid-2026).
    7. Verify with area-scoped regression rather than the whole-platform cycle, and watch error rates after rollout with automated rollback on alert.

    SQL Server exit

    Feasible now (1 owned database)

    The database is solely owned by this system, so the migration is self-contained. Recommended target: PostgreSQL.

    Steps
    1. Inventory the schema and query surface of sqlserver:BookingCommissionRate: tables, stored procedures, triggers, cross-database joins and anything else engine-specific.
    2. Confirm the target: PostgreSQL (relational model; keep transactions and joins, swap the engine).
    3. Data access is not through an ORM, so port the SQL by hand: translate T-SQL constructs, replace stored procedures with application code or target-native equivalents, and add integration tests around the queries that matter first.
    4. Stand up the target alongside SQL Server, backfill with an ETL pass (pgloader or an export/import job), then dual-write or replicate until parity is proven.
    5. Move reads to the target, watch correctness and latency, then cut writes over and keep SQL Server read-only until confidence is earned.
    6. Decommission the SQL Server database and remove the connection strings and firewall paths that pointed at it.

    Containerisation

    Ready to containerise

    Modern runtime, no hosted legacy transport: this service can follow the estate's proven container path (Dockerfile, shared pipeline template, ECS via Terraform).

    Steps
    1. Add a Dockerfile and make the app read all configuration from environment variables and the secrets manager, never from machine-local files.
    2. Log to stdout and expose a health check endpoint so ECS can supervise it.
    3. Adopt the shared ci.yml pipeline template with the container parameters (awsRegion, containerAfterBuild, ecsTerraformRepo), which is exactly how the estate's existing AWS services deploy.
    4. Define the service in the Terraform repo, deploy to a non-production environment, then shift traffic and disarm the deployment-group release pipeline.

    Recommended actions

    No specific actions for this repo. It either needs only normal maintenance, or its work is covered by an estate-level action. See the full programme.

    Assessment notes

    phenix-booking-commission-rate-api

    Purpose

    Stores and retrieves commission rates against a booking for a team. Sits between consuming applications and the teams service; every rate update inserts a new row so history is tracked.

    Tech stack

    C# on .NET 8, ASP.NET Core Web API with MediatR command/query handlers, Dapper + System.Data.SqlClient for data access, Swashbuckle/NSwag for OpenAPI, PhenixAuth authentication, TC.ConnectionBroker suite and TC.Streams (Redis provider). The database is a SQL Server DACPAC project (db/BookingCommissionRate.sqlproj, Sql120 schema provider).

    Deployment

    Three release pipelines under \finance\commission\ (API, API Stealth, and a separate Database release) built from two build pipelines (phenix-booking-commission-rate-api and its Database build); release_count 3. CI uses shared azure-pipelines-templates with .NET SDK 8.0.x; the DB build uses the shared build-db.yml template.

    Dependencies

    Internal: teams-service (via TC.Teams.Contracts and REST calls resolved through ConnectionBroker). Also consumes shared TC platform NuGet packages (ConnectionBroker, Streams, Exceptions, HealthChecks). External: New Relic APM.

    Data stores

    Owns the BookingCommissionRate SQL Server database (DACPAC-deployed). Request/response logging to MongoDB database bookingCommissionRate_logs; Redis used for TC.Streams eventing.

    Integration points

    Versioned REST API with Swagger UI; publishes/consumes events over Redis streams (TC.Streams); outbound HTTP to teams-service.

    Code health

    Two test projects (Common unit tests and API integration tests). CI on shared templates with build + DB pipelines. Last commit 2025-08-01, roughly a year old but on a current runtime.

    Modernisation risks

    Low: modern .NET 8 stack with its own database. The SSDT sqlproj (Sql120/.NET Framework 4.8.1 tooling) is the main legacy element, and the codebase shares the estate-wide coupling to internal TC.* NuGet packages.