Compare commits

..

36 Commits

Author SHA1 Message Date
cesnimda ac64d2ee22 fix(a11y): announce singular calendar and search counts
Preserve the real result count and localized date. Zero and multiple entries keep the existing translations. The Bokmål search noun has the same form in both cases.

Verified from f6143b9c with 37 component tests and six isolated Chromium/SQLite journeys on ports 4397/5397. New zero/one/two checks reproduced three singular failures before the fix. Next static export, TypeScript and scoped lint passed.

(cherry picked from commit 86d2305e64)
2026-11-20 19:31:15 +01:00
cesnimda 8b9aa1dafe test(cv): qualify concurrent library renames in two browser tabs
(cherry picked from commit 68f33253a8)
2026-11-20 19:29:09 +01:00
cesnimda 925b2033e3 Record ten successful concept history round trips
(cherry picked from commit 859bb8544a)
2026-11-20 19:24:33 +01:00
cesnimda d555e1d932 Preserve browser navigation through the five design journeys
(cherry picked from commit 9795a491e0)
2026-11-20 19:24:33 +01:00
cesnimda f6143b9c7d fix(cv): preserve concurrent names when renaming from the library
(cherry picked from commit 89128e1c33)
2026-11-20 13:59:48 +01:00
cesnimda a6a95e81d0 Reserve landing preview geometry and defer secondary images
(cherry picked from commit c7f79a4b96)
2026-11-20 13:56:39 +01:00
cesnimda 910573f836 fix(test): resolve PDF fixture from SDK build output
(cherry picked from commit 2aaf7a2426)
2026-11-20 08:58:58 +01:00
cesnimda 7a2b8a95c1 Preserve multilingual CV section boundaries in rewrite previews
(cherry picked from commit bd368f841c)
2026-11-20 08:56:07 +01:00
cesnimda 245f2feaa8 test(documents): record integrated native frozen attachment journey 2026-11-19 21:02:36 +01:00
cesnimda 398fafb72d fix(documents): clean up only snapshots created by the current copy
(cherry picked from commit fa8154da9e)
2026-11-19 20:57:39 +01:00
cesnimda 990a3bfa58 docs: bind recovered connected CV result to the existing test 2026-11-19 20:53:12 +01:00
cesnimda 22a0d3a8c4 perf(applications): scope latest mail to filtered candidates
(cherry picked from commit 1047dfa267)
2026-11-19 20:47:46 +01:00
cesnimda d8cf604c46 design: publish five interactive Jobjakt concepts and review evidence 2026-11-19 20:42:57 +01:00
cesnimda 5fd5c47045 docs: reassess A3 completion and preservation gaps 2026-11-18 19:36:57 +01:00
cesnimda 2c5d04513e perf(users): project only administrative summary fields 2026-11-18 19:11:00 +01:00
cesnimda 213793c11c docs: qualify combined native connected workflows 2026-11-18 19:02:16 +01:00
cesnimda 1ec1542936 test(discovery): prove explicit native tracker journey 2026-11-18 18:57:13 +01:00
cesnimda 3509b95132 fix(checklist): recover only system-key duplicate races 2026-11-18 18:53:36 +01:00
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
cesnimda 1db5f488f6 docs: qualify public landmark accessibility without visual change 2026-11-18 07:26:14 +01:00
cesnimda 36084473c3 fix(a11y): expose public landing landmarks 2026-11-18 07:25:19 +01:00
cesnimda 5b50cb2713 docs: qualify anonymous language navigation recovery 2026-11-18 07:20:01 +01:00
cesnimda d9fbed526b docs: retain referenced landing verification logs 2026-11-18 07:17:25 +01:00
cesnimda c536e091b0 fix(landing): keep anonymous language selection local 2026-11-18 07:17:10 +01:00
cesnimda 900ffb437d docs: qualify integrated native workflow regression 2026-11-18 07:14:11 +01:00
cesnimda 4eb8a2933b docs(perf): preserve source-bound static encoding measurements 2026-11-18 01:23:47 +01:00
cesnimda 0765b15133 fix(dev-deps): qualify scoped Jest glob upgrade 2026-11-18 01:19:46 +01:00
cesnimda 7340c57806 docs: qualify recovered development dependency build 2026-11-18 01:07:36 +01:00
cesnimda ed4d8e5696 fix(dev-deps): update TypeScript ESLint glob dependency 2026-11-18 01:07:36 +01:00
cesnimda cbca0a768b fix(interview): retain answer drafts during same-job refresh 2026-11-18 01:07:36 +01:00
cesnimda 5e04db9212 docs: preserve native browser recovery and connected CV evidence 2026-11-18 01:06:51 +01:00
cesnimda a88e260d39 test: qualify connected CV creation and responsive read recovery 2026-11-18 01:05:19 +01:00
cesnimda 5262bee15a fix: preserve CV editor heading hierarchy in compact layouts 2026-11-18 00:53:00 +01:00
cesnimda 336bc09987 fix(interview): scope parent reads and drafts to their application 2026-11-18 00:43:26 +01:00
552 changed files with 39657 additions and 2018 deletions
@@ -0,0 +1,129 @@
using System.Data.Common;
using System.Text.Json;
using JobTrackerApi.Models;
using JobTrackerApi.Services;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using Xunit;
using Xunit.Abstractions;
namespace JobTrackerApi.MariaDb.Tests;
public sealed class AnalyticsStatsPersistenceTests(ITestOutputHelper output)
{
private const string Owner = "rd21-owner";
[Theory]
[InlineData(0)]
[InlineData(250)]
[InlineData(2500)]
public async Task Stats_keep_owned_results_with_bounded_native_roundtrips(int size)
{
await using var database = await MariaDbDatabase.CreateAsync();
var recorder = new Reads();
await using var db = database.Context(interceptor: recorder);
var company = new Company { Name = "Synthetic analytics", OwnerUserId = Owner };
db.Companies.Add(company);
await db.SaveChangesAsync();
var date = DateTime.Now.AddDays(-10);
db.JobApplications.AddRange(Enumerable.Range(0, size).Select(_ => Job(company.Id, Owner, "Applied", date)));
db.JobApplications.Add(Job(company.Id, "foreign-owner", "Private", date));
db.JobApplications.Add(Job(company.Id, null, "Unowned", date));
await db.SaveChangesAsync();
db.ChangeTracker.Clear();
recorder.Sql.Clear();
var stats = await new AnalyticsService(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(db.ChangeTracker.Entries());
Assert.All(recorder.Sql, sql =>
{
Assert.DoesNotContain("Description", sql);
Assert.DoesNotContain("CoverLetterText", sql);
});
output.WriteLine(JsonSerializer.Serialize(new { database.ActualVersion, OwnedRows = size,
Commands = recorder.Sql.Count, Sql = recorder.Sql }));
Assert.Equal(size == 0 ? 2 : 3, recorder.Sql.Count);
}
[Fact]
public async Task Stats_preserve_native_nullable_dates_deletion_ownership_and_mutation()
{
await using var database = await MariaDbDatabase.CreateAsync();
await using var db = database.Context();
var company = new Company { Name = "Synthetic semantics", OwnerUserId = Owner };
db.Add(company);
await db.SaveChangesAsync();
var now = DateTime.Now;
db.JobApplications.AddRange(
Job(company.Id, Owner, "Applied", now.AddDays(-29)),
Job(company.Id, Owner, "Interview", now.AddDays(-31)),
Job(company.Id, Owner, "", null),
Job(company.Id, Owner, " ", now.AddDays(2)),
Job(company.Id, Owner, "Unknown", null),
Job(company.Id, Owner, "Deleted", now, deleted: true),
Job(company.Id, "foreign-owner", "Private", now),
Job(company.Id, null, "Unowned", now));
await db.SaveChangesAsync();
var service = new AnalyticsService(db);
var stats = await service.GetStatsAsync(default);
Assert.Equal(6, stats.Total);
Assert.Equal(5, stats.Active);
Assert.Equal(1, stats.Deleted);
Assert.Equal(2, stats.AppliedLast30Days);
Assert.Equal(20, stats.AverageDaysSinceApplied);
Assert.Equal(3, stats.ByStatus["Unknown"]);
Assert.Equal(1, stats.ByStatus["Applied"]);
Assert.Equal(1, stats.ByStatus["Interview"]);
await using var other = database.Context("foreign-owner");
Assert.Equal(1, (await new AnalyticsService(other).GetStatsAsync(default)).Total);
await using var anonymous = database.Context(null!);
var denied = await new AnalyticsService(anonymous).GetStatsAsync(default);
Assert.Equal(0, denied.Total);
Assert.Empty(denied.ByStatus);
db.JobApplications.Add(Job(company.Id, Owner, "Saved", null));
await db.SaveChangesAsync();
Assert.Equal(7, (await service.GetStatsAsync(default)).Total);
output.WriteLine(database.ActualVersion);
}
[Fact]
public async Task Cancellation_at_native_command_boundary_prevents_later_stats_reads()
{
await using var database = await MariaDbDatabase.CreateAsync();
using var cancellation = new CancellationTokenSource();
var recorder = new Reads { BeforeRead = cancellation.Cancel };
await using var db = database.Context(interceptor: recorder);
await Assert.ThrowsAnyAsync<OperationCanceledException>(() =>
new AnalyticsService(db).GetStatsAsync(cancellation.Token));
Assert.Single(recorder.Sql);
output.WriteLine(database.ActualVersion);
}
private static JobApplication Job(int companyId, string? owner, string status, DateTime? date, bool deleted = false) => new()
{
CompanyId = companyId, OwnerUserId = owner, JobTitle = "Synthetic analyst", Status = status,
DateApplied = date, IsDeleted = deleted, Description = "Synthetic wide data must not be selected",
CoverLetterText = "Synthetic private letter must not be selected",
};
private sealed class Reads : DbCommandInterceptor
{
public List<string> Sql { get; } = [];
public Action? BeforeRead { get; init; }
public override ValueTask<InterceptionResult<DbDataReader>> ReaderExecutingAsync(DbCommand command,
CommandEventData eventData, InterceptionResult<DbDataReader> result, CancellationToken cancellationToken = default)
{
Sql.Add(command.CommandText);
BeforeRead?.Invoke();
return base.ReaderExecutingAsync(command, eventData, result, cancellationToken);
}
}
}
@@ -0,0 +1,124 @@
using JobTrackerApi.Models;
using JobTrackerApi.Services;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using MySqlConnector;
using Xunit;
using Xunit.Abstractions;
namespace JobTrackerApi.MariaDb.Tests;
public sealed class ApplicationChecklistPersistenceTests(ITestOutputHelper output)
{
private const string Owner = "rd21-owner";
[Theory]
[InlineData("system-key")]
[InlineData("foreign-key")]
[InlineData("unrelated-unique")]
public async Task Seed_recovers_only_its_actual_unique_constraint(string scenario)
{
await using var database = await MariaDbDatabase.CreateAsync();
int jobId;
const string spoof = "IX_ApplicationChecklistItems_JobApplicationId_SystemKey";
await using (var seed = database.Context())
{
seed.Users.Add(new ApplicationUser { Id = Owner, UserName = spoof, NormalizedUserName = spoof });
var job = new JobApplication { OwnerUserId = Owner, Company = new Company { OwnerUserId = Owner, Name = "Synthetic checklist" }, Status = "Interview", Version = 7 };
seed.JobApplications.Add(job);
await seed.SaveChangesAsync();
jobId = job.Id;
seed.ApplicationChecklistItems.AddRange(
new ApplicationChecklistItem { OwnerUserId = Owner, JobApplicationId = jobId, SystemKey = "prepare-cv", AutoSignal = ChecklistSignalKeys.Cv,
IsSystemGenerated = true, Title = "Prepare CV", Category = ChecklistCategories.Preparation, Status = ChecklistStatuses.Dismissed },
new ApplicationChecklistItem { OwnerUserId = Owner, JobApplicationId = jobId, Title = "Manual decision", Category = ChecklistCategories.Custom,
Status = ChecklistStatuses.Done, SortOrder = 90 });
await seed.SaveChangesAsync();
}
var race = new Race();
await using var winner = database.Context(interceptor: new Gate(race, winner: true));
var losingGate = new Gate(race, winner: false, saveOtherFirst: scenario == "unrelated-unique");
await using var loser = database.Context(interceptor: losingGate);
if (scenario == "foreign-key")
loser.ApplicationChecklistItems.Add(new ApplicationChecklistItem { OwnerUserId = Owner, JobApplicationId = int.MaxValue,
Title = "Invalid parent must fail", Status = ChecklistStatuses.Done });
if (scenario == "unrelated-unique")
loser.Users.Add(new ApplicationUser { Id = "other-user", UserName = spoof, NormalizedUserName = spoof });
using var timeout = new CancellationTokenSource(TimeSpan.FromSeconds(30));
var winningRead = new ApplicationChecklistService(winner).GetAsync(Owner, jobId, timeout.Token);
var losingRead = new ApplicationChecklistService(loser).GetAsync(Owner, jobId, timeout.Token);
Assert.NotNull(await winningRead);
var observed = await Record.ExceptionAsync(async () => await losingRead);
var saveError = Assert.IsType<DbUpdateException>(losingGate.Failure);
var native = Assert.IsType<MySqlException>(saveError.InnerException);
output.WriteLine($"Server={database.ActualVersion}; scenario={scenario}; native={native.Number}; message={native.Message}; service={observed?.GetType().Name ?? "none"}");
if (scenario == "system-key")
{
Assert.Equal(1062, native.Number);
Assert.Null(observed);
var first = (await winningRead)!;
var second = (await losingRead)!;
Assert.Equal(first.Items.Select(item => item.Id).Order(), second.Items.Select(item => item.Id).Order());
Assert.Equal(ChecklistStatuses.Dismissed, second.Items.Single(item => item.SystemKey == "prepare-cv").Status);
Assert.Equal(ChecklistStatuses.Done, second.Items.Single(item => item.SystemKey == null).Status);
}
else
{
if (scenario == "unrelated-unique")
{
Assert.EndsWith("for key 'UserNameIndex'", native.Message);
Assert.Contains(spoof, native.Message, StringComparison.Ordinal);
}
Assert.IsType<DbUpdateException>(observed);
Assert.Equal(scenario == "foreign-key" ? 1452 : 1062, native.Number);
Assert.True(loser.ChangeTracker.Entries().Any(entry => entry.State == EntityState.Added));
}
await using var verify = database.Context();
Assert.Equal(15, await verify.ApplicationChecklistItems.CountAsync());
Assert.Equal(7, (await verify.JobApplications.SingleAsync()).Version);
Assert.Equal(1, await verify.Users.CountAsync());
}
private sealed class Race
{
private int _arrivals;
public TaskCompletionSource BothReady { get; } = new(TaskCreationOptions.RunContinuationsAsynchronously);
public TaskCompletionSource Committed { get; } = new(TaskCreationOptions.RunContinuationsAsynchronously);
public void Arrive() { if (Interlocked.Increment(ref _arrivals) == 2) BothReady.TrySetResult(); }
}
private sealed class Gate(Race race, bool winner, bool saveOtherFirst = false) : SaveChangesInterceptor
{
private bool _used;
public Exception? Failure { get; private set; }
public override async ValueTask<InterceptionResult<int>> SavingChangesAsync(DbContextEventData data, InterceptionResult<int> result, CancellationToken ct = default)
{
if (_used) return result;
_used = true;
race.Arrive();
await race.BothReady.Task.WaitAsync(ct);
if (!winner) await race.Committed.Task.WaitAsync(ct);
if (saveOtherFirst)
{
// Force the unrelated tracked write first; normal batch ordering hits checklist duplicates first.
var context = data.Context!;
var seeds = context.ChangeTracker.Entries<ApplicationChecklistItem>()
.Where(entry => entry.State == EntityState.Added).ToList();
foreach (var seed in seeds) seed.State = EntityState.Detached;
try { await context.SaveChangesAsync(ct); }
finally { foreach (var seed in seeds) context.Add(seed.Entity); }
}
return result;
}
public override ValueTask<int> SavedChangesAsync(SaveChangesCompletedEventData data, int result, CancellationToken ct = default)
{
if (winner) race.Committed.TrySetResult();
return ValueTask.FromResult(result);
}
public override Task SaveChangesFailedAsync(DbContextErrorEventData data, CancellationToken ct = default)
{
Failure = data.Exception;
return Task.CompletedTask;
}
}
}
@@ -0,0 +1,94 @@
using System.Data.Common;
using System.Security.Claims;
using JobTrackerApi.Controllers;
using JobTrackerApi.Models;
using JobTrackerApi.Services;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging.Abstractions;
using Moq;
using Xunit;
using Xunit.Abstractions;
namespace JobTrackerApi.MariaDb.Tests;
public sealed class UserListProjectionTests(ITestOutputHelper output)
{
[Theory]
[InlineData(1)]
[InlineData(2)]
public async Task Summary_projects_only_required_columns_and_retains_global_admin_safety(int adminCount)
{
await using var database = await MariaDbDatabase.CreateAsync();
var recorder = new ReaderRecorder();
await using var db = database.Context(interceptor: recorder);
var linkedAt = new DateTimeOffset(2026, 11, 18, 10, 0, 0, TimeSpan.Zero);
db.Roles.AddRange(new IdentityRole("Admin") { Id = "admins", NormalizedName = "ADMIN" },
new IdentityRole("Member") { Id = "members", NormalizedName = "MEMBER" });
for (var index = 0; index < 75; index++)
{
var id = $"summary-{index:D2}";
db.Users.Add(new ApplicationUser
{
Id = id, Email = id + "@example.test", UserName = id,
FirstName = index == 0 ? "Åse" : null, LastName = index == 0 ? "Nordlys" : null,
DisplayName = index == 0 ? "Reviewed administrator" : null,
EmailConfirmed = index == 0, TwoFactorEnabled = index == 0,
GoogleEmail = index == 0 ? "linked@example.test" : null, GoogleLinkedAt = index == 0 ? linkedAt : null,
ProfileCvText = new string('c', 65_536), ProfileCvStructureJson = new string('j', 65_536),
AvatarImageDataUrl = new string('a', 16_384), PasswordHash = "synthetic-private-hash",
TotpSecretEncrypted = "synthetic-private-totp"
});
db.UserRoles.Add(new IdentityUserRole<string> { UserId = id, RoleId = index < adminCount ? "admins" : "members" });
}
await db.SaveChangesAsync();
db.ChangeTracker.Clear();
recorder.Commands.Clear();
await using var scope = database.App.Services.CreateAsyncScope();
var controller = new UsersController(scope.ServiceProvider.GetRequiredService<UserManager<ApplicationUser>>(),
scope.ServiceProvider.GetRequiredService<RoleManager<IdentityRole>>(), Mock.Of<IAppEmailSender>(),
new ConfigurationBuilder().Build(), NullLogger<UsersController>.Instance,
ExternalOrigin.Parse("http://localhost:3000", production: false), db: db)
{
ControllerContext = new ControllerContext { HttpContext = new DefaultHttpContext
{ User = new ClaimsPrincipal(new ClaimsIdentity([new Claim(ClaimTypes.NameIdentifier, "summary-00")], "test")) } }
};
var result = await controller.List(default);
var rows = Assert.IsType<List<UsersController.UserDto>>(Assert.IsType<OkObjectResult>(result.Result).Value);
Assert.Equal(75, rows.Count);
var current = Assert.Single(rows, row => row.Id == "summary-00");
Assert.Equal("Åse", current.FirstName); Assert.Equal("Nordlys", current.LastName);
Assert.Equal("Reviewed administrator", current.DisplayName);
Assert.Equal("linked@example.test", current.GoogleEmail); Assert.Equal(linkedAt, current.GoogleLinkedAt);
Assert.True(current.EmailConfirmed); Assert.True(current.TwoFactorEnabled); Assert.True(current.IsCurrentUser);
Assert.Equal(adminCount > 1, current.CanRemoveAdmin); Assert.Equal(["Admin"], current.Roles);
var member = rows[^1];
Assert.Null(member.FirstName); Assert.Null(member.GoogleLinkedAt); Assert.False(member.IsCurrentUser);
Assert.True(member.CanRemoveAdmin); Assert.Equal(["Member"], member.Roles);
Assert.Equal(Enumerable.Range(0, 75).Select(index => $"summary-{index:D2}"), rows.Select(row => row.Id));
Assert.Empty(db.ChangeTracker.Entries<ApplicationUser>());
Assert.Equal(2, recorder.Commands.Count);
var sql = recorder.Commands[0];
Assert.Equal(10, sql.Split("FROM", StringSplitOptions.None)[0].Split(',').Length);
foreach (var excluded in new[] { "ProfileCvText", "ProfileCvStructureJson", "AvatarImageDataUrl", "PasswordHash", "TotpSecretEncrypted", "SecurityStamp", "StripeCustomerId", "DashboardLayoutJson" })
Assert.DoesNotContain(excluded, sql, StringComparison.Ordinal);
output.WriteLine($"Actual server:{database.ActualVersion}; users:75; admins:{adminCount}; SELECT columns:10; reader commands:2; excluded large fixture text:11059200 bytes");
output.WriteLine(sql);
}
private sealed class ReaderRecorder : DbCommandInterceptor
{
public List<string> Commands { get; } = [];
public override ValueTask<InterceptionResult<DbDataReader>> ReaderExecutingAsync(DbCommand command,
CommandEventData eventData, InterceptionResult<DbDataReader> result, CancellationToken cancellationToken = default)
{
Commands.Add(command.CommandText);
return base.ReaderExecutingAsync(command, eventData, result, cancellationToken);
}
}
}
@@ -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();
}
}
}
@@ -0,0 +1,134 @@
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 ApplicationChecklistConcurrencyTests(ITestOutputHelper output)
{
[Fact]
public async Task Native_duplicate_seed_race_recovers_both_reads_without_losing_user_decisions()
{
await using var database = await Database.Create();
var race = new SeedRace();
await using var winner = database.Context(new SeedGate(race, winner: true));
var loserGate = new SeedGate(race, winner: false);
await using var loser = database.Context(loserGate);
using var timeout = new CancellationTokenSource(TimeSpan.FromSeconds(20));
var results = await Task.WhenAll(
new ApplicationChecklistService(winner).GetAsync(Database.Owner, database.JobId, timeout.Token),
new ApplicationChecklistService(loser).GetAsync(Database.Owner, database.JobId, timeout.Token));
Assert.All(results, result => Assert.NotNull(result));
Assert.Equal(results[0]!.Items.Select(x => x.Id).Order(), results[1]!.Items.Select(x => x.Id).Order());
Assert.All(results, result =>
{
Assert.Equal(14, result!.Items.Count(x => x.SystemKey != null));
Assert.Equal(ChecklistStatuses.Dismissed, result.Items.Single(x => x.SystemKey == "prepare-cv").Status);
Assert.Equal("Manual decision", result.Items.Single(x => x.SystemKey == null).Title);
Assert.Equal(ChecklistStatuses.Done, result.Items.Single(x => x.SystemKey == null).Status);
});
var duplicate = Assert.IsType<SqliteException>(Assert.IsType<DbUpdateException>(loserGate.Failure).InnerException);
Assert.Equal(2067, duplicate.SqliteExtendedErrorCode);
await using var verify = database.Context();
Assert.Equal(15, await verify.ApplicationChecklistItems.CountAsync());
Assert.Equal(7, (await verify.JobApplications.SingleAsync()).Version);
Assert.DoesNotContain(loser.ChangeTracker.Entries<ApplicationChecklistItem>(), entry => entry.State == EntityState.Added);
output.WriteLine("Native SQLite duplicate2067 observed and recovered; both calls returned the same15 persisted IDs, user decisions and job revision7 preserved.");
}
[Fact]
public async Task Concurrent_seed_recovery_does_not_swallow_an_unrelated_native_foreign_key_failure()
{
await using var database = await Database.Create();
var race = new SeedRace();
await using var winner = database.Context(new SeedGate(race, winner: true));
var loserGate = new SeedGate(race, winner: false);
await using var loser = database.Context(loserGate);
var invalidCustom = new ApplicationChecklistItem { OwnerUserId = Database.Owner, JobApplicationId = int.MaxValue, Title = "Invalid parent must fail", Status = ChecklistStatuses.Done };
loser.ApplicationChecklistItems.Add(invalidCustom);
using var timeout = new CancellationTokenSource(TimeSpan.FromSeconds(20));
var winningRead = new ApplicationChecklistService(winner).GetAsync(Database.Owner, database.JobId, timeout.Token);
var losingRead = new ApplicationChecklistService(loser).GetAsync(Database.Owner, database.JobId, timeout.Token);
Assert.NotNull(await winningRead);
var observed = await Record.ExceptionAsync(async () => await losingRead);
output.WriteLine($"Native save error={((loserGate.Failure as DbUpdateException)?.InnerException as SqliteException)?.SqliteExtendedErrorCode}; service exception={observed?.GetType().Name ?? "none"}.");
var error = Assert.IsType<DbUpdateException>(observed);
var native = Assert.IsType<SqliteException>(error.InnerException);
Assert.Equal(787, native.SqliteExtendedErrorCode);
Assert.Equal(EntityState.Added, loser.Entry(invalidCustom).State);
await using var verify = database.Context();
Assert.Equal(15, await verify.ApplicationChecklistItems.CountAsync());
Assert.False(await verify.ApplicationChecklistItems.AnyAsync(x => x.Title == invalidCustom.Title));
output.WriteLine("Native SQLite foreign-key787 propagated despite another request having persisted all missing default keys.");
}
private sealed class SeedRace
{
private int _arrivals;
public TaskCompletionSource BothReady { get; } = new(TaskCreationOptions.RunContinuationsAsynchronously);
public TaskCompletionSource WinnerCommitted { get; } = new(TaskCreationOptions.RunContinuationsAsynchronously);
public void Arrive() { if (Interlocked.Increment(ref _arrivals) == 2) BothReady.TrySetResult(); }
}
private sealed class SeedGate(SeedRace race, bool winner) : SaveChangesInterceptor
{
private bool _used;
public Exception? Failure { get; private set; }
public override async ValueTask<InterceptionResult<int>> SavingChangesAsync(DbContextEventData eventData, InterceptionResult<int> result, CancellationToken cancellationToken = default)
{
if (_used) return result;
_used = true;
race.Arrive();
await race.BothReady.Task.WaitAsync(cancellationToken);
if (!winner) await race.WinnerCommitted.Task.WaitAsync(cancellationToken);
return result;
}
public override ValueTask<int> SavedChangesAsync(SaveChangesCompletedEventData eventData, int result, CancellationToken cancellationToken = default)
{
if (winner) race.WinnerCommitted.TrySetResult();
return ValueTask.FromResult(result);
}
public override Task SaveChangesFailedAsync(DbContextErrorEventData eventData, CancellationToken cancellationToken = default)
{
Failure = eventData.Exception;
return Task.CompletedTask;
}
}
private sealed class Database(string file) : IAsyncDisposable
{
public const string Owner = "owner";
public int JobId { get; private set; }
public JobTrackerContext Context(SaveChangesInterceptor? interceptor = null)
{
var options = new DbContextOptionsBuilder<JobTrackerContext>().UseSqlite($"Data Source={file};Pooling=False");
if (interceptor != null) options.AddInterceptors(interceptor);
var user = new Mock<ICurrentUserService>();
user.SetupGet(x => x.UserId).Returns(Owner);
return new JobTrackerContext(options.Options, user.Object);
}
public static async Task<Database> Create()
{
var database = new Database(Path.Combine(Path.GetTempPath(), $"checklist-race-{Guid.NewGuid():N}.db"));
await using var db = database.Context();
await db.Database.EnsureCreatedAsync();
db.Users.Add(new ApplicationUser { Id = Owner });
var job = new JobApplication { OwnerUserId = Owner, Company = new Company { OwnerUserId = Owner, Name = "Synthetic" }, Status = "Interview", Version = 7 };
db.JobApplications.Add(job);
await db.SaveChangesAsync();
database.JobId = job.Id;
db.ApplicationChecklistItems.AddRange(
new ApplicationChecklistItem { OwnerUserId = Owner, JobApplicationId = job.Id, SystemKey = "prepare-cv", AutoSignal = ChecklistSignalKeys.Cv, IsSystemGenerated = true, Title = "Prepare CV", Category = ChecklistCategories.Preparation, Status = ChecklistStatuses.Dismissed },
new ApplicationChecklistItem { OwnerUserId = Owner, JobApplicationId = job.Id, Title = "Manual decision", Category = ChecklistCategories.Custom, Status = ChecklistStatuses.Done, SortOrder = 90 });
await db.SaveChangesAsync();
return database;
}
public ValueTask DisposeAsync() { File.Delete(file); return ValueTask.CompletedTask; }
}
}
+22 -11
View File
@@ -21,7 +21,7 @@ public sealed class JobQueryParityTests
[Theory]
[InlineData(250)]
[InlineData(2500)]
public async Task Ordinary_table_materialises_correspondence_groups_only_for_the_returned_page(int size)
public async Task Job_list_reads_correspondence_only_for_relevant_applications(int size)
{
await using var connection = new SqliteConnection("Data Source=:memory:");
await connection.OpenAsync();
@@ -36,7 +36,7 @@ public sealed class JobQueryParityTests
var jobs = Enumerable.Range(0, size).Select(i => new JobApplication
{
Company = company, OwnerUserId = "owner", JobTitle = $"Application {i:D4}", Status = "Applied",
DateApplied = new DateTime(2026, 10, 1),
DateApplied = new DateTime(2026, 10, 1), Location = i % 50 == 0 ? "Bergen" : "Oslo",
}).ToList();
db.JobApplications.AddRange(jobs);
await db.SaveChangesAsync();
@@ -62,20 +62,31 @@ public sealed class JobQueryParityTests
Assert.Equal(size, page.Total);
var expected = jobs.Skip(15).Take(15).Select(job => job.Id).ToArray();
Assert.Equal(expected, page.Items.Select(job => job.Id));
var (sql, parameters) = Assert.Single(aggregate.Commands);
await using var replay = connection.CreateCommand();
replay.CommandText = sql;
foreach (var parameter in parameters) replay.Parameters.AddWithValue(parameter.Key, parameter.Value ?? DBNull.Value);
var materialised = new List<int>();
await using (var reader = await replay.ExecuteReaderAsync())
while (await reader.ReadAsync()) materialised.Add(reader.GetInt32(0));
Assert.Equal(15, materialised.Count);
Assert.Equal(expected.Order(), materialised.Order());
async Task AssertMessageRows(int[] expectedIds)
{
var (sql, parameters) = Assert.Single(aggregate.Commands);
await using var replay = connection.CreateCommand();
replay.CommandText = sql;
foreach (var parameter in parameters) replay.Parameters.AddWithValue(parameter.Key, parameter.Value ?? DBNull.Value);
var materialised = new List<int>();
await using (var reader = await replay.ExecuteReaderAsync())
while (await reader.ReadAsync()) materialised.Add(reader.GetInt32(0));
Assert.Equal(expectedIds.Length, materialised.Count);
Assert.Equal(expectedIds.Order(), materialised.Order());
}
await AssertMessageRows(expected);
aggregate.Commands.Clear();
await controller.GetBoard();
await controller.GetAll(q: "absent");
Assert.Empty(aggregate.Commands);
var candidates = jobs.Where(job => job.Location == "Bergen").Select(job => job.Id).ToArray();
var filtered = await controller.GetAll(location: "Bergen", readiness: "needs-work", sortBy: "jobTitle");
var filteredPage = Assert.IsType<PagedResult<JobApplicationDto>>(Assert.IsType<OkObjectResult>(filtered.Result).Value);
Assert.Equal(candidates.Length, filteredPage.Total);
Assert.Equal(candidates.Take(15), filteredPage.Items.Select(job => job.Id));
await AssertMessageRows(candidates);
}
private sealed class CorrespondenceAggregateRecorder : DbCommandInterceptor
+10 -4
View File
@@ -5,6 +5,7 @@
<Nullable>enable</Nullable>
<IsPackable>false</IsPackable>
<RestorePackagesWithLockFile>true</RestorePackagesWithLockFile>
<DefaultItemExcludes>$(DefaultItemExcludes);PdfBrowserStub/**</DefaultItemExcludes>
</PropertyGroup>
<ItemGroup>
@@ -24,14 +25,19 @@
<ProjectReference Include="..\JobTrackerApi\JobTrackerApi.csproj" />
<!-- Build the fixture, but only our explicit subdirectory copy owns its output.
The Linux apphost has no .exe suffix and collides with that directory if copied to root. -->
<ProjectReference Include="PdfBrowserStub/PdfBrowserStub.csproj" ReferenceOutputAssembly="false" Private="false" />
<Compile Remove="PdfBrowserStub/**/*.cs" />
<ProjectReference Include="PdfBrowserStub/PdfBrowserStub.csproj" ReferenceOutputAssembly="false" Private="false" OutputItemType="PdfBrowserStubAssembly" />
</ItemGroup>
<Target Name="CopyPdfBrowserStub" AfterTargets="Build">
<Error Condition="'@(PdfBrowserStubAssembly)' == ''" Text="The PDF browser stub project returned no output assembly." />
<PropertyGroup>
<PdfBrowserStubOutput>@(PdfBrowserStubAssembly->'%(RootDir)%(Directory)%(Filename)')</PdfBrowserStubOutput>
</PropertyGroup>
<ItemGroup>
<PdfBrowserFiles Include="PdfBrowserStub/bin/$(Configuration)/net9.0/*" />
<PdfBrowserFiles Include="$(PdfBrowserStubOutput).*" />
<!-- The Unix apphost is the only fixture file without an extension. -->
<PdfBrowserFiles Include="$(PdfBrowserStubOutput)" Condition="$([System.IO.File]::Exists('$(PdfBrowserStubOutput)'))" />
</ItemGroup>
<Copy SourceFiles="@(PdfBrowserFiles)" DestinationFolder="$(TargetDir)PdfBrowserStub" />
<Copy SourceFiles="@(PdfBrowserFiles)" DestinationFolder="$(TargetDir)PdfBrowserStub" SkipUnchangedFiles="true" />
</Target>
</Project>
@@ -934,6 +934,32 @@ public sealed class ProfileCvControllerTests
Assert.Contains("42", json, StringComparison.OrdinalIgnoreCase);
}
[Theory]
[InlineData("Expérience", "Expe\u0301rience", "## Éducation")]
[InlineData("Γλώσσες", "Γλώσσες", "## Εκπαίδευση")]
[InlineData("Språk", "Languages", "## Utdanning")]
[InlineData("Portfolio – 2026", "Portfolio – 2026", "## Certificates")]
[InlineData("Expérience", "Expérience", "Projets supplémentaires")]
[InlineData("Språk", "Languages", "Utdanning:")]
public async Task Rewrite_preview_replaces_only_the_selected_document_section(string heading, string selected, string nextHeading)
{
var source = $"## {heading}\r\n\r\nTravail en équipe\r\nOriginal work.\r\n{nextHeading}\r\nKeep this content.";
var user = new ApplicationUser { Id = "user-1", ProfileCvText = source };
var users = CreateUserManager();
users.Setup(x => x.GetUserAsync(It.IsAny<ClaimsPrincipal>())).ReturnsAsync(user);
var ai = new Mock<ISummarizerService>();
ai.Setup(x => x.SummarizeSectionAsync(It.IsAny<string>(), It.IsAny<string>(), 900, 180))
.ReturnsAsync("Updated work.");
await using var db = CreateDb();
var controller = CreateController(users.Object, ai.Object, db, CreatePaths());
var action = await controller.BuildRewritePreview(new ProfileCvController.RewriteSectionRequest { SectionName = selected });
var preview = Assert.IsType<ProfileCvPreviewDto>(Assert.IsType<OkObjectResult>(action.Result).Value);
Assert.Equal($"## {heading}\nUpdated work.\n\n{nextHeading}\nKeep this content.", preview.FullText.ReplaceLineEndings("\n"));
ai.Verify(x => x.SummarizeSectionAsync(It.IsAny<string>(), It.Is<string>(text => text.Contains("Original work.") && !text.Contains("Keep this content.")), 900, 180), Times.Once);
Assert.Equal(source, user.ProfileCvText);
}
[Fact]
public async Task Parse_returns_structured_cv_and_persists_it()
{
@@ -149,56 +149,6 @@ public sealed class SavedJobSearchSqliteTests(ITestOutputHelper output)
fixture.Discovery.VerifyNoOtherCalls();
}
[Theory]
[InlineData("Soins de proximité", "aide-soignant·e", "Orle\u0301ans / Orléans, Centre-Val de Loire")]
[InlineData("Opieka bez lokalizacji", "pielęgniarka", "")]
public async Task Temporary_search_keeps_legacy_filters_and_dismissal_history(string name, string query, string location)
{
await using var fixture = await SqliteFixture.CreateAsync();
var firstSeen = new DateTimeOffset(2025, 3, 3, 8, 0, 0, TimeSpan.Zero);
var previousRun = firstSeen.AddDays(1);
var legacy = new SavedJobSearch
{
OwnerUserId = "owner-1", Name = name, Query = query, Location = location,
CreatedAtUtc = firstSeen, UpdatedAtUtc = previousRun, LastRunAtUtc = previousRun,
Results = [new SavedJobSearchResult
{
ExternalJobId = "historical-nav-id", FirstSeenAtUtc = firstSeen,
LastSeenAtUtc = previousRun, IsDismissed = true
}]
};
fixture.Db.SavedJobSearches.Add(legacy);
await fixture.Db.SaveChangesAsync();
fixture.Db.ChangeTracker.Clear();
fixture.Discovery.Setup(x => x.SearchAsync("lærer", "Tønsberg", It.IsAny<CancellationToken>()))
.ReturnsAsync(Array.Empty<DiscoveredJob>());
fixture.Discovery.Setup(x => x.SearchAsync(query, location, It.IsAny<CancellationToken>()))
.ReturnsAsync(new[] { Job("historical-nav-id") });
Assert.IsType<OkObjectResult>((await fixture.Controller.Search("lærer", "Tønsberg", default)).Result);
var original = Assert.Single(await List(fixture.Controller));
Assert.Equal(new JobDiscoveryController.SavedSearchDto(legacy.Id, name, query, location, true, previousRun, 1, 1), original);
var run = Assert.IsType<JobDiscoveryController.SavedSearchRunDto>(Assert.IsType<OkObjectResult>(
(await fixture.Controller.RunSavedSearch(legacy.Id, default)).Result).Value);
var seen = Assert.Single(run.Jobs);
Assert.False(seen.IsNew);
Assert.True(seen.IsDismissed);
fixture.Db.ChangeTracker.Clear();
var retained = Assert.Single(await List(fixture.Controller));
Assert.True(retained.LastRunAtUtc > previousRun);
Assert.Equal(original with { LastRunAtUtc = retained.LastRunAtUtc }, retained);
var history = await fixture.Db.SavedJobSearchResults.AsNoTracking().SingleAsync();
Assert.Equal(legacy.Id, history.SavedJobSearchId);
Assert.Equal("historical-nav-id", history.ExternalJobId);
Assert.Equal(firstSeen, history.FirstSeenAtUtc);
Assert.Equal(retained.LastRunAtUtc, history.LastSeenAtUtc);
Assert.True(history.IsDismissed);
fixture.Discovery.Verify(x => x.SearchAsync("lærer", "Tønsberg", It.IsAny<CancellationToken>()), Times.Once);
fixture.Discovery.Verify(x => x.SearchAsync(query, location, It.IsAny<CancellationToken>()), Times.Once);
fixture.Discovery.VerifyNoOtherCalls();
}
[Theory]
[InlineData("name-empty")]
[InlineData("name-long")]
@@ -30,6 +30,17 @@ public sealed class SubmittedApplicationPackageTests
Assert.Equal("exact submitted bytes", await File.ReadAllTextAsync(destination));
Assert.Equal("32283fd0838392ef9d8c707f521096966432939d5d83624bbfce150cde3ce26c", result.Sha256);
await File.WriteAllTextAsync(source, "a later draft");
await Assert.ThrowsAsync<IOException>(() => storage.SnapshotAsync(source, destination, default));
Assert.Equal("exact submitted bytes", await File.ReadAllTextAsync(destination));
var next = storage.CreatePackagePath(7, 2, "source.txt");
await Assert.ThrowsAnyAsync<OperationCanceledException>(() =>
storage.SnapshotAsync(source, next, new CancellationToken(canceled: true)));
Assert.False(File.Exists(next));
await storage.SnapshotAsync(source, next, default);
Assert.Equal("a later draft", await File.ReadAllTextAsync(next));
}
finally
{
+42 -2
View File
@@ -18,10 +18,11 @@ using Microsoft.Data.Sqlite;
using JobTrackerApi.Data;
using Moq;
using Xunit;
using Xunit.Abstractions;
namespace JobTrackerApi.Tests;
public sealed class UsersControllerTests
public sealed class UsersControllerTests(ITestOutputHelper output)
{
[Fact]
public async Task SetRoles_rejects_removing_the_final_administrator()
@@ -171,11 +172,26 @@ public sealed class UsersControllerTests
db.Roles.AddRange(adminRole, memberRole);
var usersToAdd = Enumerable.Range(1, 75).Select(index => User(index == 1 ? "admin-1" : $"user-{index}")).ToList();
usersToAdd[0].TwoFactorEnabled = true;
usersToAdd[0].FirstName = "Åse";
usersToAdd[0].LastName = "Nordlys";
usersToAdd[0].DisplayName = "Reviewed administrator";
usersToAdd[0].GoogleEmail = "linked@example.test";
usersToAdd[0].GoogleLinkedAt = DateTimeOffset.Parse("2026-11-18T10:00:00Z");
usersToAdd[0].EmailConfirmed = true;
foreach (var user in usersToAdd)
{
user.ProfileCvText = new string('c', 65_536);
user.ProfileCvStructureJson = new string('j', 65_536);
user.AvatarImageDataUrl = new string('a', 16_384);
user.PasswordHash = "synthetic-private-password-hash";
user.TotpSecretEncrypted = "synthetic-private-totp";
}
db.Users.AddRange(usersToAdd);
db.UserRoles.Add(new IdentityUserRole<string> { UserId = "admin-1", RoleId = adminRole.Id });
foreach (var user in usersToAdd.Skip(1))
db.UserRoles.Add(new IdentityUserRole<string> { UserId = user.Id, RoleId = memberRole.Id });
await db.SaveChangesAsync();
db.ChangeTracker.Clear();
counter.Reset();
var manager = TestHostFactory.CreateUserManager();
@@ -187,6 +203,28 @@ public sealed class UsersControllerTests
Assert.True(Assert.Single(rows, row => row.Id == "admin-1").TwoFactorEnabled);
Assert.False(Assert.Single(rows, row => row.Id == "user-2").TwoFactorEnabled);
Assert.Equal(2, counter.ReaderCount);
var adminRow = Assert.Single(rows, row => row.Id == "admin-1");
Assert.Equal("Åse", adminRow.FirstName);
Assert.Equal("Nordlys", adminRow.LastName);
Assert.Equal("Reviewed administrator", adminRow.DisplayName);
Assert.Equal("linked@example.test", adminRow.GoogleEmail);
Assert.Equal(usersToAdd[0].GoogleLinkedAt, adminRow.GoogleLinkedAt);
Assert.True(adminRow.EmailConfirmed);
Assert.True(adminRow.IsCurrentUser);
Assert.False(adminRow.CanRemoveAdmin);
Assert.Equal(["Admin"], adminRow.Roles);
Assert.Equal(["Member"], Assert.Single(rows, row => row.Id == "user-2").Roles);
Assert.True(Assert.Single(rows, row => row.Id == "user-2").CanRemoveAdmin);
Assert.Equal(rows.OrderBy(row => row.Email, StringComparer.Ordinal).Select(row => row.Id), rows.Select(row => row.Id));
Assert.Null(Assert.Single(rows, row => row.Id == "user-2").FirstName);
Assert.Empty(db.ChangeTracker.Entries<ApplicationUser>());
var userSql = counter.Commands[0];
var selectedColumns = userSql.Split("FROM", StringSplitOptions.None)[0].Split(',').Length;
output.WriteLine($"User SELECT columns: {selectedColumns}; readers: {counter.ReaderCount}; fixture users:75; large excluded text bytes per user:147456");
output.WriteLine(userSql);
Assert.Equal(10, selectedColumns);
foreach (var excluded in new[] { "ProfileCvText", "ProfileCvStructureJson", "AvatarImageDataUrl", "PasswordHash", "TotpSecretEncrypted", "SecurityStamp", "StripeCustomerId", "DashboardLayoutJson" })
Assert.DoesNotContain(excluded, userSql, StringComparison.Ordinal);
manager.Verify(userManager => userManager.GetRolesAsync(It.IsAny<ApplicationUser>()), Times.Never);
manager.Verify(userManager => userManager.GetUsersInRoleAsync(It.IsAny<string>()), Times.Never);
}
@@ -229,8 +267,9 @@ public sealed class UsersControllerTests
private sealed class CommandCounter : DbCommandInterceptor
{
public int ReaderCount { get; private set; }
public List<string> Commands { get; } = [];
public void Reset() => ReaderCount = 0;
public void Reset() { ReaderCount = 0; Commands.Clear(); }
public override ValueTask<InterceptionResult<DbDataReader>> ReaderExecutingAsync(
DbCommand command,
@@ -239,6 +278,7 @@ public sealed class UsersControllerTests
CancellationToken cancellationToken = default)
{
ReaderCount++;
Commands.Add(command.CommandText);
return base.ReaderExecutingAsync(command, eventData, result, cancellationToken);
}
}
@@ -538,7 +538,9 @@ Canonical profile:
{
// Both filters depend on rule evaluation and workflow signals that include normalized
// note content, so evaluate before pagination to keep totals/pages correct.
var latestMessages = await LoadLatestMessagesAsync(_db.Correspondences.AsNoTracking());
var candidateIds = query.Select(j => j.Id);
var latestMessages = await LoadLatestMessagesAsync(_db.Correspondences.AsNoTracking()
.Where(message => candidateIds.Contains(message.JobApplicationId)));
var pre = await query.ToListAsync(cancellationToken);
var filtered = new List<JobApplication>();
foreach (var j in pre)
@@ -581,6 +581,9 @@ public sealed partial class ProfileCvController : ControllerBase
: string.Join("\n\n", structuredCv.Sections.Select(section => $"## {section.Name}\n{section.Content}"));
}
if (sourceText is not null && FindRewriteSection(sourceText, sectionName) is { } range)
return sourceText[range.Start..range.End].Trim();
var matchingSection = structuredCv.Sections.FirstOrDefault(section => string.Equals(section.Name, sectionName, StringComparison.OrdinalIgnoreCase));
if (matchingSection is not null && !string.IsNullOrWhiteSpace(matchingSection.Content))
{
@@ -618,6 +621,33 @@ public sealed partial class ProfileCvController : ControllerBase
return null;
}
private static readonly Regex RewriteHeading = new(
@"^(?:(?<marker>#{1,2})[ \t]+(?<name>[^\r\n]+?)|(?<name>[\p{Lu}\p{Lt}][\p{L}\p{M} &/]+?))(?<colon>:)?[ \t]*\r?$",
RegexOptions.Multiline | RegexOptions.CultureInvariant);
private static (int Start, int End, string Name)? FindRewriteSection(string text, string sectionName)
{
var target = NormalizeRewriteSectionName(sectionName.Normalize());
foreach (Match heading in RewriteHeading.Matches(text))
{
var name = heading.Groups["name"].Value.Trim();
if (!string.Equals(NormalizeRewriteSectionName(name.Normalize()), target, StringComparison.OrdinalIgnoreCase))
continue;
var next = heading.NextMatch();
if (heading.Groups["marker"].Success && next.Success &&
!next.Groups["marker"].Success && !next.Groups["colon"].Success &&
!SectionAliases.ContainsKey(next.Groups["name"].Value.Trim()))
{
// The first unmarked line may be prose. Preserve later legacy headings even without a blank separator.
var bodyStart = heading.Index + heading.Length;
if (text.AsSpan(bodyStart, next.Index - bodyStart).Trim().IsEmpty)
next = next.NextMatch();
}
return (heading.Index, next.Success ? next.Index : text.Length, name);
}
return null;
}
private static string ReplaceOrAppendCvSection(string source, string sectionName, string sectionDraft)
{
var trimmedSource = (source ?? string.Empty).Trim();
@@ -625,20 +655,14 @@ public sealed partial class ProfileCvController : ControllerBase
if (string.IsNullOrWhiteSpace(trimmedDraft)) return trimmedSource;
if (string.IsNullOrWhiteSpace(trimmedSource)) return $"## {sectionName}\n{trimmedDraft}";
var normalizedHeading = sectionName.Trim().ToLowerInvariant();
var headingPattern = new Regex(@"^(##\s+|#\s+)?(?<name>[A-Z][A-Za-z &/]+):?\s*$", RegexOptions.Multiline);
var matches = headingPattern.Matches(trimmedSource).ToList();
var targetIndex = matches.FindIndex(match => string.Equals(match.Groups["name"].Value.Trim(), normalizedHeading, StringComparison.OrdinalIgnoreCase));
if (targetIndex < 0)
if (FindRewriteSection(trimmedSource, sectionName) is not { } range)
{
return $"{trimmedSource}\n\n## {sectionName}\n{trimmedDraft}".Trim();
}
var start = matches[targetIndex].Index;
var end = targetIndex + 1 < matches.Count ? matches[targetIndex + 1].Index : trimmedSource.Length;
var before = trimmedSource[..start].TrimEnd();
var after = trimmedSource[end..].TrimStart();
return string.Join("\n\n", new[] { before, $"## {sectionName}\n{trimmedDraft}", after }.Where(part => !string.IsNullOrWhiteSpace(part))).Trim();
var before = trimmedSource[..range.Start].TrimEnd();
var after = trimmedSource[range.End..].TrimStart();
return string.Join("\n\n", new[] { before, $"## {range.Name}\n{trimmedDraft}", after }.Where(part => !string.IsNullOrWhiteSpace(part))).Trim();
}
private static IReadOnlyList<CvTemplateDescriptor> GetCvTemplateDescriptors()
@@ -55,6 +55,19 @@ public sealed class UsersController : ControllerBase
{
var users = await _db.Users.AsNoTracking()
.OrderBy(user => user.Email)
.Select(user => new ApplicationUser
{
Id = user.Id,
Email = user.Email,
UserName = user.UserName,
FirstName = user.FirstName,
LastName = user.LastName,
DisplayName = user.DisplayName,
EmailConfirmed = user.EmailConfirmed,
TwoFactorEnabled = user.TwoFactorEnabled,
GoogleEmail = user.GoogleEmail,
GoogleLinkedAt = user.GoogleLinkedAt
})
.ToListAsync(cancellationToken);
var roleRows = await (
from userRole in _db.UserRoles.AsNoTracking()
+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()
@@ -388,7 +388,7 @@ public sealed class ApplicationChecklistService : IApplicationChecklistService
await _db.SaveChangesAsync(ct);
return items;
}
catch (DbUpdateException)
catch (DbUpdateException ex) when (IsDuplicateSystemKey(ex))
{
foreach (var item in seeded) _db.Entry(item).State = EntityState.Detached;
@@ -401,6 +401,17 @@ public sealed class ApplicationChecklistService : IApplicationChecklistService
}
}
private static bool IsDuplicateSystemKey(DbUpdateException exception) => exception.InnerException switch
{
Microsoft.Data.Sqlite.SqliteException sqlite => sqlite.SqliteErrorCode == 19
&& sqlite.SqliteExtendedErrorCode == 2067
&& sqlite.Message.EndsWith("UNIQUE constraint failed: ApplicationChecklistItems.JobApplicationId, ApplicationChecklistItems.SystemKey'.", StringComparison.Ordinal),
MySqlConnector.MySqlException mysql => mysql.Number == 1062
&& (mysql.Message.EndsWith("for key 'IX_ApplicationChecklistItems_JobApplicationId_SystemKey'", StringComparison.Ordinal)
|| mysql.Message.EndsWith("for key 'ApplicationChecklistItems.IX_ApplicationChecklistItems_JobApplicationId_SystemKey'", StringComparison.Ordinal)),
_ => false,
};
private async Task SyncAutoCompletionAsync(List<ApplicationChecklistItem> items, ChecklistSignals signals, CancellationToken ct)
{
var changed = false;
+3 -1
View File
@@ -92,10 +92,12 @@ public sealed class AttachmentStorage : IAttachmentStorage
var destination = EnsureManagedPath(destinationPath, allowMissingLeaf: true);
if (File.Exists(destination)) throw new IOException("A submitted package file already exists at the destination.");
var created = false;
try
{
await using var input = new FileStream(source, FileMode.Open, FileAccess.Read, FileShare.Read);
await using var output = new FileStream(destination, FileMode.CreateNew, FileAccess.Write, FileShare.None);
created = true;
using var hash = System.Security.Cryptography.IncrementalHash.CreateHash(System.Security.Cryptography.HashAlgorithmName.SHA256);
var buffer = new byte[81920];
int read;
@@ -111,7 +113,7 @@ public sealed class AttachmentStorage : IAttachmentStorage
}
catch
{
if (File.Exists(destination)) File.Delete(destination);
if (created) File.Delete(destination);
throw;
}
}
+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:
@@ -13,3 +13,9 @@ The first build could not execute tests because C: was full. Only this run's fre
Remaining investigation:concurrent Career Profile changes during render may require their own snapshot binding. AttachmentStorage.SnapshotAsync has a separate source-backed destination-ownership cleanup concern; no deterministic race reproduction or fix is claimed here. MariaDB, actual HTTP/browser capture, real models/providers, native device/AT, physical PDF acceptance, integrated security and recovery were not rerun. Existing accepted PDF metrics/visuals remain source-bound.
Rollback:revert the source commit, rebuild on the isolated development branch and rerun the affected suite. No migration/data repair is involved. UI callers retain the existing revision-conflict/review flow; an aborted capture publishes no package. This does not establish atomic consistency across every package source entity or filesystem race.
## Submitted attachment cleanup ownership
On 19 November, review of `AttachmentStorage.SnapshotAsync` found that its exception path treated the presence of a file as permission to delete it. The destination may already have been claimed by another writer. The snapshotter now records success of its own exclusive `FileMode.CreateNew` open. Only that invocation's partial destination is eligible for cleanup. The existing early duplicate rejection and error message are preserved.
The storage lifecycle test uses real files under a disposable fixture root. It verifies the captured bytes and hash, a refused duplicate following a change to the source, preservation of the first capture, cancellation cleanup and a successful retry into the second destination. All 29 selected submitted-package, attachment consistency and attachment-controller tests passed on the dedicated Release build. The package service still records a path for outer rollback only after a successful snapshot. No customer data, migration or exporter was involved. There was no forced two-writer interleaving or live store rehearsal.
+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.
File diff suppressed because it is too large Load Diff
@@ -1,56 +0,0 @@
# Offline European geography contract QA
17 November 2026. Bounded documentation/tooling increment authorised by the current direct roadmap continuation. This is executable specification QA, not GJ-01/GJ-02 implementation or acceptance. No application imports, dependencies, settings, migrations, HTTP requests, provider/model calls or qualification statuses change.
19 November: the [multi-country extension](GEOGRAPHY_MULTI_COUNTRY_QA.md) adds BE/FR and DE/PL fixtures, expansion and locale-change invariants. The outcomes below retain the original `48861bca` checkpoint; use the extension for current validator counts.
## Inputs and identity
Application baseline: `eb2538772e1bfabbeb291e4a5efa177c79074de1` (A3). Isolated branch `codex/global-geo-contracts`; worktree `E:/Storage/Projects/Active/temp docs/jobjakt-local-build/global-geo-contracts`.
The validator reads committed Git blobs directly. It does not copy a country registry, inspect another checkout's uncommitted data or require the I18N worktree to remain present. Required commits must exist locally; missing objects fail execution rather than falling back to stale checkout files. It performs no fetch.
| Source commit | Repository path | Exact Git blob |
| --- | --- | --- |
| `39fb9df06904e44916e258da0ed975dd46b9691c` | `docs/i18n/00/EUROPE_COUNTRY_LANGUAGE_MATRIX.md` | `4b88eb52e91d1c1ad0bb9082ed3ce075e0602dbd` |
| `39fb9df06904e44916e258da0ed975dd46b9691c` | `docs/i18n/00/EUROPE_RELEASE_COVERAGE.csv` | `395fc09934a516a2445fddb092b5de18c9469080` |
| `0ec9f98e6ed4a646fc5e017d8eb6fade07653f37` | `docs/global-jobs/00/GEOGRAPHY_DECISIONS.md` | `48f108ef02648f53490ae505b223ebff321264bb` |
The I18N source commit was inspected in the existing `i18n-message-census` worktree. Both matrix/CSV blob identities also match A3 exactly. All inputs are available in this local repository object store. The GJ planning documents remain on their separate planning history; they are not merged or replaced here. The geography decision blob is bound for traceability; its prose semantics were reviewed by a human-readable source inspection, not automatically interpreted by the script.
Authority: Prompt 7 and the GJ pack retain predecessor/initiative gates; GJ-00 geography decisions define branch refinement and typed relationships. The later EUROPE-READY owner addendum §§4/14 requires country/refinement contract tests and §15 preserves shared owners and gates. Existing `docs/i18n/00/IMPLEMENTATION_PLAN.md` permits future fixture design without inventing dependent runtime. Current direct instruction narrows this increment to offline documentation contracts. It does not authorise a runtime scope compiler.
## What runs
From the repository root, using installed Node and Git only:
```text
rtk proxy node docs/global-jobs/00/validate-contracts.cjs --self-test
rtk proxy node --check docs/global-jobs/00/validate-contracts.cjs
rtk git diff --check
```
The first command checks the matrix's exact 59-code roster and 1,062 coverage cells (18 columns per country); validates status vocabulary and the frozen qualification snapshot, including the sole existing Norway NAV fixture result; and checks XK's explicit non-ISO caveat. Updating any status requires a separately reviewed source/evidence change and validator update. This snapshot guard is not a general release approval engine.
`GEOGRAPHY_CONTRACT_FIXTURES.json` contains 13 deliberately synthetic typed identities, seven typed edges and 12 selection expectation cases. Every ID uses the `s:` namespace, edition `synthetic-1`, and explicit synthetic provenance. Display labels resemble representative locations, but neither the IDs nor edges are authoritative geographic data or a licensed boundary dataset. Administrative reachability is used only to check fixture expectations; settlement intersection and shared footprint cannot substitute for administrative containment. No query plan is emitted and no function is exported for application use.
Cases cover whole Warwickshire, one/two towns, removing refinements, independent Bergen OR, Vestfold/Tønsberg, distinct Oslo identities, Stockholm municipality versus settlement and parent/country removal. Query/tree/map are declared expected scope lists whose consistency is checked; no UI, query service or map is exercised. Four preference examples cover EN/NO→GB, NB→SE, PL→DE and FR→BE+FR as separate residence/UI/ad/document-language fields. One explicit country-change fixture preserves unrelated preferences and a saved-search sentinel, removes only incompatible branches and requires an explanation. JSON roundtrip checks apply to these fixtures only, not server persistence.
## Validation outcome
Executed with Node `v24.19.0`:
- PASS: 59 country rows / 1,062 coverage cells; 13 nodes, 12 selection cases, four preference examples and one country-change expectation.
- PASS: 22 negative mutations rejected. They cover false release claims, missing/duplicate/invented countries, invalid status, crediting the NAV fixture to GB, typed identity/edition/provenance errors, invented geometry, cross-country edges, unresolved scopes, invalid refinements, broad-parent leakage, map divergence, language/saved-search resets, invisible filters, missing explanations, settlement overlap treated as containment, administrative cycles and invalid journey country.
- PASS: Node syntax check and staged Git diff whitespace check (exit 0 each).
- RED evidence: before implementation, the permissive validator failed the negative suite with `Missing expected exception: must reject false release coverage` (exit 1). First implemented run then caught the real CSV's NO/SE/GB administrative hierarchy `AWAITING REVIEW` nuance; the corrected frozen-snapshot guard preserves that existing status.
The 22 mutations are checks of the validator, not 22 additional product tests. The counts above describe one successful final contract run; intermediate reruns are not added. Syntax/diff verification is recorded separately from product tests.
Required `rtk proxy graphify update .` completed exit 0 with 19,842 nodes / 48,008 edges, explicitly AST-only/no LLM. It retained warnings for unavailable PDF/SQL extractors and 146 code files yielding no symbols. Generated `graphify-out/` is local/untracked and excluded from this documentation commit; graph counts are structural orientation, not acceptance tests.
## Gates and limits
All 59 entries remain candidate scope with their existing statuses. Real geography licences, exact dataset epochs/IDs/geometry, provider rights, live operation, map attribution/privacy, native-language/device/AT evidence and release approval remain open. Phase 10 D02/frozen-candidate acceptance, Product Review, GJ implementation authority and sequential accepted stages are unchanged. No precise town/radius, accessible tree, map switching, server preference persistence or country-specific provider behavior is qualified by these checks.
The existing NAV municipality substring limitation remains assigned to GJ geography work; this increment does not establish or repair a separate Norway regression. No main merge, orchestrator action, push or deployment occurs. Application builds/browser/backend/hosted/provider/model suites were intentionally not run for documentation-only tooling.
@@ -1,62 +0,0 @@
# Multi-country geography specification QA
19 November 2026. Extends the accepted offline contract checkpoint `48861bca706637fdb217e0e834e67fe052113195` on `codex/global-geo-contracts`. Application baseline remains `eb2538772e1bfabbeb291e4a5efa177c79074de1`; no application source is modified or claimed current by these checks.
## Eligible gap and gates
The current central TODO still gates GJ-01 on Phase 10 D02, Product Review and initiative approval. GJ-02 runtime geography, licensed datasets, providers/maps, locale rollout and release approval remain separate. The existing 59-country coverage snapshot retains every status. Current owner scope permits useful offline specification qualification only.
The earlier corpus had GB/NO cross-border scope but no BE/FR or DE/PL location-selection examples; its DE/FR reference nodes were unused. Its four preference examples checked field shapes, while only one country-change expectation was validated and no locale-change expectation preserved canonical selection. This increment extends that same corpus and small validator; it creates no second country/locale registry or runtime compiler.
## Added contracts
- BE/FR independent city branches and DE/PL independent city branches combine as OR using distinct country/type IDs.
- Expanding the BE/FR tree has exactly the same declared countries, branches and query/tree/map scopes as the collapsed counterpart.
- Two intentionally fictional locations called `Synthetic Riverside` in different countries retain distinct identifiers and both effective scopes. Labels cannot merge them.
- Removing FR from a temporary BE/FR query or DE from DE/PL removes only the incompatible branch and explains the change. It preserves residence, UI/ad/document languages and the separate named saved-search definition.
- A declared FR→NL UI-locale change preserves countries, canonical branch IDs, residence, ad/document languages and the literal named saved search.
All added identities/relations remain under synthetic namespace `s:`, edition `synthetic-1`, provenance `synthetic-no-boundary-claim`. Familiar labels do not establish real administrative containment, legal language status, licensed data/geometry or precise settlement coverage. The equal-name locations are deliberately fictional. The locale example does not activate or qualify French/Dutch UI catalogues.
## Evidence
Original validator plus the new negative controls **FAILED**: `Missing expected exception: must reject BE FR retains an incompatible filter`. This proved that the additional country-change declarations were not being checked, rather than merely counting more positive fixtures.
The final `rtk proxy node docs/global-jobs/00/validate-contracts.cjs --self-test` **PASSED**:
| Check | Final count |
| --- | ---: |
| Existing candidate rows / frozen status cells | 59 / 1,062 |
| Synthetic nodes / typed edges | 21 / 13 |
| Selection expectation cases | 16 |
| Existing preference examples | 4 |
| Country-change / locale-change expectations | 3 / 1 |
| Rejected negative mutations | 30 |
The original 22 mutations are included in 30, not additional product tests. Eight new controls reject hidden removed-country filters, compatible-branch loss, absent explanation, rewritten saved definitions, locale-driven country/document changes, expansion broadening and same-label scope merging. These validate specification consistency; no browser, API, persistence, map or query-engine behavior is exercised.
Node syntax and Git source whitespace checks passed. Native red/green output and source/artifact hashes are under [evidence/multi-country](evidence/multi-country/SOURCE_RECEIPTS.json). The country matrix/CSV/geography decision Git bindings remain exactly those in the [original report](GEOGRAPHY_CONTRACT_QA.md); no refresh of external licensing/provider evidence is implied.
AST-only `graphify update . --no-cluster` completed exit 0: 19,848 nodes / 49,194 edges. Missing PDF/SQL extractors and 146 inputs yielding no symbols remain graph limitations. Generated graph files stay local/untracked; no semantic/LLM graph pass was run.
No application tests/build/browser, real geographic datasets, provider/model/translation service or human/native-language/device qualification was run. No central roadmap edit, runtime feature, qualification-status promotion, main merge or production deployment. Only normal development-branch Git publication is authorised.
## 20 November 2026 · existing saved-search compatibility
GJ-00 ADR-07 requires future migration to retain the original keyword, unresolved free-text location, search identity and dismissal/first-seen history. EUROPE-READY §§2 and 11 also require temporary geography changes to preserve named searches. The 19 November specification run above could establish neither database readback nor what the current discovery runner actually receives.
Two cases in `SavedJobSearchSqliteTests.Temporary_search_keeps_legacy_filters_and_dismissal_history` seed existing rows and historical dismissed results in SQLite, clear EF tracking, run a different ad hoc search and reload the named search. One stored value contains composed and decomposed accents with punctuation. The other has a Polish occupation keyword and an empty location. The strict discovery stub checks the original arguments on manual rerun. The final database read verifies the original search ID, name, filters, active state, bare external ID, original first-seen instant and dismissal. A repeated result updates last-seen and last-run and remains previously seen.
The test baseline was `6da2e79a8a8d5e77bf5d6d1acf12a762e1ae138a`. The saved-search entity, discovery controller, runner and pre-existing SQLite tests matched integration `245f2feaa8bee2db8f5da0797b3e33f6ef8b056e` byte for byte. The authoritative ADR blob in planning commit `0ec9f98e` was `dcde56f5435da64ca4ac4e4e1b0b69e29d9c6f2e`.
The locked restore used the local NuGet cache. .NET SDK 9.0.317 built and ran the following selection.
```powershell
dotnet test JobTrackerApi.Tests/JobTrackerApi.Tests.csproj --no-restore --filter 'FullyQualifiedName~SavedJobSearchSqliteTests|FullyQualifiedName~SavedJobSearchAlertTests|FullyQualifiedName~JobDiscoveryControllerTests'
```
**PASSED** 27 cases, including the two new cases. The breakdown was 12 SQLite persistence, 12 existing alert-worker and three existing discovery-controller cases. Failed 0, skipped 0. Local TRX SHA-256 was `933ab479e2d7d7b2b704a8341947673c2c5c5ff90c45cfa80ad8ec4ae128efee`. No provider or model was contacted.
The AST-only Graphify refresh passed with 19,854 nodes and 49,213 edges. SQL extraction remained unavailable and 146 source inputs yielded no symbols. The generated graph stays local.
**NOT RUN** MariaDB, HTTP/browser, real providers, authenticated country/language preference updates, a migration and rollback. Current persisted location is a string. Empty means no location text. Existing rows carry no authority to interpret a string as a canonical place, country or radius. At GJ-06 entry, reuse these legacy cases against approved migration and rollback on MariaDB, alongside owner isolation and result history checks. GJ-01 entry requirements remain open.
@@ -1,72 +0,0 @@
{
"base": "48861bca706637fdb217e0e834e67fe052113195",
"policy": "LF-normalised UTF8 source, exact raw artifact bytes",
"redSource": {
"sha256Lf": "e9976a642147c1760dde193a973c0b6be9af8344e1cb98760218bafef65a696c",
"derivation": "48861bca validator plus exactly the eight new selfTest cases after invalid journey country; current fixture unchanged"
},
"sources": [
{
"file": "docs/global-jobs/00/validate-contracts.cjs",
"sha256Lf": "03963222086071855af9c41c8df77fe9ad9a76952f86f813a42512af9b43e782"
},
{
"file": "docs/global-jobs/00/GEOGRAPHY_CONTRACT_FIXTURES.json",
"sha256Lf": "c6c9f324369195d05410df57d04e9d9c799bd6f3fda453d156973edee5e5b231"
}
],
"artifacts": [
{
"file": "red.log",
"bytes": 1097,
"sha256": "6eaab9962a4f9998d8ae79592529f28f46476e6ea447a46b24439122423d183c"
},
{
"file": "green.json",
"bytes": 277,
"sha256": "fe313355b73dbfea34d66ed91f57b241ce3e1e976a65f4c3d4a7e1eb9972b643"
},
{
"file": "green.stderr.log",
"bytes": 0,
"sha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"
}
],
"node": "v24.19.0",
"results": {
"countries": 59,
"coverageCells": 1062,
"syntheticNodes": 21,
"syntheticScenarios": 16,
"preferenceJourneys": 4,
"countryChangeInvariants": 3,
"localeChangeInvariants": 1,
"qualification": "offline specification consistency only",
"rejectedMutations": 30
},
"limits": [
"Offline specification only",
"No coverage or acceptance promotion",
"External source rights not refreshed"
],
"checks": {
"syntax": {
"command": "rtk proxy node --check docs/global-jobs/00/validate-contracts.cjs",
"exitCode": 0
},
"diff": {
"command": "rtk git diff --check",
"exitCode": 0
},
"sourceArtifactBindings": {
"exitCode": 0
},
"graph": {
"command": "rtk proxy graphify update . --no-cluster",
"exitCode": 0,
"nodes": 19848,
"edges": 49194,
"scope": "AST only; generated graph untracked"
}
}
}
@@ -1,11 +0,0 @@
{
"countries": 59,
"coverageCells": 1062,
"syntheticNodes": 21,
"syntheticScenarios": 16,
"preferenceJourneys": 4,
"countryChangeInvariants": 3,
"localeChangeInvariants": 1,
"qualification": "offline specification consistency only",
"rejectedMutations": 30
}
-192
View File
@@ -1,192 +0,0 @@
// Offline specification QA only; never imported by the application.
const assert = require('node:assert/strict');
const { execFileSync } = require('node:child_process');
const { readFileSync } = require('node:fs');
const path = require('node:path');
const root = path.resolve(__dirname, '../../..');
const git = (...args) => execFileSync('git', args, { cwd: root, encoding: 'utf8', maxBuffer: 4 * 1024 * 1024 });
const load = () => JSON.parse(readFileSync(path.join(__dirname, 'GEOGRAPHY_CONTRACT_FIXTURES.json'), 'utf8'));
function validate(fixture, matrix, coverage) {
assert.equal(fixture.schema, 1);
assert.equal(fixture.purpose, 'offline-specification-only');
assert.equal(fixture.sourceCommit, '39fb9df06904e44916e258da0ed975dd46b9691c');
assert.equal(fixture.baseline, 'eb2538772e1bfabbeb291e4a5efa177c79074de1');
const unique = (values, label) => assert.equal(new Set(values).size, values.length, `duplicate ${label}`);
const sorted = values => [...values].sort();
const codes = [...matrix.matchAll(/^\| [^|]+ \| ([A-Z]{2}) \|/gm)].map(match => match[1]);
assert.equal(codes.length, 59);
unique(codes, 'matrix code');
assert(matrix.includes('XK is a CLDR user-assigned territory code, not ISO 3166-1'));
// This pinned CSV has no quoted fields; fail rather than silently parse a new format.
assert(!coverage.includes('"'), 'CSV format changed; review parser');
const [header, ...lines] = coverage.trim().split(/\r?\n/).map(line => line.split(','));
const columns = 'territoryCode,scopeReview,countrySelectable,administrativeHierarchy,canonicalResolution,mapCountrySwitching,canonicalLocationFilters,providerCoverage,countryAwareResults,multiCountrySavedSearches,marketLanguageOptions,marketCatalogue,currencyAndTimezone,mobile,accessibility,countryTestEvidence,humanApproval,productionAvailability,existingNavFixture'.split(',');
assert.deepEqual(header, columns);
unique(lines.map(row => row[0]), 'coverage code');
assert.deepEqual(sorted(lines.map(row => row[0])), sorted(codes));
const statuses = ['NOT IMPLEMENTED', 'IMPLEMENTED', 'TESTED', 'BLOCKED', 'AWAITING REVIEW', 'ACCEPTED', 'RELEASED'];
for (const row of lines) {
assert.equal(row.length, columns.length);
for (let i = 1; i < row.length; i++) {
assert(statuses.includes(row[i]), `invalid status ${row[0]} ${columns[i]}`);
let expected = 'NOT IMPLEMENTED';
if (['scopeReview', 'humanApproval'].includes(columns[i])) expected = 'AWAITING REVIEW';
if (columns[i] === 'administrativeHierarchy' && ['NO', 'SE', 'GB'].includes(row[0])) expected = 'AWAITING REVIEW';
if (columns[i] === 'productionAvailability' || (columns[i] === 'providerCoverage' && ['NO', 'SE', 'GB'].includes(row[0]))) expected = 'BLOCKED';
if (columns[i] === 'existingNavFixture' && row[0] === 'NO') expected = 'TESTED';
assert.equal(row[i], expected, `unqualified coverage change ${row[0]} ${columns[i]}`);
}
}
const nodes = new Map(fixture.nodes.map(node => [node.id, node]));
unique(fixture.nodes.map(node => node.id), 'node ID');
for (const node of fixture.nodes) {
assert(codes.includes(node.country));
assert(['county', 'municipality', 'town', 'settlement', 'state', 'region'].includes(node.type));
assert(node.id.startsWith(`s:${node.country}:${node.type}:`), 'typed country identity mismatch');
assert.equal(node.edition, 'synthetic-1');
assert.equal(node.provenance, 'synthetic-no-boundary-claim');
assert.equal(typeof node.label, 'string');
assert(node.label.trim());
assert(!('coordinates' in node || 'geometry' in node || 'providerCode' in node), 'unqualified spatial/provider data');
}
unique(fixture.edges.map(edge => JSON.stringify(edge)), 'edge');
for (const edge of fixture.edges) {
assert(nodes.has(edge.child) && nodes.has(edge.parent), 'unresolved edge');
assert.notEqual(edge.child, edge.parent);
assert.equal(nodes.get(edge.child).country, nodes.get(edge.parent).country, 'cross-country edge');
assert(['administrative-parent', 'settlement-intersects', 'same-footprint'].includes(edge.type));
if (edge.type === 'settlement-intersects') assert.equal(nodes.get(edge.child).type, 'settlement');
}
// Reachability checks fixture declarations only; this is not a runtime scope compiler.
function ancestor(child, parent, trail = []) {
assert(!trail.includes(child), 'administrative cycle');
return fixture.edges.filter(edge => edge.type === 'administrative-parent' && edge.child === child)
.some(edge => edge.parent === parent || ancestor(edge.parent, parent, [...trail, child]));
}
for (const node of nodes.keys()) assert(!ancestor(node, node), 'administrative cycle');
function checkBranches(branches, countries) {
unique(countries, 'search country');
assert(countries.every(country => codes.includes(country)));
unique(branches.map(branch => branch.root), 'branch');
for (const branch of branches) {
assert(nodes.has(branch.root), 'unresolved scope');
assert(countries.includes(nodes.get(branch.root).country), 'incompatible country scope');
unique(branch.refinements, 'refinement');
for (const refinement of branch.refinements) {
assert(nodes.has(refinement) && ancestor(refinement, branch.root), 'invalid refinement');
assert.equal(nodes.get(refinement).country, nodes.get(branch.root).country);
}
}
}
unique(fixture.scenarios.map(scenario => scenario.name), 'scenario name');
assert(fixture.scenarios.length >= 12);
for (const scenario of fixture.scenarios) {
checkBranches(scenario.branches, scenario.countries);
assert(scenario.expanded.every(id => nodes.has(id)));
const leaves = scenario.branches.flatMap(branch => branch.refinements.length
? branch.refinements.filter(id => !branch.refinements.some(other => id !== other && ancestor(other, id))) : [branch.root]);
unique(leaves, 'effective scope');
for (const surface of ['query', 'tree', 'map']) {
assert.deepEqual(sorted(scenario.expected[surface]), sorted(leaves), `incorrect ${surface} scope: ${scenario.name}`);
}
if (scenario.equivalentTo) {
const other = fixture.scenarios.find(item => item.name === scenario.equivalentTo);
assert(other && other !== scenario, 'missing equivalent selection');
assert.deepEqual(scenario.countries, other.countries, 'expansion changes search countries');
assert.deepEqual(scenario.branches, other.branches, 'expansion changes selected branches');
assert.deepEqual(scenario.expected, other.expected, 'expansion changes effective scope');
}
assert.deepEqual(JSON.parse(JSON.stringify(scenario)), scenario, 'fixture roundtrip');
}
const countryChanges = [fixture.countryChange, ...fixture.additionalCountryChanges];
for (const change of countryChanges) {
checkBranches(change.beforeBranches, change.beforeCountries);
checkBranches(change.afterBranches, change.afterCountries);
const retained = change.beforeBranches.filter(branch => change.afterCountries.includes(nodes.get(branch.root).country));
assert.deepEqual(change.afterBranches, retained, 'only incompatible filters may clear');
assert.deepEqual(change.cleared, change.beforeBranches.filter(branch => !retained.includes(branch)).map(branch => branch.root));
assert(change.explanation.trim(), 'country change explanation required');
assert.deepEqual(change.after, change.before, 'unrelated preferences/saved search changed');
assert.deepEqual(Object.keys(change.before).sort(), ['adLanguages', 'documentLanguages', 'residence', 'savedSearch', 'uiLocale']);
}
const { uiLocale: previousLocale, ...previousSelection } = fixture.localeChange.before;
const { uiLocale: nextLocale, ...nextSelection } = fixture.localeChange.after;
assert(typeof previousLocale === 'string' && previousLocale.trim());
assert(typeof nextLocale === 'string' && nextLocale.trim());
assert.notEqual(previousLocale, nextLocale, 'fixture must exercise an actual locale change');
checkBranches(previousSelection.branches, previousSelection.countries);
checkBranches(nextSelection.branches, nextSelection.countries);
assert.deepEqual(nextSelection, previousSelection, 'locale change rewrites search or document preferences');
assert.equal(fixture.journeys.length, 4);
for (const journey of fixture.journeys) {
assert(codes.includes(journey.residence));
assert(journey.countries.length && journey.countries.every(country => codes.includes(country)));
unique(journey.countries, 'journey country');
assert.equal(typeof journey.uiLocale, 'string');
assert(journey.adLanguages.length && journey.documentLanguages.length);
assert(journey.adLanguages.every(language => typeof language === 'string'));
assert(journey.documentLanguages.every(language => typeof language === 'string'));
}
return { countries: codes.length, coverageCells: lines.length * (columns.length - 1), syntheticNodes: nodes.size,
syntheticScenarios: fixture.scenarios.length, preferenceJourneys: fixture.journeys.length, countryChangeInvariants: countryChanges.length,
localeChangeInvariants: 1,
qualification: 'offline specification consistency only' };
}
function selfTest(fixture, matrix, coverage) {
const cases = [
['false release coverage', (f, m, c) => [f, m, c.replace('BLOCKED', 'RELEASED')]],
['cross-country edge', f => { f.edges[0].parent = 's:NO:county:vestfold'; }],
['invalid refinement', f => { f.scenarios[1].branches[0].refinements = ['s:NO:municipality:tonsberg']; }],
['unqualified provenance', f => { f.nodes[0].provenance = 'licensed-real-data'; }],
['duplicate country', (f, m, c) => [f, m, c + c.trim().split('\n')[1] + '\n']],
['missing country', (f, m, c) => [f, m, c.trim().split('\n').slice(0, -1).join('\n')]],
['invented country', (f, m, c) => [f, m, c.replace('AD,', 'ZZ,')]],
['invalid status', (f, m, c) => [f, m, c.replace('BLOCKED', 'HEALTHY')]],
['NO fixture credited to GB', (f, m, c) => [f, m, c.replace(/^GB,(.*),NOT IMPLEMENTED$/m, 'GB,$1,TESTED')]],
['wrong type identity', f => { f.nodes[0].type = 'town'; }],
['missing edition', f => { delete f.nodes[0].edition; }],
['invented geometry', f => { f.nodes[0].geometry = {}; }],
['unresolved scope', f => { f.scenarios[0].branches[0].root = 'missing'; }],
['parent incorrectly ORed with town', f => { f.scenarios[1].expected.query.push(f.scenarios[1].branches[0].root); }],
['map divergent from query', f => { f.scenarios[1].expected.map = []; }],
['unrelated language reset', f => { f.countryChange.after.uiLocale = 'nb-NO'; }],
['saved search overwritten', f => { f.countryChange.after.savedSearch = 'rewritten'; }],
['invisible country filter', f => { f.countryChange.afterBranches = f.countryChange.beforeBranches; }],
['silent country clearing', f => { f.countryChange.explanation = ''; }],
['settlement overlap used as containment', f => {
f.scenarios[9].branches[0].refinements = ['s:SE:settlement:stockholm'];
}],
['administrative cycle', f => { f.edges.push({child: f.edges[0].parent, parent: f.edges[0].child, type: 'administrative-parent'}); }],
['invalid journey country', f => { f.journeys[0].countries = ['ZZ']; }],
['BE FR retains an incompatible filter', f => { f.additionalCountryChanges[0].afterBranches = f.additionalCountryChanges[0].beforeBranches; }],
['BE FR drops a compatible branch', f => { f.additionalCountryChanges[0].afterBranches = []; }],
['country change lacks an explanation', f => { f.additionalCountryChanges[1].explanation = ''; }],
['temporary country change rewrites a saved definition', f => { f.additionalCountryChanges[0].after.savedSearch.countries = ['BE']; }],
['locale switch changes country scope', f => { f.localeChange.after.countries = ['BE']; }],
['locale switch changes document language', f => { f.localeChange.after.documentLanguages = ['nl']; }],
['expansion broadens the selected branch', f => {
f.scenarios[13].branches[0].refinements = [];
for (const surface of ['query', 'tree', 'map']) f.scenarios[13].expected[surface] = ['s:BE:region:brussels', 's:FR:town:paris'];
}],
['equal labels merge distinct countries', f => { f.scenarios[15].expected.query.pop(); }],
];
for (const [name, mutate] of cases) {
const candidate = structuredClone(fixture);
const inputs = mutate(candidate, matrix, coverage) || [candidate, matrix, coverage];
assert.throws(() => validate(...inputs), undefined, `must reject ${name}`);
}
return cases.length;
}
const fixture = load();
// Read committed inputs directly; never copy a second register or use another worktree's dirty files.
const bindings = [
[fixture.sourceCommit, 'docs/i18n/00/EUROPE_COUNTRY_LANGUAGE_MATRIX.md', '4b88eb52e91d1c1ad0bb9082ed3ce075e0602dbd'],
[fixture.sourceCommit, 'docs/i18n/00/EUROPE_RELEASE_COVERAGE.csv', '395fc09934a516a2445fddb092b5de18c9469080'],
['0ec9f98e6ed4a646fc5e017d8eb6fade07653f37', 'docs/global-jobs/00/GEOGRAPHY_DECISIONS.md', '48f108ef02648f53490ae505b223ebff321264bb'],
];
for (const [commit, file, blob] of bindings) assert.equal(git('rev-parse', `${commit}:${file}`).trim(), blob, `source binding: ${file}`);
const matrix = git('show', `${fixture.sourceCommit}:docs/i18n/00/EUROPE_COUNTRY_LANGUAGE_MATRIX.md`);
const coverage = git('show', `${fixture.sourceCommit}:docs/i18n/00/EUROPE_RELEASE_COVERAGE.csv`);
const result = validate(fixture, matrix, coverage);
if (process.argv.includes('--self-test')) result.rejectedMutations = selfTest(fixture, matrix, coverage);
console.log(JSON.stringify(result, null, 2));
@@ -0,0 +1,35 @@
# Native MariaDB qualification: statistics and checklist recovery
18November2026. Isolated codex/perf-mariadb-qualification started at1db5f488; analytics41134d8f was cherry-picked asbe984f1b, then the recovered checklist correction was tested alongside it. No startup-script, existing app container, persistent development data, production service or model was changed.
## Actual provider evidence
Docker Desktop's local Linux engine became available after the user started the local app. The existing disposable MariaDB lane was used with its cached pinned12.2.2 manifest, a generated jobtracker-it project, fresh loopback port, tmpfs database,1CPU/768MiB limit and existing generated jt_it schema guard. Exact observed version: **12.2.2-MariaDB-ubu2404**. The fixture initialises the actual startup schema, uses independent TCP contexts and drops only each successfully-created schema. Locked restore used the existing NuGet cache with package sources cleared; no package versions changed or network restore was needed.
| Execution | Result | Meaning |
| --- | --- | --- |
| Original statistics, five new cases |3 expected budget failures /2 passes | Owned results/cancellation remained correct; measured5 commands for250/2500 active rows and4 empty |
| Original checklist, corrected native ordering |1 pass /2 failures | Genuine duplicate recovery succeeds; unrelated FK1452 and username-unique1062 errors were swallowed |
| Optimised statistics and narrowed checklist |8/8 passed,0skips | New actual-provider cases pass; statistics uses3 active/2 empty commands |
| Complete MariaDB persistence project |**98/98 passed,0skips**,169seconds | Includes those8; never add98+8 |
| Ordinary affected checklist project subset |**17/17 passed**,0skips | Includes two new SQLite concurrency cases and15 existing service cases; earlier2-case runs overlap17 |
This supersedes the prior NOT RUN boundary for these specific local MariaDB operations. It does not establish hosted CI, production equivalence, query plans/rows examined, load/p95/throughput, connection-pool tuning, restore/rollback, TLS, physical PDF fidelity or human/device/provider/model acceptance. Statistics' date projection still grows with applied active rows; only the measured roundtrips are reduced. No new cache, schema, migration, controller/DTO or overview change was introduced.
## Checklist defect and minimal correction
The original seed method recovered any DbUpdateException once another request had persisted all missing system keys. Native SQLite reproduced FK787 being swallowed; real MariaDB reproduced FK1452 and an unrelated username-unique1062 being swallowed. The catch now handles only the actual checklist system-key unique constraint. Unknown/foreign-key/concurrency failures propagate through existing error handling. MySQL matching uses the terminal key identity, so a duplicate value containing the checklist index's name cannot impersonate that index. SQLite requires its exact unique column-list suffix and native19/2067 codes. Existing missing-key revalidation and detach-only-this-call's-seeds behaviour remain.
Positive races retain the same15 persisted IDs,14 system items, dismissed/manual user decisions and job revision7. Other pending writes remain tracked after failure. This is bounded recovery correctness, not an unrestricted retry or proof that every network-uncertain write is idempotent.
The first native unrelated-unique proposal hit the genuine checklist constraint before the intended username error. Its corrected test interceptor temporarily detaches only new checklist seeds, flushes the unrelated tracked user first and restores those seeds; real EF/MySqlConnector still produces the error. The final synthetic duplicate value was shortened so MariaDB's diagnostic truncation retains the entire index-name text. Original and corrected negative runs are retained; these verifier changes are not application fixes. Red test-file snapshots were not frozen at execution; original production Git baseline and native failure outputs are retained, rather than claiming complete immutable red test sources.
The historical reminders log contains two distinct observations: expected duplicate-key diagnostics and a separate OperationCanceledException stack in GetReminders. Deterministic duplicate races can return both successful service results despite EF logging. No request correlation proves the cause or harmlessness of the historical cancelled HTTP request, and this package does not claim to fix it.
## Isolation and evidence
After the98-case run, zero jt_it schemas remained. Cleanup verified generated project/service labels, pinned image and tmpfs at /var/lib/mysql with **no persistent mounts**, retained server logs, then removed only the owned mariadb-test service with Compose rm--stop--force. No down/-v was used. Docker reports this tmpfs in HostConfig.Tmpfs rather than Mounts; an initial stricter inspection failed safely before cleanup, then was corrected from the actual fields. The user's three local app containers remained healthy.
Exact source/native gzip/TRX, target identity, cleanup and counts: [receipts](native-mariadb-20261118/evidence/SOURCE_RECEIPTS.json). All data/accounts are synthetic; application credentials and browser traces are excluded. The ordinary test source and API classifier were copied byte-for-byte from the recovered worktree; current source hashes bind both test projects. Adding the ordinary test file after the MariaDB run changes neither the API nor the separate MariaDB assembly, so unchanged native evidence is reused. Source/API/tests have no pending product changes beyond those listed.
AST-only update passed19,974nodes/49,552edges with existing PDF/SQL/symbol-free input warnings; no model processing. Rollback restores the small predicate/count deltas and removes their tests; no data migration or rollback is required. Formal roadmap/security/release gates remain open.
@@ -0,0 +1,43 @@
# 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.
## Subsequent actual-provider qualification
The historical boundaries above describe this original package. The later [native MariaDB qualification](NATIVE_MARIADB_20261118.md) records 98 passing local persistence tests, including the real-provider statistics cases and measured command counts. Hosted/production, query plans and workload performance remain separate.
@@ -12,3 +12,22 @@ The focused SQLite test records and replays the actual SQL aggregate. Each fixtu
**PASSED** 36 selected Release tests with pinned SDK 9.0.317 and no restore. 18 JobQueryParity, 10 ApplicationCalendar, five RulesEngineProspect and three OwnershipGuard cases. The 16 existing parity cases cover ordering, filters, board, ownership and pagination. Two expected pre-fix failures are preserved. [Native red and final test logs](../ui-modernisation/evidence/perf-job-page/)
These counts measure rows returned by the aggregate under a disposable SQLite fixture. MariaDB plan/rows examined, API response time and production performance remain unmeasured. No index, migration or worker configuration changed.
## Filtered readiness and follow-up views
On 19 November the same SQLite regression fixture exposed a separate account-wide read in the derived-filter path. With a Bergen location filter, the old latest-message aggregate returned all 250 or 2,500 owned groups. Only five or 50 applications respectively were candidates for the readiness evaluation. The controller now limits the correspondence aggregate to the existing SQL candidate query before evaluating readiness or follow-up and paging. It uses a database subquery so the application need not send an unbounded list of IDs.
| Owned jobs with correspondence | Aggregate rows before | Aggregate rows after | Matching jobs on first page |
| ---: | ---: | ---: | ---: |
| 250 | 250 | 5 | 5 |
| 2,500 | 2,500 | 50 | 15 |
The test records and replays the actual EF-generated aggregate and compares its IDs with the fixture. Both new assertions failed on baseline `2a212c78`. The ordinary table still returned 15 page-scoped groups and the ordinary board and empty page issued no aggregate. The 38-test affected Release run passed, including table/board parity, ownership and workflow signals. The local native test receipt had SHA-256 `f84ca67a361dbcbca83ae762a02a5a90526a78d0e4ee8a3e1098773f0d29987b`.
Run the pinned .NET 9.0.317 SDK against `JobTrackerApi.Tests/JobTrackerApi.Tests.csproj` with `--no-restore -c Release` and the filter below.
```text
FullyQualifiedName~JobQueryParityTests|FullyQualifiedName~ApplicationCalendar|FullyQualifiedName~RulesEngineProspect|FullyQualifiedName~OwnershipGuard|FullyQualifiedName~JobApplicationsWorkflowSignalsTests
```
The measurements establish returned aggregate rows on these fixtures. Runtime on MariaDB, query plans for unselective searches and end-to-end latency remain open. The rollback unit is the filtered correspondence query change in `ReadJobsAsync`.
+30
View File
@@ -0,0 +1,30 @@
# Admin user-summary SQL projection
18 November 2026. Baseline `63db9c8a`, isolated `codex/perf-mariadb-qualification`. Relevant controller/test source matches A3 `213793c1`; no frontend, route, DTO, schema, role/mutation, package or configuration change.
## Result
The production user list previously loaded all 49 Identity columns, including CV text/structure, avatar data, password hash and encrypted TOTP state, before mapping ten fields into the unchanged summary DTO. EF now selects only those ten required fields. The two-query role batching, global admin count, current-user flag, full list, existing email ordering, null fields and linked-Google timestamp are preserved. Reads remain untracked; create/reset/role/delete and legacy manually-constructed-controller behavior are unchanged.
| Measurement | Before | After |
| --- | ---: | ---: |
| Actual SQLite user SELECT columns | 49 | 10 |
| Actual MariaDB user SELECT columns | Not separately run | 10 |
| Reader commands | 2 | 2 |
| Synthetic users per fixture | 75 | 75 |
Each fixture user has 147,456 ASCII bytes across CV text/structure/avatar fields. Those three fields total **11,059,200 bytes** across the fixture and are now absent from the database result. This is eliminated known fixture content, not a measured wire payload, heap allocation, latency or production workload improvement. The HTTP DTO payload is unchanged. No credentials were returned by the old DTO; no disclosure exploit is claimed. Full Users fetch and role-row growth remain open under PERF11; this change does not constitute pagination.
## Verification
- Original ordinary run: six passed, one failed because the new test compared SQLite BINARY order with culture-sensitive .NET order. The verifier was corrected to ordinal order; no application sorting changed.
- Corrected unchanged-source baseline: six passed, one expected failure, actual SELECT49 rather than10. Native SQL and TRX retain the baseline field list.
- Final affected ordinary subset: **12/12 passed, zero skips**, including seven UsersController tests and existing ownership/current-user checks. The summary case verifies all ten fields, null values, order, 75 rows, arbitrary Member role, current-user/last-admin safety, two queries, no identity role N+1 calls and no tracked partial user entities.
- Actual pinned local **MariaDB12.2.2**: **2/2 passed, zero skips**, separate 75-user one-admin/two-admin fixtures. Actual startup schema, independent generated databases, real EF/Pomelo SELECT10/two commands, returned DTO values, global last-admin state, nulls, ordering and no tracking verified. This targeted run does not extend the earlier98-case result to this new controller source as a full-project run.
- Compilation succeeded. Existing xUnit2012 warning in the earlier checklist native test remains; no warning suppression. No frontend changes require a new frontend build/browser run for this projection; actual HTTP auth and final UI/security acceptance remain separate.
The standard disposable lane used a fresh generated project, loopback port, pinned cached image, tmpfs/no persistent mounts,1CPU/768MiB and existing guarded schema lifecycle. All generated schemas were gone and only the owned test service was removed; user app containers/volumes were not targeted. No production/model/provider/restore execution. Exact source/native result/target/cleanup bindings: [receipts](user-list-projection/evidence/SOURCE_RECEIPTS.json).
Rollback removes only the Select; no data or schema rollback. Plan and preservation scope: [implementation plan](USER_LIST_PROJECTION_PLAN.md). Formal Phase10, Product Review, security, release, human/device and European rollout gates remain open.
Final AST-only graph refresh passed:19,993nodes/49,618edges, including the new native projection test. Existing optional PDF/SQL/symbol-free input warnings retained; no model labeling.
@@ -0,0 +1,15 @@
# User-list projection implementation plan
Existing isolated `codex/perf-mariadb-qualification`, source63db9c8a; relevant API/test baseline equivalent to A3 1ec15429. Owner PERF-01 instructions authorise bounded measured projections while keeping pagination separately open. Sequential root execution: parallel worker quota was unavailable; no competing mutable environment.
Goal: stop loading full CV, avatar, credentials and account integration state for the existing admin summary response. Existing two-query batching is retained. Use EF's ordinary projection into the existing summary inputs; no cache, schema, new DTO, route, package or UI control.
Reach: UsersController.List production context branch; ToDto's ten required user fields; existing UsersControllerTests relational query counter and representative user fixture. Existing legacy/manual-construction branch and all create/role/reset/delete callers retain signatures and semantics. AdminUsersPage remains unchanged and still receives the complete ordered list. This is not completion of PERF11 paging.
Alternatives considered: server pagination would require coordinated DataGrid filtering/sorting/mobile navigation and is larger; restricting fields in SQL immediately removes unnecessary large data while preserving compatibility. Returning fewer DTO fields would break consumers and is rejected.
- [x] Extend existing relational test with large synthetic CV/profile/avatar and credential fields, all summary fields, last-admin/current-user/role assertions, actual selected-column capture and no tracking. Run unchanged application and retain expected projection failure.
- [x] Add only the ten ToDto input fields to the production EF Select. Re-run all UsersControllerTests and relevant existing identity/ownership tests. Measure actual selected fields and excluded synthetic text bytes, without inferring network payload or latency gains.
- [x] Review SQL translation/safety, source-bound evidence, AST refresh, commit and publish; integrate only validated change into A3 and update central TODO/status/checkpoint. Native MariaDB execution remains separate unless run on this exact projection.
Review focus: null summary values; linked Google timestamp; current/last-admin safety and arbitrary role preservation; no extra identity role calls or tracked partial user entities; stable existing email ordering/full result count. Existing tests cover manual fallback and mutation safeguards. Rollback is the Select removal; no data rollback. All formal roadmap/security/release gates remain.
@@ -0,0 +1,28 @@
# Public landing preview measurements
The landing page now reserves the space occupied by its three 1440 × 900 SVG previews while the files are in flight. The dashboard preview begins within the first viewport on desktop and tablet and keeps its default eager load. The two subsequent previews use the browser’s native lazy loading. All three retain their original files, order and translated alternative text.
## Local browser results
Each row covers two cold Chromium 151.0.7922.34 contexts, English/light and Norwegian Bokmål/dark. The probe served the real static exports on loopback with synthetic signed-out authentication responses. It held the SVG response bodies until it could measure their pending layout. The displacement column measures the change in the last preview’s bottom edge in CSS pixels between pending and decoded states. The request and byte columns cover the three previews and the favicon only. The server served these assets uncompressed.
| Viewport | Preview displacement before → after | Initial asset requests before → after | Initial body bytes before → after |
| --- | ---: | ---: | ---: |
| 1440 × 900 | 1,132 → 0 | 4 → 4 | 28,397 → 28,397 |
| 768 × 1024 | 1,346 → 0 | 4 → 4 | 28,397 → 28,397 |
| 390 × 844 | 668 → 0 | 4 → 4 | 28,397 → 28,397 |
| 320 × 568 | 537 → 0 | 4 → 4 | 28,397 → 28,397 |
| 844 × 390 | 1,488 → 0 | 4 → 3 | 28,397 → 18,036 |
All ten comparisons retained the exact settled top, width, height and alternative text of each image. Chromium loaded the 10,361-byte workspace preview on scroll in both landscape-phone samples. Scrolling through the page decoded every image once per sample. In the other eight samples Chromium prefetched the secondary images before scrolling.
Every cold context requested the 1,017-byte SVG favicon. Requests for the ICO, manifest and PWA PNGs totaled zero in this navigation sample. Those assets remain available for other browser and install flows. Browser prefetch distances can vary. Production latency, field Core Web Vitals, other browser engines, physical devices and the future launch design remain open.
## Reproduction and verification
From an installed `job-tracker-ui` checkout, run `node ../docs/performance/landing-previews/measure.mjs <static-export-directory>` for each build. The JSON output includes pending and settled image rectangles, local request paths, response-body sizes and the browser version. The probe checks the document language, successful image decoding, accessible labels and absence of unexpected application requests or errors. The paired receipts are [before](before.json.gz) and [after](after.json.gz).
- Application source baseline `245f2feaa8bee2db8f5da0797b3e33f6ef8b056e`. The baseline export resided at checkout `171e616b`. Git reported an empty `job-tracker-ui` diff between those commits. Baseline index SHA-256 `31dfd9b2d2e7ea7d9e696b5485d24d7b8daf0b1e078e6539e94a04955b8ff1f8`.
- Candidate landing component blob `a73053174690588c5764f09683d5cabb0fe270e8`. Candidate index SHA-256 `8a8c1121f8a54fad47b91348346ca483bc0e4c06bd1211c85de525931a9d46d8`. Both checkouts used lockfile SHA-256 `1f718d8faa55f5e540d3d7886a51dd19b02b916b6cb23a462ae229e388d7ab98`.
- The new regression check caught missing native width and height attributes on the first implementation with MUI Box. The final native images passed. Three suites passed 41 tests covering landing content, language, auth redirect and public auth presentation. Scoped ESLint passed. The ordinary Next 16.4.6 production build passed TypeScript checking and static export.
- PERF-04 and PERF-15 remain partial. Launch image selection and rights, install-specific devices, other app routes and deployed delivery require their own evidence. A revert of this application change restores the previous eager previews and loading geometry.
Binary file not shown.
Binary file not shown.
@@ -0,0 +1,95 @@
// Run from an installed job-tracker-ui checkout. The argument is a built static export.
import assert from 'node:assert/strict';
import { readFile } from 'node:fs/promises';
import { createServer } from 'node:http';
import { createRequire } from 'node:module';
import path from 'node:path';
const { chromium } = createRequire(path.resolve('package.json'))('playwright');
const root = path.resolve(process.argv[2] || 'out');
const previews = ['/mockups/dashboard.svg', '/mockups/pipeline.svg', '/mockups/workspace.svg'];
const tracked = new Set([...previews, '/favicon.svg', '/favicon.ico', '/logo192.png', '/logo512.png', '/manifest.json']);
const mime = { '.html': 'text/html', '.css': 'text/css', '.js': 'application/javascript', '.svg': 'image/svg+xml', '.ico': 'image/x-icon', '.png': 'image/png', '.json': 'application/json' };
const requests = [];
let imageGate;
const server = createServer(async (req, res) => {
try {
const pathname = new URL(req.url, 'http://localhost').pathname;
const file = path.resolve(root, '.' + (pathname === '/' ? '/index.html' : pathname));
if (req.method !== 'GET' || !file.startsWith(root + path.sep)) {
res.writeHead(400).end();
return;
}
const body = await readFile(file);
if (tracked.has(pathname)) requests.push({ path: pathname, bytes: body.length });
if (previews.includes(pathname)) await imageGate;
res.writeHead(200, { 'Content-Type': mime[path.extname(file)] || 'application/octet-stream', 'Cache-Control': 'no-store' });
res.end(body);
} catch {
res.writeHead(404).end();
}
});
await new Promise(resolve => server.listen(0, '127.0.0.1', resolve));
const origin = 'http://127.0.0.1:' + server.address().port;
const browser = await chromium.launch({ channel: 'chromium', args: ['--disable-background-networking'] });
try {
const states = [];
for (const [width, height] of [[1440, 900], [768, 1024], [390, 844], [320, 568], [844, 390]]) {
for (const [lang, theme] of [['en', 'light'], ['nb', 'dark']]) {
const begin = requests.length;
let release;
imageGate = new Promise(resolve => { release = resolve; });
const context = await browser.newContext({ viewport: { width, height }, deviceScaleFactor: 1, colorScheme: theme, serviceWorkers: 'block' });
const page = await context.newPage();
const unexpected = [];
page.on('pageerror', error => unexpected.push(error.message));
await page.addInitScript(({ lang, theme }) => {
localStorage.setItem('uiLanguage', lang);
localStorage.setItem('jobtracker.themeMode', theme);
}, { lang, theme });
await context.route('**/*', route => {
const url = new URL(route.request().url());
const local = ['127.0.0.1', 'localhost'].includes(url.hostname);
if (local && route.request().method() === 'GET' && url.pathname === '/api/auth/me') return route.fulfill({ status: 401, json: {} });
if (local && route.request().method() === 'GET' && url.pathname === '/api/auth/config') {
return route.fulfill({ json: { requireAuth: true, localEnabled: true, allowRegistration: true } });
}
if (origin === url.origin && !url.pathname.startsWith('/api/')) return route.continue();
unexpected.push(url.pathname);
return route.abort();
});
const images = page.locator('main img[src^="/mockups/"]');
const boxes = () => images.evaluateAll(nodes => nodes.map(image => {
const rect = image.getBoundingClientRect();
return { src: image.getAttribute('src'), top: Math.round(rect.top + scrollY), width: Math.round(rect.width), height: Math.round(rect.height), alt: image.alt, naturalWidth: image.naturalWidth, naturalHeight: image.naturalHeight };
}));
await page.goto(origin, { waitUntil: 'domcontentloaded' });
await page.getByRole('heading', { level: 1 }).waitFor();
await images.nth(2).waitFor({ state: 'attached' });
await page.evaluate(() => new Promise(resolve => requestAnimationFrame(() => requestAnimationFrame(resolve))));
const pending = await boxes();
release();
await page.waitForLoadState('networkidle');
const before = await boxes();
const initial = requests.slice(begin);
assert.equal(await page.locator('html').getAttribute('lang'), lang === 'nb' ? 'nb-NO' : 'en');
for (const image of await images.all()) {
await image.scrollIntoViewIfNeeded();
await image.evaluate(element => element.decode());
}
const after = await boxes();
assert.deepEqual(after.map(image => image.src), previews);
assert.ok(after.every(image => image.alt && image.naturalWidth === 1440 && image.naturalHeight === 900));
assert.deepEqual(unexpected, []);
states.push({ width, height, lang, theme, pending, before, after, initial, settled: requests.slice(begin) });
await context.close();
}
}
console.log(JSON.stringify({ browser: browser.version(), states }, null, 2));
} finally {
await browser.close();
server.closeAllConnections();
await new Promise(resolve => server.close(resolve));
}
@@ -0,0 +1,365 @@
{
"baseline": "1db5f488f6138e4f0f33749452b7d9f47658f4b0",
"candidateHead": "be984f1b",
"candidateDelta": "Reviewed ApplicationChecklistService narrow classifier; source hashes below",
"native": [
{
"file": "state.json.gz",
"rawBytes": 263,
"rawSha256": "14a8a012e7af5f731540d6c539187a1b9590536e43fceb97170154a010dae5b6",
"gzipSha256": "081326aef36aec9879e4b51c063ec87151f287a0417e35224fe54b8372604edf"
},
{
"file": "target.json.gz",
"rawBytes": 480,
"rawSha256": "3094a11fbbbad68ca01ca9668438564a29b4142752abeafb0b5afcb755ecb177",
"gzipSha256": "eca5d54bd9672274af0fad1e0005a08722dbfa941fb06a20a771ef42b7484f5c"
},
{
"file": "start.txt.gz",
"rawBytes": 1698,
"rawSha256": "ed8b02e69cda13fa442dac34fc5bf1d046b481cfd77a436c2b001099871667a6",
"gzipSha256": "2bed921ad2d3cc917a6b8360a1cbeea2779e235aa9f25f17dd1219b93710150f"
},
{
"file": "restore.txt.gz",
"rawBytes": 1708,
"rawSha256": "e2e1cd7fe736511fa682d7f6f1d458fa00be57e44bbd3fb12a4e5e9996f93a84",
"gzipSha256": "e47176aab7f430b34dfe9af83cd3fe03b6c43c0639b23f68b27becaa10335225"
},
{
"file": "baseline.txt.gz",
"rawBytes": 18572,
"rawSha256": "0c7ba5b475c16b561c955c3dad149a4ebf15ff6796c31438d963420fa70f93a7",
"gzipSha256": "ddbdfe2febf5c72ff53e7fd60fe0650f4eb340d35a1520e1d382e5bd690b64ed"
},
{
"file": "baseline.trx.gz",
"rawBytes": 26073,
"rawSha256": "76ba28b8d14eac934492ef5d1b9e66ec828015c2e1cea60251fb5db833583121",
"gzipSha256": "06a80722382e3de1c6d1b65fd72eaf1003fbe59116f73edd812e66e5f1112fae"
},
{
"file": "baseline.exit.txt.gz",
"rawBytes": 3,
"rawSha256": "f1b2f662800122bed0ff255693df89c4487fbdcf453d3524a42d4ec20c3d9c04",
"gzipSha256": "baf0683e1103b94b68d94e8a12d7e144b4e0571e9948de7fb0d85103b045460e"
},
{
"file": "checklist-baseline.txt.gz",
"rawBytes": 11890,
"rawSha256": "6f18ee0c89d2671fe77885cf9e6fea6eb217b0b881659aa88661e760d52478c7",
"gzipSha256": "eb4e72dc1dcc4f0b825a223fdbb04030494fd8bdc1018598b56990ed9d18b9b8"
},
{
"file": "checklist-baseline.trx.gz",
"rawBytes": 15303,
"rawSha256": "80a736c8c7f10dd008512a84b85d2ef70fe7781f694e7c4070d278b195b44db3",
"gzipSha256": "949cc22dc48cfde8cb0db7c6c1c660419550f43286c27a985d1a4f1bc3819d5b"
},
{
"file": "checklist-baseline.exit.txt.gz",
"rawBytes": 3,
"rawSha256": "f1b2f662800122bed0ff255693df89c4487fbdcf453d3524a42d4ec20c3d9c04",
"gzipSha256": "baf0683e1103b94b68d94e8a12d7e144b4e0571e9948de7fb0d85103b045460e"
},
{
"file": "checklist-baseline-corrected.txt.gz",
"rawBytes": 11916,
"rawSha256": "0b0ecfa6ea70e76a87991e40c3390513d0040388af1ed880956bf322fcce52a7",
"gzipSha256": "ee4585a14dc3db7ec102a612d5206fda90814d02a47ade651912142a64586347"
},
{
"file": "checklist-baseline-corrected.trx.gz",
"rawBytes": 15307,
"rawSha256": "00948a9f9bbf5ecc0f013e1ef99613248fc57949532d529eab6cd6760fb1b586",
"gzipSha256": "9a8a4f35f256ad58ec336bc33e036f259e005adf0c9b14797fc2ae0acffb2184"
},
{
"file": "checklist-baseline-corrected.exit.txt.gz",
"rawBytes": 3,
"rawSha256": "f1b2f662800122bed0ff255693df89c4487fbdcf453d3524a42d4ec20c3d9c04",
"gzipSha256": "baf0683e1103b94b68d94e8a12d7e144b4e0571e9948de7fb0d85103b045460e"
},
{
"file": "candidate.txt.gz",
"rawBytes": 2868,
"rawSha256": "9fb27fcbb311262987c7358323cc95049a4243d4eb6063c06742218f2cbba51f",
"gzipSha256": "af3b11c6ac1d10339a9ee88e124509a34f3cfa2b455867be4753525d4dd74f56"
},
{
"file": "candidate.trx.gz",
"rawBytes": 19793,
"rawSha256": "765b4c7d01de8d1b2110e7e598d6d3fdb849333bb5135a9a92038110b7639043",
"gzipSha256": "2ffd80b6496310b4ea3260a852008590d92c756ced5d63c4c2d6ef6215464fe5"
},
{
"file": "candidate.exit.txt.gz",
"rawBytes": 3,
"rawSha256": "13bf7b3039c63bf5a50491fa3cfd8eb4e699d1ba1436315aef9cbe5711530354",
"gzipSha256": "7f636460b48b02e48ffda30b26e6cf24cebee6b983bfd77e79a2f7205a71497f"
},
{
"file": "full.txt.gz",
"rawBytes": 1204,
"rawSha256": "cdd7e671c5f3f1d448537268abc8ba21179cf8a0ff285ee876a4da8938266665",
"gzipSha256": "5cb8bc51c0dc2114843da48065dc0655a6822465fd127505f8af3910dd94fc86"
},
{
"file": "full.trx.gz",
"rawBytes": 167700,
"rawSha256": "f132ccbdf646187418f5e98fd2f501ba88ade812e5f12feba485026c0203873d",
"gzipSha256": "1fb3eed294d94ce4d4a173bd7b241ea375134742e655e026fa089dfcffcc6f09"
},
{
"file": "full.exit.txt.gz",
"rawBytes": 3,
"rawSha256": "13bf7b3039c63bf5a50491fa3cfd8eb4e699d1ba1436315aef9cbe5711530354",
"gzipSha256": "7f636460b48b02e48ffda30b26e6cf24cebee6b983bfd77e79a2f7205a71497f"
},
{
"file": "server.txt.gz",
"rawBytes": 6252,
"rawSha256": "49263816a13229f4fad67c3408abd580651a1036bc5fd8baed18a9ed806de695",
"gzipSha256": "b4f5d10e4b0bfb7fbdf2f33b02abb02a8ea6ac2e4e8c7e94bcd68a7659703aca"
},
{
"file": "remaining-schemas.txt.gz",
"rawBytes": 2,
"rawSha256": "9a271f2a916b0b6ee6cecb2426f0b3206ef074578be55d9bc94f6f3fe3ab86aa",
"gzipSha256": "8afc61325213625995e1de8b0d2df70f01b1d5304993484a41cc9df249f00fad"
},
{
"file": "cleanup.txt.gz",
"rawBytes": 408,
"rawSha256": "6f14edd5ae32f306d6d9fe6e0462430dcc52a7f097a718dc2e233b6d2316a0c7",
"gzipSha256": "6c384ac059786a9bdeb8f4310aac50f6c1053e40ed981c4f56adb41028fe73ec"
},
{
"file": "cleanup.exit.txt.gz",
"rawBytes": 3,
"rawSha256": "13bf7b3039c63bf5a50491fa3cfd8eb4e699d1ba1436315aef9cbe5711530354",
"gzipSha256": "7f636460b48b02e48ffda30b26e6cf24cebee6b983bfd77e79a2f7205a71497f"
},
{
"file": "cleanup.py.gz",
"rawBytes": 2509,
"rawSha256": "942ef2644c4d8078f5db05ee2e4227a75e8922433b77dd0f1a791e34cf6b537b",
"gzipSha256": "22ca184e044bf336caebbc3fe0a28d703dcaf0f02080b3693bf9af160ec85f1e"
},
{
"file": "serial.runsettings.gz",
"rawBytes": 147,
"rawSha256": "5a1dc26f49fa2a9874e30aa868ca5de5973449bd5325d23ae1e3e84fcd560fc5",
"gzipSha256": "cf64d8cbc38b1cf9677671e4e1ea6e9d944e3cea6965235b1df73f37536e8006"
},
{
"file": "resources.compose.yml.gz",
"rawBytes": 58,
"rawSha256": "102bff56fc8f487656fecb2aa308f4b79972dbca2c259d7ee931546a206d3b03",
"gzipSha256": "e10009fa468b5f677d955e1151b125efbf746380428ab4aecd9aba14d841d781"
},
{
"file": "NuGet.Config.gz",
"rawBytes": 74,
"rawSha256": "9508cae5f76364f56e80eb97cb16493977243cf38e5cca6284e3d74f83b20a2c",
"gzipSha256": "05db889e8047b1623c559f092197f603f433f4d73b1774ff936736ba488fe087"
},
{
"file": "unit-baseline.stdout.txt.gz",
"rawBytes": 4856,
"rawSha256": "0bbb5b8c9b03be13f83127bc850d86efe3a1d32864611b37d22e79767ec56eec",
"gzipSha256": "f6999c1104c316f34f69fb96a2f8122e453ff154d89a4015e6e9a4240f041206"
},
{
"file": "unit-baseline.stderr.txt.gz",
"rawBytes": 193,
"rawSha256": "142203fabbdb3da84197036c836b727f68b527336a2f5b5dd7ac6d4baeab9e21",
"gzipSha256": "2aa698372ab8697ad475e4a6824a8b226cc486cd31a6f3fd5959f45547a64b8e"
},
{
"file": "unit-baseline.exit.json.gz",
"rawBytes": 478,
"rawSha256": "908fe0dc4832b47d8f80f791afae55e892ae64e6ee1c8da70ebfe95ee46b6955",
"gzipSha256": "eccb1d15d394dcbc636c0930476d2e5a217309bde7a0deb082066df56fb1c458"
},
{
"file": "unit-final.stdout.txt.gz",
"rawBytes": 1634,
"rawSha256": "d74c1aa6cb7d281ecae4aa24fb2eb4fbcf9bfb7f7529552cdf29755a4f871580",
"gzipSha256": "e5c6468347a57a83c4ecdb6a85687f294214ddf226b34b14e7aea9aa9ef460c0"
},
{
"file": "unit-final.exit.json.gz",
"rawBytes": 473,
"rawSha256": "d0e384c114af6e1454f9ce7bd596509c635774e9a32d6dbb07c0ee9387650da8",
"gzipSha256": "f71572b28404d28cf64457bdc55adbf0cb76b5d854683ffb119418a3b1e6d593"
},
{
"file": "unit-qualified-related.stdout.txt.gz",
"rawBytes": 1658,
"rawSha256": "76025529ace3e58eea933eada5957a694af8aa1ef487b3e26dbbb91b2fc21d08",
"gzipSha256": "613acb0ab3cd2d02a9fa93a646374c8b24fc1fcc456765101bd0b79229e0c074"
},
{
"file": "unit-qualified-related.exit.json.gz",
"rawBytes": 497,
"rawSha256": "f9fb6160fd85e2bb0c4151931742847a235df35361865f6bc3b62fe148f78fc7",
"gzipSha256": "5ec423cd4f69b05058ed1c9f9122dfd87d13f1a8c43305e4c96e4746fc0b9220"
},
{
"file": "unit-checklist-all.stdout.txt.gz",
"rawBytes": 3368,
"rawSha256": "527f0a8189d6c04d32b8afad1f182034397e101d9729259a36af87376c7ebecb",
"gzipSha256": "579fab8fa01132747591fcdc15007e29484f755785b9a54641fb25cd8a633b95"
},
{
"file": "unit-checklist-all.exit.json.gz",
"rawBytes": 472,
"rawSha256": "80f0fea9a71d254f6fbf3582f4029447e2399710a93cdc70692f22ce528d713c",
"gzipSha256": "23b9b1bca5c2aa2e9ac1ce26abb33f3844883a9d6b2c7c69106f27e4aa459a72"
},
{
"file": "unit-checklist-all.trx.gz",
"rawBytes": 27089,
"rawSha256": "6ff38bc16958b118cdea606df44f1c69114b79d7f4ff4069c9ef9cfa8b80c99b",
"gzipSha256": "f9e28cc034f78897835ae493485adbcd8d7f95feeb83d4bd5f13eeb9a71dee83"
}
],
"sources": {
"JobTrackerApi/Services/AnalyticsService.cs": "0859ad9202bbaf4de810f8b1bc9946cbed061f69105c02993f079715f59aa2b1",
"JobTrackerApi/Services/ApplicationChecklistService.cs": "0c807ab96cbb4a638d3f5ba62b2608cdfb599751df2de4e3d58b6d599b69b5e8",
"JobTrackerApi.MariaDb.Tests/AnalyticsStatsPersistenceTests.cs": "7b95ba1a69456aaf61aa6fd7825e7f0374756d6997066275b8e48f77910b9e68",
"JobTrackerApi.MariaDb.Tests/ApplicationChecklistPersistenceTests.cs": "4e455291fdc786ed368891cd20c0aec3fac20fe32b84201fbebdbd784ab19bf0",
"JobTrackerApi.MariaDb.Tests/MariaDbDatabase.cs": "1375d97093f686f77d511ef6d81ad2d62ecf329aa6e7bf53036cd6e199035e40",
"JobTrackerApi.MariaDb.Tests/JobTrackerApi.MariaDb.Tests.csproj": "2df22a5b79fae14566b437081932218254eb811c8dc1b2af3d51692d8e0d6825",
"JobTrackerApi.MariaDb.Tests/packages.lock.json": "0389a52bfdf31aac07feac5c2ad2ce6771d9b450c899caf9c53ef7ecace0db49",
"JobTrackerApi/JobTrackerApi.csproj": "50164c5dceafc805cc73018bfcd444428736029f6fdad220e4ff07cf38e116c4",
"JobTrackerApi/packages.lock.json": "f63bbf68503fd46effda290a29551ebacac84d0faf8c367fe28caa11ec404abf",
"JobTrackerApi.Tests/ApplicationChecklistConcurrencyTests.cs": "b8c520e15d7886b501d39367acaa4e08529b0605a8f470242eec09c8ae23f84c",
"JobTrackerApi.Tests/JobTrackerApi.Tests.csproj": "6564ff0044af2ce8c55d557b180c57e16e238395424778878b56eb9e3e082c0d",
"JobTrackerApi.Tests/packages.lock.json": "548f67d1ef3b5a9acfe5fc6124891583b6073ac4b6ca515241330e097152bc4a"
},
"trx": {
"baseline.trx": {
"total": "5",
"executed": "5",
"passed": "2",
"failed": "3",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
},
"checklist-baseline.trx": {
"total": "3",
"executed": "3",
"passed": "1",
"failed": "2",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
},
"checklist-baseline-corrected.trx": {
"total": "3",
"executed": "3",
"passed": "1",
"failed": "2",
"error": "0",
"timeout": "0",
"aborted": "0",
"inconclusive": "0",
"passedButRunAborted": "0",
"notRunnable": "0",
"notExecuted": "0",
"disconnected": "0",
"warning": "0",
"completed": "0",
"inProgress": "0",
"pending": "0"
},
"candidate.trx": {
"total": "8",
"executed": "8",
"passed": "8",
"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"
},
"full.trx": {
"total": "98",
"executed": "98",
"passed": "98",
"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"
},
"unit-checklist-all.trx": {
"total": "17",
"executed": "17",
"passed": "17",
"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"
}
},
"isolation": {
"name": "jobtracker-it-fc0e8c29a256416d8b911f07f80fef8d-mariadb-test-1",
"id": "e4e7603940fdd67f7e24787867036f8436b1fc7320c1c36f6e1d5fdf67a0aac6",
"project": "jobtracker-it-fc0e8c29a256416d8b911f07f80fef8d",
"service": "mariadb-test",
"image": "mariadb:12.2.2@sha256:42a27baaba3e8f3f0159d16381d5a7156661aa91dcc65f663cabb6a6f9503c00",
"tmpfsDatabase": true,
"persistentMounts": [],
"memoryBytes": 805306368,
"cpuNano": 1000000000,
"port": 56408
}
}
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.

Some files were not shown because too many files have changed in this diff Show More