Compare commits

...

17 Commits

Author SHA1 Message Date
cesnimda 63db9c8a34 fix(checklist): recover only system-key duplicate races 2026-11-18 18:53:20 +01:00
cesnimda be984f1b5f perf(analytics): combine stats scalar count queries 2026-11-18 18:28:51 +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
336 changed files with 27752 additions and 411 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,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; }
}
}
+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;
@@ -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.
@@ -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.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
@@ -0,0 +1,21 @@
# PERF-BASE / PERF-12 static encoding measurement
Recorded 17 November, preserved and qualified 18 November 2026. Frozen source `eb2538772e1bfabbeb291e4a5efa177c79074de1`, Node24.19.0 Windows, Next16.4.6 static export, explicit API5302 build. This is an offline content-size/encoding baseline, not an application optimisation, current later-source export, deployed compression test or production readiness. The previous performance baseline used a different application source and is not a controlled before/after comparison.
| Frozen export group | Files | Raw bytes | Gzip6 bytes | Brotli5 bytes |
| --- | ---: | ---: | ---: | ---: |
| JavaScript | 58 | 3,674,509 | 1,089,362 | 1,015,470 |
| CSS | 2 | 3,958 | 1,189 | 1,073 |
| SVG | 4 | 28,397 | 6,971 | 6,404 |
| HTML | 3 | 32,504 | 8,339 | 7,486 |
| Root-declared scripts, deduplicated, including legacy | 7 | 582,094 | 178,820 | 169,211 |
All67 text assets were compressed three times in memory and decompressed with exact byte equality:402 roundtrip assertions passed. Native JSON retains each raw SHA256, encoded sizes and all three elapsed-time samples. Root-declared scripts exclude later dynamic imports; complete export inventory is not a route/network request budget. No source maps were emitted by this frozen build. Headers, TLS, cache state, transfer and on-device decompression are not measured.
The summed per-file median encoding costs were approximately84.9ms gzip6 and180.6ms Brotli5 on this warm-file Windows host. They are exploratory local CPU observations, not a batch-time median or server capacity result. Other development/browser work was active; there was no controlled idle-host/load experiment. These timings justify no production throughput/latency or cost claim. Encoded content sizes are deterministic for the recorded inputs/runtime; no live delivery savings are claimed.
The local desktop-linux Docker endpoint was confirmed to be the local Windows named pipe; a read-only version probe failed because that pipe was absent. No daemon/infrastructure repair, container/image operation or repeated unchanged failure was attempted. Runtime Nginx/static encoding, Accept-Encoding/Vary/cache and private-response boundaries remain unqualified. No gzip/Brotli configuration, CDN, topology, image, API middleware, dependency, file deletion or production change was made.
Next eligible runtime experiment requires an available authorised disposable Nginx/container lane. Compare public immutable assets first; retain HTML revalidation and private API/document isolation, one encoding layer, correct MIME/cache/Vary behavior and exact decode integrity. Brotli module presence and target CPU/storage cost must be proven rather than assumed. Keep PERF-12 PARTIAL and deployed configuration unchanged until that evidence exists. PERF-04 requested-icon and PERF-09 route-chunk concerns retain their own measurements and gates; this census does not qualify either.
[Source, producer and native receipts](evidence/SOURCE_RECEIPTS.json) preserve the exact frozen manifest and assert-bearing Node script without adding a runtime/CI runner. No new backend/MariaDB/browser/provider/model/hosted/native-device or production qualification.
@@ -0,0 +1,33 @@
{
"sourceCommit": "eb2538772e1bfabbeb291e4a5efa177c79074de1",
"sourceGitBlobSha256": {
"job-tracker-ui/package.json": "8b31e44c10b77b6d1e007af04c757c0577f12972ff3f6c7079bbc4c446a0d415",
"job-tracker-ui/package-lock.json": "ac90fbdc79e2e0f23d54748814b41a03f5dcaf8fd27291b3dcb73b2603a83e72",
"job-tracker-ui/next.config.js": "2bbcc9d6093d6f263114f4992fd9c77a6172f0602deb92bf7163823ba58b1757",
"job-tracker-ui/app/layout.tsx": "d2e460998e4182f11657089850f9144059f453ebd9c4d1fbcd3f6aee25449843"
},
"nativeReceipts": [
{
"path": "measure-static-encoding.mjs.txt",
"canonicalSha256": "b700120c790f4ec50f125ade040b82044ccbc79a5d0142885d7a34910762b682",
"rawSha256": "b700120c790f4ec50f125ade040b82044ccbc79a5d0142885d7a34910762b682",
"gzipSha256": "020bb4bc3445a426f8757b9268b8b3b62e1ddbc8d8961d8a35c511840c7cb7d5",
"nativeEncoding": "utf-8-sig"
},
{
"path": "static-encoding.json",
"canonicalSha256": "a5ba46dcad650f8de1bbadcb5f77331ed3f40fc05058f5c79d347471b654a25b",
"rawSha256": "a5ba46dcad650f8de1bbadcb5f77331ed3f40fc05058f5c79d347471b654a25b",
"gzipSha256": "941f8e1bb95196a1c3dd2341623a2f4fd7a79460395afab34562aba14712bcd9",
"nativeEncoding": "utf-8-sig"
},
{
"path": "static-encoding.txt",
"canonicalSha256": "8ae1d675b5874c82ddf4cc0e4a4e7351822f293953ec8338034d3cc3736fefa1",
"rawSha256": "1171e4f98ed0c9eac50f6b1f71c6f643e6e324c4c29aba6ac868e7d7a3717ccd",
"gzipSha256": "5efc6aaf111bfec3478589d5d6d5ced531623a40d41c07408f233b9be84053b7",
"nativeEncoding": "utf-16"
}
],
"scope": "Frozen offline export census/encoding only, not current runtime or deployed transfer"
}
@@ -0,0 +1,34 @@
import fs from 'node:fs';
import path from 'node:path';
import crypto from 'node:crypto';
import os from 'node:os';
import assert from 'node:assert/strict';
import { performance } from 'node:perf_hooks';
import { gzipSync, gunzipSync, brotliCompressSync, brotliDecompressSync, constants } from 'node:zlib';
const [exportPath, output] = process.argv.slice(2);
const root = path.resolve(exportPath);
const sha = bytes => crypto.createHash('sha256').update(bytes).digest('hex');
function walk(dir) { return fs.readdirSync(dir, { withFileTypes: true }).flatMap(e => e.isDirectory() ? walk(path.join(dir, e.name)) : [path.join(dir, e.name)]); }
const entries = walk(root).filter(name => /\.(?:js|css|html|svg)$/.test(name)).sort();
assert.ok(entries.length > 0);
const median = values => [...values].sort((a,b)=>a-b)[Math.floor(values.length/2)];
const files = entries.map(name => {
const raw = fs.readFileSync(name), relative = path.relative(root, name).replaceAll('\\', '/');
const gzipTimes = [], brotliTimes = [];
let gzip, brotli;
for (let repetition=0; repetition<3; repetition++) {
let start = performance.now(); gzip = gzipSync(raw, { level: 6 }); gzipTimes.push(performance.now()-start);
start = performance.now(); brotli = brotliCompressSync(raw, { params: { [constants.BROTLI_PARAM_QUALITY]: 5 } }); brotliTimes.push(performance.now()-start);
assert.deepEqual(gunzipSync(gzip), raw); assert.deepEqual(brotliDecompressSync(brotli), raw);
}
return { path: relative, sha256: sha(raw), rawBytes: raw.length, gzip6Bytes: gzip.length, brotli5Bytes: brotli.length, gzipMilliseconds: gzipTimes, brotliMilliseconds: brotliTimes, gzipMedianMilliseconds: median(gzipTimes), brotliMedianMilliseconds: median(brotliTimes) };
});
const sum = group => ({ files: group.length, rawBytes: group.reduce((n,x)=>n+x.rawBytes,0), gzip6Bytes: group.reduce((n,x)=>n+x.gzip6Bytes,0), brotli5Bytes: group.reduce((n,x)=>n+x.brotli5Bytes,0) });
const html = fs.readFileSync(path.join(root, 'index.html'), 'utf8');
const scriptPaths = [...new Set([...html.matchAll(/<script\b[^>]*\bsrc="([^"]+)"[^>]*>/g)].map(m=>m[1].split('?')[0].replace(/^\//,'')))];
assert.ok(scriptPaths.length > 0);
const indexScripts = files.filter(f=>scriptPaths.includes(f.path));
assert.equal(indexScripts.length, scriptPaths.length);
const report = { source: 'eb2538772e1bfabbeb291e4a5efa177c79074de1', environment: { node: process.version, platform: process.platform, architecture: process.arch, cpu: os.cpus()[0].model }, buildApiBase: 'http://localhost:5302/api', indexSha256: sha(Buffer.from(html)), repetitions: 3, summaries: { javascript: sum(files.filter(x=>x.path.endsWith('.js'))), css: sum(files.filter(x=>x.path.endsWith('.css'))), svg: sum(files.filter(x=>x.path.endsWith('.svg'))), html: sum(files.filter(x=>x.path.endsWith('.html'))), declaredIndexScripts: sum(indexScripts) }, sourceMaps: walk(root).filter(name=>name.endsWith('.map')).length, files, limits: ['Offline warm-file compression cost and content sizes only; excludes HTTP headers/TLS/network', 'No nginx/CDN/API compression configuration or production change', 'Complete export inventory is not a route request budget; root declared scripts exclude later dynamic imports', 'Three local repeats do not establish field latency, server throughput or deployed encoding'] };
fs.writeFileSync(output, JSON.stringify(report, null, 2)+'\n');
console.log(JSON.stringify({ summaries: report.summaries, sourceMaps: report.sourceMaps, verifiedRoundTrips: files.length * 3 * 2 }));
File diff suppressed because it is too large Load Diff
@@ -0,0 +1 @@
{"summaries":{"javascript":{"files":58,"rawBytes":3674509,"gzip6Bytes":1089362,"brotli5Bytes":1015470},"css":{"files":2,"rawBytes":3958,"gzip6Bytes":1189,"brotli5Bytes":1073},"svg":{"files":4,"rawBytes":28397,"gzip6Bytes":6971,"brotli5Bytes":6404},"html":{"files":3,"rawBytes":32504,"gzip6Bytes":8339,"brotli5Bytes":7486},"declaredIndexScripts":{"files":7,"rawBytes":582094,"gzip6Bytes":178820,"brotli5Bytes":169211}},"sourceMaps":0,"verifiedRoundTrips":402}
@@ -0,0 +1,38 @@
# Development dependency triage
Source: exact A3 `eb2538772e1bfabbeb291e4a5efa177c79074de1`, isolated branch `codex/dev-dependency-triage`. This is a bounded npm dependency investigation, not formal integrated security acceptance. The redirect-header qualification and committed audit receipts were read before work.
## Findings and applicability
The fresh full lock-only audit returned **50 package records (7 moderate, 43 high)**, not the historical 49. Those records deduplicate to **three concrete advisories**; other records are npm metavulnerability propagation through Jest and ESLint. They are development tooling in this lock. Attacker-controlled patterns, directory trees, or tooling configuration would be needed to reach these availability failures. A production HTTP exploit, tenant impact, or data disclosure was not demonstrated. Treat tooling that processes untrusted contributions as exposed until independently assessed.
| Advisory | Concrete affected lock entries at baseline | Result |
| --- | --- | --- |
| [Picomatch repeated-extglob ReDoS, high](https://github.com/micromatch/picomatch/pull/194) / GHSA-fc5q-39xc-vjpf | 2.3.2 under anymatch and micromatch; root 4.0.5 | Official registry latest is 4.0.7 and advisory affects <=4.0.7 with no patched release. **OPEN**; upgrading to latest would not qualify a fix. |
| [Minimatch globparts amplification, moderate](https://github.com/isaacs/minimatch/security/advisories/GHSA-g3hv-75wg-m249) | Root 9.0.9 and TypeScript ESLint's nested 10.2.6 | **PARTIALLY REMEDIATED**: nested copy becomes 11.0.9 through upstream TypeScript ESLint 8.73.0. Root 9.0.9 remains under glob/Jest; its ^9 range cannot accept patched >=11.0.1. Trigger requires optimizationLevel >=2 and attacker-controlled patterns. |
| [Glob cancellation bypass, moderate](https://github.com/isaacs/node-glob/security/advisories/GHSA-3g3m-2fjr-6pw4) | Root 10.5.0; nested 7.2.3 is outside this advisory's >=9 range | **OPEN**: patched >=14.0.2 does not satisfy Jest's ^10.5.0 range. Requires async traversal using cancellation and attacker-influenced patterns/trees. No forced cross-major override or Jest downgrade applied. |
The audit's suggested Jest 30.2.0, jsdom environment 29.7.0, and Next ESLint config 14.2.35 downgrades are not accepted remedies: they change the supported toolchain rather than supply compatible patched leaf packages. No audit suppression, force fix, rule weakening, production configuration, or dependency override was added.
## Compatible change
`npm update typescript-eslint --package-lock-only --ignore-scripts --no-audit` uses eslint-config-next 16.4.6's existing `typescript-eslint: ^8.56.0` range. Eleven coordinated TypeScript ESLint entries move 8.68.0 to 8.73.0; the maintainer now declares minimatch ^11.0.1, selecting nested 11.0.9. Its required @isaacs/nonrecursive-glob-match 1.1.0 is added, and the ESLint plugin's allowed ignore dependency updates 7.0.6 to 7.0.16. There are exactly 13 changed existing lock entries and one addition; see machine-readable `evidence/lock-delta.json`. Direct dependency declarations, application source, Jest/Next versions, and existing overrides remain unchanged. Package.json adds only the explicit Node regression command.
Minimatch 11.0.9 requires Node 20 or >=22. Verification uses the recorded local Node version; Node 18 is not qualified for this updated tool dependency. Next 16 already requires Node >=20.9.0. Install scripts were disabled without changing approval policy.
## Verification and evidence limits
- Fresh isolated `npm ci --ignore-scripts --no-audit`: PASS, 826 installed packages. `npm ls` for the affected trees: PASS; nested installed minimatch 11.0.9 and TypeScript ESLint 8.73.0 agree with the lock. Shared A3 and sibling node_modules were not used or modified.
- Bounded regression on official baseline minimatch 10.2.6 tarball: expected FAIL, missing the expansion-budget exception. Only eight repetitions (at most 256 patterns), local process, 15-second outer timeout; no abusive payload or service target.
- Permanent `npm run test:glob-security`: PASS, two cases for expansion rejection and ordinary path behavior. The first exploratory assertion expected the earlier 11.0.1 cap behavior, while 11.0.9 throws RangeError; corrected to the installed source's explicit rejection behavior. That initial failed exploratory output was overwritten by the runner and is not a retained native receipt. Final test and independent baseline receipts are retained.
- `npm run test:redirect-security`: PASS, two existing same/cross-realm cases. Full frontend ESLint and TypeScript checks: PASS without configuration changes.
- Candidate full lock audit: FAIL exit1, **49 records (2 moderate, 47 high)**, still three concrete advisories. The affected nested minimatch node is removed from its advisory; root minimatch remains. Five TypeScript ESLint metavulnerability severities change moderate to high through residual picomatch propagation; @types/jest disappears despite unchanged Jest entries. These registry/metavulnerability changes are **not** evidence that this patch eliminated an independent advisory or reduced aggregate risk. Native snapshots are preserved separately.
- Candidate production-tree lock audit (`--omit=dev`): PASS exit0, zero returned findings. This is scoped evidence, not a full dependency or release clearance.
- Own `graphify update .`: PASS, AST-only, 19,837 nodes / 48,046 edges. Optional PDF/SQL extraction dependencies were absent. Newly generated untracked graph artifacts are retained in sibling `dev-dependency-triage-evidence/graphify-out`; shared A3 graph was not updated.
- NOT RUN: full build/browser lane, Jest suite (Jest and runtime dependencies unchanged), backend, hosted CI, providers, live models, native/device/AT, formal integrated security scan, deployed or production validation. No runtime/UI/document behavior claim is made from tooling checks.
`evidence/SOURCE_RECEIPTS.json` binds exact source hashes, commands, versions, exits, and native gzip receipts. Raw subprocess stdout/stderr bytes avoid Windows PowerShell encoding conversion. Official registry metadata and advisory/fix sources are retained with hashes. Parent integration must rerun the narrow checks after a fresh locked install; rollback is a revert and locked reinstall, which restores the affected nested version. No push, main merge, orchestrator action, or deployment was performed.
## Root recovery qualification, 18 November 2026
The isolated candidate remained source-identical to efa438201 through the usage-limit interruption. Root ran the standard Next16.4.6 build: compile, TypeScript and static export passed exit0 without warning bypass. Root also repeated the two glob and two redirect regressions, all passing; repeated cases are not added to prior test totals. Exact native outputs are gzip-bound in the receipt. No browser or formal integrated security qualification is implied. Earlier NOT RUN build statement is historical and superseded by this scoped result; Node20/Linux/hosted checks remain separate.
@@ -0,0 +1,245 @@
{
"baseline": "eb2538772e1bfabbeb291e4a5efa177c79074de1",
"node": "v24.19.0",
"npm": "11.17.0",
"sourceSha256Lf": {
"job-tracker-ui/package.json": "09987e915c07a212fe0e460785283a0f78efe85b4f3f05b252219ebb1914ee72",
"job-tracker-ui/package-lock.json": "2ddb39aae463fd706512be2b0a654f4575192c92b7f209af64de8897123d7666",
"job-tracker-ui/test/typescript-eslint-glob-security.test.mjs": "ce08ecc4d216e5d22965dbd40c0f94fbe6666d0b9fcf64601dc29a6bc7e261d7"
},
"nativeReceipts": [
{
"path": "baseline-audit.exit.json.gz",
"rawSha256": "f468f8bf84d59a390a40e5d5ac0291111e0e6eeb79821864810ae628cbd3507e",
"gzipSha256": "4761ccb47a53fb185b703d6c40024da0ffd4d99a4a86cb3c05e8d72c6c3e785d",
"rawBytes": 15
},
{
"path": "baseline-audit.stderr.txt.gz",
"rawSha256": "799f544422ef20e84949c8feabb844390db9306ac5cf97419981d0291eb45156",
"gzipSha256": "de490ffd4557141616c16a97c1366601a12b3963d5f0ed8a91d1a9c5b95a91f7",
"rawBytes": 209
},
{
"path": "baseline-audit.stdout.json.gz",
"rawSha256": "6aa612fb8fcfdc034dbdeb218fb02293270bfc8c1d0f058fa297619cfae1209a",
"gzipSha256": "4111ca771b7c17e9162a5eccfec2972ee64478f81307b11a0b9128b5b2222dcc",
"rawBytes": 25336
},
{
"path": "baseline-regression.exit.json.gz",
"rawSha256": "c3dee3219b98a8127997224f95bcc0ffe1ec533a01ce1d0ea92161dba22e6d7b",
"gzipSha256": "fe757b52a6e97554691f6355528b6630679b8ab647e317cb9bc5b0a15ddd17c2",
"rawBytes": 211
},
{
"path": "baseline-regression.stderr.txt.gz",
"rawSha256": "0b13f43d70e80ae802e117bcddeae10854e55fdc173e93f38f761e2a286dd52b",
"gzipSha256": "a7d00819a6d37f41858640cda29712755345217d1b1870991df98cf8d98f0883",
"rawBytes": 777
},
{
"path": "baseline-regression.stdout.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "candidate-audit.exit.json.gz",
"rawSha256": "f468f8bf84d59a390a40e5d5ac0291111e0e6eeb79821864810ae628cbd3507e",
"gzipSha256": "4761ccb47a53fb185b703d6c40024da0ffd4d99a4a86cb3c05e8d72c6c3e785d",
"rawBytes": 15
},
{
"path": "candidate-audit.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "candidate-audit.stdout.json.gz",
"rawSha256": "7208ace3c4f1cc35b0bec59922be92872a26bf15d8eb673ec3011f1664cf2f77",
"gzipSha256": "6db6e4f1add642556129e7773965bae1bc3c94ec489c0b4e979691fa6eb4aaf3",
"rawBytes": 25452
},
{
"path": "ci.stderr.txt.gz",
"rawSha256": "88c9d02e27f8dc6de23c0236a18ec15a9f61be204fee5bdedb245f8f8799d35a",
"gzipSha256": "a7ea99ffe5cfdd0159c1f56fe4a93275cbd911eee6d4699562cdb68c8ba03c2a",
"rawBytes": 1055
},
{
"path": "ci.stdout.txt.gz",
"rawSha256": "7a9ad18851e094a42725309fd03e68a7faf154f912049c148c8c30af0edca105",
"gzipSha256": "5c462b5a8b4016f2a75578a865f1655b400c320310a86496da629a05eb29047a",
"rawBytes": 93
},
{
"path": "GHSA-3g3m-2fjr-6pw4.json.gz",
"rawSha256": "ba661d336d2a6de3d418a317f4d1b298b845a14383842c68a1c0b994eb0454c8",
"gzipSha256": "d616a633ee3e832dc995ff142060d837bbae210942e8537071f62a9ce7d8950c",
"rawBytes": 4652
},
{
"path": "GHSA-fc5q-39xc-vjpf.json.gz",
"rawSha256": "cc99706e61047047b6690db94abb98b5940d007196775c12902c0f79d8aedbd5",
"gzipSha256": "daedfd4d95519bcd43a91b7349dcfc7ca924b5541cce5b7b86bdf31a667c52e0",
"rawBytes": 4025
},
{
"path": "GHSA-g3hv-75wg-m249.json.gz",
"rawSha256": "b324fca01e28e662e2dabba5ad7d2f4ab267420b2245ebe3068f5ec3a54dd30a",
"gzipSha256": "a9b8dd4e8657eff5ada3d57294a072a2b803e41cd450640ae296eca74762ca3f",
"rawBytes": 10021
},
{
"path": "glob-regression.exit.json.gz",
"rawSha256": "da0113d8a762cfbd47093480ce9c5e3bdb547a6a02c3a612678072fa8e0a61d2",
"gzipSha256": "ac7c689c35be456b71bd3c6d8fb15e25dfda3bf5ec73d2bdd0c887ec88f35698",
"rawBytes": 68
},
{
"path": "glob-regression.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "glob-regression.stdout.txt.gz",
"rawSha256": "af2e33a765c3163572fbc756d2c280b1ceb35cddd23d16f2920d3f6ad579316e",
"gzipSha256": "443252413f047c9af76284c6b9712fd5dcb032c250905d3dd8ce7c2970a9df94",
"rawBytes": 379
},
{
"path": "installed-tree.exit.json.gz",
"rawSha256": "ed9b78f66d3418e95de323567452eb48f8be835f650ba9c6a6a366b5f75b567a",
"gzipSha256": "f3710e2cb07ac6540f2b8237a42aaa13c2125b0e4dfccf0280fff2308d7caf95",
"rawBytes": 150
},
{
"path": "installed-tree.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "installed-tree.stdout.txt.gz",
"rawSha256": "5238a84a19bfb88f03fed8b8b1075b66d354d488a81a79c758acca514aa61828",
"gzipSha256": "ba2b51415dd600c1c33f96adddd762993e75b65c4864ca9a453bd5e63f7698ab",
"rawBytes": 12618
},
{
"path": "lint.exit.json.gz",
"rawSha256": "63a408719e42acbe473035d4580a52afd27197ee394ce6804dd5f6f4ef447833",
"gzipSha256": "9b2c7159a441b0dd4a29219a15496ad9daec1a1923b046f89ad9d56206c61545",
"rawBytes": 54
},
{
"path": "lint.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "lint.stdout.txt.gz",
"rawSha256": "90b7cd72b55fedd90de76daaa13f3c58e1b051481ede133c1904168b2f6bf6b0",
"gzipSha256": "70335ab21127cfe30ee80c025401b632f2b7be204fcbb5f2a9d9f2982008eb53",
"rawBytes": 58
},
{
"path": "minimatch-fix-commit.json.gz",
"rawSha256": "95407060d7db69d56937a3f8fa92880ea7cf497a9188d44f5ee12bfbd10c1458",
"gzipSha256": "b196cd707fbf9b1b8c81a7ab3dd8a29ac938a91b5cea968f664ef238ff04a511",
"rawBytes": 10589
},
{
"path": "production-audit.exit.json.gz",
"rawSha256": "47b8b6b49d4695fe6e036bd916538aff4f46773e212ca0d429db80f3963e2cfe",
"gzipSha256": "0610f69ca93f69d5ad6b87fc15dac7e1be30033bb24c59033de8d2f93f275d38",
"rawBytes": 15
},
{
"path": "production-audit.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "production-audit.stdout.json.gz",
"rawSha256": "ede7d93f96b8531dc5e48ee942f62801d359d7f070660fd79ad680dd17fef56a",
"gzipSha256": "cd6f6bd64e7698b382744793b37e274911a896db15e3acd2725bb30f770a2b88",
"rawBytes": 365
},
{
"path": "redirect-regression.exit.json.gz",
"rawSha256": "ded6dd68d16715de062e13a0b43f34b960c41c7d9d331afdb390c1712191b558",
"gzipSha256": "b2699c4826b7ed316324107592ee4e4154d5c743f75a4559c3763c15c9f4abdc",
"rawBytes": 72
},
{
"path": "redirect-regression.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "redirect-regression.stdout.txt.gz",
"rawSha256": "df3fb3fa2482abe2c8612e25bfafd664f7a1d968e758ca6e8129e8d58820ca3f",
"gzipSha256": "01b8e9fc8a5d9bb259d03136861c854708123d9e5a08bd9f16eb409a97cf236e",
"rawBytes": 389
},
{
"path": "typecheck.exit.json.gz",
"rawSha256": "7d7f1482a8eec7f11c30b2dc2f32b709e0dfcf4404b42471dc701b0d3bb25d7e",
"gzipSha256": "bc69db1fd7ebbd1f09a3af4bbbcc308883bc185e80c587a6f9238aea46ec6d08",
"rawBytes": 59
},
{
"path": "typecheck.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "typecheck.stdout.txt.gz",
"rawSha256": "c6cdd224453c93bedaa01ce7fc28e1053d4eb1586cb06e05351508baec36ca9b",
"gzipSha256": "69785b4c92c52a672b306df65bdacf07f335d0046df12ac11a2906938db394ee",
"rawBytes": 70
},
{
"path": "typescript-eslint-update.stderr.txt.gz",
"rawSha256": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855",
"gzipSha256": "46b50c321b39e89a491b6727a01628c34245605a30beb3e7414c5e01cff90e6e",
"rawBytes": 0
},
{
"path": "typescript-eslint-update.stdout.txt.gz",
"rawSha256": "7ad6c03b16aa7ae15777766b0a09681846373f7f49bfff351127b1b74cab3824",
"gzipSha256": "0c0830bbf261fcac0d5a6360624da9659936f1815930461c822f3f6f81a7d3a0",
"rawBytes": 86
},
{
"path": "root-build.txt.gz",
"rawSha256": "06b4d1c773298c49d5b45559fbbfec44e87ae9fb70f1dd063f546174840816db",
"gzipSha256": "16605e62e1df79add88c7ebe18f78841d5507c184082e18612c2e6420bce4853",
"rawBytes": 1196,
"nativeEncoding": "UTF-16LE BOM (Windows PowerShell)"
},
{
"path": "root-glob-tests.txt.gz",
"rawSha256": "1d0c63a81afac70ba172093f95a41fada0a25e7e34fb1a7b08f57d8d06daa30b",
"gzipSha256": "7c680314d8ab2799e64e381f8ff3d43add7a2a60a6304df4c7327dbdcfacf718",
"rawBytes": 746,
"nativeEncoding": "UTF-16LE BOM (Windows PowerShell)"
},
{
"path": "root-redirect-tests.txt.gz",
"rawSha256": "0c7aa85745a86b23809ec7ab55d55b6c8aa13d5cfa1dae0b59dca5a9fcaade5d",
"gzipSha256": "4822218c9647b819d138866918e04fc49ebdb115e1f26374432145a246c4df39",
"rawBytes": 762,
"nativeEncoding": "UTF-16LE BOM (Windows PowerShell)"
}
],
"sourceCommit": "efa438201c66d74149d76646ea9243efa145c10f",
"rootVerification": "18 November 2026: normal Next16.4.6 build/TypeScript/static export exit0; glob2 and redirect2 tests exit0 (repeat of existing cases)."
}

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