- BettingOdds

Run #14

Failed Guard: — Preflight: — Build: — Test: —

Persisted agent run. Review patches, guard/preflight results, and take actions (apply/build/test/autopilot).

Back

Live pipeline

Real-time step updates (SignalR).

Live: Connecting…

Waiting for updates…

Autopilot is disabled because there is no PatchSet on this run yet.

Planner: gpt-5-mini Implementer: gpt-5-mini Reviewer: gpt-5-mini Guard: gpt-5-mini

Autopilot Timeline

Each card represents one PatchSet attempt with Guard/Preflight/Apply/Build/Test outcomes.

0 PatchSets

Task

Agent run objective

TASK: Implement NBA Injury storage schema (snapshots, enterprise-grade) using EF migrations.
Requirements
•	Create Domain entities only (no EF attributes) for injuries:
o	NbaInjurySnapshotBatch (identity PK; SourceName, PulledAtUtc, optional SeasonId, optional Notes, BatchGuid or BatchKey string)
o	NbaPlayerInjurySnapshot (identity PK; FK to batch; AsOfUtc (or use batch PulledAtUtc); TeamId int; nullable PlayerId long?; PlayerName string; Status enum; Description string?; ReturnDateUtc DateTime?; IsMapped bool; RawJson string?; CreatedUtc)
o	Enum NbaInjuryStatus (Unknown, Available, Probable, Questionable, Doubtful, Out)
•	Update AppDbContext:
o	Add DbSets
o	Configure tables, keys, FK batch→snapshots (Restrict)
o	String max lengths (PlayerName 80, SourceName 40, Status as int, Description 300, RawJson max)
o	Indexes:
	Batch: (SourceName, PulledAtUtc)
	Snapshot: (TeamId, AsOfUtc) and (PlayerId, AsOfUtc) (PlayerId nullable -> still index)
	Snapshot unique: (BatchId, TeamId, PlayerName) (or (BatchId, TeamId, PlayerId) if mapped) — choose safe uniqueness
•	Add migration + update DB
Constraints
•	Domain doesn’t depend on anything.
•	DbContext not used from Pages.
•	UTC everywhere.
Deliverable
•	PatchSet containing entity files + DbContext mapping + migration.
Reviewer must validate
•	Snapshot model supports multiple pulls/day
•	Indexes are sane and scalable
•	Migration builds

Created

2026-02-19 18:48

Completed

2026-02-19 18:50

Repo

—

Models

Planner: gpt-5-mini · Implementer: gpt-5-mini · Reviewer: gpt-5-mini · Guard: gpt-5-mini

Governance bundle

—

Files bundle

—

Steps

total

Planner / Implementer / Reviewer / Guard / Apply / Build / Test

Patch sets

generated

Latest: —

Executions

build/test

Captured logs are shown below.

Pipeline steps

Each step is persisted with messages and duration.

