Compare commits

...

3 Commits

Author SHA1 Message Date
cesnimda 6d8168ea91 test(calendar): qualify native status and follow-up journey 2026-11-18 13:22:57 +01:00
cesnimda f604f028d3 perf(analytics): combine stats scalar count queries 2026-11-18 13:22:57 +01:00
cesnimda dacdf16934 feat(dev): add isolated Windows Docker rebuild script 2026-11-18 13:11:26 +01:00
67 changed files with 1439 additions and 6 deletions
@@ -0,0 +1,290 @@
using System.Data.Common;
using System.Text.Json;
using JobTrackerApi.Data;
using JobTrackerApi.Models;
using JobTrackerApi.Services;
using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using Moq;
using Xunit;
using Xunit.Abstractions;
namespace JobTrackerApi.Tests;
public sealed class AnalyticsStatsQueryTests(ITestOutputHelper output)
{
[Theory]
[InlineData(0)]
[InlineData(250)]
[InlineData(2500)]
public async Task Stats_keep_narrow_server_aggregates_with_two_fewer_roundtrips(int size)
{
await using var fixture = await Fixture.Create();
var now = DateTime.Now;
fixture.Db.JobApplications.AddRange(Enumerable.Range(0, size).Select(i => fixture.Job("owner", "Applied", now.AddDays(-10))));
fixture.Db.JobApplications.Add(fixture.Job("foreign", "Private", now));
fixture.Db.JobApplications.Add(fixture.Job(null, "Unowned", now));
await fixture.Db.SaveChangesAsync();
fixture.Db.ChangeTracker.Clear();
fixture.Recorder.Commands.Clear();
var stats = await new AnalyticsService(fixture.Db).GetStatsAsync(default);
Assert.Equal(size, stats.Total);
Assert.Equal(size, stats.Active);
Assert.Equal(0, stats.Deleted);
Assert.Equal(size, stats.AppliedLast30Days);
Assert.Equal(size == 0 ? 0 : 10, stats.AverageDaysSinceApplied);
Assert.Equal(size == 0 ? 0 : 1, stats.ByStatus.Count);
if (size > 0) Assert.Equal(size, stats.ByStatus["Applied"]);
Assert.Empty(fixture.Db.ChangeTracker.Entries());
var rows = await fixture.Recorder.ReplayRows(fixture.Connection);
output.WriteLine(JsonSerializer.Serialize(new { Provider = "SQLite", OwnedRows = size, Commands = fixture.Recorder.Commands.Count, ReturnedRowsPerCommand = rows, Sql = fixture.Recorder.Commands.Select(x => x.Sql) }));
Assert.All(fixture.Recorder.Commands, command =>
{
Assert.DoesNotContain("Description", command.Sql);
Assert.DoesNotContain("CoverLetterText", command.Sql);
Assert.DoesNotContain("JobTitle", command.Sql);
});
Assert.Equal(size == 0 ? 2 : 3, fixture.Recorder.Commands.Count);
Assert.Equal(size == 0 ? 0 : size + 2, rows.Sum());
}
[Fact]
public async Task Stats_preserve_deleted_nullable_future_dates_status_keys_and_live_owner_filters()
{
await using var fixture = await Fixture.Create();
var now = DateTime.Now;
var statuses = new[] { "Applied", "Applied", "applied", "", " ", "Unknown", " Applied " };
DateTime?[] dates = [now.AddDays(-29.5), now.AddDays(-30.5), now.AddDays(-10.375), now.AddDays(2), null, null, null];
fixture.Db.JobApplications.AddRange(statuses.Select((status, i) => fixture.Job("owner", status, dates[i])));
fixture.Db.JobApplications.Add(fixture.Job("owner", "Deleted", now, deleted: true));
fixture.Db.JobApplications.Add(fixture.Job("owner", "Deleted", null, deleted: true));
fixture.Db.JobApplications.Add(fixture.Job("foreign", "Private", now.AddDays(-1)));
fixture.Db.JobApplications.Add(fixture.Job(null, "Unowned", now));
await fixture.Db.SaveChangesAsync();
var service = new AnalyticsService(fixture.Db);
var stats = await service.GetStatsAsync(default);
Assert.Equal(9, stats.Total);
Assert.Equal(7, stats.Active);
Assert.Equal(2, stats.Deleted);
Assert.Equal(3, stats.AppliedLast30Days); // Future dates still satisfy the existing lower bound.
Assert.Equal(17.6, stats.AverageDaysSinceApplied); // Nulls excluded; future age clamped to zero.
Assert.Equal(3, stats.ByStatus["Unknown"]);
Assert.Equal(2, stats.ByStatus["Applied"]);
Assert.Equal(1, stats.ByStatus["applied"]);
Assert.Equal(1, stats.ByStatus[" Applied "]);
Assert.Equal(4, stats.ByStatus.Count);
fixture.User.SetupGet(x => x.UserId).Returns("foreign");
Assert.Equal(1, (await service.GetStatsAsync(default)).Total);
fixture.User.SetupGet(x => x.UserId).Returns((string?)null);
var anonymous = await service.GetStatsAsync(default);
Assert.Equal(0, anonymous.Total);
Assert.Equal(0, anonymous.Active);
Assert.Equal(0, anonymous.AppliedLast30Days);
Assert.Equal(0, anonymous.AverageDaysSinceApplied);
Assert.Empty(anonymous.ByStatus);
}
[Theory]
[InlineData(true)]
[InlineData(false)]
public async Task Deleted_only_and_null_applied_dates_keep_zero_averages(bool deleted)
{
await using var fixture = await Fixture.Create();
fixture.Db.JobApplications.Add(fixture.Job("owner", "Saved", null, deleted));
await fixture.Db.SaveChangesAsync();
fixture.Recorder.Commands.Clear();
var stats = await new AnalyticsService(fixture.Db).GetStatsAsync(default);
Assert.Equal(1, stats.Total);
Assert.Equal(deleted ? 0 : 1, stats.Active);
Assert.Equal(deleted ? 1 : 0, stats.Deleted);
Assert.Equal(0, stats.AppliedLast30Days);
Assert.Equal(0, stats.AverageDaysSinceApplied);
Assert.Equal(deleted ? 2 : 3, fixture.Recorder.Commands.Count);
}
[Fact]
public async Task Applied_volume_keeps_the_exact_thirty_day_lower_bound_inclusive()
{
await using var fixture = await Fixture.Create();
var atBoundary = fixture.Job("owner", "Applied", null);
var beforeBoundary = fixture.Job("owner", "Applied", null);
fixture.Db.JobApplications.AddRange(atBoundary, beforeBoundary);
await fixture.Db.SaveChangesAsync();
var setBoundary = false;
fixture.Recorder.BeforeReader = () =>
{
var parameter = fixture.Recorder.Commands.Last().Parameters.FirstOrDefault(x => x.Key.Contains("last30", StringComparison.Ordinal));
if (setBoundary || parameter.Value is not DateTime cutoff) return;
// Use the service's captured cutoff, so this assertion cannot drift with the clock.
using var command = fixture.Connection.CreateCommand();
command.CommandText = "UPDATE JobApplications SET DateApplied = $date WHERE Id = $id";
command.Parameters.AddWithValue("$date", cutoff);
command.Parameters.AddWithValue("$id", atBoundary.Id);
command.ExecuteNonQuery();
command.Parameters["$date"].Value = cutoff.AddTicks(-1);
command.Parameters["$id"].Value = beforeBoundary.Id;
command.ExecuteNonQuery();
setBoundary = true;
};
var stats = await new AnalyticsService(fixture.Db).GetStatsAsync(default);
Assert.True(setBoundary);
Assert.Equal(1, stats.AppliedLast30Days);
Assert.Equal(30, stats.AverageDaysSinceApplied);
}
[Fact]
public async Task Repeated_stats_observe_mutations_without_caching()
{
await using var fixture = await Fixture.Create();
var job = fixture.Job("owner", "Saved", null);
fixture.Db.JobApplications.Add(job);
await fixture.Db.SaveChangesAsync();
var service = new AnalyticsService(fixture.Db);
var before = await service.GetStatsAsync(default);
Assert.Equal(1, before.Active);
job.IsDeleted = true;
job.DateApplied = DateTime.Now;
await fixture.Db.SaveChangesAsync();
var after = await service.GetStatsAsync(default);
Assert.Equal(1, after.Total);
Assert.Equal(0, after.Active);
Assert.Empty(after.ByStatus);
Assert.Equal(1, before.ByStatus["Saved"]);
}
[Fact]
public async Task Cancellation_reaches_the_native_command_and_stops_later_queries()
{
await using var fixture = await Fixture.Create();
using var cancellation = new CancellationTokenSource();
fixture.Recorder.Commands.Clear();
fixture.Recorder.BeforeReader = () => cancellation.Cancel();
await Assert.ThrowsAnyAsync<OperationCanceledException>(() => new AnalyticsService(fixture.Db).GetStatsAsync(cancellation.Token));
Assert.Single(fixture.Recorder.Commands);
Assert.Equal(cancellation.Token, fixture.Recorder.LastToken);
}
[Fact]
public async Task Pomelo_generates_the_actual_stats_aggregate_without_opening_a_database()
{
var connectionGuard = new ClosedConnectionGuard();
var capture = new PomeloCommandCapture();
var options = new DbContextOptionsBuilder<JobTrackerContext>()
.UseMySql("Server=127.0.0.1;Database=translation_only;User=none;Password=none;", new MariaDbServerVersion(new Version(12, 2, 2)))
.AddInterceptors(connectionGuard, capture).Options;
var user = new Mock<ICurrentUserService>();
user.SetupGet(x => x.UserId).Returns("owner");
await using var db = new JobTrackerContext(options, user.Object);
await Assert.ThrowsAsync<CapturedSqlException>(() => new AnalyticsService(db).GetStatsAsync(default));
Assert.Equal(System.Data.ConnectionState.Closed, db.Database.GetDbConnection().State);
Assert.Equal(1, connectionGuard.SuppressedOpenRequests);
Assert.Contains("COUNT(", capture.Sql);
Assert.Contains("CASE", capture.Sql);
Assert.Contains("`OwnerUserId`", capture.Sql);
Assert.Contains("`DateApplied`", capture.Sql);
Assert.Contains(">=", capture.Sql);
Assert.Contains("GROUP BY", capture.Sql);
Assert.DoesNotContain("Description", capture.Sql);
output.WriteLine("Pomelo SQL compiled but not executed: " + capture.Sql);
}
[Fact]
public async Task Legacy_null_status_still_merges_into_unknown()
{
var options = new DbContextOptionsBuilder<JobTrackerContext>().UseInMemoryDatabase(Guid.NewGuid().ToString(), config => config.EnableNullChecks(false)).Options;
var user = new Mock<ICurrentUserService>();
user.SetupGet(x => x.UserId).Returns("owner");
await using var db = new JobTrackerContext(options, user.Object);
db.JobApplications.AddRange(new JobApplication { OwnerUserId = "owner", Status = null! }, new JobApplication { OwnerUserId = "owner", Status = "Unknown" });
await db.SaveChangesAsync();
var stats = await new AnalyticsService(db).GetStatsAsync(default);
Assert.Equal(2, stats.ByStatus["Unknown"]);
}
private sealed class Fixture(SqliteConnection connection, JobTrackerContext db, Mock<ICurrentUserService> user, CommandRecorder recorder) : IAsyncDisposable
{
public SqliteConnection Connection => connection;
public JobTrackerContext Db => db;
public Mock<ICurrentUserService> User => user;
public CommandRecorder Recorder => recorder;
public JobApplication Job(string? owner, string status, DateTime? applied, bool deleted = false) => new()
{
OwnerUserId = owner, CompanyId = 1, JobTitle = "Synthetic", Status = status, DateApplied = applied, IsDeleted = deleted,
Description = new string('x', 4096), CoverLetterText = new string('y', 4096)
};
public static async Task<Fixture> Create()
{
var connection = new SqliteConnection("Data Source=:memory:");
await connection.OpenAsync();
var recorder = new CommandRecorder();
var user = new Mock<ICurrentUserService>();
user.SetupGet(x => x.UserId).Returns("owner");
var db = new JobTrackerContext(new DbContextOptionsBuilder<JobTrackerContext>().UseSqlite(connection).AddInterceptors(recorder).Options, user.Object);
await db.Database.EnsureCreatedAsync();
db.Users.AddRange(new ApplicationUser { Id = "owner" }, new ApplicationUser { Id = "foreign" });
db.Companies.Add(new Company { Id = 1, Name = "Synthetic", OwnerUserId = "owner" });
await db.SaveChangesAsync();
recorder.Commands.Clear();
return new Fixture(connection, db, user, recorder);
}
public async ValueTask DisposeAsync() { await db.DisposeAsync(); await connection.DisposeAsync(); }
}
private sealed class CommandRecorder : DbCommandInterceptor
{
public List<(string Sql, Dictionary<string, object?> Parameters)> Commands { get; } = [];
public Action? BeforeReader { get; set; }
public CancellationToken LastToken { get; private set; }
public override ValueTask<InterceptionResult<DbDataReader>> ReaderExecutingAsync(DbCommand command, CommandEventData eventData, InterceptionResult<DbDataReader> result, CancellationToken cancellationToken = default)
{
Commands.Add((command.CommandText, command.Parameters.Cast<DbParameter>().ToDictionary(p => p.ParameterName, p => p.Value)));
LastToken = cancellationToken;
BeforeReader?.Invoke();
return ValueTask.FromResult(result);
}
public async Task<List<int>> ReplayRows(SqliteConnection connection)
{
var rows = new List<int>();
foreach (var captured in Commands)
{
await using var command = connection.CreateCommand();
command.CommandText = captured.Sql;
foreach (var parameter in captured.Parameters) command.Parameters.AddWithValue(parameter.Key, parameter.Value ?? DBNull.Value);
var count = 0;
await using var reader = await command.ExecuteReaderAsync();
while (await reader.ReadAsync()) count++;
rows.Add(count);
}
return rows;
}
}
private sealed class CapturedSqlException : Exception;
private sealed class ClosedConnectionGuard : DbConnectionInterceptor
{
public int SuppressedOpenRequests { get; private set; }
public override InterceptionResult ConnectionOpening(DbConnection connection, ConnectionEventData eventData, InterceptionResult result)
{
SuppressedOpenRequests++;
return InterceptionResult.Suppress();
}
public override ValueTask<InterceptionResult> ConnectionOpeningAsync(DbConnection connection, ConnectionEventData eventData, InterceptionResult result, CancellationToken cancellationToken = default)
=> ValueTask.FromResult(ConnectionOpening(connection, eventData, result));
}
private sealed class PomeloCommandCapture : DbCommandInterceptor
{
public string Sql { get; private set; } = "";
public override ValueTask<InterceptionResult<DbDataReader>> ReaderExecutingAsync(DbCommand command, CommandEventData eventData, InterceptionResult<DbDataReader> result, CancellationToken cancellationToken = default)
{
Sql = command.CommandText;
throw new CapturedSqlException();
}
}
}
+12 -4
View File
@@ -25,10 +25,18 @@ namespace JobTrackerApi.Services
var last30 = now.AddDays(-30);
// Aggregate server-side (COUNT/GROUP BY) instead of pulling every row into memory.
var total = await _db.JobApplications.AsNoTracking().CountAsync(cancellationToken);
var active = await _db.JobApplications.AsNoTracking().CountAsync(j => !j.IsDeleted, cancellationToken);
var appliedLast30Days = await _db.JobApplications.AsNoTracking()
.CountAsync(j => !j.IsDeleted && j.DateApplied >= last30, cancellationToken);
var counts = await _db.JobApplications.AsNoTracking()
.GroupBy(_ => 1)
.Select(g => new
{
Total = g.Count(),
Active = g.Count(j => !j.IsDeleted),
AppliedLast30Days = g.Count(j => !j.IsDeleted && j.DateApplied >= last30)
})
.SingleOrDefaultAsync(cancellationToken);
var total = counts?.Total ?? 0;
var active = counts?.Active ?? 0;
var appliedLast30Days = counts?.AppliedLast30Days ?? 0;
var byStatus = await _db.JobApplications
.AsNoTracking()
+99
View File
@@ -0,0 +1,99 @@
# Standalone local project: do not combine with production Compose or its .env.
services:
database:
image: mariadb:12.2.2@sha256:42a27baaba3e8f3f0159d16381d5a7156661aa91dcc65f663cabb6a6f9503c00
environment:
MARIADB_ROOT_PASSWORD: ${JT_LOCAL_DB_ROOT_PASSWORD:?Run rebuild-windows-docker.ps1 first}
MARIADB_DATABASE: jobtracker
MARIADB_USER: jobtracker
MARIADB_PASSWORD: ${JT_LOCAL_DB_PASSWORD:?Run rebuild-windows-docker.ps1 first}
volumes:
- database:/var/lib/mysql
command: ["--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]
healthcheck:
test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
interval: 3s
timeout: 5s
retries: 45
start_period: 20s
restart: unless-stopped
backend:
image: jobjakt-windows-local-backend:latest
build:
context: ..
dockerfile: JobTrackerApi/Dockerfile
environment:
ASPNETCORE_ENVIRONMENT: Development
ASPNETCORE_URLS: http://+:8080
Database__Provider: mariadb
Database__ServerVersion: "12.2.2"
ConnectionStrings__JobTracker: Server=database;Database=jobtracker;User ID=jobtracker;Password=${JT_LOCAL_DB_PASSWORD};SslMode=None
Data__Root: /data
AccountLifecycle__TombstonesRoot: /account-lifecycle/tombstones
Auth__Require: "true"
Auth__JwtKey: ${JT_LOCAL_JWT_KEY:?Run rebuild-windows-docker.ps1 first}
Auth__AdminEmail: ${JT_LOCAL_ADMIN_EMAIL:?Run rebuild-windows-docker.ps1 first}
Auth__AdminPassword: ${JT_LOCAL_ADMIN_PASSWORD:?Run rebuild-windows-docker.ps1 first}
Auth__AllowRegistration: "false"
App__PublicBaseUrl: http://localhost:${JT_LOCAL_PORT:-3000}
App__Version: windows-local
App__CommitSha: ${JT_LOCAL_COMMIT:-unknown}
HttpsRedirection__Enabled: "false"
Proxy__TrustForwardedHeaders: "false"
Ai__BaseUrl: http://127.0.0.1:9
Summarizer__BaseUrl: http://127.0.0.1:9
Ai__ExternalProcessingEnabled: "false"
Email__Enabled: "false"
AccountLifecycle__DeletionEnabled: "false"
Workers__RulesEnabled: "false"
Workers__FollowUpRemindersEnabled: "false"
Workers__SavedJobSearchAlertsEnabled: "false"
Workers__DailyExportEnabled: "false"
Workers__JobEnrichmentEnabled: "false"
Workers__AiOperationsEnabled: "false"
Workers__CvDocumentImportsEnabled: "false"
volumes:
- files:/data
- tombstones:/account-lifecycle/tombstones
depends_on:
database:
condition: service_healthy
networks:
default:
aliases: [backend-web]
healthcheck:
test: ["CMD", "curl", "-fsS", "http://127.0.0.1:8080/ready"]
interval: 5s
timeout: 5s
retries: 45
start_period: 90s
restart: unless-stopped
frontend:
image: jobjakt-windows-local-frontend:latest
build:
context: ../job-tracker-ui
shm_size: 1gb
args:
NEXT_PUBLIC_API_BASE_URL: /api
environment:
APP_PUBLIC_BASE_URL: http://localhost:${JT_LOCAL_PORT:-3000}
INGRESS_MODE: direct
ports:
- "127.0.0.1:${JT_LOCAL_PORT:-3000}:80"
depends_on:
backend:
condition: service_healthy
healthcheck:
test: ["CMD", "wget", "-q", "-O", "/dev/null", "http://127.0.0.1/health"]
interval: 3s
timeout: 5s
retries: 20
start_period: 10s
restart: unless-stopped
volumes:
database:
files:
tombstones:
+37
View File
@@ -0,0 +1,37 @@
# Rebuild and run locally on Windows
Start Docker Desktop in **Linux containers** mode, then run PowerShell:
```powershell
powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Users\Connor\.codex\worktrees\direct-roadmap-integration\Job tracker\scripts\rebuild-windows-docker.ps1"
```
Open http://localhost:3000 after the script finishes. It rebuilds backend/frontend from that checkout, reports its branch/commit and starts a separate `jobjakt-windows-local` project. It neither pulls Git changes nor selects `main`; run it again after development checkpoints are integrated into this checkout. Working-copy changes are included in Docker's ordinary build context. First build needs internet for existing base images and locked dependencies.
Login is `local-admin@example.test`. The generated password is the `JT_LOCAL_ADMIN_PASSWORD` value in `.env.windows-local` at the checkout root; open that private file locally to read it. The file is ignored by Git. Keep it and use the same checkout for subsequent rebuilds: changing database credentials after volumes exist prevents connection. The separate local database starts empty; existing production accounts/data are not imported.
Useful options:
```powershell
# Use another local port if3000 is occupied.
.\scripts\rebuild-windows-docker.ps1 -Port 3001
# Validate configuration without building or starting containers.
.\scripts\rebuild-windows-docker.ps1 -ValidateOnly
# Rebuild without Docker layer cache when needed.
.\scripts\rebuild-windows-docker.ps1 -NoCache
# Stop this local project, retaining its database/files and credentials.
docker --context desktop-linux compose --project-name jobjakt-windows-local --env-file .env.windows-local -f dev/windows-local.compose.yml stop
```
The last commands run from the same checkout root. `-DockerContext default` is available if that is your local Linux Docker context. The start path rejects remote Docker endpoints and non-Linux engines. The script never deletes volumes or pushes images. Database/files/tombstones have separate named volumes owned by this project; only frontend port3000 is exposed, on127.0.0.1. The API/database are internal.
This stack intentionally has no AI sidecar/Ollama, mail delivery or background provider/model workers. Existing manual application/Career/CV/PDF workflows remain available; generative and sidecar-dependent import functions need their separately approved test stack. AI activation remains a separate owner decision, including model identity and local-only routing. No production Compose/environment is loaded.
## Verification
18November2026: PowerShell parser and rendered Compose contract tests **2/2 PASSED**, zero skips; `-ValidateOnly` twice PASSED, preserving the credential file. Checks cover exact build contexts, three-service allowlist, loopback port, internal API/database, persistent project-owned volumes, same-origin routing, authentication and disabled external/background processing. `python scripts/test-windows-docker.py` executes no build/container commands.
**Docker build/start NOT RUN:** local Docker Desktop Linux engine pipe was absent when inspected. Start Docker Desktop before running the script. Source/static checks do not establish container startup, image builds, Node20 compatibility, database migration parity, PDF fidelity or full release qualification.
@@ -0,0 +1,39 @@
# PERF-06 · Analytics stats aggregate queries
Application baseline `1db5f488f6138e4f0f33749452b7d9f47658f4b0`, isolated `codex/analytics-query-batch`. Roadmap source `271d37d1`, `docs/direct-roadmap/LATEST_CHECKPOINT.md` and PERF-06 in `ROADMAP_TODO.md`, required a measured baseline before combining queries. The only application edit is inside `AnalyticsService.GetStatsAsync`; controller, DTO, overview, schema, configuration, Career completeness and caching are unchanged.
## Native baseline and change
Before editing the service, a command interceptor recorded the SQL and parameters actually issued by GetStats against disposable in-memory **native SQLite** fixtures. Replaying those exact recorded commands/parameters against the unchanged fixture measured result-row counts. The diagnostic replay commands run after the service and are not included in its command count. Every fixture also contains a foreign-owned application and an unowned application, with wide synthetic text columns that must not appear in the selected projection.
| Owned active applications | Before service commands | After service commands | Before replay result rows | After replay result rows |
| ---: | ---: | ---: | --- | --- |
| 0 | 4 | 2 | `[1,1,1,0]` | `[0,0]` |
| 250 | 5 | 3 | `[1,1,1,1,250]` | `[1,1,250]` |
| 2,500 | 5 | 3 | `[1,1,1,1,2500]` | `[1,1,2500]` |
The baseline issued three separate scalar counts (total, non-deleted, non-deleted applied since the cutoff), then the existing status group query and, when active rows exist, the existing DateApplied projection. A constant-group aggregate now returns the same three counts in one command. An empty owned set produces no aggregate row, explicitly mapped to zero counts. Deleted-only tenants retain their total and skip the date query. Status grouping, whitespace-to-Unknown merging, dictionary order, date projection and client-side age calculation remain the existing code.
This proves **two fewer service database roundtrips** on these fixtures. It does not establish lower latency, fewer physical database rows examined, better query plans, or higher throughput. Active dates still return one row per non-deleted application with an applied date; memory/row growth for that existing projection is unchanged. No wide application blobs or tracked application entities are materialized by stats.
## Preservation checks
The final ten dedicated cases cover native SQLite command/row behavior at zero/250/2,500 owned rows; foreign and null-owner denial; live owner switching on the same context; deleted-only tenants; null applied dates; future dates included in the existing lower-bound applied-volume predicate but clamped to zero age; exact inclusive 30-day cutoff versus one tick before; status case/whitespace keys; repeat reads after a mutation; and cancellation reaching the native command and preventing later queries. The cutoff fixture uses the service's actual captured DateTime parameter, avoiding clock-boundary flakiness.
Nine of those dedicated cases execute SQLite. The legacy **null Status** case uses EF InMemory with null checks disabled because the current native SQLite schema requires Status; it verifies the unchanged defensive Unknown merge, not native nullable-column compatibility. One additional dedicated case checks Pomelo SQL generation as described below. The overview method's entire LF-normalized byte range is unchanged and hashed in the receipts. Existing related salary/stage/calendar/rules/ownership/query-parity cases also pass.
## Exact execution evidence
- Original service, first nine dedicated cases: **4 passed / 5 expected failures**. Only roundtrip budget assertions failed; captured native commands/result rows establish the baseline. This is red evidence, not an accepted test pass.
- Initial optimized run: **9/9 passed**. The exact-cutoff case was then added.
- Final Release run: **51/51 passed, zero skipped**, comprising ten dedicated cases plus 41 existing related cases: salary 1, stage 4, ownership 3, rules/prospect 5, calendar 10, query parity 18. This total includes the overlapping focused runs; it is not 51+9.
- Additional distinct Pomelo SQL-generation case: **1/1 passed**, after parent review requested provider translation evidence. With Pomelo 9.0.0 and explicit MariaDB 12.2.2 metadata, the test invokes the actual GetStats method, suppresses the connection-open request, captures its first compiled provider command, and throws a sentinel before reader execution. The MySqlConnection remains Closed. Generated SQL contains the conditional counts, tenant filter, inclusive applied-date predicate and GROUP BY, with no wide description projection. No hand-written duplicate aggregate or server contact is involved. Native `pomelo.trx` retains the SQL; this is translation-only, not actual database acceptance. The existing 51 cases were not repeated; run-specific test-source hashes distinguish the added case.
- Release API/test/stub compilation succeeded as part of those native test commands. Pinned SDK **9.0.317**, runtime 9.0.19, Windows x64, cached locked restore with an empty package-source config. All generated build/test/cache/temp artifacts are in the isolated E: workspace/evidence area. Existing global NuGet packages were selected explicitly; the initial isolated-home cache miss and successful cached retry are retained. No package versions or lock files changed and no external package source was contacted.
- Native stdout/stderr/TRX, exact commands/exits, source/overview hashes, SDK identity and original roadmap evidence are preserved in [evidence](perf-06/evidence/SOURCE_RECEIPTS.json). [Structured query measurements](perf-06/evidence/QUERY_MEASUREMENTS.json) and [reconciled test counts](perf-06/evidence/TEST_SUMMARY.json) are derived from the native TRX, with self-checks against the expected shapes.
- Final AST-only graph refresh after the Pomelo test: PASS, 19,928 nodes / 48,200 edges. Extractor/community-label warnings are retained; no model labeling was started. The newly generated untracked graph is retained in sibling `analytics-query-batch-evidence/graphify-out`, with artifact hashes; shared graphs are untouched.
## Separate gates and limits
**Actual MariaDB execution/server acceptance, EXPLAIN/rows examined, native cancellation and provider-specific status collation remain NOT RUN.** Pomelo SQL generation alone does not establish those properties. Before MariaDB qualification, execute the actual service against a disposable pinned MariaDB fixture with the same ownership/deletion/date/status cases and measure its command/plan behavior. SQLite results do not qualify the standard MariaDB deployment or infer throughput gains. The change adds no cross-query transaction snapshot; status/date queries remain separate, as before.
No full backend suite, frontend regression, browser, hosted CI, production workload, provider/model, deployment or orchestrator work was performed. Parent review/integration and real-provider qualification remain separate decisions. No main merge or push was performed by this worker.
Binary file not shown.
@@ -0,0 +1,150 @@
{
"baseline": [
{
"Provider": "SQLite",
"OwnedRows": 0,
"Commands": 4,
"ReturnedRowsPerCommand": [
1,
1,
1,
0
],
"Sql": [
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0",
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")",
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" >= @__last30_0",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\""
]
},
{
"Provider": "SQLite",
"OwnedRows": 250,
"Commands": 5,
"ReturnedRowsPerCommand": [
1,
1,
1,
1,
250
],
"Sql": [
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0",
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")",
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" >= @__last30_0",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\"",
"SELECT \"j\".\"DateApplied\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" IS NOT NULL"
]
},
{
"Provider": "SQLite",
"OwnedRows": 2500,
"Commands": 5,
"ReturnedRowsPerCommand": [
1,
1,
1,
1,
2500
],
"Sql": [
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0",
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")",
"SELECT COUNT(*)\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" >= @__last30_0",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\"",
"SELECT \"j\".\"DateApplied\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" IS NOT NULL"
]
}
],
"final": [
{
"Provider": "SQLite",
"OwnedRows": 0,
"Commands": 2,
"ReturnedRowsPerCommand": [
0,
0
],
"Sql": [
"SELECT COUNT(*) AS \"Total\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") THEN 1\r\nEND) AS \"Active\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") AND \"j0\".\"DateApplied\" >= @__last30_0 THEN 1\r\nEND) AS \"AppliedLast30Days\"\r\nFROM (\r\n SELECT \"j\".\"DateApplied\", \"j\".\"IsDeleted\", 1 AS \"Key\"\r\n FROM \"JobApplications\" AS \"j\"\r\n WHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0\r\n) AS \"j0\"\r\nGROUP BY \"j0\".\"Key\"\r\nLIMIT 2",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\""
]
},
{
"Provider": "SQLite",
"OwnedRows": 250,
"Commands": 3,
"ReturnedRowsPerCommand": [
1,
1,
250
],
"Sql": [
"SELECT COUNT(*) AS \"Total\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") THEN 1\r\nEND) AS \"Active\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") AND \"j0\".\"DateApplied\" >= @__last30_0 THEN 1\r\nEND) AS \"AppliedLast30Days\"\r\nFROM (\r\n SELECT \"j\".\"DateApplied\", \"j\".\"IsDeleted\", 1 AS \"Key\"\r\n FROM \"JobApplications\" AS \"j\"\r\n WHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0\r\n) AS \"j0\"\r\nGROUP BY \"j0\".\"Key\"\r\nLIMIT 2",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\"",
"SELECT \"j\".\"DateApplied\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" IS NOT NULL"
]
},
{
"Provider": "SQLite",
"OwnedRows": 2500,
"Commands": 3,
"ReturnedRowsPerCommand": [
1,
1,
2500
],
"Sql": [
"SELECT COUNT(*) AS \"Total\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") THEN 1\r\nEND) AS \"Active\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") AND \"j0\".\"DateApplied\" >= @__last30_0 THEN 1\r\nEND) AS \"AppliedLast30Days\"\r\nFROM (\r\n SELECT \"j\".\"DateApplied\", \"j\".\"IsDeleted\", 1 AS \"Key\"\r\n FROM \"JobApplications\" AS \"j\"\r\n WHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0\r\n) AS \"j0\"\r\nGROUP BY \"j0\".\"Key\"\r\nLIMIT 2",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\"",
"SELECT \"j\".\"DateApplied\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" IS NOT NULL"
]
}
],
"related": [
{
"Provider": "SQLite",
"OwnedRows": 0,
"Commands": 2,
"ReturnedRowsPerCommand": [
0,
0
],
"Sql": [
"SELECT COUNT(*) AS \"Total\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") THEN 1\r\nEND) AS \"Active\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") AND \"j0\".\"DateApplied\" >= @__last30_0 THEN 1\r\nEND) AS \"AppliedLast30Days\"\r\nFROM (\r\n SELECT \"j\".\"DateApplied\", \"j\".\"IsDeleted\", 1 AS \"Key\"\r\n FROM \"JobApplications\" AS \"j\"\r\n WHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0\r\n) AS \"j0\"\r\nGROUP BY \"j0\".\"Key\"\r\nLIMIT 2",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\""
]
},
{
"Provider": "SQLite",
"OwnedRows": 250,
"Commands": 3,
"ReturnedRowsPerCommand": [
1,
1,
250
],
"Sql": [
"SELECT COUNT(*) AS \"Total\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") THEN 1\r\nEND) AS \"Active\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") AND \"j0\".\"DateApplied\" >= @__last30_0 THEN 1\r\nEND) AS \"AppliedLast30Days\"\r\nFROM (\r\n SELECT \"j\".\"DateApplied\", \"j\".\"IsDeleted\", 1 AS \"Key\"\r\n FROM \"JobApplications\" AS \"j\"\r\n WHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0\r\n) AS \"j0\"\r\nGROUP BY \"j0\".\"Key\"\r\nLIMIT 2",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\"",
"SELECT \"j\".\"DateApplied\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" IS NOT NULL"
]
},
{
"Provider": "SQLite",
"OwnedRows": 2500,
"Commands": 3,
"ReturnedRowsPerCommand": [
1,
1,
2500
],
"Sql": [
"SELECT COUNT(*) AS \"Total\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") THEN 1\r\nEND) AS \"Active\", COUNT(CASE\r\n WHEN NOT (\"j0\".\"IsDeleted\") AND \"j0\".\"DateApplied\" >= @__last30_0 THEN 1\r\nEND) AS \"AppliedLast30Days\"\r\nFROM (\r\n SELECT \"j\".\"DateApplied\", \"j\".\"IsDeleted\", 1 AS \"Key\"\r\n FROM \"JobApplications\" AS \"j\"\r\n WHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0\r\n) AS \"j0\"\r\nGROUP BY \"j0\".\"Key\"\r\nLIMIT 2",
"SELECT \"j\".\"Status\", COUNT(*) AS \"Count\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\")\r\nGROUP BY \"j\".\"Status\"",
"SELECT \"j\".\"DateApplied\"\r\nFROM \"JobApplications\" AS \"j\"\r\nWHERE @__ef_filter__p_1 AND \"j\".\"OwnerUserId\" = @__ef_filter__CurrentUserId_0 AND NOT (\"j\".\"IsDeleted\") AND \"j\".\"DateApplied\" IS NOT NULL"
]
}
],
"pomelo": []
}
@@ -0,0 +1,244 @@
{
"baseline": "1db5f488f6138e4f0f33749452b7d9f47658f4b0",
"roadmapSource": "271d37d1",
"baselineServiceSha256Lf": "88968cfb23e298a8db0c541fc134d3f6e1a0864443baafa24ec9c70f5faeee11",
"sourceSha256Lf": {
"JobTrackerApi/Services/AnalyticsService.cs": "0859ad9202bbaf4de810f8b1bc9946cbed061f69105c02993f079715f59aa2b1",
"JobTrackerApi.Tests/AnalyticsStatsQueryTests.cs": "4c11c99c392c4fe770dae39e4e0a6af71869410268908425322ac9042b4caa25",
"JobTrackerApi/JobTrackerApi.csproj": "50164c5dceafc805cc73018bfcd444428736029f6fdad220e4ff07cf38e116c4",
"JobTrackerApi.Tests/JobTrackerApi.Tests.csproj": "6564ff0044af2ce8c55d557b180c57e16e238395424778878b56eb9e3e082c0d",
"JobTrackerApi/packages.lock.json": "f63bbf68503fd46effda290a29551ebacac84d0faf8c367fe28caa11ec404abf",
"JobTrackerApi.Tests/packages.lock.json": "548f67d1ef3b5a9acfe5fc6124891583b6073ac4b6ca515241330e097152bc4a"
},
"overviewUnchangedSha256Lf": "5ae34fbd456f76e3215b227c499154a700394acc5870e98baa10a25f82dd3f48",
"nativeReceipts": [
{
"path": "baseline.trx.gz",
"rawSha256": "0cfdd06a851cc8d8c98b3065dad540e2682f64c87b9d3b57bc1181a3d4251595",
"gzipSha256": "b7ed8ccc520c1e4f90a4a1bb497f590a5b5eb761579c51e2b11f57669ef16f9f",
"rawBytes": 33153
},
{
"path": "baseline.exit.json.gz",
"rawSha256": "f7efa5369267584aecf389b8b9ced993c802ca7510837a2f4bb6af64cabee00e",
"gzipSha256": "37a20ee637dd5cd7006728b330d6e1e5e97183dfdc5a1aa8858b73d03fcf9338",
"rawBytes": 469
},
{
"path": "baseline.stderr.txt.gz",
"rawSha256": "8a49c99e252f93ad5f0bfa72f828d8270f8d73378eb2057b645c365f4ef394d9",
"gzipSha256": "20a42b896bff92fb1de2561e32bbc96fe3495771ee3bee18ac00b509b7f6c8c7",
"rawBytes": 782
},
{
"path": "baseline.stdout.txt.gz",
"rawSha256": "24a0c4ebc1ec30b415616fff784993eaa6e4db34004c1f72ccaaf21e5f5393d2",
"gzipSha256": "e0ab1ccd0ca7fc340b85313e38e36064f09fd3273f8b2b14192698c723ed1c47",
"rawBytes": 18240
},
{
"path": "final.trx.gz",
"rawSha256": "9809164998214d6229ce2ae17a92bfda28f6df53d59881c52320b5e592e8a50d",
"gzipSha256": "22f3e05f63217755106fbc0e19fae97f547d10aa31d7a080bf8544dd0c475d2a",
"rawBytes": 19199
},
{
"path": "final.exit.json.gz",
"rawSha256": "56f04d240300a79b6b95f4e85c1ac7e71e28752ba43117e3af100414c6836f85",
"gzipSha256": "9f59b6aed0b6fd1d9ae3c8030f8ee7ac353008755afbfe958fccc1686d7433fd",
"rawBytes": 462
},
{
"path": "final.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "final.stdout.txt.gz",
"rawSha256": "0a310a146116711cc5acec5209f7e47fc09a74d7069e31a4a8e8de2cb102263b",
"gzipSha256": "32b865e89eb0f147ed3cd7d0cfd3196f0abb9590a878e1cd2051ff1c4e252303",
"rawBytes": 2500
},
{
"path": "graph-artifacts.json.gz",
"rawSha256": "525974fdd4376c3ffdc80a4c38d9125063ce53cebf252b3aa35d5be700fa2e04",
"gzipSha256": "4c6741770d72a2936903a0e56a7dfd4c17dcc25fb4ab4f36cd4281837613dfff",
"rawBytes": 424
},
{
"path": "graph-final-artifacts.json.gz",
"rawSha256": "bbf1cb9140faeb803f679135973503465b81e852c57a0f70fe8771c0a582f132",
"gzipSha256": "c90dfd8b0d7709883ebf921c050b388bfe15c727a1fe1cdfaf96d6fb93ae9ff4",
"rawBytes": 424
},
{
"path": "graph-final.exit.json.gz",
"rawSha256": "4f4f3be6ad6b528d4e936c80571d404779fbdce454abf3d361eec3365a03772e",
"gzipSha256": "4a6bbb34469691ad44f1c4490e3f8102c132a4ce1c8456a03b67ecf4d017cc7c",
"rawBytes": 94
},
{
"path": "graph-final.stderr.txt.gz",
"rawSha256": "8757dcf1461d6b3128c3bdc048447e23eabd3e05538514a1318d10af024586c2",
"gzipSha256": "1273c4e70d6b9fe6154bf42a0aa917e4a21b35a50776939735c6156e7e41b6fc",
"rawBytes": 725
},
{
"path": "graph-final.stdout.txt.gz",
"rawSha256": "d75537e648fdc2cea191d13d9a9342f5440dbc5bce6b98a4869c41bc263579cf",
"gzipSha256": "b752a37d98031e6f92228c2ecec2eb95fb3f6c73408c363175d6da022aba9cb2",
"rawBytes": 1169
},
{
"path": "graph.exit.json.gz",
"rawSha256": "2609a5c688566b24a0229f7f5ef328ab9d11c309f29048c3c87963e625066dea",
"gzipSha256": "a90f5c0ab24ac9d292395d12e048783821e2a33b00dde88ea5ce8b50035a9196",
"rawBytes": 94
},
{
"path": "graph.stderr.txt.gz",
"rawSha256": "252f13231cdf5188fedb3f87caa797600ea7eee4e589778807168be2fe7c20c1",
"gzipSha256": "742558330e5618c0487c801ccaa3b27a8fdbe6a6f8d8df1123d3411fa7eabca0",
"rawBytes": 669
},
{
"path": "graph.stdout.txt.gz",
"rawSha256": "c76c12ed748397c7fe062a6900f4719ee128d73b57c38196b10b1fb74b0fb971",
"gzipSha256": "9a5f15999b64f9d537315d3da6327b261ab7a1a6057d1c8cb1f61f15daa4ca47",
"rawBytes": 2928
},
{
"path": "NuGet.Config.gz",
"rawSha256": "2142cfb2dfa2c7feefbe40fabcc68b0dfecadafa99a1db9b70239d977cf2a7ef",
"gzipSha256": "f69b2177a7e14d14bbf0f5f66292e0aa0ec4e22ac56e016a63e407db01a41591",
"rawBytes": 113
},
{
"path": "pomelo.trx.gz",
"rawSha256": "78d6865a361821c39ff1314c3b39027acf15c411a3e5e718d3b2a937bb5d21d2",
"gzipSha256": "ab13f9032406fae9c6a6e18f1449c20dd7ef6a56a8f7f655f08317d57112f8ae",
"rawBytes": 3738
},
{
"path": "pomelo-generated-sql.txt.gz",
"rawSha256": "98e8ea948a12b98f33ed66946c629a41b83a71ab369794a8be4bb6742287c5ff",
"gzipSha256": "7b4d463080964e66980735df680e485833f406ddf282cf5c0f9f0ce764a74a68",
"rawBytes": 494
},
{
"path": "pomelo.exit.json.gz",
"rawSha256": "0fcda1c553282de3b85c8b398bfa6f3959424ab92ee0590023783e3ba4348578",
"gzipSha256": "d126bc2e72367ea43f96cdd0de58d15cf2d805884c91e2c66357b3a3d64998f5",
"rawBytes": 510
},
{
"path": "pomelo.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "pomelo.stdout.txt.gz",
"rawSha256": "514805b39aa81de333b4796dd1e622a5d0956202c911403bd08839b2c0a94059",
"gzipSha256": "59017c3ca6efec93ae7308f0f0ef1d60e468e9f637479d3949a15bd6a1e19506",
"rawBytes": 1470
},
{
"path": "related.trx.gz",
"rawSha256": "ee8f44ad2f3e67c69165a9d21722a58572633a588009884c76877273fed04074",
"gzipSha256": "dcefc964158456d1aa2d5b58ac630de579ab455137bdb3f052b3b156e39a91be",
"rawBytes": 82468
},
{
"path": "related-run-sources.json.gz",
"rawSha256": "3e4adeaa74793556ae789929e3844f109bfa619e940465fa0d8c379273797d02",
"gzipSha256": "62119f84bdeb87a83352c7a1b192c10fca32ad202228b442bc8628aa5d6af15a",
"rawBytes": 406
},
{
"path": "related.exit.json.gz",
"rawSha256": "ef658a012e34cd6722aa9edc904ea4ca8b13d7e950a357994c9ae38c01c8cfc9",
"gzipSha256": "3da9ed91394e419e8906e013a5d7b83e9a43dcdd5d99879bc80086343896517f",
"rawBytes": 722
},
{
"path": "related.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "related.stdout.txt.gz",
"rawSha256": "d983b3f3f4baa951a105e280ce8d93ffc167b6ca3fb617edd8d6f9d78d239df0",
"gzipSha256": "0aeb4b15a3946738c5878aaa01137e179c0cbe6f32d69efbb9ce388d72937da3",
"rawBytes": 8002
},
{
"path": "restore-cached.exit.json.gz",
"rawSha256": "337301aa9d2fff23a0ffbbffdcc77215cef28ed08fa3ddb2792d93931eef0e87",
"gzipSha256": "58bd0d2d31584b19d573d0fc7b33140f0f85b7ed4f623fb063daded0dc3dc159",
"rawBytes": 310
},
{
"path": "restore-cached.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "restore-cached.stdout.txt.gz",
"rawSha256": "271a7efafd57e4889a2094bd64280710a0c2fce0f12ccab9789e421b4241869f",
"gzipSha256": "d2155860fadba93e89eac27f7b44b6776530a4ce77c4f8e31a48b5f8669fcef7",
"rawBytes": 488
},
{
"path": "restore.exit.json.gz",
"rawSha256": "8bf4635a3f8301adfa741ea41bd86f16b8f13117734d8830feab4fb416d19d0e",
"gzipSha256": "2408933238d86fa9c532cb0ec583952b77778dea6119698efbde2b0cf67e885a",
"rawBytes": 310
},
{
"path": "restore.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "restore.stdout.txt.gz",
"rawSha256": "55a03484d9fec31f39414c5363f0bfe7a2dbf6836039d88b28d80769e241d973",
"gzipSha256": "8972df257e0b36320e9a8897ca72034507ae2451f815fa408236cd48d643c486",
"rawBytes": 10564
},
{
"path": "roadmap-checkpoint.txt.gz",
"rawSha256": "9ac029153db7b7265d00c11b6155d8fbf58d30cc9f0418f8440324f860138498",
"gzipSha256": "c337a0b2a70a1135e88829aaa54cb8a89c92524aa8a8ca749bb4f544d0443d53",
"rawBytes": 226686
},
{
"path": "roadmap-perf-source.txt.gz",
"rawSha256": "ac4cda9471ef29fd0a942ec986269b14354d46a3688eb00e9b4acd7c5826427f",
"gzipSha256": "94fbc0fa1f081065c183b202360a9e4476deca0f9f56c6de4c2ba7438f554326",
"rawBytes": 53575
},
{
"path": "sdk.exit.json.gz",
"rawSha256": "d752216624832dac2c78b4c38943cddf20fb970e7030fc556557917946de44e6",
"gzipSha256": "a8912a8383fc5a47d2238e48493a5e6e23055e090fa58eadf8bf51c8c06801a7",
"rawBytes": 115
},
{
"path": "sdk.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "sdk.stdout.txt.gz",
"rawSha256": "ebeeab4ff7b83567d77106097e9d5fce8fff28a7cb8cb1ff5aeca16453104a7a",
"gzipSha256": "b5ec27efd8af9856eff8962e44fc8be8ff49ef6fdee5f2018bbecdd17f948230",
"rawBytes": 1251
}
]
}
@@ -0,0 +1,74 @@
{
"baseline": {
"total": "9",
"executed": "9",
"passed": "4",
"failed": "5",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
},
"final": {
"total": "9",
"executed": "9",
"passed": "9",
"failed": "0",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
},
"related": {
"total": "51",
"executed": "51",
"passed": "51",
"failed": "0",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
},
"pomelo": {
"total": "1",
"executed": "1",
"passed": "1",
"failed": "0",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
}
}
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
@@ -0,0 +1,55 @@
# Native application status, follow-up and calendar connection
18 November 2026. Application baseline `1db5f488f6138e4f0f33749452b7d9f47658f4b0`; roadmap receipt `271d37d1a875256643602db20bbd3c381a291c05`. Isolated branch `codex/a3-connected-followup`. Test/evidence changes only: no application, API, model, provider, data model or scheduling-policy change.
## Missing boundary now exercised
The original 34-route/57-group registers and A3 design/IM10 authority remain unchanged. The existing [controlled follow-up journey](visual-correction/FOLLOWUP_JOURNEY_REVIEW.md) passed eight representative journeys with every response intercepted. It already established the parent refresh-token repair; this package does not repeat that matrix or claim another stale-agenda defect. Existing `phase7-reminders.spec.ts` native tests checked actual reminder dates/history/retry/ownership but did not assert the adjacent calendar's native readback after the user mutation. The separately completed 44-case native package covers other families and is not added to these counts.
Two new cases in the existing `job-tracker-ui/e2e/phase7-reminders.spec.ts` cover EN/light/1440 and Bokmål/dark/390:
- Create a disposable synthetic care-coordinator application, then use the real Applications row menu to set Waiting. Require PATCH204 and durable status readback, preserving the existing follow-up date.
- Open Reminders, schedule three days through the existing control, require PATCH204 and the subsequent actual calendar GET200 with the moved date/recordedAt. The retained policy is absolute-millisecond arithmetic followed by the UTC date slice; no local-calendar/DST reinterpretation.
- Open Month and the populated day, keyboard-open the linked application, require the matching workspace GET200/Waiting, return and retain Month preference.
- Clear the follow-up through the existing control. Require PATCH204, calendar GET200 without that event, the selected day still selected with count zero, unchanged Month mode, empty-day feedback and durable null follow-up with Waiting unchanged.
- Preserve exact status/date payloads and two FollowUpSet history values. No draft/send/model/provider action is issued. Each case records eight reminder GETs from the existing Shell/page/navigation sources, not a claim of one GET per page.
No runtime defect was required to make the new cases pass. The complete affected-file run exposed two inherited verifier failures: both searched for the retired exact header name `Norsk`. Actual snapshots show `Norsk bokmål`. Only those two selector strings changed; existing moved-focus, no-extra-read, explicit retry, captured date and history assertions remain intact. The original negative reports and their source hash are retained.
## Executed results
| Run | Outcome | Accounting |
| --- | --- | --- |
| New focused cases | 2 passed | Initial actual HTTP/browser proof, included again below |
| Affected file before inherited selector repair | 6 passed / 2 failed | Both failures are the obsolete header name, not application behavior |
| Final complete affected file | **8 passed**, zero skipped/unexpected/flaky | Six existing cases plus the two new cases; this is the final total |
Final run retained **21 screenshots and 21 complete all-enabled axe/target-size vectors, zero returned violations**, with incomplete findings preserved. Four screenshots/audits and two native readback records for the new cases are extracted alongside the native receipts. EN desktop and NB phone scheduled-month captures were inspected: recorded date/context, visible selected day and wrapping remain usable in those samples. Full-page sticky navigation can overlay an off-viewport segment in a tall capture; these images do not establish physical-device or comprehensive focus-occlusion acceptance.
Scoped TypeScript compiler API checking the complete spec plus imported types returned zero diagnostics; scoped ESLint and source whitespace checks passed. No full Jest, new application build or backend unit run was performed for this test-only increment.
AST-only `graphify update . --no-cluster` completed exit 0 with 19,930 nodes / 49,369 edges. Generated graph stays local/untracked; missing PDF/SQL extractors and 147 symbol-free inputs (including owned temporary transform-cache data) remain graph limits, not product acceptance gaps.
## Source/runtime identity and isolation
The existing qualified root E-drive frontend export/API DLL were reused read-only through this worktree's own `node_modules`, `out` and API `bin` junctions. Entry comparison found no root working-tree difference from the application baseline under `job-tracker-ui/src` or `JobTrackerApi`. Frontend source tree: `6a8b38361f57f199ebe298d2193de63d90b009e4`. Backend tree: `b7701b2459186f665fe5759a533b6e434cc122b0`, identical at `eb253877` and this baseline, so the previously qualified Release API binary was reused. No installation, shared module/export/binary mutation, rebuild or restore.
The existing Playwright config managed fresh API5302/UI3300, disposable E-drive SQLite, synthetic Identity/CSRF/session accounts and one serial Chromium worker. `PLAYWRIGHT_STATIC_EXPORT=true`, `PLAYWRIGHT_PREBUILT_EXPORT=true`, `PLAYWRIGHT_REUSE_SERVERS=false`; SDK host `C:/Users/Connor/.dotnet/dotnet.exe`; TEMP/TMP and test output remain on E. Model/import/alert workers and delivery remain disabled under the existing fixture contracts. External requests are blocked by the existing owner fixture: final report records zero blocked external attempts. Both owned ports were confirmed closed after the run.
From `job-tracker-ui`, the native test command was:
```text
rtk proxy node node_modules/@playwright/test/cli.js test e2e/phase7-reminders.spec.ts --project chromium --workers=1 --reporter=line,json
```
Exact source, raw/gzip native hashes, original-source derivation, case outcomes and extracted artifacts are bound in [SOURCE_RECEIPTS.json](evidence/connected-calendar/SOURCE_RECEIPTS.json). Traces and disposable credentials stay outside Git.
## Backend log finding remains open
Both affected runs logged `UNIQUE constraint failed: ApplicationChecklistItems.JobApplicationId, ApplicationChecklistItems.SystemKey`. The final log also contains a middleware exception stack naming `JobApplicationsController.GetReminders` at line 689. No backend fix or clean-server claim is made. The focused new-two-case run did not record that uniqueness error; this does not establish absence.
Exact local native log: `E:/Storage/Projects/Active/temp docs/jobjakt-local-build/a3-connected-followup/.artifacts/reminders-qualified.log` (UTF-16LE). Its byte-identical gzip is committed as `evidence/connected-calendar/reminders-qualified.log.gz`. The uniqueness exception chain appears at lines 39/57 following the first existing test marker at line 29. New EN/NB test markers appear at 75/76, followed by the remaining middleware stack through 107 (`GetReminders` at 88). Native EN case start `2026-11-18T12:12:30.248Z`, duration 6,969 ms; NB start `12:12:37.228Z`, duration 7,448 ms; both have empty Playwright error arrays.
Server lines lack request IDs/timestamps, and the existing request-boundary collector records request metadata rather than unsolicited GET response statuses. Therefore this evidence cannot correlate the exception to a specific Shell/page GET or infer its client response status. Selected status/follow-up/calendar/workspace responses are asserted separately. Concurrent Shell/page reminder materialization is a reproduction candidate, not an established cause. Root was notified for independent backend triage.
SQLite migration/Data Protection and Node color-environment warnings remain in raw logs. No warning suppression or database workaround was used. MariaDB/hosted CI, real delivery/providers, timezone/precision/interview scheduling models, native devices/AT/native-language, final owner/A3/Phase10/security/recovery/release acceptance remain separate. No orchestrator, push, main merge or deployment.
@@ -0,0 +1,216 @@
{
"baseline": "1db5f488f6138e4f0f33749452b7d9f47658f4b0",
"roadmap": "271d37d1a875256643602db20bbd3c381a291c05",
"sourcePolicy": "LF-normalized UTF8 source; exact raw/gzip evidence bytes",
"test": {
"path": "job-tracker-ui/e2e/phase7-reminders.spec.ts",
"sha256Lf": "dab45b17dcb5963ef45f6ec8b00f5476d2eeb9e14e83776de23235ca94267e45"
},
"original": {
"originalTestSha256Lf": "b3d7281d510d19aedee125f4d2859fcc1631a01761cd0ca9c042ad43c1cd9ed9",
"originalTestSha256Raw": "fd8abe327ebbfd77fa4d62b245bb1b26dc7b34a2d670b327e9286cbf26abb341"
},
"originalSourceDerivation": "Final spec with exactly two inherited header exact-name Norsk bokmål selectors restored to Norsk",
"application": {
"frontendTree": "6a8b38361f57f199ebe298d2193de63d90b009e4",
"backendTree": "b7701b2459186f665fe5759a533b6e434cc122b0",
"backendQualifiedFrom": "eb2538772e1bfabbeb291e4a5efa177c79074de1",
"rootWorkingSourceDiffVsBaseline": "empty for job-tracker-ui/src and JobTrackerApi at entry"
},
"runs": {
"focused": {
"passed": 2,
"total": 2
},
"affectedOriginal": {
"passed": 6,
"failed": 2,
"total": 8
},
"affectedFinal": {
"passed": 8,
"failed": 0,
"total": 8
}
},
"final": {
"screenshots": 21,
"audits": 21,
"violations": 0,
"externalRequests": 0,
"cases": [
{
"title": "[P7-05 Reminders] actual empty and four workflow groups preserve counts, reasons, routes and owner boundaries",
"status": "passed"
},
{
"title": "[P7-05 connected calendar] en/1440 actual application status, follow-up and adjacent agenda stay connected",
"status": "passed"
},
{
"title": "[P7-05 connected calendar] nb/390 actual application status, follow-up and adjacent agenda stay connected",
"status": "passed"
},
{
"title": "[P7-05 Reminders] plus3, plus7 and clear persist actual dates and one history event per write with existing UTC-date semantics",
"status": "passed"
},
{
"title": "[P7-05 Reminders] held single PATCH locks every row action and failed explicit Retry preserves its captured date and moved focus",
"status": "passed"
},
{
"title": "[P7-05 Reminders] committed PATCH204 followed by a failed reload retries only GET and preserves its single history event",
"status": "passed"
},
{
"title": "[P7-05 Reminders] live EN/Bokmal translates status/date controls and generated reasons without a page-triggered refetch",
"status": "passed"
},
{
"title": "[P7-05 Reminders] eight finite bilingual theme widths preserve long rows and keyboard-accessible actions",
"status": "passed"
}
]
},
"native": [
{
"file": "connected-focused.json.gz",
"rawBytes": 581131,
"rawSha256": "226cfb760e2be6cf79bdd2be506c48ac71febcebab50ce61da8d354c4e978e37",
"gzipBytes": 371798,
"gzipSha256": "a37ab9b85aeb974a8f5836038a461c57e6a05d2d69d40cc51e62fc11bc54a553"
},
{
"file": "connected-focused.log.gz",
"rawBytes": 4652,
"rawSha256": "2b4d62119b0c20b3848250f9d80969f17b4df7acfbbae4f3625d6444be31202a",
"gzipBytes": 1366,
"gzipSha256": "c352cfd9219db1cc4f2f087dd405c2412b82d1994781613defeb197b01bd3db4"
},
{
"file": "reminders-final.json.gz",
"rawBytes": 3866522,
"rawSha256": "b2cedf914ea9c444afd67d281bdab5ab4782dfa1c59060d27adcc313b6375293",
"gzipBytes": 2577189,
"gzipSha256": "37c9b12b94ecf6032d083cbbf001a1ed052d8820b288b1840a88e0dc5bee084e"
},
{
"file": "reminders-final.log.gz",
"rawBytes": 34606,
"rawSha256": "4f11eab476bfe91d7793a70776a8e61ecda5e9c67eb3ea757fa821622d6704cc",
"gzipBytes": 4471,
"gzipSha256": "f1fe9acc7a57bf23e0a9d66a5cdfc0d7c285958148732772397565e9628a0e2c"
},
{
"file": "reminders-qualified.json.gz",
"rawBytes": 4229497,
"rawSha256": "f09e019f813f93efbbce3b4b5310cbd6191b85aa4cc2ed7c5ca8250fcfd58db4",
"gzipBytes": 2830947,
"gzipSha256": "412809283630e2690db41eb8c578061703ba9a163e1a4c161c26768766a8371c"
},
{
"file": "reminders-qualified.log.gz",
"rawBytes": 30294,
"rawSha256": "eace58032f3f7dd9c24b5753c01cce3d991036a7559339cedcb62937557f2186",
"gzipBytes": 3990,
"gzipSha256": "3d881db24c75990edadc9a4390a2173d6000409bf916bf6417377f33cb4e7933"
}
],
"limits": [
"Overlapping runs are not additive",
"SQL checklist uniqueness error remains in final raw server log; not clean-backend acceptance",
"No model/provider/delivery/MariaDB/human/device/AT or whole-A3 acceptance"
],
"artifacts": [
{
"file": "connected-calendar-native-readbacks-en-1440.json",
"bytes": 4545,
"sha256": "934daa73ae6753ad8c9655265325a674dc381953cc8388d66d760044130c0104"
},
{
"file": "connected-calendar-native-readbacks-nb-390.json",
"bytes": 4543,
"sha256": "43a1be26d0184eb8f33b08e0bb7e1fc82cc8c2fd9f6913ada69eec952f082fd4"
},
{
"file": "p7-reminders-en-light-1440-connected-cleared-selected-day-audit-en-1440.json",
"bytes": 15112,
"sha256": "660a1c13db578398904dd7070facd083ffa92ef2e6aab9037d17258b4dec8123"
},
{
"file": "p7-reminders-en-light-1440-connected-cleared-selected-day-en-1440.png",
"bytes": 103972,
"sha256": "adee1afeb5b194742c84c42b1f0bcbf96e30e324abdd472992d759148c3a2c6a"
},
{
"file": "p7-reminders-en-light-1440-connected-status-scheduled-month-audit-en-1440.json",
"bytes": 15937,
"sha256": "ea894d8ee02ff583dae5421eb9c718d68547da805c140eb336606f7d3dee0064"
},
{
"file": "p7-reminders-en-light-1440-connected-status-scheduled-month-en-1440.png",
"bytes": 108690,
"sha256": "830881f6f38db9eb88ebeeb515c6c2cb97af759f56097acdce74f472c876e8b2"
},
{
"file": "p7-reminders-nb-dark-390-connected-cleared-selected-day-audit-nb-390.json",
"bytes": 16099,
"sha256": "343f969b6f90aa67b5492cb47baddf7c47da8ab5d4cd70415d091c70a3a521c5"
},
{
"file": "p7-reminders-nb-dark-390-connected-cleared-selected-day-nb-390.png",
"bytes": 68123,
"sha256": "e1f4dc9eae3ba585e2ae3e0d114fb493da000010453ef70ed95a013e53bab726"
},
{
"file": "p7-reminders-nb-dark-390-connected-status-scheduled-month-audit-nb-390.json",
"bytes": 16901,
"sha256": "8b971da8b075a7d071f1cfa0dcbc968a4f310df541c130b8c1342a0c260422cb"
},
{
"file": "p7-reminders-nb-dark-390-connected-status-scheduled-month-nb-390.png",
"bytes": 71335,
"sha256": "cb052d8cbbbd1f947b018fef4a766e5b73d34d9389411d39cac28bbcbc878049"
}
],
"runtimeArtifacts": [
{
"file": "JobTrackerApi/bin/Release/net9.0/JobTrackerApi.dll",
"realPath": "E:\\Storage\\Projects\\Active\\temp docs\\jobjakt-local-build\\next-security-patch\\JobTrackerApi\\bin\\Release\\net9.0\\JobTrackerApi.dll",
"bytes": 11518976,
"sha256": "ac5c11394bcc6fe2272db96fc2f87143c62617120d173e7ae52ce1c15cb16227"
},
{
"file": "job-tracker-ui/out/index.html",
"realPath": "E:\\Storage\\Projects\\Active\\temp docs\\jobjakt-local-build\\next-security-patch\\job-tracker-ui\\out\\index.html",
"bytes": 9260,
"sha256": "31dfd9b2d2e7ea7d9e696b5485d24d7b8daf0b1e078e6539e94a04955b8ff1f8"
}
],
"tools": {
"node": "v24.19.0",
"typescript": "5.9.3",
"playwright": "1.62.1"
},
"checks": {
"specTypecheck": {
"exitCode": 0,
"scope": "complete phase7-reminders spec plus imported source types; no emit/incremental"
},
"scopedLint": {
"exitCode": 0,
"file": "job-tracker-ui/e2e/phase7-reminders.spec.ts"
},
"sourceDiff": {
"exitCode": 0
},
"graph": {
"command": "rtk proxy graphify update . --no-cluster",
"exitCode": 0,
"nodes": 19930,
"edges": 49369,
"scope": "AST only, untracked graph; includes owned transform-cache inputs; no semantic/provider pass"
}
}
}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","sample":{"language":"en","theme":"light","width":1440,"height":900},"waiting":{"id":7,"companyId":3,"company":{"id":3,"ownerUserId":"04543de0-8158-4a05-a3b0-91e709427821","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:30.5335702","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":"2026-10-14T00:00:00","feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":2},"scheduledItems":[{"jobApplicationId":7,"jobTitle":"Recorded community care coordinator — æøå","companyName":"Connected synthetic care employer","kind":"follow-up","date":"2026-10-16","recordedAt":"2026-10-16T00:00:00"}],"final":{"id":7,"companyId":3,"company":{"id":3,"ownerUserId":"04543de0-8158-4a05-a3b0-91e709427821","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:30.5335702","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":4},"history":[{"id":10,"type":"FollowUpSet","oldValue":"2026-10-14T00:00:00.0000000","newValue":"2026-10-16T00:00:00.0000000","note":null,"at":"2026-11-18T13:12:33.0301475"},{"id":11,"type":"FollowUpSet","oldValue":"2026-10-16T00:00:00.0000000","newValue":null,"note":null,"at":"2026-11-18T13:12:35.4187892"}],"qualification":"Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model."}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","sample":{"language":"nb","theme":"dark","width":390,"height":844},"waiting":{"id":8,"companyId":4,"company":{"id":4,"ownerUserId":"a89a6f7d-1fbd-445e-8749-5f1b5c4eeab8","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:37.6164347","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":"2026-10-14T00:00:00","feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":2},"scheduledItems":[{"jobApplicationId":8,"jobTitle":"Recorded community care coordinator — æøå","companyName":"Connected synthetic care employer","kind":"follow-up","date":"2026-10-16","recordedAt":"2026-10-16T00:00:00"}],"final":{"id":8,"companyId":4,"company":{"id":4,"ownerUserId":"a89a6f7d-1fbd-445e-8749-5f1b5c4eeab8","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:37.6164347","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":4},"history":[{"id":14,"type":"FollowUpSet","oldValue":"2026-10-14T00:00:00.0000000","newValue":"2026-10-16T00:00:00.0000000","note":null,"at":"2026-11-18T13:12:40.7958794"},{"id":15,"type":"FollowUpSet","oldValue":"2026-10-16T00:00:00.0000000","newValue":null,"note":null,"at":"2026-11-18T13:12:43.2443118"}],"qualification":"Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model."}
+69 -2
View File
@@ -198,6 +198,73 @@ test('[P7-05 Reminders] actual empty and four workflow groups preserve counts, r
} finally { await foreignApi.dispose(); await anonymous.dispose(); }
});
for (const sample of [desktop, { language: 'nb', theme: 'dark', width: 390, height: 844 }] as Sample[]) {
test(`[P7-05 connected calendar] ${sample.language}/${sample.width} actual application status, follow-up and adjacent agenda stay connected`, async ({ page, session }, info) => {
test.setTimeout(180_000);
await page.clock.setFixedTime(new Date(fixedTime));
const t = translations[sample.language];
const employer = await company(page.request, session.owner, 'Connected synthetic care employer');
const row = await job(page.request, session.owner, employer.id, 'Recorded community care coordinator — æøå', {
status: 'Applied', dateApplied: '2026-01-01T12:00:00Z', followUpAt: '2026-10-14T00:00:00Z',
});
await enter(page, session.owner, sample);
await page.goto('/jobs');
await keyboard(page, page.getByRole('button', { name: `${t.jobTableActions}: ${row.jobTitle}`, exact: true }));
const changed = response(page, 'PATCH', `${jobsUrl}/${row.id}/status`);
await keyboard(page, page.getByRole('menuitem', { name: text(t.jobTableSetStatus, { status: t.statusWaiting }), exact: true }));
expect((await changed).status()).toBe(204);
const waiting = await nativeJob(page.request, row.id);
expect(waiting.status).toBe('Waiting');
expect(waiting.followUpAt?.slice(0, 10)).toBe('2026-10-14');
await page.goto('/reminders?source=connected-calendar');
const agenda = page.getByRole('region', { name: t.calendarAgendaTitle, exact: true });
const linkName = `${row.jobTitle} · ${employer.name}`;
const original = agenda.getByRole('link', { name: linkName, exact: true });
await expect(original).toBeVisible();
await expect(article(page, row.jobTitle)).toBeVisible();
const calendarRead = response(page, 'GET', `${apiUrl}/calendar/agenda?from=2026-10-01&to=2026-10-31`);
const scheduled = response(page, 'PATCH', `${jobsUrl}/${row.id}/followup`);
await keyboard(page, snooze(page, row, 3, sample.language));
expect((await scheduled).status()).toBe(204);
const items = await json<Array<{ jobApplicationId: number; kind: string; date: string; recordedAt: string }>>(await calendarRead);
expect(items.filter(item => item.jobApplicationId === row.id)).toMatchObject([{ kind: 'follow-up', date: '2026-10-16' }]);
await expect(original).toBeVisible();
await expect(original.locator('xpath=..').locator('time')).toHaveAttribute('datetime', items.find(item => item.jobApplicationId === row.id)!.recordedAt);
await keyboard(page, page.getByRole('button', { name: t.calendarMonth, exact: true }));
const date = await page.evaluate(language => new Intl.DateTimeFormat(language === 'nb' ? 'nb-NO' : 'en-GB', { dateStyle: 'medium', timeZone: 'UTC' }).format(new Date('2026-10-16T12:00:00Z')), sample.language);
const dayName = text(t.calendarDayEvents, { date, count: 1 });
await keyboard(page, agenda.getByRole('button', { name: dayName, exact: true }));
await expect(original).toBeVisible();
await capture(page, info, sample, 'connected-status-scheduled-month');
const workspace = response(page, 'GET', `${jobsUrl}/${row.id}/workspace`);
await keyboard(page, original);
await expect(page).toHaveURL(new RegExp(`/jobs/${row.id}$`));
expect(await json<{ id: number; status: string }>(await workspace)).toMatchObject({ id: row.id, status: 'Waiting' });
await page.goBack();
await expect(page.getByRole('button', { name: t.calendarMonth, exact: true })).toHaveAttribute('aria-pressed', 'true');
await keyboard(page, agenda.getByRole('button', { name: dayName, exact: true }));
await expect(original).toBeVisible();
const clearingCalendar = response(page, 'GET', `${apiUrl}/calendar/agenda?from=2026-10-01&to=2026-10-31`);
const cleared = response(page, 'PATCH', `${jobsUrl}/${row.id}/followup`);
await keyboard(page, clear(page, row, sample.language));
expect((await cleared).status()).toBe(204);
expect((await json<Array<{ jobApplicationId: number }>>(await clearingCalendar)).filter(item => item.jobApplicationId === row.id)).toEqual([]);
await expect(agenda.getByText(t.calendarDayEmpty, { exact: true })).toBeVisible();
await expect(page.getByRole('button', { name: t.calendarMonth, exact: true })).toHaveAttribute('aria-pressed', 'true');
await expect(agenda.getByRole('button', { name: text(t.calendarDayEvents, { date, count: 0 }), exact: true })).toHaveAttribute('aria-pressed', 'true');
await expect(original).toHaveCount(0);
const final = await nativeJob(page.request, row.id);
expect(final.status).toBe('Waiting'); expect(final.followUpAt).toBeNull();
expect(requests(session, 'PATCH', `/api/jobapplications/${row.id}/status`).map(request => request.body)).toEqual([{ status: 'Waiting' }]);
expect(requests(session, 'PATCH', `/api/jobapplications/${row.id}/followup`).map(request => request.body)).toEqual([{ followUpAt: '2026-10-16' }, { followUpAt: null }]);
expect((await history(page.request, row.id)).map(event => event.newValue?.slice(0, 10) ?? null)).toEqual(['2026-10-16', null]);
expect(session.requests.filter(request => /followup-draft|send-followup/.test(request.path))).toEqual([]);
await capture(page, info, sample, 'connected-cleared-selected-day');
await info.attach('connected-calendar-native-readbacks', { body: JSON.stringify({ boundary, sample, waiting, scheduledItems: items, final,
history: await history(page.request, row.id), qualification: 'Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model.' }), contentType: 'application/json' });
});
}
test('[P7-05 Reminders] plus3, plus7 and clear persist actual dates and one history event per write with existing UTC-date semantics', async ({ page, session }, info) => {
test.setTimeout(90_000); await page.clock.setFixedTime(new Date(fixedTime));
const source = await company(page.request, session.owner, 'Recorded scheduling company');
@@ -242,7 +309,7 @@ test('[P7-05 Reminders] held single PATCH locks every row action and failed expl
expect(await history(page.request, row.id)).toEqual([]); await capture(page, info, desktop, 'captured-patch-failure');
await page.clock.setFixedTime(new Date('2026-10-13T23:30:00-08:00'));
await keyboard(page, region(page).getByRole('button', { name: translations.en.retry, exact: true })); await expect.poll(() => attempts).toBe(2);
await expect(region(page)).toBeFocused(); const external = page.locator('header').getByRole('button', { name: 'Norsk', exact: true });
await expect(region(page)).toBeFocused(); const external = page.locator('header').getByRole('button', { name: 'Norsk bokmål', exact: true });
await external.focus(); await expect(external).toBeFocused(); second.release();
await expect(snooze(page, row, 3)).toBeEnabled(); await expect(region(page).getByRole('alert')).toHaveCount(0); await expect(external).toBeFocused();
expect(requests(session, 'PATCH', `/api/jobapplications/${row.id}/followup`).map(request => request.body)).toEqual([{ followUpAt: '2026-10-16' }, { followUpAt: '2026-10-16' }]);
@@ -281,7 +348,7 @@ test('[P7-05 Reminders] live EN/Bokmal translates status/date controls and gener
await expect.poll(() => requests(session, 'GET', '/api/jobapplications/reminders').length).toBeGreaterThanOrEqual(2);
const baseline = requests(session, 'GET', '/api/jobapplications/reminders').length;
const preference = response(page, 'PUT', `${apiUrl}/auth/preferences/language`);
await keyboard(page, page.locator('header').getByRole('button', { name: 'Norsk', exact: true })); expect((await preference).status()).toBe(204);
await keyboard(page, page.locator('header').getByRole('button', { name: 'Norsk bokmål', exact: true })); expect((await preference).status()).toBe(204);
await expect(page.locator('html')).toHaveAttribute('lang', 'nb-NO'); await expect(region(page, 'nb').getByRole('article')).toHaveCount(4);
for (const row of rows) await expect(article(page, row.jobTitle)).toContainText(fixtureReason(row, 'nb'));
await expect(article(page, rows[1].jobTitle).getByText(translations.nb.statusInterview, { exact: true })).toBeVisible();
+83
View File
@@ -0,0 +1,83 @@
[CmdletBinding()]
param(
[ValidateRange(1024, 65535)][int]$Port = 3000,
[ValidateSet('desktop-linux', 'default')][string]$DockerContext = 'desktop-linux',
[switch]$NoCache,
[switch]$ValidateOnly
)
$ErrorActionPreference = 'Stop'
$repo = Split-Path -Parent $PSScriptRoot
$composeFile = Join-Path $repo 'dev/windows-local.compose.yml'
$envFile = Join-Path $repo '.env.windows-local'
$project = 'jobjakt-windows-local'
function Invoke-DockerChecked {
param([string[]]$DockerArguments)
& docker --context $DockerContext @DockerArguments
if ($LASTEXITCODE -ne 0) { throw "Docker failed (exit $LASTEXITCODE). Existing data volumes have been retained." }
}
function New-LocalSecret {
$bytes = New-Object byte[] 32
$random = [System.Security.Cryptography.RandomNumberGenerator]::Create()
try { $random.GetBytes($bytes) } finally { $random.Dispose() }
return ([BitConverter]::ToString($bytes)).Replace('-', '').ToLowerInvariant()
}
Get-Command docker -ErrorAction Stop | Out-Null
$sourceCommit = & git -C $repo rev-parse HEAD
if ($LASTEXITCODE -ne 0) { throw 'Run this script from its existing Git checkout.' }
$sourceBranch = & git -C $repo branch --show-current
Write-Host "Building checkout $sourceBranch at $sourceCommit"
Write-Host 'No fetch, reset, production Compose, image push or volume deletion is performed.'
if (-not (Test-Path -LiteralPath $envFile)) {
# Reuse on later runs: replacing these passwords would break existing volumes.
$lines = @(
"JT_LOCAL_DB_ROOT_PASSWORD=$(New-LocalSecret)",
"JT_LOCAL_DB_PASSWORD=$(New-LocalSecret)",
"JT_LOCAL_JWT_KEY=$(New-LocalSecret)",
'JT_LOCAL_ADMIN_EMAIL=local-admin@example.test',
"JT_LOCAL_ADMIN_PASSWORD=Jt1!$(New-LocalSecret)"
)
[IO.File]::WriteAllLines($envFile, $lines, (New-Object Text.UTF8Encoding($false)))
Write-Host "Created private local credentials: $envFile"
}
$previousPort = $env:JT_LOCAL_PORT
$previousCommit = $env:JT_LOCAL_COMMIT
try {
$env:JT_LOCAL_PORT = [string]$Port
$env:JT_LOCAL_COMMIT = $sourceCommit
$composeArgs = @('compose', '--project-name', $project,
'--env-file', $envFile, '-f', $composeFile)
Invoke-DockerChecked -DockerArguments ($composeArgs + @('config', '--quiet'))
if ($ValidateOnly) {
Write-Host 'Compose configuration is valid; no images built or containers started.'
return
}
$contextJson = & docker context inspect $DockerContext
if ($LASTEXITCODE -ne 0) { throw "Docker context '$DockerContext' was not found. Start Docker Desktop in Linux containers mode." }
$endpoint = ($contextJson | ConvertFrom-Json)[0].Endpoints.docker.Host
if ($endpoint -notlike 'npipe://*') { throw 'This script only starts a local Windows Docker named-pipe engine.' }
$engine = & docker --context $DockerContext info --format '{{.OSType}}' 2>$null
if ($LASTEXITCODE -ne 0 -or $engine -ne 'linux') {
throw 'Start Docker Desktop, select Linux containers, wait until the engine is ready, then rerun this script.'
}
$buildArgs = @('build', 'backend', 'frontend')
if ($NoCache) { $buildArgs = @('build', '--no-cache', 'backend', 'frontend') }
Invoke-DockerChecked -DockerArguments ($composeArgs + $buildArgs)
Invoke-DockerChecked -DockerArguments ($composeArgs + @('up', '-d', '--wait', '--wait-timeout', '300', 'database', 'backend', 'frontend'))
Invoke-DockerChecked -DockerArguments ($composeArgs + @('ps'))
Write-Host "Open http://localhost:$Port"
Write-Host 'Login: local-admin@example.test (password is JT_LOCAL_ADMIN_PASSWORD in the private credentials file).'
Write-Host "Credentials: $envFile"
Write-Host 'Re-running this script rebuilds the current checkout and retains the local database/files.'
}
finally {
$env:JT_LOCAL_PORT = $previousPort
$env:JT_LOCAL_COMMIT = $previousCommit
}
+65
View File
@@ -0,0 +1,65 @@
"""Offline configuration checks; never build images or start containers."""
import json
import os
from pathlib import Path
import shutil
import subprocess
import tempfile
import unittest
ROOT = Path(__file__).resolve().parents[1]
class WindowsDockerTests(unittest.TestCase):
def test_powershell_script_parses(self):
shell = shutil.which('powershell') or shutil.which('pwsh')
if not shell:
self.skipTest('PowerShell is not installed')
script = ROOT / 'scripts/rebuild-windows-docker.ps1'
code = ('$errors=$null; $tokens=$null; '
'[System.Management.Automation.Language.Parser]::ParseFile('
+ "'" + str(script).replace("'", "''") + "'"
+ ', [ref]$tokens, [ref]$errors) | Out-Null; '
'if ($errors.Count) { $errors | Write-Error; exit 1 }')
result = subprocess.run([shell, '-NoProfile', '-Command', code], capture_output=True, text=True)
self.assertEqual(0, result.returncode, result.stderr)
def test_rendered_compose_is_local_persistent_and_uses_this_checkout(self):
with tempfile.TemporaryDirectory() as folder:
env_file = Path(folder) / '.env'
env_file.write_text('\n'.join([
'JT_LOCAL_DB_ROOT_PASSWORD=fixture-root', 'JT_LOCAL_DB_PASSWORD=fixture-database',
'JT_LOCAL_JWT_KEY=fixture-signing-key-not-a-real-secret',
'JT_LOCAL_ADMIN_EMAIL=local-admin@example.test', 'JT_LOCAL_ADMIN_PASSWORD=Fixture1!',
'JT_LOCAL_PORT=3100', 'JT_LOCAL_COMMIT=fixture-commit',
]), encoding='utf-8')
environment = {key: value for key, value in os.environ.items() if not key.startswith('JT_LOCAL_')}
result = subprocess.run([
'docker', 'compose', '--project-name', 'jobjakt-windows-local', '--env-file', str(env_file),
'-f', str(ROOT / 'dev/windows-local.compose.yml'), 'config', '--format', 'json',
], capture_output=True, text=True, env=environment)
self.assertEqual(0, result.returncode, result.stderr)
config = json.loads(result.stdout)
services = config['services']
self.assertEqual({'database', 'backend', 'frontend'}, set(services))
self.assertEqual('jobjakt-windows-local', config['name'])
self.assertFalse(services['database'].get('ports'))
self.assertFalse(services['backend'].get('ports'))
port = services['frontend']['ports'][0]
self.assertEqual(('127.0.0.1', '3100', 80), (port['host_ip'], port['published'], port['target']))
self.assertEqual(ROOT.resolve(), Path(services['backend']['build']['context']).resolve())
self.assertEqual((ROOT / 'job-tracker-ui').resolve(), Path(services['frontend']['build']['context']).resolve())
backend = services['backend']['environment']
self.assertEqual('Server=database;Database=jobtracker;User ID=jobtracker;Password=fixture-database;SslMode=None', backend['ConnectionStrings__JobTracker'])
self.assertEqual('true', backend['Auth__Require'])
self.assertEqual('http://localhost:3100', backend['App__PublicBaseUrl'])
self.assertEqual('false', backend['Ai__ExternalProcessingEnabled'])
self.assertTrue(all(value == 'false' for key, value in backend.items() if key.startswith('Workers__')))
self.assertEqual('direct', services['frontend']['environment']['INGRESS_MODE'])
self.assertEqual('/api', services['frontend']['build']['args']['NEXT_PUBLIC_API_BASE_URL'])
self.assertEqual({'database', 'files', 'tombstones'}, set(config['volumes']))
self.assertFalse(any(volume.get('external') for volume in config['volumes'].values()))
if __name__ == '__main__':
unittest.main()