Step	Status	Started	Completed	ms	Model	Msgs
Planner	Succeeded	2026-02-19 18:48:32	2026-02-19 18:48:57	24829	gpt-5-mini	2
Step messages User planner_schema UTC: 2026-02-20 02:48:32 TASK: TASK: Implement NBA Injury storage schema (snapshots, enterprise-grade) using EF migrations. Requirements • Create Domain entities only (no EF attributes) for injuries: o NbaInjurySnapshotBatch (identity PK; SourceName, PulledAtUtc, optional SeasonId, optional Notes, BatchGuid or BatchKey string) o NbaPlayerInjurySnapshot (identity PK; FK to batch; AsOfUtc (or use batch PulledAtUtc); TeamId int; nullable PlayerId long?; PlayerName string; Status enum; Description string?; ReturnDateUtc DateTime?; IsMapped bool; RawJson string?; CreatedUtc) o Enum NbaInjuryStatus (Unknown, Available, Probable, Questionable, Doubtful, Out) • Update AppDbContext: o Add DbSets o Configure tables, keys, FK batch→snapshots (Restrict) o String max lengths (PlayerName 80, SourceName 40, Status as int, Description 300, RawJson max) o Indexes:  Batch: (SourceName, PulledAtUtc)  Snapshot: (TeamId, AsOfUtc) and (PlayerId, AsOfUtc) (PlayerId nullable -> still index)  Snapshot unique: (BatchId, TeamId, PlayerName) (or (BatchId, TeamId, PlayerId) if mapped) — choose safe uniqueness • Add migration + update DB Constraints • Domain doesn’t depend on anything. • DbContext not used from Pages. • UTC everywhere. Deliverable • PatchSet containing entity files + DbContext mapping + migration. Reviewer must validate • Snapshot model supports multiple pulls/day • Indexes are sane and scalable • Migration builds SOLUTION TREE: BettingOdds +---App \| +---Agents \| \| +---Autopilot \| \| \| \| AgentAutopilotRunner.cs \| \| \| \| AutopilotOptions.cs \| \| +---Git \| \| \| \| GitRunner.cs \| \| +---Guard \| \| \| \| GuardEvaluator.cs \| \| \| \| GuardPolicyOptions.cs \| \| +---Live \| \| \| \| AaiRunHub.cs \| \| \| \| BackgroundTaskQueue.cs \| \| \| \| IAaiLiveNotifier.cs \| \| \| \| QueuedHostedService.cs \| \| \| \| SignalRAaiLiveNotifier.cs \| \| +---Models \| \| \| \| AgentPatch.cs \| \| \| \| AgentPolicyGuard.cs \| \| \| \| AgentRunContext.cs \| \| \| \| AgentRunResult.cs \| \| \| \| IAgentPolicyGuard.cs \| \| +---Patching \| \| \| \| PatchNormalization.cs \| \| \| \| PatchPreflightValidator.cs \| \| \| \| PreflightPolicyOptions.cs \| \| \| \| UnifiedDiffBuilder.cs \| \| +---RunLaunch \| \| \| \| AaiRunLauncher.cs \| \| +---Steps \| \| \| +---Models \| \| \| \| \| ImplementerInput.cs \| \| \| \| \| PlannerInput.cs \| \| \| \| \| ReviewerInput.cs \| \| \| \| AgentJson.cs \| \| \| \| IAgentStep.cs \| \| \| \| ImplementerAgent.cs \| \| \| \| PlannerAgent.cs \| \| \| \| ReviewerAgent.cs \| \| +---Tests \| \| \| \| TestAuthorAgent.cs \| \| \| AaiRunWriter.cs \| \| \| AgentOrchestrator.cs \| \| \| AgentPolicyOptions.cs \| \| \| CommandPolicy.cs \| \| \| DiffApplier.cs \| \| \| DotnetRunner.cs \| \| \| OpenAiOptions.cs \| \| \| OpenAiResponsesClient.cs \| \| \| RepoFileService.cs \| +---Dtos \| \| \| NbaTeamAdvancedRow.cs \| +---Pricing \| \| \| FairLinesEngine.cs \| \| \| FairLinesMath.cs \| \| \| FairLinesOptions.cs \| \| \| FairLinesResult.cs \| \| \| IFairLinesEngine.cs \| \| \| IStartingLineupResolver.cs \| \| \| NbaProjectionService.cs \| \| \| ProjectionResult.cs \| \| \| StartingLineupResolver.cs \| +---Queries \| \| +---Agents \| \| \| \| AaiRunsQuery.cs \| \| +---Games \| \| \| \| GameRow.cs \| \| \| \| GamesQuery.cs \| \| \| \| IGamesQuery.cs \| \| +---Matchup \| \| \| \| IMatchupQuery.cs \| \| \| \| MatchupQuery.cs \| \| \| \| MatchupVm.cs \| \| +---Player \| \| \| \| IPlayerQuery.cs \| \| \| \| PlayerQuery.cs \| \| +---Teams \| \| \| \| ISyncTeamStatsQuery.cs \| \| \| \| ITeamQuery.cs \| \| \| \| ITeamsQuery.cs \| \| \| \| SyncTeamStatsQuery.cs \| \| \| \| TeamQuery.cs \| \| \| \| TeamsQuery.cs \| +---Sync \| \| +---GameSync \| \| \| \| GameSyncOrchestrator.cs \| \| \| \| IGameSyncOrchestrator.cs \| \| +---Modules \| \| \| +---Impl \| \| \| \| \| PlayerSnapshotBuilder.cs \| \| \| \| \| PlayerSync.cs \| \| \| \| \| ScheduleSync.cs \| \| \| \| \| TeamStatsSync.cs \| \| \| \| IPlayerSnapshotBuilder.cs \| \| \| \| IPlayerSync.cs \| \| \| \| IScheduleSync.cs \| \| \| \| ITeamStatsSync.cs \| \| \| ISeasonResolver.cs \| \| \| ISyncCenter.cs \| \| \| NbaSeedService.cs \| \| \| SeasonResolver.cs \| \| \| SyncCenter.cs \| \| \| SyncOptions.cs \| \| \| SyncResult.cs \| \| \| SyncTeamStatsUseCase.cs \| +---Time \| \| \| CostaRicaAppClock.cs \| \| \| IAppClock.cs +---Data \| \| AppDbContext.cs \| \| AppDbContextFactory.cs +---docs \| \| AGENT_EF_PATTERN.md \| \| AGENT_RULES.md \| \| AGENTS.md \| \| ARCHITECTURE.md \| \| CODING_RULES.md \| \| CODING_STANDARDS.md \| \| PR_TEMPLATE.md \| \| PRICING_MODEL_CONTRACT.md \| \| ROADMAP.md \| \| TASKS.md +---Domain \| +---Entities \| \| +---Agents \| \| \| +---Enums \| \| \| \| \| AaiApplyResult.cs \| \| \| \| \| AaiDotnetExecutionType.cs \| \| \| \| \| AaiGuardSeverity.cs \| \| \| \| \| AaiMessageRole.cs \| \| \| \| \| AaiRunStatus.cs \| \| \| \| \| AaiStepStatus.cs \| \| \| \| \| AaiStepType.cs \| \| \| \| AaiAgentMessage.cs \| \| \| \| AaiAgentPatch.cs \| \| \| \| AaiAgentPatchSet.cs \| \| \| \| AaiAgentRun.cs \| \| \| \| AaiAgentRunStep.cs \| \| \| \| AaiDotnetExecution.cs \| \| \| \| AaiGuardReport.cs \| \| \| \| AaiGuardViolation.cs \| \| \| \| AaiPatchApplyAttempt.cs \| \| \| \| AaiPatchPreflightReport.cs \| \| \| \| AaiPatchPreflightViolation.cs \| \| \| \| AaiRepoFileSnapshot.cs \| \| \| NbaGame.cs \| \| \| NbaPlayer.cs \| \| \| NbaPlayerGameStat.cs \| \| \| NbaPlayerRelevanceSnapshot.cs \| \| \| NbaPlayerRollingStatsSnapshot.cs \| \| \| NbaPlayerTeam.cs \| \| \| NbaSeason.cs \| \| \| NbaTeam.cs \| \| \| NbaTeamStatsSnapshot.cs \| +---Enum \| +---ValueObjects +---Infrastructure \| +---NbaStats \| \| \| NbaScheduleClient.cs \| \| \| NbaStatsClient.cs \| \| \| NbaStatsService.cs \| +---Time +---Migrations \| \| 20260212223141_Init.cs \| \| 20260212223141_Init.Designer.cs \| \| 20260213025511_NbaSchemaV1.cs \| \| 20260213025511_NbaSchemaV1.Designer.cs \| \| 20260218153318_Reconcile_NbaTeams_LogoUrl.cs \| \| 20260218153318_Reconcile_NbaTeams_LogoUrl.Designer.cs \| \| 20260218153704_AddAaiAgenticSchema.cs \| \| 20260218153704_AddAaiAgenticSchema.Designer.cs \| \| 20260218154538_Repair_AaiAgenticSchema.cs \| \| 20260218154538_Repair_AaiAgenticSchema.Designer.cs \| \| 20260218154908_Repair_AaiAgenticSchema2.cs \| \| 20260218154908_Repair_AaiAgenticSchema2.Designer.cs \| \| 20260218224121_AddAaiPatchPreflight.cs \| \| 20260218224121_AddAaiPatchPreflight.Designer.cs \| \| 20260218231615_Aai_ApplyAttempt_CommitFields.cs \| \| 20260218231615_Aai_ApplyAttempt_CommitFields.Designer.cs \| \| 20260219003652_Aai_Latest_Updates.cs \| \| 20260219003652_Aai_Latest_Updates.Designer.cs \| \| AppDbContextModelSnapshot.cs +---Pages \| +---Agents \| \| +---Runs \| \| \| +---Partials \| \| \| \| \| _AutopilotTimeline.cshtml \| \| \| \| \| _ExecutionsCard.cshtml \| \| \| \| \| _GuardCard.cshtml \| \| \| \| \| _LivePipeline.cshtml \| \| \| \| \| _LivePipelineScripts.cshtml \| \| \| \| \| _OverviewAndStats.cshtml \| \| \| \| \| _PatchSetsCard.cshtml \| \| \| \| \| _RepoSnapshotsCard.cshtml \| \| \| \| \| _ReviewerOutput.cshtml \| \| \| \| \| _RunActions.cshtml \| \| \| \| \| _RunHeader.cshtml \| \| \| \| \| _StatusBanner.cshtml \| \| \| \| \| _StepsTable.cshtml \| \| \| \| Details.cshtml \| \| \| \| Details.cshtml.cs \| \| \| Index.cshtml \| \| \| Index.cshtml.cs \| +---Nba \| \| \| Games.cshtml \| \| \| Games.cshtml.cs \| \| \| Matchup.cshtml \| \| \| Matchup.cshtml.cs \| \| \| Player.cshtml \| \| \| Player.cshtml.cs \| \| \| Sync.cshtml \| \| \| Sync.cshtml.cs \| \| \| SyncTeamStats.cshtml \| \| \| SyncTeamStats.cshtml.cs \| \| \| Team.cshtml \| \| \| Team.cshtml.cs \| \| \| Teams.cshtml \| \| \| Teams.cshtml.cs \| +---Shared \| \| \| _Layout.cshtml \| \| \| _Layout.cshtml.css \| \| \| _ValidationScriptsPartial.cshtml \| \| _ViewImports.cshtml \| \| _ViewStart.cshtml \| \| Error.cshtml \| \| Error.cshtml.cs \| \| Index.cshtml \| \| Index.cshtml.cs \| \| Privacy.cshtml \| \| Privacy.cshtml.cs +---Properties \| \| AssemblyInfo.cs \| \| launchSettings.json +---wwwroot \| +---css \| \| \| poc.css \| \| \| site.css \| +---img \| \| +---nba \| \| \| +---76ers \| \| \| \| \| logo.png \| \| \| +---allstar \| \| \| \| \| logo.png \| \| \| +---bucks \| \| \| \| \| logo.png \| \| \| +---bulls \| \| \| \| \| logo.png \| \| \| +---cavs \| \| \| \| \| logo.png \| \| \| +---celtics \| \| \| \| \| logo.png \| \| \| +---clippers \| \| \| \| \| logo.png \| \| \| +---grizzlies \| \| \| \| \| logo.png \| \| \| +---gs \| \| \| \| \| logo.png \| \| \| +---hawks \| \| \| \| \| logo.png \| \| \| +---heat \| \| \| \| \| logo.png \| \| \| +---hornets \| \| \| \| \| logo.png \| \| \| +---jazz \| \| \| \| \| logo.png \| \| \| +---kings \| \| \| \| \| logo.png \| \| \| +---knicks \| \| \| \| \| logo.png \| \| \| +---lakers \| \| \| \| \| logo.png \| \| \| +---magic \| \| \| \| \| logo.png \| \| \| +---mavs \| \| \| \| \| logo.png \| \| \| +---nets \| \| \| \| \| logo.png \| \| \| +---nuguets \| \| \| \| \| logo.png \| \| \| +---pacers \| \| \| \| \| logo.png \| \| \| +---pelicans \| \| \| \| \| logo.png \| \| \| +---pistons \| \| \| \| \| logo.png \| \| \| +---raptors \| \| \| \| \| logo.png \| \| \| +---rockets \| \| \| \| \| logo.png \| \| \| +---spurs \| \| \| \| \| logo.png \| \| \| +---suns \| \| \| \| \| logo.png \| \| \| +---thunder \| \| \| \| \| logo.png \| \| \| +---trailblazers \| \| \| \| \| logo.png \| \| \| +---wizards \| \| \| \| \| logo.png \| \| \| +---wolves \| \| \| \| \| logo.png \| +---js \| \| \| site.js \| +---lib \| \| +---bootstrap \| \| \| +---dist \| \| \| \| +---css \| \| \| \| \| \| bootstrap-grid.css \| \| \| \| \| \| bootstrap-grid.css.map \| \| \| \| \| \| bootstrap-grid.min.css \| \| \| \| \| \| bootstrap-grid.min.css.map \| \| \| \| \| \| bootstrap-grid.rtl.css \| \| \| \| \| \| bootstrap-grid.rtl.css.map \| \| \| \| \| \| bootstrap-grid.rtl.min.css \| \| \| \| \| \| bootstrap-grid.rtl.min.css.map \| \| \| \| \| \| bootstrap-reboot.css \| \| \| \| \| \| bootstrap-reboot.css.map \| \| \| \| \| \| bootstrap-reboot.min.css \| \| \| \| \| \| bootstrap-reboot.min.css.map \| \| \| \| \| \| bootstrap-reboot.rtl.css \| \| \| \| \| \| bootstrap-reboot.rtl.css.map \| \| \| \| \| \| bootstrap-reboot.rtl.min.css \| \| \| \| \| \| bootstrap-reboot.rtl.min.css.map \| \| \| \| \| \| bootstrap-utilities.css \| \| \| \| \| \| bootstrap-utilities.css.map \| \| \| \| \| \| bootstrap-utilities.min.css \| \| \| \| \| \| bootstrap-utilities.min.css.map \| \| \| \| \| \| bootstrap-utilities.rtl.css \| \| \| \| \| \| bootstrap-utilities.rtl.css.map \| \| \| \| \| \| bootstrap-utilities.rtl.min.css \| \| \| \| \| \| bootstrap-utilities.rtl.min.css.map \| \| \| \| \| \| bootstrap.css \| \| \| \| \| \| bootstrap.css.map \| \| \| \| \| \| bootstrap.min.css \| \| \| \| \| \| bootstrap.min.css.map \| \| \| \| \| \| bootstrap.rtl.css \| \| \| \| \| \| bootstrap.rtl.css.map \| \| \| \| \| \| bootstrap.rtl.min.css \| \| \| \| \| \| bootstrap.rtl.min.css.map \| \| \| \| +---js \| \| \| \| \| \| bootstrap.bundle.js \| \| \| \| \| \| bootstrap.bundle.js.map \| \| \| \| \| \| bootstrap.bundle.min.js \| \| \| \| \| \| bootstrap.bundle.min.js.map \| \| \| \| \| \| bootstrap.esm.js \| \| \| \| \| \| bootstrap.esm.js.map \| \| \| \| \| \| bootstrap.esm.min.js \| \| \| \| \| \| bootstrap.esm.min.js.map \| \| \| \| \| \| bootstrap.js \| \| \| \| \| \| bootstrap.js.map \| \| \| \| \| \| bootstrap.min.js \| \| \| \| \| \| bootstrap.min.js.map \| \| \| \| LICENSE \| \| +---jquery \| \| \| +---dist \| \| \| \| \| jquery.js \| \| \| \| \| jquery.min.js \| \| \| \| \| jquery.min.map \| \| \| \| \| jquery.slim.js \| \| \| \| \| jquery.slim.min.js \| \| \| \| \| jquery.slim.min.map \| \| \| \| LICENSE.txt \| \| +---jquery-validation \| \| \| +---dist \| \| \| \| \| additional-methods.js \| \| \| \| \| additional-methods.min.js \| \| \| \| \| jquery.validate.js \| \| \| \| \| jquery.validate.min.js \| \| \| \| LICENSE.md \| \| +---jquery-validation-unobtrusive \| \| \| +---dist \| \| \| \| \| jquery.validate.unobtrusive.js \| \| \| \| \| jquery.validate.unobtrusive.min.js \| \| \| \| LICENSE.txt \| \| +---microsoft \| \| \| +---signalr \| \| \| \| +---dist \| \| \| \| \| +---browser \| \| \| \| \| \| \| signalr.min.js \| \| favicon.ico \| appsettings.Development.json \| appsettings.json \| BettingOdds.csproj \| libman.json \| Program.cs RULES: Assistant planner_schema UTC: 2026-02-20 02:48:57 {"summary":"Add domain entities and EF mapping for NBA injury snapshot storage (batch \u002B snapshots), create EF migration and update DB. Use fluent configuration in AppDbContext with proper lengths, indexes (including filtered unique indexes to safely handle nullable PlayerId), FK with Restrict, enum stored as int, and nvarchar(max) for raw JSON. Ensure snapshots support multiple pulls/day via AsOfUtc and PulledAtUtc.","plan":["Create domain enum: Domain/Enum/NbaInjuryStatus.cs containing public enum NbaInjuryStatus { Unknown = 0, Available = 1, Probable = 2, Questionable = 3, Doubtful = 4, Out = 5 }. Domain project only; no EF attributes.","Create batch entity: Domain/Entities/NbaInjurySnapshotBatch.cs with properties: long Id (identity PK), string SourceName, DateTime PulledAtUtc (UTC), int? SeasonId, string? Notes, string BatchGuid (or BatchKey) and ICollection\u003CNbaPlayerInjurySnapshot\u003E PlayerInjuries. No EF attributes. Ensure DateTime usage is UTC by convention (no conversion here).","Create snapshot entity: Domain/Entities/NbaPlayerInjurySnapshot.cs with properties: long Id (identity PK), long BatchId, NbaInjurySnapshotBatch? Batch, DateTime AsOfUtc, int TeamId, long? PlayerId, string PlayerName, NbaInjuryStatus Status, string? Description, DateTime? ReturnDateUtc, bool IsMapped, string? RawJson, DateTime CreatedUtc. No EF attributes.","Update AppDbContext (Data/AppDbContext.cs): Add DbSet\u003CNbaInjurySnapshotBatch\u003E NbaInjurySnapshotBatches and DbSet\u003CNbaPlayerInjurySnapshot\u003E NbaPlayerInjurySnapshots.","In AppDbContext.OnModelCreating configure mapping via Fluent API:","- Map tables: \u0027NbaInjurySnapshotBatch\u0027 and \u0027NbaPlayerInjurySnapshot\u0027.","- Configure PKs: Id on both tables (identity).","- Batch fields: SourceName max length 40 (required), PulledAtUtc required, SeasonId optional, Notes optional (nvarchar(300) or smaller?), BatchGuid/BatchKey max length 100 (choose 100) or required as appropriate. Add non-unique index on (SourceName, PulledAtUtc).","- Snapshot fields: BatchId FK required, AsOfUtc required, TeamId required, PlayerId nullable, PlayerName required max length 80, Status stored as int, Description nullable max length 300, ReturnDateUtc nullable, IsMapped required, RawJson as nvarchar(max) (no length limit), CreatedUtc required.","- Configure FK relationship: NbaPlayerInjurySnapshot -\u003E NbaInjurySnapshotBatch with HasForeignKey(b =\u003E b.BatchId) and OnDelete(DeleteBehavior.Restrict) (SQL RESTRICT behavior).","- Configure indexes:"," * Non-unique index on NbaPlayerInjurySnapshot (TeamId, AsOfUtc) to support lookups by team snapshot times."," * Non-unique index on NbaPlayerInjurySnapshot (PlayerId, AsOfUtc) to support player-time lookups (PlayerId is nullable; index still created)."," * Create safe uniqueness using two filtered unique indexes to handle nullable PlayerId:"," - Unique index for mapped rows: (BatchId, TeamId, PlayerId) WHERE PlayerId IS NOT NULL."," - Unique index for unmapped rows: (BatchId, TeamId, PlayerName) WHERE PlayerId IS NULL."," This prevents duplicate entries per batch/team for the same player whether mapped or not while avoiding null-related uniqueness problems.","- Make sure Status is configured to be stored as integer with HasConversion\u003Cint\u003E() or HasColumnType(\u0022int\u0022).","- Configure PlayerName length 80, SourceName length 40, Description length 300 and RawJson as HasColumnType(\u0022nvarchar(max)\u0022).","- Add index on Batch (SourceName, PulledAtUtc) as non-unique to support queries for source/time.","Add appropriate comments in AppDbContext mapping explaining indexes and UTC conventions so reviewers understand decisions.","Add a new EF migration: from solution root run \u0027dotnet ef migrations add AddNbaInjuries --project BettingOdds.csproj --startup-project BettingOdds.csproj --context AppDbContext -o Migrations\u0027 (adjust paths if migration folder differs).","Inspect the generated migration to ensure:","- Tables created with correct column types, lengths, nullable settings.","- FK created with OnDelete: Restrict (DeleteBehavior.Restrict) translated to SQL.","- Indexes present: (SourceName, PulledAtUtc) on batch; (TeamId, AsOfUtc) and (PlayerId, AsOfUtc) on snapshot; filtered unique indexes as created (HasFilter strings in migration).","Apply migration to DB: \u0027dotnet ef database update --project BettingOdds.csproj --startup-project BettingOdds.csproj --context AppDbContext\u0027.","Run full solution build and tests (if any): \u0027dotnet build\u0027 and run test projects to ensure migration compiles and no domain references break.","Reviewer validation checklist (add to PR description):","- Snapshots support multiple pulls/day: Batch.PulledAtUtc records each pull; Snapshot.AsOfUtc stores precise snapshot time. Indexes include AsOfUtc to allow multiple per-day snapshots.","- Indexes are scalable: per-team and per-player time-based indexes are narrow and use ints/longs \u002B datetime; filtered unique indexes minimize uniqueness conflicts and keep uniqueness checks targeted (only mapped vs unmapped rows).","- Migration builds: confirm generated migration compiles and AppDbContextModelSnapshot updated. If using SQL Server, filtered indexes use HasFilter with SQL \u0027PlayerId IS NOT NULL\u0027 / \u0027PlayerId IS NULL\u0027. For other providers adjust or use computed/coalesced indexes if necessary.","Files to add/modify (exact paths):","- Add: Domain/Enum/NbaInjuryStatus.cs","- Add: Domain/Entities/NbaInjurySnapshotBatch.cs","- Add: Domain/Entities/NbaPlayerInjurySnapshot.cs","- Modify: Data/AppDbContext.cs (add DbSet\u003C\u003E props and OnModelCreating fluent mapping).","- Add migration files under Migrations (via dotnet ef migrations add).","Notes and implementation considerations:","- Keep Domain project free of EF attributes; all EF configuration belongs in Data/AppDbContext.","- Use DateTime (not DateTimeOffset) for UTC timestamps per project conventions; ensure all code stores Utc times (CreatedUtc, PulledAtUtc, AsOfUtc).","- Use nvarchar(max) for RawJson to support large payloads. Use reasonable max length for BatchGuid/BatchKey (e.g., 100) if included; choose varchar size consistent with other keys in project.","- If target DB is not SQL Server, the filtered unique index syntax may require provider-specific adjustments. If cross-provider support is required, an alternative is to enforce uniqueness in application logic \u002B a non-unique DB index; mention this in PR if needed.","- Include migration SQL check by running \u0027dotnet ef migrations script -o add_nba_injuries.sql\u0027 and reviewing DDL for indexes and FK ON DELETE behavior."]}
Implementer	Running	2026-02-19 18:49:04	—	—	gpt-5-mini	1
Step messages User implementer_schema UTC: 2026-02-20 02:49:08 ATTEMPT 1/3 TASK: TASK: Implement NBA Injury storage schema (snapshots, enterprise-grade) using EF migrations. Requirements • Create Domain entities only (no EF attributes) for injuries: o NbaInjurySnapshotBatch (identity PK; SourceName, PulledAtUtc, optional SeasonId, optional Notes, BatchGuid or BatchKey string) o NbaPlayerInjurySnapshot (identity PK; FK to batch; AsOfUtc (or use batch PulledAtUtc); TeamId int; nullable PlayerId long?; PlayerName string; Status enum; Description string?; ReturnDateUtc DateTime?; IsMapped bool; RawJson string?; CreatedUtc) o Enum NbaInjuryStatus (Unknown, Available, Probable, Questionable, Doubtful, Out) • Update AppDbContext: o Add DbSets o Configure tables, keys, FK batch→snapshots (Restrict) o String max lengths (PlayerName 80, SourceName 40, Status as int, Description 300, RawJson max) o Indexes:  Batch: (SourceName, PulledAtUtc)  Snapshot: (TeamId, AsOfUtc) and (PlayerId, AsOfUtc) (PlayerId nullable -> still index)  Snapshot unique: (BatchId, TeamId, PlayerName) (or (BatchId, TeamId, PlayerId) if mapped) — choose safe uniqueness • Add migration + update DB Constraints • Domain doesn’t depend on anything. • DbContext not used from Pages. • UTC everywhere. Deliverable • PatchSet containing entity files + DbContext mapping + migration. Reviewer must validate • Snapshot model supports multiple pulls/day • Indexes are sane and scalable • Migration builds PLAN: - Create domain enum: Domain/Enum/NbaInjuryStatus.cs containing public enum NbaInjuryStatus { Unknown = 0, Available = 1, Probable = 2, Questionable = 3, Doubtful = 4, Out = 5 }. Domain project only; no EF attributes. - Create batch entity: Domain/Entities/NbaInjurySnapshotBatch.cs with properties: long Id (identity PK), string SourceName, DateTime PulledAtUtc (UTC), int? SeasonId, string? Notes, string BatchGuid (or BatchKey) and ICollection<NbaPlayerInjurySnapshot> PlayerInjuries. No EF attributes. Ensure DateTime usage is UTC by convention (no conversion here). - Create snapshot entity: Domain/Entities/NbaPlayerInjurySnapshot.cs with properties: long Id (identity PK), long BatchId, NbaInjurySnapshotBatch? Batch, DateTime AsOfUtc, int TeamId, long? PlayerId, string PlayerName, NbaInjuryStatus Status, string? Description, DateTime? ReturnDateUtc, bool IsMapped, string? RawJson, DateTime CreatedUtc. No EF attributes. - Update AppDbContext (Data/AppDbContext.cs): Add DbSet<NbaInjurySnapshotBatch> NbaInjurySnapshotBatches and DbSet<NbaPlayerInjurySnapshot> NbaPlayerInjurySnapshots. - In AppDbContext.OnModelCreating configure mapping via Fluent API: - - Map tables: 'NbaInjurySnapshotBatch' and 'NbaPlayerInjurySnapshot'. - - Configure PKs: Id on both tables (identity). - - Batch fields: SourceName max length 40 (required), PulledAtUtc required, SeasonId optional, Notes optional (nvarchar(300) or smaller?), BatchGuid/BatchKey max length 100 (choose 100) or required as appropriate. Add non-unique index on (SourceName, PulledAtUtc). - - Snapshot fields: BatchId FK required, AsOfUtc required, TeamId required, PlayerId nullable, PlayerName required max length 80, Status stored as int, Description nullable max length 300, ReturnDateUtc nullable, IsMapped required, RawJson as nvarchar(max) (no length limit), CreatedUtc required. - - Configure FK relationship: NbaPlayerInjurySnapshot -> NbaInjurySnapshotBatch with HasForeignKey(b => b.BatchId) and OnDelete(DeleteBehavior.Restrict) (SQL RESTRICT behavior). - - Configure indexes: - * Non-unique index on NbaPlayerInjurySnapshot (TeamId, AsOfUtc) to support lookups by team snapshot times. - * Non-unique index on NbaPlayerInjurySnapshot (PlayerId, AsOfUtc) to support player-time lookups (PlayerId is nullable; index still created). - * Create safe uniqueness using two filtered unique indexes to handle nullable PlayerId: - - Unique index for mapped rows: (BatchId, TeamId, PlayerId) WHERE PlayerId IS NOT NULL. - - Unique index for unmapped rows: (BatchId, TeamId, PlayerName) WHERE PlayerId IS NULL. - This prevents duplicate entries per batch/team for the same player whether mapped or not while avoiding null-related uniqueness problems. - - Make sure Status is configured to be stored as integer with HasConversion<int>() or HasColumnType("int"). - - Configure PlayerName length 80, SourceName length 40, Description length 300 and RawJson as HasColumnType("nvarchar(max)"). - - Add index on Batch (SourceName, PulledAtUtc) as non-unique to support queries for source/time. - Add appropriate comments in AppDbContext mapping explaining indexes and UTC conventions so reviewers understand decisions. - Add a new EF migration: from solution root run 'dotnet ef migrations add AddNbaInjuries --project BettingOdds.csproj --startup-project BettingOdds.csproj --context AppDbContext -o Migrations' (adjust paths if migration folder differs). - Inspect the generated migration to ensure: - - Tables created with correct column types, lengths, nullable settings. - - FK created with OnDelete: Restrict (DeleteBehavior.Restrict) translated to SQL. - - Indexes present: (SourceName, PulledAtUtc) on batch; (TeamId, AsOfUtc) and (PlayerId, AsOfUtc) on snapshot; filtered unique indexes as created (HasFilter strings in migration). - Apply migration to DB: 'dotnet ef database update --project BettingOdds.csproj --startup-project BettingOdds.csproj --context AppDbContext'. - Run full solution build and tests (if any): 'dotnet build' and run test projects to ensure migration compiles and no domain references break. - Reviewer validation checklist (add to PR description): - - Snapshots support multiple pulls/day: Batch.PulledAtUtc records each pull; Snapshot.AsOfUtc stores precise snapshot time. Indexes include AsOfUtc to allow multiple per-day snapshots. - - Indexes are scalable: per-team and per-player time-based indexes are narrow and use ints/longs + datetime; filtered unique indexes minimize uniqueness conflicts and keep uniqueness checks targeted (only mapped vs unmapped rows). - - Migration builds: confirm generated migration compiles and AppDbContextModelSnapshot updated. If using SQL Server, filtered indexes use HasFilter with SQL 'PlayerId IS NOT NULL' / 'PlayerId IS NULL'. For other providers adjust or use computed/coalesced indexes if necessary. - Files to add/modify (exact paths): - - Add: Domain/Enum/NbaInjuryStatus.cs - - Add: Domain/Entities/NbaInjurySnapshotBatch.cs - - Add: Domain/Entities/NbaPlayerInjurySnapshot.cs - - Modify: Data/AppDbContext.cs (add DbSet<> props and OnModelCreating fluent mapping). - - Add migration files under Migrations (via dotnet ef migrations add). - Notes and implementation considerations: - - Keep Domain project free of EF attributes; all EF configuration belongs in Data/AppDbContext. - - Use DateTime (not DateTimeOffset) for UTC timestamps per project conventions; ensure all code stores Utc times (CreatedUtc, PulledAtUtc, AsOfUtc). - - Use nvarchar(max) for RawJson to support large payloads. Use reasonable max length for BatchGuid/BatchKey (e.g., 100) if included; choose varchar size consistent with other keys in project. - - If target DB is not SQL Server, the filtered unique index syntax may require provider-specific adjustments. If cross-provider support is required, an alternative is to enforce uniqueness in application logic + a non-unique DB index; mention this in PR if needed. - - Include migration SQL check by running 'dotnet ef migrations script -o add_nba_injuries.sql' and reviewing DDL for indexes and FK ON DELETE behavior. SOLUTION TREE: BettingOdds +---App \| +---Agents \| \| +---Autopilot \| \| \| \| AgentAutopilotRunner.cs \| \| \| \| AutopilotOptions.cs \| \| +---Git \| \| \| \| GitRunner.cs \| \| +---Guard \| \| \| \| GuardEvaluator.cs \| \| \| \| GuardPolicyOptions.cs \| \| +---Live \| \| \| \| AaiRunHub.cs \| \| \| \| BackgroundTaskQueue.cs \| \| \| \| IAaiLiveNotifier.cs \| \| \| \| QueuedHostedService.cs \| \| \| \| SignalRAaiLiveNotifier.cs \| \| +---Models \| \| \| \| AgentPatch.cs \| \| \| \| AgentPolicyGuard.cs \| \| \| \| AgentRunContext.cs \| \| \| \| AgentRunResult.cs \| \| \| \| IAgentPolicyGuard.cs \| \| +---Patching \| \| \| \| PatchNormalization.cs \| \| \| \| PatchPreflightValidator.cs \| \| \| \| PreflightPolicyOptions.cs \| \| \| \| UnifiedDiffBuilder.cs \| \| +---RunLaunch \| \| \| \| AaiRunLauncher.cs \| \| +---Steps \| \| \| +---Models \| \| \| \| \| ImplementerInput.cs \| \| \| \| \| PlannerInput.cs \| \| \| \| \| ReviewerInput.cs \| \| \| \| AgentJson.cs \| \| \| \| IAgentStep.cs \| \| \| \| ImplementerAgent.cs \| \| \| \| PlannerAgent.cs \| \| \| \| ReviewerAgent.cs \| \| +---Tests \| \| \| \| TestAuthorAgent.cs \| \| \| AaiRunWriter.cs \| \| \| AgentOrchestrator.cs \| \| \| AgentPolicyOptions.cs \| \| \| CommandPolicy.cs \| \| \| DiffApplier.cs \| \| \| DotnetRunner.cs \| \| \| OpenAiOptions.cs \| \| \| OpenAiResponsesClient.cs \| \| \| RepoFileService.cs \| +---Dtos \| \| \| NbaTeamAdvancedRow.cs \| +---Pricing \| \| \| FairLinesEngine.cs \| \| \| FairLinesMath.cs \| \| \| FairLinesOptions.cs \| \| \| FairLinesResult.cs \| \| \| IFairLinesEngine.cs \| \| \| IStartingLineupResolver.cs \| \| \| NbaProjectionService.cs \| \| \| ProjectionResult.cs \| \| \| StartingLineupResolver.cs \| +---Queries \| \| +---Agents \| \| \| \| AaiRunsQuery.cs \| \| +---Games \| \| \| \| GameRow.cs \| \| \| \| GamesQuery.cs \| \| \| \| IGamesQuery.cs \| \| +---Matchup \| \| \| \| IMatchupQuery.cs \| \| \| \| MatchupQuery.cs \| \| \| \| MatchupVm.cs \| \| +---Player \| \| \| \| IPlayerQuery.cs \| \| \| \| PlayerQuery.cs \| \| +---Teams \| \| \| \| ISyncTeamStatsQuery.cs \| \| \| \| ITeamQuery.cs \| \| \| \| ITeamsQuery.cs \| \| \| \| SyncTeamStatsQuery.cs \| \| \| \| TeamQuery.cs \| \| \| \| TeamsQuery.cs \| +---Sync \| \| +---GameSync \| \| \| \| GameSyncOrchestrator.cs \| \| \| \| IGameSyncOrchestrator.cs \| \| +---Modules \| \| \| +---Impl \| \| \| \| \| PlayerSnapshotBuilder.cs \| \| \| \| \| PlayerSync.cs \| \| \| \| \| ScheduleSync.cs \| \| \| \| \| TeamStatsSync.cs \| \| \| \| IPlayerSnapshotBuilder.cs \| \| \| \| IPlayerSync.cs \| \| \| \| IScheduleSync.cs \| \| \| \| ITeamStatsSync.cs \| \| \| ISeasonResolver.cs \| \| \| ISyncCenter.cs \| \| \| NbaSeedService.cs \| \| \| SeasonResolver.cs \| \| \| SyncCenter.cs \| \| \| SyncOptions.cs \| \| \| SyncResult.cs \| \| \| SyncTeamStatsUseCase.cs \| +---Time \| \| \| CostaRicaAppClock.cs \| \| \| IAppClock.cs +---Data \| \| AppDbContext.cs \| \| AppDbContextFactory.cs +---docs \| \| AGENT_EF_PATTERN.md \| \| AGENT_RULES.md \| \| AGENTS.md \| \| ARCHITECTURE.md \| \| CODING_RULES.md \| \| CODING_STANDARDS.md \| \| PR_TEMPLATE.md \| \| PRICING_MODEL_CONTRACT.md \| \| ROADMAP.md \| \| TASKS.md +---Domain \| +---Entities \| \| +---Agents \| \| \| +---Enums \| \| \| \| \| AaiApplyResult.cs \| \| \| \| \| AaiDotnetExecutionType.cs \| \| \| \| \| AaiGuardSeverity.cs \| \| \| \| \| AaiMessageRole.cs \| \| \| \| \| AaiRunStatus.cs \| \| \| \| \| AaiStepStatus.cs \| \| \| \| \| AaiStepType.cs \| \| \| \| AaiAgentMessage.cs \| \| \| \| AaiAgentPatch.cs \| \| \| \| AaiAgentPatchSet.cs \| \| \| \| AaiAgentRun.cs \| \| \| \| AaiAgentRunStep.cs \| \| \| \| AaiDotnetExecution.cs \| \| \| \| AaiGuardReport.cs \| \| \| \| AaiGuardViolation.cs \| \| \| \| AaiPatchApplyAttempt.cs \| \| \| \| AaiPatchPreflightReport.cs \| \| \| \| AaiPatchPreflightViolation.cs \| \| \| \| AaiRepoFileSnapshot.cs \| \| \| NbaGame.cs \| \| \| NbaPlayer.cs \| \| \| NbaPlayerGameStat.cs \| \| \| NbaPlayerRelevanceSnapshot.cs \| \| \| NbaPlayerRollingStatsSnapshot.cs \| \| \| NbaPlayerTeam.cs \| \| \| NbaSeason.cs \| \| \| NbaTeam.cs \| \| \| NbaTeamStatsSnapshot.cs \| +---Enum \| +---ValueObjects +---Infrastructure \| +---NbaStats \| \| \| NbaScheduleClient.cs \| \| \| NbaStatsClient.cs \| \| \| NbaStatsService.cs \| +---Time +---Migrations \| \| 20260212223141_Init.cs \| \| 20260212223141_Init.Designer.cs \| \| 20260213025511_NbaSchemaV1.cs \| \| 20260213025511_NbaSchemaV1.Designer.cs \| \| 20260218153318_Reconcile_NbaTeams_LogoUrl.cs \| \| 20260218153318_Reconcile_NbaTeams_LogoUrl.Designer.cs \| \| 20260218153704_AddAaiAgenticSchema.cs \| \| 20260218153704_AddAaiAgenticSchema.Designer.cs \| \| 20260218154538_Repair_AaiAgenticSchema.cs \| \| 20260218154538_Repair_AaiAgenticSchema.Designer.cs \| \| 20260218154908_Repair_AaiAgenticSchema2.cs \| \| 20260218154908_Repair_AaiAgenticSchema2.Designer.cs \| \| 20260218224121_AddAaiPatchPreflight.cs \| \| 20260218224121_AddAaiPatchPreflight.Designer.cs \| \| 20260218231615_Aai_ApplyAttempt_CommitFields.cs \| \| 20260218231615_Aai_ApplyAttempt_CommitFields.Designer.cs \| \| 20260219003652_Aai_Latest_Updates.cs \| \| 20260219003652_Aai_Latest_Updates.Designer.cs \| \| AppDbContextModelSnapshot.cs +---Pages \| +---Agents \| \| +---Runs \| \| \| +---Partials \| \| \| \| \| _AutopilotTimeline.cshtml \| \| \| \| \| _ExecutionsCard.cshtml \| \| \| \| \| _GuardCard.cshtml \| \| \| \| \| _LivePipeline.cshtml \| \| \| \| \| _LivePipelineScripts.cshtml \| \| \| \| \| _OverviewAndStats.cshtml \| \| \| \| \| _PatchSetsCard.cshtml \| \| \| \| \| _RepoSnapshotsCard.cshtml \| \| \| \| \| _ReviewerOutput.cshtml \| \| \| \| \| _RunActions.cshtml \| \| \| \| \| _RunHeader.cshtml \| \| \| \| \| _StatusBanner.cshtml \| \| \| \| \| _StepsTable.cshtml \| \| \| \| Details.cshtml \| \| \| \| Details.cshtml.cs \| \| \| Index.cshtml \| \| \| Index.cshtml.cs \| +---Nba \| \| \| Games.cshtml \| \| \| Games.cshtml.cs \| \| \| Matchup.cshtml \| \| \| Matchup.cshtml.cs \| \| \| Player.cshtml \| \| \| Player.cshtml.cs \| \| \| Sync.cshtml \| \| \| Sync.cshtml.cs \| \| \| SyncTeamStats.cshtml \| \| \| SyncTeamStats.cshtml.cs \| \| \| Team.cshtml \| \| \| Team.cshtml.cs \| \| \| Teams.cshtml \| \| \| Teams.cshtml.cs \| +---Shared \| \| \| _Layout.cshtml \| \| \| _Layout.cshtml.css \| \| \| _ValidationScriptsPartial.cshtml \| \| _ViewImports.cshtml \| \| _ViewStart.cshtml \| \| Error.cshtml \| \| Error.cshtml.cs \| \| Index.cshtml \| \| Index.cshtml.cs \| \| Privacy.cshtml \| \| Privacy.cshtml.cs +---Properties \| \| AssemblyInfo.cs \| \| launchSettings.json +---wwwroot \| +---css \| \| \| poc.css \| \| \| site.css \| +---img \| \| +---nba \| \| \| +---76ers \| \| \| \| \| logo.png \| \| \| +---allstar \| \| \| \| \| logo.png \| \| \| +---bucks \| \| \| \| \| logo.png \| \| \| +---bulls \| \| \| \| \| logo.png \| \| \| +---cavs \| \| \| \| \| logo.png \| \| \| +---celtics \| \| \| \| \| logo.png \| \| \| +---clippers \| \| \| \| \| logo.png \| \| \| +---grizzlies \| \| \| \| \| logo.png \| \| \| +---gs \| \| \| \| \| logo.png \| \| \| +---hawks \| \| \| \| \| logo.png \| \| \| +---heat \| \| \| \| \| logo.png \| \| \| +---hornets \| \| \| \| \| logo.png \| \| \| +---jazz \| \| \| \| \| logo.png \| \| \| +---kings \| \| \| \| \| logo.png \| \| \| +---knicks \| \| \| \| \| logo.png \| \| \| +---lakers \| \| \| \| \| logo.png \| \| \| +---magic \| \| \| \| \| logo.png \| \| \| +---mavs \| \| \| \| \| logo.png \| \| \| +---nets \| \| \| \| \| logo.png \| \| \| +---nuguets \| \| \| \| \| logo.png \| \| \| +---pacers \| \| \| \| \| logo.png \| \| \| +---pelicans \| \| \| \| \| logo.png \| \| \| +---pistons \| \| \| \| \| logo.png \| \| \| +---raptors \| \| \| \| \| logo.png \| \| \| +---rockets \| \| \| \| \| logo.png \| \| \| +---spurs \| \| \| \| \| logo.png \| \| \| +---suns \| \| \| \| \| logo.png \| \| \| +---thunder \| \| \| \| \| logo.png \| \| \| +---trailblazers \| \| \| \| \| logo.png \| \| \| +---wizards \| \| \| \| \| logo.png \| \| \| +---wolves \| \| \| \| \| logo.png \| +---js \| \| \| site.js \| +---lib \| \| +---bootstrap \| \| \| +---dist \| \| \| \| +---css \| \| \| \| \| \| bootstrap-grid.css \| \| \| \| \| \| bootstrap-grid.css.map \| \| \| \| \| \| bootstrap-grid.min.css \| \| \| \| \| \| bootstrap-grid.min.css.map \| \| \| \| \| \| bootstrap-grid.rtl.css \| \| \| \| \| \| bootstrap-grid.rtl.css.map \| \| \| \| \| \| bootstrap-grid.rtl.min.css \| \| \| \| \| \| bootstrap-grid.rtl.min.css.map \| \| \| \| \| \| bootstrap-reboot.css \| \| \| \| \| \| bootstrap-reboot.css.map \| \| \| \| \| \| bootstrap-reboot.min.css \| \| \| \| \| \| bootstrap-reboot.min.css.map \| \| \| \| \| \| bootstrap-reboot.rtl.css \| \| \| \| \| \| bootstrap-reboot.rtl.css.map \| \| \| \| \| \| bootstrap-reboot.rtl.min.css \| \| \| \| \| \| bootstrap-reboot.rtl.min.css.map \| \| \| \| \| \| bootstrap-utilities.css \| \| \| \| \| \| bootstrap-utilities.css.map \| \| \| \| \| \| bootstrap-utilities.min.css \| \| \| \| \| \| bootstrap-utilities.min.css.map \| \| \| \| \| \| bootstrap-utilities.rtl.css \| \| \| \| \| \| bootstrap-utilities.rtl.css.map \| \| \| \| \| \| bootstrap-utilities.rtl.min.css \| \| \| \| \| \| bootstrap-utilities.rtl.min.css.map \| \| \| \| \| \| bootstrap.css \| \| \| \| \| \| bootstrap.css.map \| \| \| \| \| \| bootstrap.min.css \| \| \| \| \| \| bootstrap.min.css.map \| \| \| \| \| \| bootstrap.rtl.css \| \| \| \| \| \| bootstrap.rtl.css.map \| \| \| \| \| \| bootstrap.rtl.min.css \| \| \| \| \| \| bootstrap.rtl.min.css.map \| \| \| \| +---js \| \| \| \| \| \| bootstrap.bundle.js \| \| \| \| \| \| bootstrap.bundle.js.map \| \| \| \| \| \| bootstrap.bundle.min.js \| \| \| \| \| \| bootstrap.bundle.min.js.map \| \| \| \| \| \| bootstrap.esm.js \| \| \| \| \| \| bootstrap.esm.js.map \| \| \| \| \| \| bootstrap.esm.min.js \| \| \| \| \| \| bootstrap.esm.min.js.map \| \| \| \| \| \| bootstrap.js \| \| \| \| \| \| bootstrap.js.map \| \| \| \| \| \| bootstrap.min.js \| \| \| \| \| \| bootstrap.min.js.map \| \| \| \| LICENSE \| \| +---jquery \| \| \| +---dist \| \| \| \| \| jquery.js \| \| \| \| \| jquery.min.js \| \| \| \| \| jquery.min.map \| \| \| \| \| jquery.slim.js \| \| \| \| \| jquery.slim.min.js \| \| \| \| \| jquery.slim.min.map \| \| \| \| LICENSE.txt \| \| +---jquery-validation \| \| \| +---dist \| \| \| \| \| additional-methods.js \| \| \| \| \| additional-methods.min.js \| \| \| \| \| jquery.validate.js \| \| \| \| \| jquery.validate.min.js \| \| \| \| LICENSE.md \| \| +---jquery-validation-unobtrusive \| \| \| +---dist \| \| \| \| \| jquery.validate.unobtrusive.js \| \| \| \| \| jquery.validate.unobtrusive.min.js \| \| \| \| LICENSE.txt \| \| +---microsoft \| \| \| +---signalr \| \| \| \| +---dist \| \| \| \| \| +---browser \| \| \| \| \| \| \| signalr.min.js \| \| favicon.ico \| appsettings.Development.json \| appsettings.json \| BettingOdds.csproj \| libman.json \| Program.cs RULES: FILES: # FILE: Migrations/20260212223141_Init.cs using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class Init : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "NbaTeamStatSnapshots", columns: table => new { NbaTeamStatSnapshotId = table.Column<int>(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Season = table.Column<string>(type: "nvarchar(16)", maxLength: 16, nullable: false), SeasonType = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: false), LastNGames = table.Column<int>(type: "int", nullable: false), TeamId = table.Column<int>(type: "int", nullable: false), TeamName = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: false), OffRtg = table.Column<decimal>(type: "decimal(7,3)", nullable: false), DefRtg = table.Column<decimal>(type: "decimal(7,3)", nullable: false), Pace = table.Column<decimal>(type: "decimal(7,3)", nullable: false), NetRtg = table.Column<decimal>(type: "decimal(7,3)", nullable: false), PulledAtUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaTeamStatSnapshots", x => x.NbaTeamStatSnapshotId); }); migrationBuilder.CreateIndex( name: "IX_NbaTeamStatSnapshots_Season_SeasonType_LastNGames_TeamId_PulledAtUtc", table: "NbaTeamStatSnapshots", columns: new[] { "Season", "SeasonType", "LastNGames", "TeamId", "PulledAtUtc" }); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "NbaTeamStatSnapshots"); } } } # FILE: Migrations/20260212223141_Init.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260212223141_Init")] partial class Init { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Models.NbaTeamStatSnapshot", b => { b.Property<int>("NbaTeamStatSnapshotId") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("NbaTeamStatSnapshotId")); b.Property<decimal>("DefRtg") .HasColumnType("decimal(7,3)"); b.Property<int>("LastNGames") .HasColumnType("int"); b.Property<decimal>("NetRtg") .HasColumnType("decimal(7,3)"); b.Property<decimal>("OffRtg") .HasColumnType("decimal(7,3)"); b.Property<decimal>("Pace") .HasColumnType("decimal(7,3)"); b.Property<DateTime>("PulledAtUtc") .HasColumnType("datetime2"); b.Property<string>("Season") .IsRequired() .HasMaxLength(16) .HasColumnType("nvarchar(16)"); b.Property<string>("SeasonType") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.Property<int>("TeamId") .HasColumnType("int"); b.Property<string>("TeamName") .IsRequired() .HasMaxLength(80) .HasColumnType("nvarchar(80)"); b.HasKey("NbaTeamStatSnapshotId"); b.HasIndex("Season", "SeasonType", "LastNGames", "TeamId", "PulledAtUtc"); b.ToTable("NbaTeamStatSnapshots"); }); #pragma warning restore 612, 618 } } } # FILE: Migrations/20260213025511_NbaSchemaV1.cs using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class NbaSchemaV1 : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "NbaTeamStatSnapshots"); migrationBuilder.EnsureSchema( name: "dbo"); migrationBuilder.CreateTable( name: "NbaPlayers", schema: "dbo", columns: table => new { PlayerId = table.Column<int>(type: "int", nullable: false), DisplayName = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: false), FirstName = table.Column<string>(type: "nvarchar(40)", maxLength: 40, nullable: false), LastName = table.Column<string>(type: "nvarchar(40)", maxLength: 40, nullable: false), IsActive = table.Column<bool>(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaPlayers", x => x.PlayerId); }); migrationBuilder.CreateTable( name: "NbaSeasons", schema: "dbo", columns: table => new { SeasonId = table.Column<int>(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), SeasonCode = table.Column<string>(type: "nvarchar(16)", maxLength: 16, nullable: false), SeasonType = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: false), IsActive = table.Column<bool>(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaSeasons", x => x.SeasonId); }); migrationBuilder.CreateTable( name: "NbaTeams", schema: "dbo", columns: table => new { TeamId = table.Column<int>(type: "int", nullable: false), Abbr = table.Column<string>(type: "nvarchar(6)", maxLength: 6, nullable: false), City = table.Column<string>(type: "nvarchar(40)", maxLength: 40, nullable: false), Name = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: false), FullName = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: false), IsActive = table.Column<bool>(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaTeams", x => x.TeamId); }); migrationBuilder.CreateTable( name: "NbaGames", schema: "dbo", columns: table => new { GameId = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false), SeasonId = table.Column<int>(type: "int", nullable: false), GameDateUtc = table.Column<DateTime>(type: "datetime2", nullable: false), Status = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: false), HomeTeamId = table.Column<int>(type: "int", nullable: false), AwayTeamId = table.Column<int>(type: "int", nullable: false), HomeScore = table.Column<int>(type: "int", nullable: true), AwayScore = table.Column<int>(type: "int", nullable: true), Arena = table.Column<string>(type: "nvarchar(120)", maxLength: 120, nullable: true), LastSyncedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaGames", x => x.GameId); table.ForeignKey( name: "FK_NbaGames_NbaSeasons_SeasonId", column: x => x.SeasonId, principalSchema: "dbo", principalTable: "NbaSeasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaGames_NbaTeams_AwayTeamId", column: x => x.AwayTeamId, principalSchema: "dbo", principalTable: "NbaTeams", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaGames_NbaTeams_HomeTeamId", column: x => x.HomeTeamId, principalSchema: "dbo", principalTable: "NbaTeams", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "NbaPlayerRelevanceSnapshots", schema: "dbo", columns: table => new { PlayerRelevanceSnapshotId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), SeasonId = table.Column<int>(type: "int", nullable: false), TeamId = table.Column<int>(type: "int", nullable: false), PlayerId = table.Column<int>(type: "int", nullable: false), AsOfUtc = table.Column<DateTime>(type: "datetime2", nullable: false), RelevanceScore = table.Column<decimal>(type: "decimal(6,2)", nullable: false), RelevanceTier = table.Column<byte>(type: "tinyint", nullable: false), MinutesSharePct = table.Column<decimal>(type: "decimal(6,2)", nullable: true), UsageProxy = table.Column<decimal>(type: "decimal(6,2)", nullable: true), AvailabilityFactor = table.Column<decimal>(type: "decimal(6,4)", nullable: true), RecentMinutesAvg = table.Column<decimal>(type: "decimal(7,2)", nullable: true), BatchId = table.Column<Guid>(type: "uniqueidentifier", nullable: false), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaPlayerRelevanceSnapshots", x => x.PlayerRelevanceSnapshotId); table.ForeignKey( name: "FK_NbaPlayerRelevanceSnapshots_NbaPlayers_PlayerId", column: x => x.PlayerId, principalSchema: "dbo", principalTable: "NbaPlayers", principalColumn: "PlayerId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaPlayerRelevanceSnapshots_NbaSeasons_SeasonId", column: x => x.SeasonId, principalSchema: "dbo", principalTable: "NbaSeasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaPlayerRelevanceSnapshots_NbaTeams_TeamId", column: x => x.TeamId, principalSchema: "dbo", principalTable: "NbaTeams", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "NbaPlayerRollingStatsSnapshots", schema: "dbo", columns: table => new { SnapshotId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), BatchId = table.Column<Guid>(type: "uniqueidentifier", nullable: false), SeasonId = table.Column<int>(type: "int", nullable: false), TeamId = table.Column<int>(type: "int", nullable: false), PlayerId = table.Column<int>(type: "int", nullable: false), LastNGames = table.Column<int>(type: "int", nullable: false), AsOfUtc = table.Column<DateTime>(type: "datetime2", nullable: false), MinutesAvg = table.Column<decimal>(type: "decimal(7,2)", nullable: false), PointsAvg = table.Column<decimal>(type: "decimal(7,2)", nullable: false), ReboundsAvg = table.Column<decimal>(type: "decimal(7,2)", nullable: false), AssistsAvg = table.Column<decimal>(type: "decimal(7,2)", nullable: false), TurnoversAvg = table.Column<decimal>(type: "decimal(7,2)", nullable: false), TS = table.Column<decimal>(type: "decimal(6,4)", nullable: false), ThreePpct = table.Column<decimal>(type: "decimal(6,4)", nullable: false), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaPlayerRollingStatsSnapshots", x => x.SnapshotId); table.ForeignKey( name: "FK_NbaPlayerRollingStatsSnapshots_NbaPlayers_PlayerId", column: x => x.PlayerId, principalSchema: "dbo", principalTable: "NbaPlayers", principalColumn: "PlayerId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaPlayerRollingStatsSnapshots_NbaSeasons_SeasonId", column: x => x.SeasonId, principalSchema: "dbo", principalTable: "NbaSeasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaPlayerRollingStatsSnapshots_NbaTeams_TeamId", column: x => x.TeamId, principalSchema: "dbo", principalTable: "NbaTeams", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "NbaPlayerTeams", schema: "dbo", columns: table => new { PlayerTeamId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), PlayerId = table.Column<int>(type: "int", nullable: false), TeamId = table.Column<int>(type: "int", nullable: false), SeasonId = table.Column<int>(type: "int", nullable: false), RosterStatus = table.Column<string>(type: "nvarchar(max)", nullable: true), JerseyNumber = table.Column<string>(type: "nvarchar(max)", nullable: true), DepthOrder = table.Column<int>(type: "int", nullable: true), StartDateUtc = table.Column<DateTime>(type: "datetime2", nullable: false), EndDateUtc = table.Column<DateTime>(type: "datetime2", nullable: true) }, constraints: table => { table.PrimaryKey("PK_NbaPlayerTeams", x => x.PlayerTeamId); table.ForeignKey( name: "FK_NbaPlayerTeams_NbaPlayers_PlayerId", column: x => x.PlayerId, principalSchema: "dbo", principalTable: "NbaPlayers", principalColumn: "PlayerId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaPlayerTeams_NbaSeasons_SeasonId", column: x => x.SeasonId, principalSchema: "dbo", principalTable: "NbaSeasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaPlayerTeams_NbaTeams_TeamId", column: x => x.TeamId, principalSchema: "dbo", principalTable: "NbaTeams", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "NbaTeamStatsSnapshots", schema: "dbo", columns: table => new { SnapshotId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), BatchId = table.Column<Guid>(type: "uniqueidentifier", nullable: false), PulledAtUtc = table.Column<DateTime>(type: "datetime2", nullable: false), SeasonId = table.Column<int>(type: "int", nullable: false), TeamId = table.Column<int>(type: "int", nullable: false), LastNGames = table.Column<int>(type: "int", nullable: false), OffRtg = table.Column<decimal>(type: "decimal(7,3)", nullable: false), DefRtg = table.Column<decimal>(type: "decimal(7,3)", nullable: false), Pace = table.Column<decimal>(type: "decimal(7,3)", nullable: false), NetRtg = table.Column<decimal>(type: "decimal(7,3)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaTeamStatsSnapshots", x => x.SnapshotId); table.ForeignKey( name: "FK_NbaTeamStatsSnapshots_NbaSeasons_SeasonId", column: x => x.SeasonId, principalSchema: "dbo", principalTable: "NbaSeasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_NbaTeamStatsSnapshots_NbaTeams_TeamId", column: x => x.TeamId, principalSchema: "dbo", principalTable: "NbaTeams", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "NbaPlayerGameStats", schema: "dbo", columns: table => new { PlayerGameStatId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), GameId = table.Column<string>(type: "nvarchar(20)", nullable: false), PlayerId = table.Column<int>(type: "int", nullable: false), TeamId = table.Column<int>(type: "int", nullable: false), DidStart = table.Column<bool>(type: "bit", nullable: false), Minutes = table.Column<decimal>(type: "decimal(5,2)", nullable: false), Points = table.Column<int>(type: "int", nullable: false), Rebounds = table.Column<int>(type: "int", nullable: false), Assists = table.Column<int>(type: "int", nullable: false), Steals = table.Column<int>(type: "int", nullable: false), Blocks = table.Column<int>(type: "int", nullable: false), Turnovers = table.Column<int>(type: "int", nullable: false), Fouls = table.Column<int>(type: "int", nullable: false), FGM = table.Column<int>(type: "int", nullable: false), FGA = table.Column<int>(type: "int", nullable: false), TPM = table.Column<int>(type: "int", nullable: false), TPA = table.Column<int>(type: "int", nullable: false), FTM = table.Column<int>(type: "int", nullable: false), FTA = table.Column<int>(type: "int", nullable: false) }, constraints: table => { table.PrimaryKey("PK_NbaPlayerGameStats", x => x.PlayerGameStatId); table.ForeignKey( name: "FK_NbaPlayerGameStats_NbaGames_GameId", column: x => x.GameId, principalSchema: "dbo", principalTable: "NbaGames", principalColumn: "GameId", onDelete: Referentia /* ... truncated for agent context ... / # FILE: Migrations/20260213025511_NbaSchemaV1.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260213025511_NbaSchemaV1")] partial class NbaSchemaV1 { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Models.NbaGame", b => { b.Property<string>("GameId") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property<string>("Arena") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int?>("AwayScore") .HasColumnType("int"); b.Property<int>("AwayTeamId") .HasColumnType("int"); b.Property<DateTime>("GameDateUtc") .HasColumnType("datetime2"); b.Property<int?>("HomeScore") .HasColumnType("int"); b.Property<int>("HomeTeamId") .HasColumnType("int"); b.Property<DateTime>("LastSyncedUtc") .HasColumnType("datetime2"); b.Property<int>("SeasonId") .HasColumnType("int"); b.Property<string>("Status") .IsRequired() .HasMaxLength(30) .HasColumnType("nvarchar(30)"); b.HasKey("GameId"); b.HasIndex("GameDateUtc"); b.HasIndex("AwayTeamId", "GameDateUtc"); b.HasIndex("HomeTeamId", "GameDateUtc"); b.HasIndex("SeasonId", "GameDateUtc"); b.ToTable("NbaGames", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaPlayer", b => { b.Property<int>("PlayerId") .HasColumnType("int"); b.Property<string>("DisplayName") .IsRequired() .HasMaxLength(80) .HasColumnType("nvarchar(80)"); b.Property<string>("FirstName") .IsRequired() .HasMaxLength(40) .HasColumnType("nvarchar(40)"); b.Property<bool>("IsActive") .HasColumnType("bit"); b.Property<string>("LastName") .IsRequired() .HasMaxLength(40) .HasColumnType("nvarchar(40)"); b.HasKey("PlayerId"); b.HasIndex("DisplayName"); b.ToTable("NbaPlayers", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaPlayerGameStat", b => { b.Property<long>("PlayerGameStatId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("PlayerGameStatId")); b.Property<int>("Assists") .HasColumnType("int"); b.Property<int>("Blocks") .HasColumnType("int"); b.Property<bool>("DidStart") .HasColumnType("bit"); b.Property<int>("FGA") .HasColumnType("int"); b.Property<int>("FGM") .HasColumnType("int"); b.Property<int>("FTA") .HasColumnType("int"); b.Property<int>("FTM") .HasColumnType("int"); b.Property<int>("Fouls") .HasColumnType("int"); b.Property<string>("GameId") .IsRequired() .HasColumnType("nvarchar(20)"); b.Property<decimal>("Minutes") .HasColumnType("decimal(5,2)"); b.Property<int>("PlayerId") .HasColumnType("int"); b.Property<int>("Points") .HasColumnType("int"); b.Property<int>("Rebounds") .HasColumnType("int"); b.Property<int>("Steals") .HasColumnType("int"); b.Property<int>("TPA") .HasColumnType("int"); b.Property<int>("TPM") .HasColumnType("int"); b.Property<int>("TeamId") .HasColumnType("int"); b.Property<int>("Turnovers") .HasColumnType("int"); b.HasKey("PlayerGameStatId"); b.HasIndex("PlayerId"); b.HasIndex("TeamId"); b.HasIndex("GameId", "PlayerId") .IsUnique(); b.ToTable("NbaPlayerGameStats", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaPlayerRelevanceSnapshot", b => { b.Property<long>("PlayerRelevanceSnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("PlayerRelevanceSnapshotId")); b.Property<DateTime>("AsOfUtc") .HasColumnType("datetime2"); b.Property<decimal?>("AvailabilityFactor") .HasColumnType("decimal(6,4)"); b.Property<Guid>("BatchId") .HasColumnType("uniqueidentifier"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("MinutesSharePct") .HasColumnType("decimal(6,2)"); b.Property<int>("PlayerId") .HasColumnType("int"); b.Property<decimal?>("RecentMinutesAvg") .HasColumnType("decimal(7,2)"); b.Property<decimal>("RelevanceScore") .HasColumnType("decimal(6,2)"); b.Property<byte>("RelevanceTier") .HasColumnType("tinyint"); b.Property<int>("SeasonId") .HasColumnType("int"); b.Property<int>("TeamId") .HasColumnType("int"); b.Property<decimal?>("UsageProxy") .HasColumnType("decimal(6,2)"); b.HasKey("PlayerRelevanceSnapshotId"); b.HasIndex("AsOfUtc"); b.HasIndex("PlayerId"); b.HasIndex("TeamId"); b.HasIndex("SeasonId", "TeamId", "AsOfUtc"); b.HasIndex("SeasonId", "TeamId", "PlayerId", "AsOfUtc") .IsUnique(); b.ToTable("NbaPlayerRelevanceSnapshots", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaPlayerRollingStatsSnapshot", b => { b.Property<long>("SnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("SnapshotId")); b.Property<DateTime>("AsOfUtc") .HasColumnType("datetime2"); b.Property<decimal>("AssistsAvg") .HasColumnType("decimal(7,2)"); b.Property<Guid>("BatchId") .HasColumnType("uniqueidentifier"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int>("LastNGames") .HasColumnType("int"); b.Property<decimal>("MinutesAvg") .HasColumnType("decimal(7,2)"); b.Property<int>("PlayerId") .HasColumnType("int"); b.Property<decimal>("PointsAvg") .HasColumnType("decimal(7,2)"); b.Property<decimal>("ReboundsAvg") .HasColumnType("decimal(7,2)"); b.Property<int>("SeasonId") .HasColumnType("int"); b.Property<decimal>("TS") .HasColumnType("decimal(6,4)"); b.Property<int>("TeamId") .HasColumnType("int"); b.Property<decimal>("ThreePpct") .HasColumnType("decimal(6,4)"); b.Property<decimal>("TurnoversAvg") .HasColumnType("decimal(7,2)"); b.HasKey("SnapshotId"); b.HasIndex("AsOfUtc"); b.HasIndex("PlayerId"); b.HasIndex("TeamId"); b.HasIndex("SeasonId", "PlayerId", "AsOfUtc"); b.HasIndex("SeasonId", "TeamId", "AsOfUtc"); b.HasIndex("SeasonId", "TeamId", "PlayerId", "LastNGames", "AsOfUtc") .IsUnique(); b.ToTable("NbaPlayerRollingStatsSnapshots", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaPlayerTeam", b => { b.Property<long>("PlayerTeamId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("PlayerTeamId")); b.Property<int?>("DepthOrder") .HasColumnType("int"); b.Property<DateTime?>("EndDateUtc") .HasColumnType("datetime2"); b.Property<string>("JerseyNumber") .HasColumnType("nvarchar(max)"); b.Property<int>("PlayerId") .HasColumnType("int"); b.Property<string>("RosterStatus") .HasColumnType("nvarchar(max)"); b.Property<int>("SeasonId") .HasColumnType("int"); b.Property<DateTime>("StartDateUtc") .HasColumnType("datetime2"); b.Property<int>("TeamId") .HasColumnType("int"); b.HasKey("PlayerTeamId"); b.HasIndex("SeasonId"); b.HasIndex("TeamId"); b.HasIndex("PlayerId", "TeamId", "SeasonId", "StartDateUtc") .IsUnique(); b.ToTable("NbaPlayerTeams", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaSeason", b => { b.Property<int>("SeasonId") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("SeasonId")); b.Property<bool>("IsActive") .HasColumnType("bit"); b.Property<string>("SeasonCode") .IsRequired() .HasMaxLength(16) .HasColumnType("nvarchar(16)"); b.Property<string>("SeasonType") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("SeasonId"); b.HasIndex("SeasonCode", "SeasonType") .IsUnique(); b.ToTable("NbaSeasons", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaTeam", b => { b.Property<int>("TeamId") .HasColumnType("int"); b.Property<string>("Abbr") .IsRequired() .HasMaxLength(6) .HasColumnType("nvarchar(6)"); b.Property<string>("City") .IsRequired() .HasMaxLength(40) .HasColumnType("nvarchar(40)"); b.Property<string>("FullName") .IsRequired() .HasMaxLength(80) .HasColumnType("nvarchar(80)"); b.Property<bool>("IsActive") .HasColumnType("bit"); b.Property<string>("Name") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.HasKey("TeamId"); b.HasIndex("Abbr"); b.ToTable("NbaTeams", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaTeamStatsSnapshot", b => { b.Property<long>("SnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("SnapshotId")); b.Property<Guid>("BatchId") .HasColumnType("uniqueidentifier"); b.Property<decimal>("DefRtg") .HasColumnType("decimal(7,3)"); b.Property<int>("LastNGames") .HasColumnType("int"); b.Property<decimal>("NetRtg") .HasColumnType("decimal(7,3)"); b.Property<decimal>("OffRtg") .HasColumnType("decimal(7,3)"); b.Property<decimal>("Pace") .HasColumnType("decimal(7,3)"); b.Property<DateTime>("PulledAtUtc") .HasColumnType("datetime2"); b.Property<int>("SeasonId") .HasColumnType("int"); b.Property<int>("TeamId") .HasColumnType("int"); b.HasKey("SnapshotId"); b.HasIndex("PulledAtUtc"); b.HasIndex("TeamId"); b.HasIndex("SeasonId", "LastNGames", "PulledAtUtc"); b.HasIndex("SeasonId", "LastNGames", "BatchId", "TeamId") .IsUnique(); b.ToTable("NbaTeamStatsSnapshots", "dbo"); }); modelBuilder.Entity("BettingOdds.Models.NbaGame", b => { b.HasOne("BettingOdds.Models.NbaTeam", "AwayTeam") .WithMany() .HasForeignKey("AwayTeamId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("BettingOdds.Models.NbaTeam", "HomeTeam") .WithMany() .HasForeignKey("HomeTeamId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("BettingOdds.Models.NbaSeason", "Season") .WithMany("Games") .HasForeignKey("SeasonId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("AwayTeam"); b.Navigation("HomeTeam"); b.Navigation("Season"); }); modelBuilder.Entity("BettingOdds.Models.NbaPlayerGameStat", b => { b.HasOne("BettingOdds.Models.NbaGame", "Game") .WithMany() .HasForeignKey("GameId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("BettingOdds.Models.NbaPlayer", "Player") .WithMany() .HasForeignKey("PlayerId") .OnDelete(DeleteBehavior.Restrict) / ... truncated for agent context ... / # FILE: Migrations/20260218153318_Reconcile_NbaTeams_LogoUrl.cs using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class Reconcile_NbaTeams_LogoUrl : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.Sql(@" IF NOT EXISTS ( SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[NbaTeams]') AND name = N'LogoUrl' ) BEGIN ALTER TABLE [dbo].[NbaTeams] ADD [LogoUrl] nvarchar(256) NULL; END "); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.Sql(@" IF EXISTS ( SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[NbaTeams]') AND name = N'LogoUrl' ) BEGIN ALTER TABLE [dbo].[NbaTeams] DROP COLUMN [LogoUrl]; END "); } } } # FILE: Migrations/20260218153318_Reconcile_NbaTeams_LogoUrl.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260218153318_Reconcile_NbaTeams_LogoUrl")] partial class Reconcile_NbaTeams_LogoUrl { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<int?>("FilesChangedCount") .HasColumnType("int"); b.Property<int>("Result") .HasColumnType("int"); b.HasKey("AaiPatchApplyAttemptId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AppliedUtc"); b.ToTable("AAI_PatchApplyAttempt", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiRepoFileSnapshot", b => { b.Property<long>("AaiRepoFileSnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiRepoFileSnapshotId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("IncludedReason") .HasMaxLength(300) .HasColumnType / ... truncated for agent context ... / # FILE: Migrations/20260218153704_AddAaiAgenticSchema.cs using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class AddAaiAgenticSchema : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { } } } # FILE: Migrations/20260218153704_AddAaiAgenticSchema.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260218153704_AddAaiAgenticSchema")] partial class AddAaiAgenticSchema { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<int?>("FilesChangedCount") .HasColumnType("int"); b.Property<int>("Result") .HasColumnType("int"); b.HasKey("AaiPatchApplyAttemptId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AppliedUtc"); b.ToTable("AAI_PatchApplyAttempt", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiRepoFileSnapshot", b => { b.Property<long>("AaiRepoFileSnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiRepoFileSnapshotId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("IncludedReason") .HasMaxLength(300) .HasColumnType("nvarchar(300 / ... truncated for agent context ... / # FILE: Migrations/20260218154538_Repair_AaiAgenticSchema.cs using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class Repair_AaiAgenticSchema : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.Sql(@" IF OBJECT_ID('[dbo].[AAI_AgentRun]', 'U') IS NULL BEGIN CREATE TABLE [dbo].[AAI_AgentRun]( [AaiAgentRunId] BIGINT IDENTITY(1,1) NOT NULL PRIMARY KEY, [TaskText] NVARCHAR(4000) NOT NULL, [RequestedByUserId] NVARCHAR(128) NULL, [RepoRoot] NVARCHAR(400) NULL, [RepoCommitSha] NVARCHAR(64) NULL, [GovernanceBundleSha256] NVARCHAR(64) NULL, [SelectedFilesBundleSha256] NVARCHAR(64) NULL, [PlannerModel] NVARCHAR(100) NULL, [ImplementerModel] NVARCHAR(100) NULL, [ReviewerModel] NVARCHAR(100) NULL, [GuardModel] NVARCHAR(100) NULL, [Status] INT NOT NULL, [CreatedUtc] DATETIME2 NOT NULL, [StartedUtc] DATETIME2 NULL, [CompletedUtc] DATETIME2 NULL, [TotalInputTokens] BIGINT NULL, [TotalOutputTokens] BIGINT NULL, [TotalCostUsd] DECIMAL(18,6) NULL ); END "); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { } } } # FILE: Migrations/20260218154538_Repair_AaiAgenticSchema.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260218154538_Repair_AaiAgenticSchema")] partial class Repair_AaiAgenticSchema { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<int?>("FilesChangedCount") .HasColumnType("int"); b.Property<int>("Result") .HasColumnType("int"); b.HasKey("AaiPatchApplyAttemptId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AppliedUtc"); b.ToTable("AAI_PatchApplyAttempt", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiRepoFileSnapshot", b => { b.Property<long>("AaiRepoFileSnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiRepoFileSnapshotId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("IncludedReason") .HasMaxLength(300) .HasColumnType("nvar / ... truncated for agent context ... / # FILE: Migrations/20260218154908_Repair_AaiAgenticSchema2.cs using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class Repair_AaiAgenticSchema2 : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "AAI_AgentPatchSet", schema: "dbo", columns: table => new { AaiAgentPatchSetId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunId = table.Column<long>(type: "bigint", nullable: false), Title = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: false), PlanMarkdown = table.Column<string>(type: "nvarchar(max)", maxLength: 256, nullable: false), ProducedByStepType = table.Column<int>(type: "int", nullable: false), PatchSetSha256 = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_AgentPatchSet", x => x.AaiAgentPatchSetId); table.ForeignKey( name: "FK_AAI_AgentPatchSet_AAI_AgentRun_AaiAgentRunId", column: x => x.AaiAgentRunId, principalSchema: "dbo", principalTable: "AAI_AgentRun", principalColumn: "AaiAgentRunId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_AgentRunStep", schema: "dbo", columns: table => new { AaiAgentRunStepId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunId = table.Column<long>(type: "bigint", nullable: false), StepType = table.Column<int>(type: "int", nullable: false), Status = table.Column<int>(type: "int", nullable: false), Model = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true), Temperature = table.Column<double>(type: "float", nullable: true), InputTokens = table.Column<long>(type: "bigint", nullable: true), OutputTokens = table.Column<long>(type: "bigint", nullable: true), CostUsd = table.Column<decimal>(type: "decimal(18,6)", nullable: true), DurationMs = table.Column<int>(type: "int", nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false), StartedUtc = table.Column<DateTime>(type: "datetime2", nullable: true), CompletedUtc = table.Column<DateTime>(type: "datetime2", nullable: true), Error = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true) }, constraints: table => { table.PrimaryKey("PK_AAI_AgentRunStep", x => x.AaiAgentRunStepId); table.ForeignKey( name: "FK_AAI_AgentRunStep_AAI_AgentRun_AaiAgentRunId", column: x => x.AaiAgentRunId, principalSchema: "dbo", principalTable: "AAI_AgentRun", principalColumn: "AaiAgentRunId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_DotnetExecution", schema: "dbo", columns: table => new { AaiDotnetExecutionId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunId = table.Column<long>(type: "bigint", nullable: false), ExecutionType = table.Column<int>(type: "int", nullable: false), Command = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: false), ExitCode = table.Column<int>(type: "int", nullable: false), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false), StartedUtc = table.Column<DateTime>(type: "datetime2", nullable: false), CompletedUtc = table.Column<DateTime>(type: "datetime2", nullable: true), DurationMs = table.Column<int>(type: "int", nullable: true), StdOut = table.Column<string>(type: "nvarchar(max)", maxLength: 256, nullable: true), StdErr = table.Column<string>(type: "nvarchar(max)", maxLength: 256, nullable: true) }, constraints: table => { table.PrimaryKey("PK_AAI_DotnetExecution", x => x.AaiDotnetExecutionId); table.ForeignKey( name: "FK_AAI_DotnetExecution_AAI_AgentRun_AaiAgentRunId", column: x => x.AaiAgentRunId, principalSchema: "dbo", principalTable: "AAI_AgentRun", principalColumn: "AaiAgentRunId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_RepoFileSnapshot", schema: "dbo", columns: table => new { AaiRepoFileSnapshotId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunId = table.Column<long>(type: "bigint", nullable: false), Path = table.Column<string>(type: "nvarchar(400)", maxLength: 400, nullable: false), ContentSha256 = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true), SizeBytes = table.Column<int>(type: "int", nullable: true), IncludedReason = table.Column<string>(type: "nvarchar(300)", maxLength: 300, nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_RepoFileSnapshot", x => x.AaiRepoFileSnapshotId); table.ForeignKey( name: "FK_AAI_RepoFileSnapshot_AAI_AgentRun_AaiAgentRunId", column: x => x.AaiAgentRunId, principalSchema: "dbo", principalTable: "AAI_AgentRun", principalColumn: "AaiAgentRunId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_AgentPatch", schema: "dbo", columns: table => new { AaiAgentPatchId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentPatchSetId = table.Column<long>(type: "bigint", nullable: false), Path = table.Column<string>(type: "nvarchar(400)", maxLength: 400, nullable: false), UnifiedDiff = table.Column<string>(type: "nvarchar(max)", maxLength: 256, nullable: false), Reason = table.Column<string>(type: "nvarchar(2000)", maxLength: 2000, nullable: false), DiffSha256 = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_AgentPatch", x => x.AaiAgentPatchId); table.ForeignKey( name: "FK_AAI_AgentPatch_AAI_AgentPatchSet_AaiAgentPatchSetId", column: x => x.AaiAgentPatchSetId, principalSchema: "dbo", principalTable: "AAI_AgentPatchSet", principalColumn: "AaiAgentPatchSetId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_GuardReport", schema: "dbo", columns: table => new { AaiGuardReportId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunId = table.Column<long>(type: "bigint", nullable: false), AaiAgentPatchSetId = table.Column<long>(type: "bigint", nullable: true), Allowed = table.Column<bool>(type: "bit", nullable: false), PolicyVersion = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: false), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_GuardReport", x => x.AaiGuardReportId); table.ForeignKey( name: "FK_AAI_GuardReport_AAI_AgentPatchSet_AaiAgentPatchSetId", column: x => x.AaiAgentPatchSetId, principalSchema: "dbo", principalTable: "AAI_AgentPatchSet", principalColumn: "AaiAgentPatchSetId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_AAI_GuardReport_AAI_AgentRun_AaiAgentRunId", column: x => x.AaiAgentRunId, principalSchema: "dbo", principalTable: "AAI_AgentRun", principalColumn: "AaiAgentRunId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_PatchApplyAttempt", schema: "dbo", columns: table => new { AaiPatchApplyAttemptId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentPatchSetId = table.Column<long>(type: "bigint", nullable: false), AppliedByUserId = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: true), AppliedUtc = table.Column<DateTime>(type: "datetime2", nullable: false), Result = table.Column<int>(type: "int", nullable: false), FilesChangedCount = table.Column<int>(type: "int", nullable: true), Error = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true), CommitShaAfterApply = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true) }, constraints: table => { table.PrimaryKey("PK_AAI_PatchApplyAttempt", x => x.AaiPatchApplyAttemptId); table.ForeignKey( name: "FK_AAI_PatchApplyAttempt_AAI_AgentPatchSet_AaiAgentPatchSetId", column: x => x.AaiAgentPatchSetId, principalSchema: "dbo", principalTable: "AAI_AgentPatchSet", principalColumn: "AaiAgentPatchSetId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_AgentMessage", schema: "dbo", columns: table => new { AaiAgentMessageId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunStepId = table.Column<long>(type: "bigint", nullable: false), Role = table.Column<int>(type: "int", nullable: false), JsonSchemaName = table.Column<string>(type: "nvarchar(120)", maxLength: 120, nullable: true), Content = table.Column<string>(type: "nvarchar(max)", maxLength: 256, nullable: false), ContentSha256 = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_AgentMessage", x => x.AaiAgentMessageId); table.ForeignKey( name: "FK_AAI_AgentMessage_AAI_AgentRunStep_AaiAgentRunStepId", column: x => x.AaiAgentRunStepId, principalSchema: "dbo", principalTable: "AAI_AgentRunStep", principalColumn: "AaiAgentRunStepId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AAI_GuardViolation", schema: "dbo", columns: table => new { AaiGuardViolationId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiGuardReportId = table.Column<long>(type: "bigint", nullable: false), Code = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: false), Severity = table.Column<int>(type: "int", nullable: false), Path = table.Column<string>(type: "nvarchar(400)", maxLength: 400, nullable: true), Message = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: false), Suggestion = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_GuardViolation", x => x.AaiGuardViolationId); table.ForeignKey( name: "FK_AAI_GuardViolation_AAI_GuardReport_AaiGuardReportId", column: x => x.AaiGuardReportId, principalSchema: "dbo", principalTable: "AAI_GuardReport", principalColumn: "AaiGuardReportId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_AAI_AgentMessage_AaiAgentRunStepId_CreatedUtc", schema: "dbo", table: "AAI_AgentMessage", columns: new[] { "AaiAgentRunStepId", "CreatedUtc" }); migrationBuilder.CreateIndex( name: "IX_AAI_AgentPatch_AaiAgentPatchSetId", schema: "dbo", table: "AAI_AgentPatch", column: "AaiAgentPatchSetId"); migrationBuilder.CreateIndex( name: "IX_AAI_AgentPatch_Path", schema: "dbo", table: "AAI_AgentPatch", column: "Path"); migrationBuilder.CreateIndex( name: "IX_AAI_AgentPatchSet_AaiAgentRunId", schema: "dbo", table: "AAI_AgentPatchSet", column: "AaiAgentRunId"); migrationBuilder.CreateIndex( name: "IX_AAI_AgentRun_CreatedUtc", schema: "dbo", table: "AAI_AgentRun", column: "CreatedUtc"); migrationBuilder.CreateIndex( name: "IX_AAI_AgentRun_RepoCommitSha", schema: "dbo", table: "AAI_AgentRun", column: "RepoCommitSha"); migrationBuilder.CreateIndex( name: "IX_AAI_AgentRun_Status_CreatedUtc", schema: "dbo", table: "AAI_AgentRun", columns: new[] { "Status", "CreatedUtc" }); migrationBuilder.CreateIndex( name: "IX_AAI_AgentRunStep_AaiAgentRunId_StepType", schema: "dbo", table: "AAI_AgentRunStep", columns: new[] { "AaiAgentRunId", "StepType" }); migrationBuilder.CreateIndex( name: "IX_AAI_AgentRunStep_Status_StartedUtc", schema: "dbo", table: "AAI_AgentRunStep", columns: new[] { "Status", "StartedUtc" }); migrationBuilder.CreateIndex( name: "IX_AAI_DotnetExecution_AaiAgentRunId_ExecutionType", schema: "dbo", table: "AAI_DotnetExecution", columns: new[] { "A / ... truncated for agent context ... / # FILE: Migrations/20260218154908_Repair_AaiAgenticSchema2.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260218154908_Repair_AaiAgenticSchema2")] partial class Repair_AaiAgenticSchema2 { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<int?>("FilesChangedCount") .HasColumnType("int"); b.Property<int>("Result") .HasColumnType("int"); b.HasKey("AaiPatchApplyAttemptId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AppliedUtc"); b.ToTable("AAI_PatchApplyAttempt", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiRepoFileSnapshot", b => { b.Property<long>("AaiRepoFileSnapshotId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiRepoFileSnapshotId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("IncludedReason") .HasMaxLength(300) .HasColumnType("nv / ... truncated for agent context ... / # FILE: Migrations/20260218224121_AddAaiPatchPreflight.cs using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class AddAaiPatchPreflight : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "AAI_PatchPreflightReports", schema: "dbo", columns: table => new { AaiPatchPreflightReportId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiAgentRunId = table.Column<long>(type: "bigint", nullable: false), AaiAgentPatchSetId = table.Column<long>(type: "bigint", nullable: false), Allowed = table.Column<bool>(type: "bit", nullable: false), PolicyVersion = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: false), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_PatchPreflightReports", x => x.AaiPatchPreflightReportId); table.ForeignKey( name: "FK_AAI_PatchPreflightReports_AAI_AgentPatchSet_AaiAgentPatchSetId", column: x => x.AaiAgentPatchSetId, principalSchema: "dbo", principalTable: "AAI_AgentPatchSet", principalColumn: "AaiAgentPatchSetId", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_AAI_PatchPreflightReports_AAI_AgentRun_AaiAgentRunId", column: x => x.AaiAgentRunId, principalSchema: "dbo", principalTable: "AAI_AgentRun", principalColumn: "AaiAgentRunId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "AAI_PatchPreflightViolations", schema: "dbo", columns: table => new { AaiPatchPreflightViolationId = table.Column<long>(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), AaiPatchPreflightReportId = table.Column<long>(type: "bigint", nullable: false), Severity = table.Column<int>(type: "int", nullable: false), Code = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: false), Message = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: false), Path = table.Column<string>(type: "nvarchar(512)", maxLength: 512, nullable: true), Suggestion = table.Column<string>(type: "nvarchar(2000)", maxLength: 2000, nullable: true), CreatedUtc = table.Column<DateTime>(type: "datetime2", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AAI_PatchPreflightViolations", x => x.AaiPatchPreflightViolationId); table.ForeignKey( name: "FK_AAI_PatchPreflightViolations_AAI_PatchPreflightReports_AaiPatchPreflightReportId", column: x => x.AaiPatchPreflightReportId, principalSchema: "dbo", principalTable: "AAI_PatchPreflightReports", principalColumn: "AaiPatchPreflightReportId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_AAI_PatchPreflightReports_AaiAgentPatchSetId_CreatedUtc", schema: "dbo", table: "AAI_PatchPreflightReports", columns: new[] { "AaiAgentPatchSetId", "CreatedUtc" }); migrationBuilder.CreateIndex( name: "IX_AAI_PatchPreflightReports_AaiAgentRunId", schema: "dbo", table: "AAI_PatchPreflightReports", column: "AaiAgentRunId"); migrationBuilder.CreateIndex( name: "IX_AAI_PatchPreflightViolations_AaiPatchPreflightReportId_Severity", schema: "dbo", table: "AAI_PatchPreflightViolations", columns: new[] { "AaiPatchPreflightReportId", "Severity" }); migrationBuilder.CreateIndex( name: "IX_AAI_PatchPreflightViolations_Code", schema: "dbo", table: "AAI_PatchPreflightViolations", column: "Code"); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "AAI_PatchPreflightViolations", schema: "dbo"); migrationBuilder.DropTable( name: "AAI_PatchPreflightReports", schema: "dbo"); } } } # FILE: Migrations/20260218224121_AddAaiPatchPreflight.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260218224121_AddAaiPatchPreflight")] partial class AddAaiPatchPreflight { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<int?>("FilesChangedCount") .HasColumnType("int"); b.Property<int>("Result") .HasColumnType("int"); b.HasKey("AaiPatchApplyAttemptId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AppliedUtc"); b.ToTable("AAI_PatchApplyAttempt", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchPreflightReport", b => { b.Property<long>("AaiPatchPreflightReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchPreflightReportId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsReq / ... truncated for agent context ... / # FILE: Migrations/20260218231615_Aai_ApplyAttempt_CommitFields.cs using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class Aai_ApplyAttempt_CommitFields : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn<int>( name: "CommitExitCode", schema: "dbo", table: "AAI_PatchApplyAttempt", type: "int", nullable: true); migrationBuilder.AddColumn<string>( name: "CommitMessage", schema: "dbo", table: "AAI_PatchApplyAttempt", type: "nvarchar(400)", maxLength: 400, nullable: true); migrationBuilder.AddColumn<string>( name: "CommitStdErr", schema: "dbo", table: "AAI_PatchApplyAttempt", type: "nvarchar(4000)", maxLength: 4000, nullable: true); migrationBuilder.AddColumn<string>( name: "CommitStdOut", schema: "dbo", table: "AAI_PatchApplyAttempt", type: "nvarchar(4000)", maxLength: 4000, nullable: true); migrationBuilder.AddColumn<DateTime>( name: "CommittedUtc", schema: "dbo", table: "AAI_PatchApplyAttempt", type: "datetime2", nullable: true); migrationBuilder.AddColumn<string>( name: "RepoCommitSha", schema: "dbo", table: "AAI_PatchApplyAttempt", type: "nvarchar(64)", maxLength: 64, nullable: true); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "CommitExitCode", schema: "dbo", table: "AAI_PatchApplyAttempt"); migrationBuilder.DropColumn( name: "CommitMessage", schema: "dbo", table: "AAI_PatchApplyAttempt"); migrationBuilder.DropColumn( name: "CommitStdErr", schema: "dbo", table: "AAI_PatchApplyAttempt"); migrationBuilder.DropColumn( name: "CommitStdOut", schema: "dbo", table: "AAI_PatchApplyAttempt"); migrationBuilder.DropColumn( name: "CommittedUtc", schema: "dbo", table: "AAI_PatchApplyAttempt"); migrationBuilder.DropColumn( name: "RepoCommitSha", schema: "dbo", table: "AAI_PatchApplyAttempt"); } } } # FILE: Migrations/20260218231615_Aai_ApplyAttempt_CommitFields.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260218231615_Aai_ApplyAttempt_CommitFields")] partial class Aai_ApplyAttempt_CommitFields { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<int?>("CommitExitCode") .HasColumnType("int"); b.Property<string>("CommitMessage") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("CommitStdErr") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<string>("CommitStdOut") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<DateTime?>("CommittedUtc") .HasColumnType("datetime2"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<int?>("FilesChangedCount") .HasColumnType("int"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<int>("Result") .HasColumnType("int"); b.HasKey("AaiPatchApplyAttemptId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AppliedUtc"); b.ToTable("AAI_PatchApplyAttempt", "dbo"); }); modelBuilder.Entity("BettingOdds.Do / ... truncated for agent context ... / # FILE: Migrations/20260219003652_Aai_Latest_Updates.cs using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace BettingOdds.Migrations { /// <inheritdoc /> public partial class Aai_Latest_Updates : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn<int>( name: "MaxOutputTokens", schema: "dbo", table: "AAI_AgentRunStep", type: "int", nullable: true); migrationBuilder.AddColumn<int>( name: "GuardMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun", type: "int", nullable: true); migrationBuilder.AddColumn<double>( name: "GuardTemperature", schema: "dbo", table: "AAI_AgentRun", type: "float", nullable: true); migrationBuilder.AddColumn<int>( name: "ImplementerMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun", type: "int", nullable: true); migrationBuilder.AddColumn<double>( name: "ImplementerTemperature", schema: "dbo", table: "AAI_AgentRun", type: "float", nullable: true); migrationBuilder.AddColumn<int>( name: "PlannerMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun", type: "int", nullable: true); migrationBuilder.AddColumn<double>( name: "PlannerTemperature", schema: "dbo", table: "AAI_AgentRun", type: "float", nullable: true); migrationBuilder.AddColumn<int>( name: "ReviewerMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun", type: "int", nullable: true); migrationBuilder.AddColumn<double>( name: "ReviewerTemperature", schema: "dbo", table: "AAI_AgentRun", type: "float", nullable: true); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "MaxOutputTokens", schema: "dbo", table: "AAI_AgentRunStep"); migrationBuilder.DropColumn( name: "GuardMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "GuardTemperature", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "ImplementerMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "ImplementerTemperature", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "PlannerMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "PlannerTemperature", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "ReviewerMaxOutputTokens", schema: "dbo", table: "AAI_AgentRun"); migrationBuilder.DropColumn( name: "ReviewerTemperature", schema: "dbo", table: "AAI_AgentRun"); } } } # FILE: Migrations/20260219003652_Aai_Latest_Updates.Designer.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20260219003652_Aai_Latest_Updates")] partial class Aai_Latest_Updates { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<int?>("GuardMaxOutputTokens") .HasColumnType("int"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("GuardTemperature") .HasColumnType("float"); b.Property<int?>("ImplementerMaxOutputTokens") .HasColumnType("int"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("ImplementerTemperature") .HasColumnType("float"); b.Property<int?>("PlannerMaxOutputTokens") .HasColumnType("int"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("PlannerTemperature") .HasColumnType("float"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<int?>("ReviewerMaxOutputTokens") .HasColumnType("int"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("ReviewerTemperature") .HasColumnType("float"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<int?>("MaxOutputTokens") .HasColumnType("int"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<int?>("CommitExitCode") .HasColumnType("int"); b.Property<string>("CommitMessage") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("CommitStdErr") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<string>("CommitStdOut") .HasMaxLe / ... truncated for agent context ... / # FILE: Migrations/AppDbContextModelSnapshot.cs // <auto-generated /> using System; using BettingOdds.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BettingOdds.Migrations { [DbContext(typeof(AppDbContext))] partial class AppDbContextModelSnapshot : ModelSnapshot { protected override void BuildModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasDefaultSchema("dbo") .HasAnnotation("ProductVersion", "9.0.2") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentMessage", b => { b.Property<long>("AaiAgentMessageId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentMessageId")); b.Property<long>("AaiAgentRunStepId") .HasColumnType("bigint"); b.Property<string>("Content") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("ContentSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("JsonSchemaName") .HasMaxLength(120) .HasColumnType("nvarchar(120)"); b.Property<int>("Role") .HasColumnType("int"); b.HasKey("AaiAgentMessageId"); b.HasIndex("AaiAgentRunStepId", "CreatedUtc"); b.ToTable("AAI_AgentMessage", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatch", b => { b.Property<long>("AaiAgentPatchId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("DiffSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("Path") .IsRequired() .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("Reason") .IsRequired() .HasMaxLength(2000) .HasColumnType("nvarchar(2000)"); b.Property<string>("UnifiedDiff") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiAgentPatchId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("Path"); b.ToTable("AAI_AgentPatch", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentPatchSet", b => { b.Property<long>("AaiAgentPatchSetId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentPatchSetId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PatchSetSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("PlanMarkdown") .IsRequired() .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<int>("ProducedByStepType") .HasColumnType("int"); b.Property<string>("Title") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.HasKey("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.ToTable("AAI_AgentPatchSet", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRun", b => { b.Property<long>("AaiAgentRunId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunId")); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("GovernanceBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<int?>("GuardMaxOutputTokens") .HasColumnType("int"); b.Property<string>("GuardModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("GuardTemperature") .HasColumnType("float"); b.Property<int?>("ImplementerMaxOutputTokens") .HasColumnType("int"); b.Property<string>("ImplementerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("ImplementerTemperature") .HasColumnType("float"); b.Property<int?>("PlannerMaxOutputTokens") .HasColumnType("int"); b.Property<string>("PlannerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("PlannerTemperature") .HasColumnType("float"); b.Property<string>("RepoCommitSha") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("RepoRoot") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("RequestedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<int?>("ReviewerMaxOutputTokens") .HasColumnType("int"); b.Property<string>("ReviewerModel") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<double?>("ReviewerTemperature") .HasColumnType("float"); b.Property<string>("SelectedFilesBundleSha256") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<string>("TaskText") .IsRequired() .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<decimal?>("TotalCostUsd") .HasColumnType("decimal(18,6)"); b.Property<long?>("TotalInputTokens") .HasColumnType("bigint"); b.Property<long?>("TotalOutputTokens") .HasColumnType("bigint"); b.HasKey("AaiAgentRunId"); b.HasIndex("CreatedUtc"); b.HasIndex("RepoCommitSha"); b.HasIndex("Status", "CreatedUtc"); b.ToTable("AAI_AgentRun", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiAgentRunStep", b => { b.Property<long>("AaiAgentRunStepId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiAgentRunStepId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<decimal?>("CostUsd") .HasColumnType("decimal(18,6)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<string>("Error") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<long?>("InputTokens") .HasColumnType("bigint"); b.Property<int?>("MaxOutputTokens") .HasColumnType("int"); b.Property<string>("Model") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<long?>("OutputTokens") .HasColumnType("bigint"); b.Property<DateTime?>("StartedUtc") .HasColumnType("datetime2"); b.Property<int>("Status") .HasColumnType("int"); b.Property<int>("StepType") .HasColumnType("int"); b.Property<double?>("Temperature") .HasColumnType("float"); b.HasKey("AaiAgentRunStepId"); b.HasIndex("AaiAgentRunId", "StepType"); b.HasIndex("Status", "StartedUtc"); b.ToTable("AAI_AgentRunStep", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiDotnetExecution", b => { b.Property<long>("AaiDotnetExecutionId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiDotnetExecutionId")); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<string>("Command") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime?>("CompletedUtc") .HasColumnType("datetime2"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<int?>("DurationMs") .HasColumnType("int"); b.Property<int>("ExecutionType") .HasColumnType("int"); b.Property<int>("ExitCode") .HasColumnType("int"); b.Property<DateTime>("StartedUtc") .HasColumnType("datetime2"); b.Property<string>("StdErr") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.Property<string>("StdOut") .HasMaxLength(256) .HasColumnType("nvarchar(max)"); b.HasKey("AaiDotnetExecutionId"); b.HasIndex("CreatedUtc"); b.HasIndex("AaiAgentRunId", "ExecutionType"); b.ToTable("AAI_DotnetExecution", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardReport", b => { b.Property<long>("AaiGuardReportId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardReportId")); b.Property<long?>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<long>("AaiAgentRunId") .HasColumnType("bigint"); b.Property<bool>("Allowed") .HasColumnType("bit"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("PolicyVersion") .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.HasKey("AaiGuardReportId"); b.HasIndex("AaiAgentPatchSetId"); b.HasIndex("AaiAgentRunId"); b.HasIndex("AaiAgentRunId", "CreatedUtc"); b.ToTable("AAI_GuardReport", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiGuardViolation", b => { b.Property<long>("AaiGuardViolationId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiGuardViolationId")); b.Property<long>("AaiGuardReportId") .HasColumnType("bigint"); b.Property<string>("Code") .IsRequired() .HasMaxLength(60) .HasColumnType("nvarchar(60)"); b.Property<DateTime>("CreatedUtc") .HasColumnType("datetime2"); b.Property<string>("Message") .IsRequired() .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property<string>("Path") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<int>("Severity") .HasColumnType("int"); b.Property<string>("Suggestion") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.HasKey("AaiGuardViolationId"); b.HasIndex("AaiGuardReportId", "Severity"); b.ToTable("AAI_GuardViolation", "dbo"); }); modelBuilder.Entity("BettingOdds.Domain.Entities.Agents.AaiPatchApplyAttempt", b => { b.Property<long>("AaiPatchApplyAttemptId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("AaiPatchApplyAttemptId")); b.Property<long>("AaiAgentPatchSetId") .HasColumnType("bigint"); b.Property<string>("AppliedByUserId") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property<DateTime>("AppliedUtc") .HasColumnType("datetime2"); b.Property<int?>("CommitExitCode") .HasColumnType("int"); b.Property<string>("CommitMessage") .HasMaxLength(400) .HasColumnType("nvarchar(400)"); b.Property<string>("CommitShaAfterApply") .HasMaxLength(64) .HasColumnType("nvarchar(64)"); b.Property<string>("CommitStdErr") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<string>("CommitStdOut") .HasMaxLength(4000) .HasColumnType("nvarchar(4000)"); b.Property<DateTime?> / ... truncated for agent context ... / # FILE: Data/AppDbContext.cs using BettingOdds.Domain.Entities; using BettingOdds.Domain.Entities.Agents; using Microsoft.EntityFrameworkCore; namespace BettingOdds.Data; public sealed class AppDbContext : DbContext { public AppDbContext(DbContextOptions<AppDbContext> options) : base(options) { } // --- DbSets --- public DbSet<NbaTeam> NbaTeams => Set<NbaTeam>(); public DbSet<NbaSeason> NbaSeasons => Set<NbaSeason>(); public DbSet<NbaTeamStatsSnapshot> NbaTeamStatsSnapshots => Set<NbaTeamStatsSnapshot>(); public DbSet<NbaGame> NbaGames => Set<NbaGame>(); public DbSet<NbaPlayer> NbaPlayers => Set<NbaPlayer>(); public DbSet<NbaPlayerTeam> NbaPlayerTeams => Set<NbaPlayerTeam>(); public DbSet<NbaPlayerGameStat> NbaPlayerGameStats => Set<NbaPlayerGameStat>(); public DbSet<NbaPlayerRelevanceSnapshot> NbaPlayerRelevanceSnapshots => Set<NbaPlayerRelevanceSnapshot>(); public DbSet<NbaPlayerRollingStatsSnapshot> NbaPlayerRollingStatsSnapshots => Set<NbaPlayerRollingStatsSnapshot>(); // --- Agentic AI (AAI) DbSets --- public DbSet<AaiAgentRun> AaiAgentRuns => Set<AaiAgentRun>(); public DbSet<AaiAgentRunStep> AaiAgentRunSteps => Set<AaiAgentRunStep>(); public DbSet<AaiAgentMessage> AaiAgentMessages => Set<AaiAgentMessage>(); public DbSet<AaiRepoFileSnapshot> AaiRepoFileSnapshots => Set<AaiRepoFileSnapshot>(); public DbSet<AaiAgentPatchSet> AaiAgentPatchSets => Set<AaiAgentPatchSet>(); public DbSet<AaiAgentPatch> AaiAgentPatches => Set<AaiAgentPatch>(); public DbSet<AaiPatchApplyAttempt> AaiPatchApplyAttempts => Set<AaiPatchApplyAttempt>(); public DbSet<AaiGuardReport> AaiGuardReports => Set<AaiGuardReport>(); public DbSet<AaiGuardViolation> AaiGuardViolations => Set<AaiGuardViolation>(); public DbSet<AaiDotnetExecution> AaiDotnetExecutions => Set<AaiDotnetExecution>(); public DbSet<AaiPatchPreflightReport> AaiPatchPreflightReports => Set<AaiPatchPreflightReport>(); public DbSet<AaiPatchPreflightViolation> AaiPatchPreflightViolations => Set<AaiPatchPreflightViolation>(); protected override void ConfigureConventions(ModelConfigurationBuilder configurationBuilder) { // Global defaults (explicit property mappings below still override these) configurationBuilder.Properties<decimal>().HaveColumnType("decimal(18,6)"); configurationBuilder.Properties<string>().HaveMaxLength(256); } protected override void OnModelCreating(ModelBuilder model) { // Force dbo schema (prevents accidental db_owner schema issues) model.HasDefaultSchema(DbNames.Schema); ConfigureTeams(model); ConfigureSeasons(model); ConfigureTeamSnapshots(model); ConfigureGames(model); ConfigurePlayers(model); ConfigurePlayerTeams(model); ConfigurePlayerGameStats(model); ConfigurePlayerRelevanceSnapshots(model); ConfigurePlayerRollingStatsSnapshots(model); ConfigureAai(model); ConfigureAaiPatchPreflight(model); } private static class DbNames { public const string Schema = "dbo"; public const string NbaTeams = "NbaTeams"; public const string NbaSeasons = "NbaSeasons"; public const string NbaTeamStatsSnapshots = "NbaTeamStatsSnapshots"; public const string NbaGames = "NbaGames"; public const string NbaPlayers = "NbaPlayers"; public const string NbaPlayerTeams = "NbaPlayerTeams"; public const string NbaPlayerGameStats = "NbaPlayerGameStats"; public const string NbaPlayerRelevanceSnapshots = "NbaPlayerRelevanceSnapshots"; public const string NbaPlayerRollingStatsSnapshots = "NbaPlayerRollingStatsSnapshots"; // --- Agentic AI (AAI) --- public const string AaiAgentRun = "AAI_AgentRun"; public const string AaiAgentRunStep = "AAI_AgentRunStep"; public const string AaiAgentMessage = "AAI_AgentMessage"; public const string AaiRepoFileSnapshot = "AAI_RepoFileSnapshot"; public const string AaiAgentPatchSet = "AAI_AgentPatchSet"; public const string AaiAgentPatch = "AAI_AgentPatch"; public const string AaiPatchApplyAttempt = "AAI_PatchApplyAttempt"; public const string AaiGuardReport = "AAI_GuardReport"; public const string AaiGuardViolation = "AAI_GuardViolation"; public const string AaiDotnetExecution = "AAI_DotnetExecution"; public const string AaiPatchPreflightReports = "AAI_PatchPreflightReports"; public const string AaiPatchPreflightViolations = "AAI_PatchPreflightViolations"; } private static void ConfigureTeams(ModelBuilder model) { model.Entity<NbaTeam>(e => { e.ToTable(DbNames.NbaTeams); e.HasKey(x => x.TeamId); // NBA TEAM_ID is provided externally (NOT identity) e.Property(x => x.TeamId).ValueGeneratedNever(); e.Property(x => x.Abbr).HasMaxLength(6); e.Property(x => x.City).HasMaxLength(40); e.Property(x => x.Name).HasMaxLength(60); e.Property(x => x.FullName).HasMaxLength(80); e.HasIndex(x => x.Abbr); }); } private static void ConfigureSeasons(ModelBuilder model) { model.Entity<NbaSeason>(e => { e.ToTable(DbNames.NbaSeasons); e.HasKey(x => x.SeasonId); // Identity PK e.Property(x => x.SeasonId).ValueGeneratedOnAdd(); e.Property(x => x.SeasonCode).HasMaxLength(16).IsRequired(); e.Property(x => x.SeasonType).HasMaxLength(32).IsRequired(); e.HasIndex(x => new { x.SeasonCode, x.SeasonType }).IsUnique(); }); } private static void ConfigureTeamSnapshots(ModelBuilder model) { model.Entity<NbaTeamStatsSnapshot>(e => { e.ToTable(DbNames.NbaTeamStatsSnapshots); e.HasKey(x => x.SnapshotId); // Identity PK (critical) e.Property(x => x.SnapshotId).ValueGeneratedOnAdd(); e.Property(x => x.BatchId).IsRequired(); e.Property(x => x.PulledAtUtc).IsRequired(); e.Property(x => x.OffRtg).HasColumnType("decimal(7,3)"); e.Property(x => x.DefRtg).HasColumnType("decimal(7,3)"); e.Property(x => x.Pace).HasColumnType("decimal(7,3)"); e.Property(x => x.NetRtg).HasColumnType("decimal(7,3)"); e.HasOne(x => x.Team) .WithMany(t => t.StatSnapshots) .HasForeignKey(x => x.TeamId) .OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Season) .WithMany(s => s.TeamStats) .HasForeignKey(x => x.SeasonId) .OnDelete(DeleteBehavior.Restrict); // One record per team per batch (season+lastN) e.HasIndex(x => new { x.SeasonId, x.LastNGames, x.BatchId, x.TeamId }).IsUnique(); // Fast "latest batch" lookups e.HasIndex(x => new { x.SeasonId, x.LastNGames, x.PulledAtUtc }); e.HasIndex(x => x.PulledAtUtc); }); } private static void ConfigureGames(ModelBuilder model) { model.Entity<NbaGame>(e => { e.ToTable(DbNames.NbaGames); e.HasKey(x => x.GameId); // String PK from NBA API e.Property(x => x.GameId).HasMaxLength(20).ValueGeneratedNever(); e.Property(x => x.Status).HasMaxLength(30); e.Property(x => x.Arena).HasMaxLength(120); e.Property(x => x.GameDateUtc).IsRequired(); e.Property(x => x.LastSyncedUtc).IsRequired(); e.HasOne(x => x.Season) .WithMany(s => s.Games) .HasForeignKey(x => x.SeasonId) .OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.HomeTeam) .WithMany() .HasForeignKey(x => x.HomeTeamId) .OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.AwayTeam) .WithMany() .HasForeignKey(x => x.AwayTeamId) .OnDelete(DeleteBehavior.Restrict); e.HasIndex(x => x.GameDateUtc); e.HasIndex(x => new { x.SeasonId, x.GameDateUtc }); e.HasIndex(x => new { x.HomeTeamId, x.GameDateUtc }); e.HasIndex(x => new { x.AwayTeamId, x.GameDateUtc }); }); } private static void ConfigurePlayers(ModelBuilder model) { model.Entity<NbaPlayer>(e => { e.ToTable(DbNames.NbaPlayers); e.HasKey(x => x.PlayerId); // NBA PERSON_ID is provided externally (NOT identity) e.Property(x => x.PlayerId).ValueGeneratedNever(); e.Property(x => x.DisplayName).HasMaxLength(80); e.Property(x => x.FirstName).HasMaxLength(40); e.Property(x => x.LastName).HasMaxLength(40); e.HasIndex(x => x.DisplayName); }); } private static void ConfigurePlayerTeams(ModelBuilder model) { model.Entity<NbaPlayerTeam>(e => { e.ToTable(DbNames.NbaPlayerTeams); e.HasKey(x => x.PlayerTeamId); // Identity PK e.Property(x => x.PlayerTeamId).ValueGeneratedOnAdd(); e.Property(x => x.StartDateUtc).IsRequired(); e.HasOne(x => x.Player).WithMany().HasForeignKey(x => x.PlayerId).OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Team).WithMany().HasForeignKey(x => x.TeamId).OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Season).WithMany().HasForeignKey(x => x.SeasonId).OnDelete(DeleteBehavior.Restrict); e.HasIndex(x => new { x.PlayerId, x.TeamId, x.SeasonId, x.StartDateUtc }).IsUnique(); }); } private static void ConfigurePlayerGameStats(ModelBuilder model) { model.Entity<NbaPlayerGameStat>(e => { e.ToTable(DbNames.NbaPlayerGameStats); e.HasKey(x => x.PlayerGameStatId); // Identity PK e.Property(x => x.PlayerGameStatId).ValueGeneratedOnAdd(); e.Property(x => x.Minutes).HasColumnType("decimal(5,2)"); e.HasOne(x => x.Game).WithMany().HasForeignKey(x => x.GameId).OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Player).WithMany().HasForeignKey(x => x.PlayerId).OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Team).WithMany().HasForeignKey(x => x.TeamId).OnDelete(DeleteBehavior.Restrict); e.HasIndex(x => new { x.GameId, x.PlayerId }).IsUnique(); }); } private static void ConfigurePlayerRelevanceSnapshots(ModelBuilder model) { model.Entity<NbaPlayerRelevanceSnapshot>(e => { e.ToTable(DbNames.NbaPlayerRelevanceSnapshots); e.HasKey(x => x.PlayerRelevanceSnapshotId); // Identity PK e.Property(x => x.PlayerRelevanceSnapshotId).ValueGeneratedOnAdd(); e.Property(x => x.AsOfUtc).IsRequired(); e.Property(x => x.BatchId).IsRequired(); e.Property(x => x.CreatedUtc).IsRequired(); // 2-decimal outputs (your standard) e.Property(x => x.RelevanceScore).HasColumnType("decimal(6,2)"); e.Property(x => x.MinutesSharePct).HasColumnType("decimal(6,2)"); e.Property(x => x.UsageProxy).HasColumnType("decimal(6,2)"); e.Property(x => x.RecentMinutesAvg).HasColumnType("decimal(7,2)"); e.Property(x => x.AvailabilityFactor).HasColumnType("decimal(6,4)"); e.HasOne(x => x.Season).WithMany().HasForeignKey(x => x.SeasonId).OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Team).WithMany().HasForeignKey(x => x.TeamId).OnDelete(DeleteBehavior.Restrict); e.HasOne(x => x.Player).WithMany().HasForeignKey(x => x.PlayerId).OnDelete(DeleteBehavior.Restrict); // One snapshot row per player/team/season/as-of e.HasIndex(x => new { x.SeasonId, x.TeamId, x.PlayerId, x.AsOfUtc }).IsUnique(); // Fast “latest snapshot” lookups per team e.HasIndex(x => new { x.SeasonId, x.TeamId, x.AsOfUtc }); e.HasIndex(x => x.AsOfUtc); }); } private static void ConfigurePlayerRollingStatsSnapshots(ModelBuilder model) { model.Entity<NbaPlayerRollingStatsSnapshot>(e => { e.ToTable(DbNames.NbaPlayerRollingStatsSnapshots); e.HasKey(x => x.SnapshotId); // Identity PK e.Property(x => x.SnapshotId).ValueGeneratedOnAdd(); e.Property(x => x.BatchId).IsRequired(); e.Property(x => x.AsOfUtc).IsRequired(); e.Property(x => x.LastNGames).IsRequired(); e.Property(x => x.CreatedUtc).IsRequired(); // Standard 2-decimal formatting for betting outputs e.Property(x => x.MinutesAvg).HasColumnType("decimal(7,2)"); e.Property(x => x.PointsAvg).HasColumnType("decimal(7,2)"); e.Property(x => x.ReboundsAvg).HasColumnType("decimal(7,2)"); e.Property(x => x.AssistsAvg).HasColumnType("decimal(7,2)"); e.Property(x => x.TurnoversAvg).HasColumnType("decimal(7,2)"); // If you store 0..1 => (6,4). If 0..100 => (6,2). e.Property(x => x.TS).HasColumnType("decimal(6,4)"); e.Property(x => x.ThreePpct).HasColumnType("decimal(6,4)"); e.HasOne<NbaSeason>() .WithMany() .HasForeignKey(x => x.SeasonId) .OnDelete(DeleteBehavior.Restrict); e.HasOne<NbaTeam>() .WithMany() .HasForeignKey(x => x.TeamId) .OnDelete(DeleteBehavior.Restrict); e.HasOne<NbaPlayer>() .WithMany() .HasForeignKey(x => x.PlayerId) .OnDelete(DeleteBehavior.Restrict); e.HasIndex(x => new { x.SeasonId, x.TeamId, x.PlayerId, x.LastNGames, x.AsOfUtc }).IsUnique(); e.HasIndex(x => new { x.SeasonId, x.TeamId, x.AsOfUtc }); e.HasIndex(x => new { x.SeasonId, x.PlayerId, x.AsOfUtc }); e.HasIndex(x => x.AsOfUtc); }); } private static void ConfigureAai(ModelBuilder model) { ConfigureAaiAgentRuns(model); ConfigureAaiAgentRunSteps(model); ConfigureAaiAgentMessages(model); ConfigureAaiRepoFileSnapshots(model); ConfigureAaiAgentPatchSets(model); ConfigureAaiAgentPatches(model); ConfigureAaiPatchApplyAttempts(model); ConfigureAaiGuardReports(model); ConfigureAaiGuardViolations(model); ConfigureAaiDotnetExecutions(model); } private static void ConfigureAaiAgentRuns(ModelBuilder model) { model.Entity<AaiAgentRun>(e => { e.ToTable(DbNames.AaiAgentRun); e.HasKey(x => x.AaiAgentRunId); e.Property(x => x.AaiAgentRunId).ValueGeneratedOnAdd(); e.Property(x => x.TaskText).HasMaxLength(4000).IsRequired(); e.Property(x => x.RequestedByUserId).HasMaxLength(128); e.Property(x => x.RepoRoot).HasMaxLength(400); e.Property(x => x.RepoCommitSha).HasMaxLength(64); e.Property(x => x.GovernanceBundleSha256).HasMaxLength(64); e.Property(x => x.SelectedFilesBundleSha256).HasMaxLength(64); e.Property(x => x.PlannerModel).HasMaxLength(100); e.Property(x => x.ImplementerModel).HasMaxLength(100); e.Property(x => x.ReviewerModel).HasMaxLength(100); e.Property(x => x.GuardModel).HasMaxLength(100); e.Property(x => x.CreatedUtc).IsRequired(); e.Property(x => x.Status).IsRequired(); e.Property(x => x.TotalCostUsd).HasColumnType("decimal(18,6)"); e.HasIndex(x => x.CreatedUtc); e.HasIndex(x => new { x.Status, x.CreatedUtc }); e.HasIndex(x => x.RepoCommitSha); }); } private static void ConfigureAaiAgentRunSteps(ModelBuilder model) { model.Entity<AaiAgentRunStep>(e => { e.ToTable(DbNames.AaiAgentRunStep); e.HasKey(x => x.AaiAgentRunStepId); e.Property(x => x.AaiAgentRunStepId).ValueGeneratedOnAdd(); e.Property(x => x.StepType).IsRequired(); e.Property(x => x.Status).IsRequired(); e.Property(x => x.Model).HasMaxLength(100); e.Property(x => x.Error).HasMaxLength(4000); e.Property(x => x.CreatedUtc).IsRequired(); e.Property(x => x.CostUsd).HasColumnType("decimal(18,6)"); e.HasOne(x => x.AgentRun) .WithMany(r => r.Steps) .HasForeignKey(x => x.AaiAgentRunId) .OnDelete(DeleteBehavior.Cascade); e.HasIndex(x => new { x.AaiAgentRunId, x.StepType }); e.HasIndex(x => new { x.Status, x.StartedUtc }); }); } private static void ConfigureAaiAgentMessages(ModelBuilder model) { model.Entity<AaiAgentMessage>(e => { e.ToTable(DbNames.AaiAgentMessage); e.HasKey(x => x.AaiAgentMessageId); e.Property(x => x.AaiAgentMessageId).ValueGeneratedOnAdd(); e.Property(x => x.Role).IsRequired(); e.Property(x => x.JsonSchemaName).HasMaxLength(120); / ... truncated for agent context ... / # FILE: Pages/Nba/Games.cshtml.cs using BettingOdds.App.Queries.Games; using BettingOdds.App.Time; using Microsoft.AspNetCore.Mvc.RazorPages; namespace BettingOdds.Pages.Nba; public class GamesModel : PageModel { private readonly IGamesQuery _games; private readonly IAppClock _clock; public List<GameRow> Games { get; private set; } = new(); // NEW: for the view (avoid DateTime.UtcNow inside cshtml) public DateTime TodayUtcStart { get; private set; } public DateTime UpcomingEndUtcExclusive { get; private set; } public List<IGrouping<DateTime, GameRow>> UpcomingDays { get; private set; } = new(); public IGrouping<DateTime, GameRow>? LastDayBeforeToday { get; private set; } public GamesModel(IGamesQuery games, IAppClock clock) { _games = games; _clock = clock; } public async Task OnGet(CancellationToken ct) { TodayUtcStart = _clock.GetTodayUtcStart(); UpcomingEndUtcExclusive = TodayUtcStart.AddDays(3); Games = await _games.GetGamesWindowAsync( todayUtcStart: TodayUtcStart, upcomingDays: 3, lookbackDays: 30, ct: ct); // Group for the view UpcomingDays = Games .Where(g => g.GameDateUtc >= TodayUtcStart && g.GameDateUtc < UpcomingEndUtcExclusive) .GroupBy(g => g.GameDateUtc.Date) .OrderBy(g => g.Key) .ToList(); LastDayBeforeToday = Games .Where(g => g.GameDateUtc < TodayUtcStart) .GroupBy(g => g.GameDateUtc.Date) .OrderByDescending(g => g.Key) .FirstOrDefault(); } } # FILE: Pages/Nba/Matchup.cshtml.cs using BettingOdds.App.Nba.Queries.Matchup; using BettingOdds.App.Nba.Sync.GameSync; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; namespace BettingOdds.Pages.Nba; public class MatchupModel : PageModel { private readonly IMatchupQuery _query; private readonly IGameSyncOrchestrator _gameSync; public MatchupVm? Vm { get; private set; } public MatchupModel(IMatchupQuery query, IGameSyncOrchestrator gameSync) { _query = query; _gameSync = gameSync; } public async Task<IActionResult> OnGet( int? homeId, int? awayId, double? totalLine, string? gameId, CancellationToken ct) { if (homeId is null \|\| awayId is null \|\| homeId == 0 \|\| awayId == 0) return BadRequest("Missing homeId/awayId."); try { Vm = await _query.GetAsync(homeId.Value, awayId.Value, totalLine, gameId, ct); return Page(); } catch (InvalidOperationException ex) { return BadRequest(ex.Message); } } public async Task<IActionResult> OnPostSyncGameAsync(string gameId, int homeId, int awayId, double? totalLine, CancellationToken ct) { if (string.IsNullOrWhiteSpace(gameId)) return RedirectToPage(new { homeId, awayId }); await _gameSync.SyncSingleGameAsync(gameId, ct); return RedirectToPage(new { homeId, awayId, gameId, totalLine }); } } # FILE: Pages/Nba/Player.cshtml.cs using BettingOdds.App.Queries.Player; using BettingOdds.Domain.Entities; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; namespace BettingOdds.Pages.Nba; public class PlayerModel : PageModel { private readonly IPlayerQuery _query; public PlayerModel(IPlayerQuery query) { _query = query; } [BindProperty(SupportsGet = true)] public int PlayerId { get; set; } [BindProperty(SupportsGet = true)] public int? TeamId { get; set; } [BindProperty(SupportsGet = true)] public int LastNGames { get; set; } = 10; public int Take { get; private set; } = 30; public string? PlayerTitle { get; private set; } public string? TeamLabel { get; private set; } public DateTime? LatestAsOfUtc { get; private set; } public string? Error { get; private set; } public List<NbaPlayerRollingStatsSnapshot> Trend { get; private set; } = new(); public PlayerPageVm.RelevanceKpi? LatestRelevance { get; private set; } public PlayerPageVm.DeltaKpi? Deltas { get; private set; } public async Task<IActionResult> OnGetAsync(CancellationToken ct) { try { var vm = await _query.GetPlayerPageAsync( new PlayerQueryArgs(PlayerId, TeamId, LastNGames, Take), ct); PlayerTitle = vm.PlayerTitle; TeamLabel = vm.TeamLabel; LatestAsOfUtc = vm.LatestAsOfUtc; Trend = vm.Trend.ToList(); LatestRelevance = vm.LatestRelevance; Deltas = vm.Deltas; return Page(); } catch (Exception ex) { Error = ex.Message; return Page(); } } public static string Signed2(decimal v) => (v >= 0 ? "+" : "") + v.ToString("0.00"); } # FILE: Pages/Nba/Sync.cshtml.cs using BettingOdds.App.Sync; using BettingOdds.App.Sync.Modules; using BettingOdds.Data; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using Microsoft.EntityFrameworkCore; namespace BettingOdds.Pages.Nba; public class SyncModel : PageModel { private readonly ISyncCenter _syncCenter; private readonly ITeamStatsSync _teamStats; private readonly IScheduleSync _schedule; private readonly IPlayerSync _players; private readonly IPlayerSnapshotBuilder _snapshots; private readonly AppDbContext _db; private readonly IConfiguration _cfg; public string? Message { get; private set; } public DateTime? LastStatsPullUtc { get; private set; } public Guid? LastBatchId { get; private set; } public DateTime? LastScheduleSyncUtc { get; private set; } // NEW statuses public DateTime? LastPlayersSyncUtc { get; private set; } public DateTime? LastRosterSyncUtc { get; private set; } public DateTime? LastPlayerStatsSyncUtc { get; private set; } public DateTime? LastPlayerRollingAsOfUtc { get; private set; } public DateTime? LastPlayerRelevanceAsOfUtc { get; private set; } public Guid? LastPlayerBatchId { get; private set; } [BindProperty] public int PastDays { get; set; } = 5; public SyncModel( ISyncCenter syncCenter, ITeamStatsSync teamStats, IScheduleSync schedule, IPlayerSync players, IPlayerSnapshotBuilder snapshots, AppDbContext db, IConfiguration cfg) { _syncCenter = syncCenter; _teamStats = teamStats; _schedule = schedule; _players = players; _snapshots = snapshots; _db = db; _cfg = cfg; } public async Task OnGet() { await LoadStatusAsync(); } public async Task<IActionResult> OnPostRunAllAsync() { var r = await _syncCenter.RunAllAsync(); Message = $@" ✅ Teams upserted: {r.TeamsUpserted} \| Team batch: {r.TeamBatchId} ✅ Games upserted: {r.GamesUpserted} ✅ Players upserted: {r.PlayersUpserted} ✅ Roster changes: {r.RosterChanges} ✅ Player stats inserted: {r.PlayerStatsInserted} ✅ Rolling snapshots: {r.RollingInserted} ✅ Relevance snapshots: {r.RelevanceInserted} \| Player batch: {r.PlayerBatchId} ".Trim(); await LoadStatusAsync(); return Page(); } public async Task<IActionResult> OnPostTeamsAndStatsAsync() { var opt = SyncOptions.FromConfig(_cfg); var seasonId = await EnsureSeasonIdAsync(opt); var (teams, batchId) = await _teamStats.SyncTeamsAndStatsAsync(seasonId, opt); Message = $"Teams + Stats synced: Teams upserted: {teams}, Stats batch: {batchId}."; await LoadStatusAsync(); return Page(); } public async Task<IActionResult> OnPostScheduleAsync() { var opt = SyncOptions.FromConfig(_cfg); var seasonId = await EnsureSeasonIdAsync(opt); var today = DateTime.UtcNow.Date; var to = today.AddDays(2); var games = await _schedule.SyncScheduleRangeAsync(seasonId, today, to); Message = $"Schedule synced: Games upserted: {games}."; await LoadStatusAsync(); return Page(); } public async Task<IActionResult> OnPostPastScheduleAsync() { if (PastDays < 1) PastDays = 1; var opt = SyncOptions.FromConfig(_cfg); var seasonId = await EnsureSeasonIdAsync(opt); var to = DateTime.UtcNow.Date; var from = to.AddDays(-PastDays); var games = await _schedule.SyncScheduleRangeAsync(seasonId, from, to); Message = $"Past schedule synced: {games} games upserted (last {PastDays} days)."; await LoadStatusAsync(); return Page(); } // ----------------------- // NEW handlers // ----------------------- public async Task<IActionResult> OnPostPlayersAsync() { var opt = SyncOptions.FromConfig(_cfg); var players = await _players.SyncPlayersAsync(opt); Message = $"Players synced: Players upserted: {players}."; await LoadStatusAsync(); return Page(); } public async Task<IActionResult> OnPostRostersAsync() { var opt = SyncOptions.FromConfig(_cfg); var seasonId = await EnsureSeasonIdAsync(opt); var changes = await _players.SyncRostersAsync(seasonId, opt); Message = $"Rosters synced: Changes applied: {changes}."; await LoadStatusAsync(); return Page(); } public async Task<IActionResult> OnPostPlayerStatsAsync() { var opt = SyncOptions.FromConfig(_cfg); var seasonId = await EnsureSeasonIdAsync(opt); var inserted = await _players.SyncPlayerGameStatsForFinalGamesAsync(seasonId, opt, onlyGameId: null); Message = $"Player game stats synced: Rows inserted: {inserted}."; await LoadStatusAsync(); return Page(); } public async Task<IActionResult> OnPostPlayerSnapshotsAsync() { var opt = SyncOptions.FromConfig(_cfg); var seasonId = await EnsureSeasonIdAsync(opt); var asOfUtc = DateTime.UtcNow; var (rollingInserted, relevanceInserted, batchId) = await _snapshots.BuildAsync(seasonId, opt, asOfUtc); Message = $"Player snapshots built: Rolling={rollingInserted}, Relevance={relevanceInserted}, Batch={batchId}, AsOf={asOfUtc:u}."; await LoadStatusAsync(); return Page(); } // ----------------------- // Status // ----------------------- private async Task LoadStatusAsync() { LastStatsPullUtc = await _db.NbaTeamStatsSnapshots .OrderByDescending(x => x.PulledAtUtc) .Select(x => (DateTime?)x.PulledAtUtc) .FirstOrDefaultAsync(); LastBatchId = await _db.NbaTeamStatsSnapshots .OrderByDescending(x => x.PulledAtUtc) .Select(x => (Guid?)x.BatchId) .FirstOrDefaultAsync(); LastScheduleSyncUtc = await _db.NbaGames .OrderByDescending(x => x.LastSyncedUtc) .Select(x => (DateTime?)x.LastSyncedUtc) .FirstOrDefaultAsync(); // Best-effort: roster sync time is a better proxy than "DateTime.UtcNow" LastRosterSyncUtc = await _db.NbaPlayerTeams .OrderByDescending(x => x.StartDateUtc) .Select(x => (DateTime?)x.StartDateUtc) .FirstOrDefaultAsync(); // Players sync time (until Player has CreatedUtc/UpdatedUtc): // Use same roster timestamp as proxy, but only if players exist. var playersExist = await _db.NbaPlayers.AnyAsync(); LastPlayersSyncUtc = playersExist ? LastRosterSyncUtc : null; LastPlayerStatsSyncUtc = await _db.NbaPlayerGameStats .Join(_db.NbaGames, s => s.GameId, g => g.GameId, (s, g) => g.GameDateUtc) .OrderByDescending(d => d) .Select(d => (DateTime?)d) .FirstOrDefaultAsync(); LastPlayerRollingAsOfUtc = await _db.NbaPlayerRollingStatsSnapshots .OrderByDescending(x => x.AsOfUtc) .Select(x => (DateTime?)x.AsOfUtc) .FirstOrDefaultAsync(); LastPlayerRelevanceAsOfUtc = await _db.NbaPlayerRelevanceSnapshots .OrderByDescending(x => x.AsOfUtc) .Select(x => (DateTime?)x.AsOfUtc) .FirstOrDefaultAsync(); LastPlayerBatchId = await _db.NbaPlayerRelevanceSnapshots .OrderByDescending(x => x.AsOfUtc) .Select(x => (Guid?)x.BatchId) .FirstOrDefaultAsync(); } /// <summary> /// “Right way”: resolve season ID the same way the new pipeline does. /// We keep this local helper so the page doesn’t need to inject ISeasonResolver too. /// </summary> private async Task<int> EnsureSeasonIdAsync(SyncOptions opt) { var season = await _db.NbaSeasons .Where(s => s.SeasonCode == opt.SeasonCode && s.SeasonType == opt.SeasonType) .Select(s => (int?)s.SeasonId) .FirstOrDefaultAsync(); if (season.HasValue) return season.Value; var entity = new BettingOdds.Domain.Entities.NbaSeason { SeasonCode = opt.SeasonCode, SeasonType = opt.SeasonType, IsActive = true }; _db.NbaSeasons.Add(entity); await _db.SaveChangesAsync(); return entity.SeasonId; } } # FILE: Pages/Nba/SyncTeamStats.cshtml.cs using BettingOdds.App.Queries; using BettingOdds.App.Sync; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; namespace BettingOdds.Pages.Nba; public class SyncTeamStatsModel : PageModel { private readonly SyncTeamStatsUseCase _useCase; private readonly ISyncTeamStatsQuery _query; public SyncTeamStatsModel(SyncTeamStatsUseCase useCase, ISyncTeamStatsQuery query) { _useCase = useCase; _query = query; } public string SeasonLabel { get; private set; } = "�"; public DateTime? LatestPulledAtUtc { get; private set; } public Guid? LatestBatchId { get; private set; } public List<SyncTeamStatsRowVm> Latest { get; private set; } = new(); [BindProperty(SupportsGet = true)] public int? SelectedLastNGames { get; set; } public async Task OnGetAsync(CancellationToken ct) { await LoadAsync(ct); } public async Task<IActionResult> OnPostSyncAsync(CancellationToken ct) { var lastN = SelectedLastNGames ?? 10; await _useCase.RunAsync(lastN, ct); // PRG pattern (preserve selection) return RedirectToPage(new { SelectedLastNGames = lastN }); } private async Task LoadAsync(CancellationToken ct) { var vm = await _query.GetPageAsync(SelectedLastNGames, ct); SelectedLastNGames = vm.SelectedLastNGames; SeasonLabel = vm.SeasonLabel; LatestPulledAtUtc = vm.LatestPulledAtUtc; LatestBatchId = vm.LatestBatchId; Latest = vm.Latest.ToList(); } } # FILE: Pages/Nba/Team.cshtml.cs using BettingOdds.App.Queries; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; namespace BettingOdds.Pages.Nba; public class TeamModel : PageModel { private readonly ITeamQuery _query; public TeamModel(ITeamQuery query) => _query = query; [BindProperty(SupportsGet = true)] public int TeamId { get; set; } [BindProperty(SupportsGet = true)] public int LastNGames { get; set; } = 10; public string? TeamTitle { get; private set; } public string? LogoUrl { get; private set; } public string SeasonLabel { get; private set; } = "�"; // Player snapshots as-of public DateTime? AsOfUtc { get; private set; } // Team advanced stats pulled time public DateTime? TeamStatsAsOfUtc { get; private set; } // Roster tier counts public int CoreCount { get; private set; } public int RotationCount { get; private set; } public int BenchCount { get; private set; } public int FringeCount { get; private set; } // Team insight blocks public TeamKpisVm? TeamKpis { get; private set; } public List<TeamTrendPoint> Trend { get; private set; } = new(); public TeamChangeVm? Change { get; private set; } public string? Error { get; private set; } public List<TeamPlayerRowVm> Rows { get; private set; } = new(); public sealed record TeamPlayerRowVm( int PlayerId, string PlayerName, byte Tier, string TierLabel, decimal RelevanceScore, decimal MinutesSharePct, decimal MinutesAvg, decimal PointsAvg, decimal ReboundsAvg, decimal AssistsAvg, decimal TS, decimal ThreePpct ); public async Task<IActionResult> OnGetAsync(CancellationToken ct) { try { // Take and TrendTake can be tuned as you like. var vm = await _query.GetTeamPageAsync( new TeamQueryArgs(TeamId, LastNGames, Take: 12, TrendTake: 20), ct ); TeamTitle = vm.TeamTitle; LogoUrl = vm.LogoUrl; SeasonLabel = vm.SeasonLabel; AsOfUtc = vm.AsOfUtc; TeamStatsAsOfUtc = vm.TeamStatsAsOfUtc; CoreCount = vm.TierCounts.Core; RotationCount = vm.TierCounts.Rotation; BenchCount = vm.TierCounts.Bench; FringeCount = vm.TierCounts.Fringe; TeamKpis = vm.TeamKpis; Trend = vm.Trend?.ToList() ?? new List<TeamTrendPoint>(); Change = vm.Change; Rows = vm.Rows.Select(r => new TeamPlayerRowVm( r.PlayerId, r.PlayerName, r.Tier, r.TierLabel, r.RelevanceScore, r.MinutesSharePct, r.MinutesAvg, r.PointsAvg, r.ReboundsAvg, r.AssistsAvg, r.TS, r.ThreePpct )).ToList(); return Page(); } catch (Exception ex) { Error = ex.Message; return Page(); } } } # FILE: Pages/Nba/Teams.cshtml.cs using BettingOdds.App.Queries; using BettingOdds.Domain.Entities; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; namespace BettingOdds.Pages.Nba; public class TeamsModel : PageModel { private readonly ITeamsQuery _query; public List<NbaTeam> Teams { get; private set; } = new(); public int TotalTeams { get; private set; } public string SeasonLabel { get; private set; } = "�"; public DateTime? LastUpdatedUtc { get; private set; } [BindProperty(SupportsGet = true)] public string? Q { get; set; } public TeamsModel(ITeamsQuery query) { _query = query; } public async Task OnGetAsync(CancellationToken ct) { var vm = await _query.GetTeamsPageAsync(ct); Teams = vm.Teams.ToList(); TotalTeams = vm.TotalTeams; SeasonLabel = vm.SeasonLabel; LastUpdatedUtc = vm.LastUpdatedUtc; } } # FILE: Pages/Nba/Games.cshtml @page @model BettingOdds.Pages.Nba.GamesModel @{ string StatusBadge(string status) { if (string.IsNullOrWhiteSpace(status)) return "bg-secondary"; if (status.Contains("Final", StringComparison.OrdinalIgnoreCase)) return "bg-success"; if (status.Contains("In Progress", StringComparison.OrdinalIgnoreCase)) return "bg-warning"; if (status.Contains("Q", StringComparison.OrdinalIgnoreCase) \|\| status.Contains("Half", StringComparison.OrdinalIgnoreCase)) return "bg-warning"; if (status.Contains("ET", StringComparison.OrdinalIgnoreCase) \|\| status.Contains("PM", StringComparison.OrdinalIgnoreCase) \|\| status.Contains("AM", StringComparison.OrdinalIgnoreCase)) return "bg-secondary"; return "bg-secondary"; } // Use model-provided groupings (no DateTime.UtcNow.Date here) var upcomingDays = Model.UpcomingDays; var lastDayBeforeToday = Model.LastDayBeforeToday; } <div class="container py-4 poc-shell"> <div class="poc-card p-4 p-md-5"> <!-- Header --> <div class="d-flex flex-column flex-lg-row align-items-lg-center justify-content-between gap-3"> <div> <h2 class="mb-1 poc-title">Upcoming Games</h2> <div class="poc-muted"> Next <b>3 days</b> from your database. Times shown in <b>UTC</b>. </div> <div class="mt-3 d-flex flex-wrap gap-2"> <span class="poc-pill">Games: @Model.Games.Count</span> <span class="poc-pill">Window: 3 days</span> <span class="poc-pill">Timezone: UTC</span> </div> </div> <div class="d-flex flex-wrap gap-2"> <a class="btn btn-outline-light btn-lg px-4" asp-page="/Index">Back</a> <a asp-page="/Nba/Sync" class="btn poc-btn-gradient btn-lg px-4"> Sync Center </a> </div> </div> <div class="mt-4 poc-divider"></div> @if (!Model.Games.Any()) { <div class="mt-4 poc-muted"> No games found. Go to <b>Sync Schedule</b> to import the next 3 days. </div> } else { <!-- Grouped by day --> <div class="mt-4 d-flex flex-column gap-4"> @ Upcoming next 3 days @ @foreach (var day in upcomingDays) { <div class="poc-card p-3 p-md-4"> <div class="d-flex flex-column flex-md-row align-items-md-center justify-content-between gap-2"> <div> <div class="fw-semibold">@day.Key.ToString("dddd, yyyy-MM-dd")</div> <div class="poc-muted small">@day.Count() game(s)</div> </div> <span class="poc-pill"> Day (UTC): @day.Key.ToString("yyyy-MM-dd") </span> </div> <div class="mt-3 table-responsive"> <table class="table poc-table align-middle mb-0 poc-responsive-table"> <thead class="d-none d-md-table-header-group"> <tr> <th>Matchup</th> <th>Status</th> <th>Game</th> <th class="text-end"></th> </tr> </thead> <tbody> @foreach (var g in day.OrderBy(x => x.GameDateUtc).ThenBy(x => x.GameId)) { <tr class="poc-row-hover"> <!-- MATCHUP --> <td class="col-matchup"> <div class="mu-pill"> <!-- Away --> <div class="mu-team mu-away"> <div class="mu-logo"> <img src="@(g.AwayLogoUrl ?? "/img/ui/team-fallback.png")" alt="@g.Away logo" class="mu-logo-img" loading="lazy" onerror="this.onerror=null; this.src='/img/ui/team-fallback.png';" /> </div> <div class="mu-text"> <div class="mu-name">@g.Away</div> <div class="mu-sub">Away</div> </div> </div> <div class="mu-vs">VS</div> <!-- Home --> <div class="mu-team mu-home"> <div class="mu-text text-end"> <div class="mu-name">@g.Home</div> <div class="mu-sub">Home</div> </div> <div class="mu-logo"> <img src="@(g.HomeLogoUrl ?? "/img/ui/team-fallback.png")" alt="@g.Home logo" class="mu-logo-img" loading="lazy" onerror="this.onerror=null; this.src='/img/ui/team-fallback.png';" /> </div> </div> </div> </td> <!-- STATUS --> <td class="col-status"> <div class="mobile-label d-md-none">Status</div> <span class="badge rounded-pill @StatusBadge(g.Status)"> @g.Status </span> </td> <!-- GAME --> <td class="col-game"> <div class="mobile-label d-md-none">Game</div> <div> <div class="poc-muted small">GameId</div> <div class="fw-semibold">@g.GameId</div> </div> </td> <!-- ACTION --> <td class="col-action text-end"> <div class="mobile-label d-md-none">Action</div> <a asp-page="/Nba/Matchup" asp-route-homeId="@g.HomeId" asp-route-awayId="@g.AwayId" class="btn btn-sm poc-btn-gradient px-3 w-100 w-md-auto"> Project </a> </td> </tr> } </tbody> </table> </div> </div> } @ Last day before today @ @if (lastDayBeforeToday != null) { <div class="poc-card p-3 p-md-4"> <div class="d-flex flex-column flex-md-row align-items-md-center justify-content-between gap-2"> <div> <div class="fw-semibold">Last Day With Matches</div> <div class="poc-muted small"> @lastDayBeforeToday.Key.ToString("dddd, yyyy-MM-dd") • @lastDayBeforeToday.Count() game(s) </div> </div> <span class="poc-pill"> Day (UTC): @lastDayBeforeToday.Key.ToString("yyyy-MM-dd") </span> </div> <div class="mt-3 table-responsive"> <table class="table poc-table align-middle mb-0 poc-responsive-table"> <thead class="d-none d-md-table-header-group"> <tr> <th>Matchup</th> <th>Status</th> <th>Game</th> <th class="text-end"></th> </tr> </thead> <tbody> @foreach (var g in lastDayBeforeToday.OrderBy(x => x.GameDateUtc).ThenBy(x => x.GameId)) { <tr class="poc-row-hover"> <!-- MATCHUP --> <td class="col-matchup"> <div class="mu-pill"> <!-- Away --> <div class="mu-team mu-away"> <div class="mu-logo"> <img src="@(g.AwayLogoUrl ?? "/img/ui/team-fallback.png")" alt="@g.Away logo" class="mu-logo-img" loading="lazy" onerror="this.onerror=null; this.src='/img/ui/team-fallback.png';" /> </div> <div class="mu-text"> <div class="mu-name">@g.Away</div> <div class="mu-sub">Away</div> </div> </div> <div class="mu-vs">VS</div> <!-- Home --> <div class="mu-team mu-home"> <div class="mu-text text-end"> <div class="mu-name">@g.Home</div> <div class="mu-sub">Home</div> </div> <div class="mu-logo"> <img src="@(g.HomeLogoUrl ?? "/img/ui/team-fallback.png")" alt="@g.Home logo" class="mu-logo-img" loading="lazy" onerror="this.onerror=null; this.src='/img/ui/team-fallback.png';" /> </div> </div> </div> </td> <!-- STATUS --> <td class="col-status"> <div class="mobile-label d-md-none">Status</div> <span class="badge rounded-pill @StatusBadge(g.Status)"> @g.Status </span> </td> <!-- GAME --> <td class="col-game"> <div class="mobile-label d-md-none">Game</div> <div> <div class="poc-muted small">GameId</div> <div class="fw-semibold">@g.GameId</div> </div> </td> <!-- ACTION --> <td class="col-action text-end"> <div class="mobile-label d-md-none">Action</div> <a asp-page="/Nba/Matchup" asp-route-homeId="@g.HomeId" asp-route-awayId="@g.AwayId" class="btn btn-sm poc-btn-gradient px-3 w-100 w-md-auto"> Project </a> </td> </tr> } </tbody> </table> </div> </div> } </div> } </div> </div> # FILE: Pages/Nba/Matchup.cshtml @page @model BettingOdds.Pages.Nba.MatchupModel @{ // --------------------------------------- // Odds helpers // --------------------------------------- string ToAmerican(double p) { if (p <= 0 \|\| p >= 1) return "—"; var odds = p >= 0.5 ? -(p / (1 - p)) 100.0 : ((1 - p) / p) * 100.0; return odds >= 0 ? $"+{odds:0}" : $"{odds:0}"; } string ToDecimal(double p) { if (p <= 0 \|\| p >= 1) return "—"; return (1.0 / p).ToString("0.00"); } // --------------------------------------- // Spread conventions (Option A sportsbook) // --------------------------------------- // baseline spread is "expected margin" (Home - Away) // sportsbook line is the opposite sign: Home -X when expected margin is +X string ToSpreadLineFromMargin(double spreadHomeMinusAway) { var line = -spreadHomeMinusAway; return line >= 0 ? $"+{line:0.00}" : $"{line:0.00}"; } // fair engine returns sportsbook-style already: Home -X => negative string ToSpreadLineFromSportsbook(decimal homeLine) { var line = (double)homeLine; return line >= 0 ? $"+{line:0.00}" : $"{line:0.00}"; } bool IsFinal(string? status) => !string.IsNullOrWhiteSpace(status) && status.Contains("Final", StringComparison.OrdinalIgnoreCase); string ScoreOrDash(int? v) => v.HasValue ? v.Value.ToString() : "—"; string BadgeDelta(double? v, string unit = "") { if (!v.HasValue) return "—"; var x = v.Value; var s = x.ToString("+0.00;-0.00;0.00"); return string.IsNullOrWhiteSpace(unit) ? s : $"{s}{unit}"; } string BadgeDeltaPct(double? v) { if (!v.HasValue) return "—"; return (v.Value * 100.0).ToString("+0.00;-0.00;0.00") + "%"; } // --------------------------------------- // Premium UI helpers (no extra CSS needed) // --------------------------------------- double Clamp01(double x) => x < 0 ? 0 : x > 1 ? 1 : x; string ConfidenceColor(double conf01) { // simple 3-tier color scaling if (conf01 >= 0.75) return "#38d996"; // green-ish if (conf01 >= 0.50) return "#f6c343"; // amber-ish return "#ff6b6b"; // red-ish } string BarColor(bool isHome) => isHome ? "#4aa3ff" : "#ff7a45"; // home blue / away orange (inline only) // team factor bars: show deviation around 1.00 // map [0.80..1.20] => [0..100] as a visual (clamped) int FactorToPct(double factor) { var pct = (factor - 0.80) / 0.40; // 0..1 return (int)Math.Round(Clamp01(pct) * 100.0); } string FactorLabel(double factor) => factor.ToString("0.000"); // nice, premium precision } <div class="container py-4 poc-shell"> <div class="poc-card p-4 p-md-5"> <!-- Header --> <div class="d-flex flex-column flex-lg-row align-items-lg-center justify-content-between gap-3"> <div> <h2 class="mb-1 poc-title">Matchup</h2> <div class="poc-muted"> Baseline projection (team ratings) + player-adjusted fair lines (relevance snapshots). </div> <div class="mt-3 d-flex flex-wrap gap-2"> <span class="poc-pill">Output: Spread • Total • Moneyline</span> <span class="poc-pill">Spread convention: Sportsbook (Home -X favored)</span> @if (!string.IsNullOrWhiteSpace(Model.Vm?.GameStatus)) { <span class="poc-pill">Status: @Model.Vm!.GameStatus</span> } @if (!string.IsNullOrWhiteSpace(Model.Vm?.Arena)) { <span class="poc-pill">@Model.Vm!.Arena</span> } @if (!string.IsNullOrWhiteSpace(Model.Vm?.GameId)) { <span class="poc-pill">Game: @Model.Vm!.GameId</span> } </div> </div> <div class="d-flex gap-2"> <a asp-page="/Nba/Games" class="btn btn-outline-light btn-lg px-4"> Back to Games </a> </div> </div> <div class="mt-4 poc-divider"></div> @if (Model.Vm == null) { <div class="mt-4 poc-muted"> Provide <b>homeId</b> and <b>awayId</b> in the query string. </div> } else { var vm = Model.Vm!; var isFinal = IsFinal(vm.GameStatus); // Baseline (team-only) var b = vm.Baseline; var bProb = b.HomeWinProbability; // Player-adjusted fair (optional) var f = vm.Fair; var hasFair = f != null; var fairProb = hasFair ? (double)f!.HomeWinProb : 0.0; // ✅ FIX: use your new points (no ImpliedPoints) double usedHomePts = hasFair && vm.FairHomePoints.HasValue ? (double)vm.FairHomePoints.Value : b.HomePoints; double usedAwayPts = hasFair && vm.FairAwayPoints.HasValue ? (double)vm.FairAwayPoints.Value : b.AwayPoints; double usedTotal = hasFair ? (double)f!.FairTotal : b.FairTotal; // Player Adjustment Impact (badge): net point swing to home relative to baseline // (home swing - away swing) / 2 is a clean symmetric measure; // but for a badge, people understand "net to home" => homePtsDelta - awayPtsDelta. double impactToHomePts = (usedHomePts - b.HomePoints) - (usedAwayPts - b.AwayPoints); // Confidence double conf01 = hasFair ? Clamp01((double)f!.Confidence) : 0.0; string confColor = ConfidenceColor(conf01); int confPct = (int)Math.Round(conf01 * 100.0); // Team factors bars double homeFactor = hasFair ? (double)f!.HomeTeamFactor : 1.0; double awayFactor = hasFair ? (double)f!.AwayTeamFactor : 1.0; int homeFactorPct = FactorToPct(homeFactor); int awayFactorPct = FactorToPct(awayFactor); <div class="row mt-4 g-4"> <!-- Left: Matchup + totals/points --> <div class="col-12 col-lg-7"> <div class="poc-card p-4 h-100"> <div class="d-flex justify-content-between align-items-start gap-3 flex-wrap"> <div class="flex-grow-1"> <div class="poc-muted small">Matchup</div> <div class="mh-shell"> <div class="mh-row"> <!-- Away --> <div class="mh-team mh-away"> <div class="mh-logo-wrap"> <img src="@vm.AwayTeamLogoUrl" alt="@vm.AwayTeamName logo" class="mh-logo" loading="lazy" onerror="this.onerror=null; this.src='/img/ui/team-fallback.png';" /> </div> <div class="mh-text"> <div class="mh-name">@vm.AwayTeamName</div> <div class="mh-sub">Away</div> </div> </div> <div class="mh-vs" aria-label="versus">VS</div> <!-- Home --> <div class="mh-team mh-home"> <div class="mh-text text-end"> <div class="mh-name">@vm.HomeTeamName</div> <div class="mh-sub">Home</div> </div> <div class="mh-logo-wrap"> <img src="@vm.HomeTeamLogoUrl" alt="@vm.HomeTeamName logo" class="mh-logo" loading="lazy" onerror="this.onerror=null; this.src='/img/ui/team-fallback.png';" /> </div> </div> </div> <div class="mh-meta"> <div class="mh-meta-left"> <span class="mh-meta-label">Game Date (UTC)</span> <span class="mh-meta-value"> @(vm.GameDateUtc.HasValue? vm.GameDateUtc.Value.ToString("u") : "—") </span> </div> <div class="mh-meta-right"> @if (!string.IsNullOrWhiteSpace(vm.GameStatus)) { <span class="mh-chip">@vm.GameStatus</span> } @if (isFinal) { <span class="mh-chip">Actual: @ScoreOrDash(vm.AwayScore) - @ScoreOrDash(vm.HomeScore)</span> } </div> </div> </div> </div> <!-- KPI strip --> <div class="poc-card p-4 kpi-card"> <div class="poc-muted small">Projected Total</div> <div class="kpi-big"> @usedTotal.ToString("0.00") </div> <div class="kpi-foot poc-muted small mt-2"> @if (hasFair) { <span>Player-adjusted (fair engine).</span> } else { <span>Baseline (team-only).</span> } </div> @if (isFinal && vm.AwayScore.HasValue && vm.HomeScore.HasValue) { var actualTotal = vm.AwayScore.Value + vm.HomeScore.Value; var totalErr = usedTotal - actualTotal; <div class="kpi-divider my-3"></div> <div class="kpi-stats"> <div class="kpi-stat"> <div class="kpi-label">Actual</div> <div class="kpi-value">@actualTotal</div> </div> <div class="kpi-vrule"></div> <div class="kpi-stat"> <div class="kpi-label">Δ (Proj - Actual)</div> <div class="kpi-value">@totalErr.ToString("0.00")</div> </div> </div> } </div> </div> <div class="mt-4 poc-divider"></div> <!-- ✅ NEW: Impact bars + confidence row --> <div class="row mt-4 g-3"> <div class="col-12"> <div class="poc-card p-4"> <div class="d-flex justify-content-between align-items-start flex-wrap gap-2"> <div> <div class="poc-muted small">Model Adjustments</div> <div class="fw-semibold mt-1">Team factors + player impact</div> </div> @if (hasFair) { <div class="d-flex flex-wrap gap-2"> <span class="poc-pill"> Player Impact: <span class="fw-semibold">@impactToHomePts.ToString("+0.00;-0.00;0.00")</span> pts to Home </span> <span class="poc-pill"> Confidence: <span class="fw-semibold">@confPct%</span> </span> </div> } else { <span class="poc-pill">Fair engine not available</span> } </div> @if (hasFair) { <div class="mt-3"> <!-- Confidence bar --> <div class="d-flex justify-content-between align-items-center"> <div class="poc-muted small">Confidence</div> <div class="poc-muted small">@conf01.ToString("0.00")</div> </div> <div class="mt-2" style="height:10px;border-radius:999px;background:rgba(255,255,255,0.08);overflow:hidden;"> <div style="height:10px;width:@confPct%;background:@confColor;"></div> </div> <div class="mt-3 row g-3"> <!-- Home factor --> <div class="col-12 col-md-6"> <div class="poc-card p-3"> <div class="d-flex justify-content-between align-items-center"> <div class="fw-semibold">@vm.HomeTeamName</div> <span class="poc-pill">Factor: @FactorLabel(homeFactor)</span> </div> <div class="mt-2" style="height:10px;border-radius:999px;background:rgba(255,255,255,0.08);overflow:hidden;"> <div style="height:10px;width:@homeFactorPct%;background:@BarColor(true);"></div> </div> <div class="mt-2 poc-muted small"> Baseline = 1.00 (higher = stronger) </div> </div> </div> <!-- Away factor --> <div class="col-12 col-md-6"> <div class="poc-card p-3"> <div class="d-flex justify-content-between align-items-center"> <div class="fw-semibold">@vm.AwayTeamName</div> <span class="poc-pill">Factor: @FactorLabel(awayFactor)</span> </div> <div class="mt-2" style="height:10px;border-radius:999px;background:rgba(255,255,255,0.08);overflow:hidden;"> <div style="height:10px;width:@awayFactorPct%;background:@BarColor(false);"></div> </div> <div class="mt-2 poc-muted small"> /* ... truncated for agent context ... / # FILE: Pages/Nba/Player.cshtml @page @model BettingOdds.Pages.Nba.PlayerModel @{ ViewData["Title"] = Model.PlayerTitle ?? "Player"; static string Pct01(decimal v) => (v 100m).ToString("0.00") + "%"; } <div class="container py-4 poc-shell"> <div class="poc-card p-4 p-md-5"> <div class="d-flex flex-column flex-md-row align-items-md-center justify-content-between gap-3 mb-3"> <div> <h2 class="mb-1 poc-title">@Model.PlayerTitle</h2> <div class="poc-muted"> Rolling performance snapshots and relevance context. </div> <div class="mt-3 d-flex flex-wrap gap-2"> <span class="poc-pill">Player ID: @Model.PlayerId</span> @if (!string.IsNullOrWhiteSpace(Model.TeamLabel)) { <span class="poc-pill">Team: @Model.TeamLabel</span> } <span class="poc-pill">Window: Last @Model.LastNGames games</span> <span class="poc-pill">Latest As-Of (UTC): @(Model.LatestAsOfUtc?.ToString("u") ?? "—")</span> </div> </div> <div class="d-flex gap-2"> @if (Model.TeamId.HasValue) { <a asp-page="/Nba/Team" asp-route-teamId="@Model.TeamId" asp-route-lastNGames="@Model.LastNGames" class="btn btn-outline-light px-4"> Back to Team </a> } <a asp-page="/Nba/Teams" class="btn btn-outline-light px-4">All Teams</a> </div> </div> <div class="poc-divider"></div> <form method="get" class="mt-3 d-flex flex-wrap gap-2 align-items-center"> <input type="hidden" name="playerId" value="@Model.PlayerId" /> @if (Model.TeamId.HasValue) { <input type="hidden" name="teamId" value="@Model.TeamId" /> } <div class="poc-muted small">Rolling window</div> <select name="lastNGames" class="form-select form-select-sm" style="max-width:160px;"> @foreach (var n in new[] { 5, 10, 15, 30 }) { <option value="@n" selected="@(Model.LastNGames == n ? "selected" : null)">Last @n</option> } </select> <button type="submit" class="btn btn-outline-light btn-sm px-3"> Apply </button> @if (Model.LatestRelevance != null) { <div class="ms-auto d-flex flex-wrap gap-2"> <span class="poc-pill">Tier: @Model.LatestRelevance.TierLabel</span> <span class="poc-pill">Relevance: @Model.LatestRelevance.RelevanceScore.ToString("0.00")</span> <span class="poc-pill">Min Share: @Model.LatestRelevance.MinutesSharePct.ToString("0.00")%</span> <span class="poc-pill">Min Avg: @Model.LatestRelevance.RecentMinutesAvg.ToString("0.00")</span> </div> } </form> @if (!string.IsNullOrWhiteSpace(Model.Error)) { <div class="mt-4 poc-card p-3"> <div class="fw-semibold">Notice</div> <div class="poc-muted">@Model.Error</div> </div> } else { <!-- KPI ROW --> <div class="row g-3 mt-3"> @if (Model.Deltas != null) { <div class="col-12 col-lg-8"> <div class="poc-card p-4"> <div class="d-flex justify-content-between align-items-center"> <div class="fw-semibold">Momentum (Δ vs Baseline)</div> <span class="poc-pill">Baseline: @Model.Deltas.BaselineAsOfUtc.ToString("u")</span> </div> <div class="row g-3 mt-2"> <div class="col-6 col-md-3"> <div class="poc-kpi"> <div class="poc-muted small">Δ MIN</div> <div class="poc-title">@BettingOdds.Pages.Nba.PlayerModel.Signed2(Model.Deltas.DeltaMinutes)</div> </div> </div> <div class="col-6 col-md-3"> <div class="poc-kpi"> <div class="poc-muted small">Δ PTS</div> <div class="poc-title">@BettingOdds.Pages.Nba.PlayerModel.Signed2(Model.Deltas.DeltaPoints)</div> </div> </div> <div class="col-6 col-md-3"> <div class="poc-kpi"> <div class="poc-muted small">Δ TS</div> <div class="poc-title">@BettingOdds.Pages.Nba.PlayerModel.Signed2(Model.Deltas.DeltaTS)</div> </div> </div> <div class="col-6 col-md-3"> <div class="poc-kpi"> <div class="poc-muted small">Δ 3P%</div> <div class="poc-title">@BettingOdds.Pages.Nba.PlayerModel.Signed2(Model.Deltas.DeltaThreePpct)</div> </div> </div> </div> <div class="mt-2 poc-muted small"> Interpreting TS/3P%: values are in <span class="fw-semibold">0..1</span> form in DB; the table below shows them as %. </div> </div> </div> } @if (Model.LatestRelevance != null) { <div class="col-12 col-lg-4"> <div class="poc-card p-4"> <div class="d-flex justify-content-between align-items-center"> <div class="fw-semibold">Role / Relevance</div> <span class="poc-pill">@Model.LatestRelevance.TierLabel</span> </div> <div class="row g-3 mt-2"> <div class="col-6"> <div class="poc-kpi"> <div class="poc-muted small">Score</div> <div class="poc-title">@Model.LatestRelevance.RelevanceScore.ToString("0.00")</div> </div> </div> <div class="col-6"> <div class="poc-kpi"> <div class="poc-muted small">Min Share</div> <div class="poc-title">@Model.LatestRelevance.MinutesSharePct.ToString("0.00")%</div> </div> </div> <div class="col-12"> <div class="poc-kpi"> <div class="poc-muted small">Recent Min Avg</div> <div class="poc-title">@Model.LatestRelevance.RecentMinutesAvg.ToString("0.00")</div> </div> </div> </div> <div class="mt-2 poc-muted small"> Tier is computed from minutes share + availability proxy. </div> </div> </div> } </div> <!-- TREND TABLE --> <div class="row g-3 mt-3"> <div class="col-12"> <div class="poc-card p-4"> <div class="d-flex justify-content-between align-items-center"> <div class="fw-semibold">Rolling Trend</div> <span class="poc-pill">Last @Model.Take snapshots</span> </div> <div class="table-responsive mt-3"> <table class="table table-dark table-borderless align-middle mb-0"> <thead> <tr class="poc-muted small"> <th>As-Of (UTC)</th> <th class="text-end">MIN</th> <th class="text-end">PTS</th> <th class="text-end">REB</th> <th class="text-end">AST</th> <th class="text-end">TOV</th> <th class="text-end">TS%</th> <th class="text-end">3P%</th> </tr> </thead> <tbody> @foreach (var s in Model.Trend) { <tr> <td class="fw-semibold">@s.AsOfUtc.ToString("u")</td> <td class="text-end">@s.MinutesAvg.ToString("0.00")</td> <td class="text-end">@s.PointsAvg.ToString("0.00")</td> <td class="text-end">@s.ReboundsAvg.ToString("0.00")</td> <td class="text-end">@s.AssistsAvg.ToString("0.00")</td> <td class="text-end">@s.TurnoversAvg.ToString("0.00")</td> <td class="text-end">@Pct01(s.TS)</td> <td class="text-end">@Pct01(s.ThreePpct)</td> </tr> } </tbody> </table> </div> <div class="mt-3 poc-muted small"> Tip: role changes show up in MIN; efficiency swings show up in TS/3P%. </div> </div> </div> </div> } </div> </div> OUTPUT CONTRACT (STRICT): - Return JSON that matches AgentPatchSet {} exactly. - Each patch must include: - Path: relative repo path using forward slashes - NewContent: FULL final file content (not a diff) - Reason: short explanation - Do NOT output unified diff. - Do NOT wrap output in markdown. - Conventions: - All namespaces must start with: namespace BettingOdds. - Domain entities: namespace BettingOdds.Domain.Entities.<Area>; - DbContext must be: namespace BettingOdds.Data; public sealed class AppDbContext : DbContext - Migrations namespace must be: namespace BettingOdds.Migrations; - Identity PKs: public long <EntityName>Id (no int Id). - Do not create alternate DbContexts. - Unique indexes must not include nullable PlayerId; use deterministic PlayerKey.
Preflight	Running	2026-02-19 18:49:04	—	—	—	0

Guard

Policy checks for patch safety.

No guard report recorded for this run.

Patch sets

Unified diffs generated by the Implementer.

No patch sets were generated.

Build & test logs

Captured dotnet execution output for this run.

No executions recorded yet.

Files included

Repo file snapshot used during this run (for audit & reproducibility).

No file snapshots recorded.