Compare commits

..

6 Commits

Author SHA1 Message Date
cesnimda 171e616b8e docs: qualify combined native connected workflows 2026-11-18 19:02:02 +01:00
cesnimda e2629c9d1a test(discovery): prove explicit native tracker journey 2026-11-18 18:57:17 +01:00
cesnimda 890b9443b3 fix(checklist): recover only system-key duplicate races 2026-11-18 18:56:30 +01:00
cesnimda c685bd7a6e test(calendar): qualify native status and follow-up journey 2026-11-18 18:56:29 +01:00
cesnimda fcc5ffa883 perf(analytics): combine stats scalar count queries 2026-11-18 18:56:29 +01:00
cesnimda dacdf16934 feat(dev): add isolated Windows Docker rebuild script 2026-11-18 13:11:26 +01:00
117 changed files with 1879 additions and 4 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,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; }
}
}
@@ -388,7 +388,7 @@ public sealed class ApplicationChecklistService : IApplicationChecklistService
await _db.SaveChangesAsync(ct); await _db.SaveChangesAsync(ct);
return items; return items;
} }
catch (DbUpdateException) catch (DbUpdateException ex) when (IsDuplicateSystemKey(ex))
{ {
foreach (var item in seeded) _db.Entry(item).State = EntityState.Detached; 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) private async Task SyncAutoCompletionAsync(List<ApplicationChecklistItem> items, ChecklistSignals signals, CancellationToken ct)
{ {
var changed = false; var changed = false;
+99
View File
@@ -0,0 +1,99 @@
# Standalone local project: do not combine with production Compose or its .env.
services:
database:
image: mariadb:12.2.2@sha256:42a27baaba3e8f3f0159d16381d5a7156661aa91dcc65f663cabb6a6f9503c00
environment:
MARIADB_ROOT_PASSWORD: ${JT_LOCAL_DB_ROOT_PASSWORD:?Run rebuild-windows-docker.ps1 first}
MARIADB_DATABASE: jobtracker
MARIADB_USER: jobtracker
MARIADB_PASSWORD: ${JT_LOCAL_DB_PASSWORD:?Run rebuild-windows-docker.ps1 first}
volumes:
- database:/var/lib/mysql
command: ["--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]
healthcheck:
test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
interval: 3s
timeout: 5s
retries: 45
start_period: 20s
restart: unless-stopped
backend:
image: jobjakt-windows-local-backend:latest
build:
context: ..
dockerfile: JobTrackerApi/Dockerfile
environment:
ASPNETCORE_ENVIRONMENT: Development
ASPNETCORE_URLS: http://+:8080
Database__Provider: mariadb
Database__ServerVersion: "12.2.2"
ConnectionStrings__JobTracker: Server=database;Database=jobtracker;User ID=jobtracker;Password=${JT_LOCAL_DB_PASSWORD};SslMode=None
Data__Root: /data
AccountLifecycle__TombstonesRoot: /account-lifecycle/tombstones
Auth__Require: "true"
Auth__JwtKey: ${JT_LOCAL_JWT_KEY:?Run rebuild-windows-docker.ps1 first}
Auth__AdminEmail: ${JT_LOCAL_ADMIN_EMAIL:?Run rebuild-windows-docker.ps1 first}
Auth__AdminPassword: ${JT_LOCAL_ADMIN_PASSWORD:?Run rebuild-windows-docker.ps1 first}
Auth__AllowRegistration: "false"
App__PublicBaseUrl: http://localhost:${JT_LOCAL_PORT:-3000}
App__Version: windows-local
App__CommitSha: ${JT_LOCAL_COMMIT:-unknown}
HttpsRedirection__Enabled: "false"
Proxy__TrustForwardedHeaders: "false"
Ai__BaseUrl: http://127.0.0.1:9
Summarizer__BaseUrl: http://127.0.0.1:9
Ai__ExternalProcessingEnabled: "false"
Email__Enabled: "false"
AccountLifecycle__DeletionEnabled: "false"
Workers__RulesEnabled: "false"
Workers__FollowUpRemindersEnabled: "false"
Workers__SavedJobSearchAlertsEnabled: "false"
Workers__DailyExportEnabled: "false"
Workers__JobEnrichmentEnabled: "false"
Workers__AiOperationsEnabled: "false"
Workers__CvDocumentImportsEnabled: "false"
volumes:
- files:/data
- tombstones:/account-lifecycle/tombstones
depends_on:
database:
condition: service_healthy
networks:
default:
aliases: [backend-web]
healthcheck:
test: ["CMD", "curl", "-fsS", "http://127.0.0.1:8080/ready"]
interval: 5s
timeout: 5s
retries: 45
start_period: 90s
restart: unless-stopped
frontend:
image: jobjakt-windows-local-frontend:latest
build:
context: ../job-tracker-ui
shm_size: 1gb
args:
NEXT_PUBLIC_API_BASE_URL: /api
environment:
APP_PUBLIC_BASE_URL: http://localhost:${JT_LOCAL_PORT:-3000}
INGRESS_MODE: direct
ports:
- "127.0.0.1:${JT_LOCAL_PORT:-3000}:80"
depends_on:
backend:
condition: service_healthy
healthcheck:
test: ["CMD", "wget", "-q", "-O", "/dev/null", "http://127.0.0.1/health"]
interval: 3s
timeout: 5s
retries: 20
start_period: 10s
restart: unless-stopped
volumes:
database:
files:
tombstones:
+37
View File
@@ -0,0 +1,37 @@
# Rebuild and run locally on Windows
Start Docker Desktop in **Linux containers** mode, then run PowerShell:
```powershell
powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Users\Connor\.codex\worktrees\direct-roadmap-integration\Job tracker\scripts\rebuild-windows-docker.ps1"
```
Open http://localhost:3000 after the script finishes. It rebuilds backend/frontend from that checkout, reports its branch/commit and starts a separate `jobjakt-windows-local` project. It neither pulls Git changes nor selects `main`; run it again after development checkpoints are integrated into this checkout. Working-copy changes are included in Docker's ordinary build context. First build needs internet for existing base images and locked dependencies.
Login is `local-admin@example.test`. The generated password is the `JT_LOCAL_ADMIN_PASSWORD` value in `.env.windows-local` at the checkout root; open that private file locally to read it. The file is ignored by Git. Keep it and use the same checkout for subsequent rebuilds: changing database credentials after volumes exist prevents connection. The separate local database starts empty; existing production accounts/data are not imported.
Useful options:
```powershell
# Use another local port if3000 is occupied.
.\scripts\rebuild-windows-docker.ps1 -Port 3001
# Validate configuration without building or starting containers.
.\scripts\rebuild-windows-docker.ps1 -ValidateOnly
# Rebuild without Docker layer cache when needed.
.\scripts\rebuild-windows-docker.ps1 -NoCache
# Stop this local project, retaining its database/files and credentials.
docker --context desktop-linux compose --project-name jobjakt-windows-local --env-file .env.windows-local -f dev/windows-local.compose.yml stop
```
The last commands run from the same checkout root. `-DockerContext default` is available if that is your local Linux Docker context. The start path rejects remote Docker endpoints and non-Linux engines. The script never deletes volumes or pushes images. Database/files/tombstones have separate named volumes owned by this project; only frontend port3000 is exposed, on127.0.0.1. The API/database are internal.
This stack intentionally has no AI sidecar/Ollama, mail delivery or background provider/model workers. Existing manual application/Career/CV/PDF workflows remain available; generative and sidecar-dependent import functions need their separately approved test stack. AI activation remains a separate owner decision, including model identity and local-only routing. No production Compose/environment is loaded.
## Verification
18November2026: PowerShell parser and rendered Compose contract tests **2/2 PASSED**, zero skips; `-ValidateOnly` twice PASSED, preserving the credential file. Checks cover exact build contexts, three-service allowlist, loopback port, internal API/database, persistent project-owned volumes, same-origin routing, authentication and disabled external/background processing. `python scripts/test-windows-docker.py` executes no build/container commands.
**Docker build/start NOT RUN:** local Docker Desktop Linux engine pipe was absent when inspected. Start Docker Desktop before running the script. Source/static checks do not establish container startup, image builds, Node20 compatibility, database migration parity, PDF fidelity or full release qualification.
@@ -0,0 +1,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.
+5 -1
View File
@@ -1,4 +1,4 @@
# PERF-06 · Analytics stats aggregate queries # 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. 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.
@@ -37,3 +37,7 @@ Nine of those dedicated cases execute SQLite. The legacy **null Status** case us
**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. **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. 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
}
}
@@ -0,0 +1,11 @@
# Combined connected-workflow validation
18 November 2026. A3 source `1ec15429`; source-equivalent isolated browser checkout `e2629c9d`. A fresh Release API build passed with zero warnings/errors using cached dependencies and no restore. Production frontend source/dependencies are unchanged since the qualified export, so that exact export was reused rather than rebuilding it. API/DLL/spec/config/lock/export hashes are retained.
**Four connected browser cases passed, zero skips/unexpected/flaky, eight zero-violation axe scans/eight screenshots**, 45.4 seconds, one Chromium worker. These are the two EN-desktop/NB-phone discovery→review→explicit tracked application cases plus the two application status→follow-up→calendar→linked workspace→clear cases, now on the combined analytics aggregate and narrowed checklist error classifier. Counts overlap the original packages; do not add reruns to distinct-case coverage.
Only disposable loopback SQLite fixtures were used. Existing external browser traffic guards, fixture search/source/import-preview, and disabled model/import/alert workers remained. No live provider, AI quality, deployed service, production data or device/assistive-technology acceptance is claimed. Existing fixture migration and development Data Protection warnings remain. No HTTP failure appears in this run; that does not explain or retrospectively fix the historical GetReminders cancellation.
The unchanged frontend needs no repeated full Jest/build for this backend integration. Full backend/security/recovery/release and visual/native-language acceptance remain separate. Actual MariaDB 98-case evidence is in its own report; these browser fixtures remain SQLite.
[Native report, build log, all attachments and source receipts](evidence/combined-connected/SOURCE_RECEIPTS.json). Rollback: revert the associated bounded implementation commits; no schema/data migration.
@@ -0,0 +1,23 @@
# Discovery to application: connected native boundary
18 November 2026. Test-only increment on existing `1db5f488` application/export/API, with pinned dependencies unchanged. The two new cases extend the existing `phase7-discovery.spec.ts` fixture and preserve its external-traffic guard. No provider, model or additional international source was activated.
## Verified journey
English/light/1440 desktop and Bokmål/dark/390 phone: discover a synthetic NAV vacancy, open its synthetic source advert, return to results, explicitly review its import preview, choose an existing company, create one actual tracked application, revisit it through the applications interface and verify its full workspace. Search, external advert HTML and import-preview responses are intercepted. Company setup, application creation (201), subsequent API reads, duplicate lookup and foreign-owner denial (404) execute against the isolated actual API and disposable SQLite database.
The application GET DTO does not expose canonical job provenance. A read-only SQLite query joins the linked job with both owner IDs constrained, proving retained source `nav` and country `NO`; the existing generated fixture-root/path guard and query-only connection prevent mutation. Career Profile and company data remain unchanged. Advert language is independently `nb`, including during English UI execution. There is one explicit create, with no automatic creation or alternative-application chooser.
Final result: **2/2 passed, zero skips/unexpected/flaky; four scoped axe scans with zero violations; four retained screenshots**, zero root horizontal overflow. Final TypeScript and scoped ESLint passed. These two cases are additional connected coverage, not a full regression or final A3 acceptance.
The original two failures were verifier mistakes: provenance was asserted on the application DTO rather than its linked job. After correcting that boundary, one desktop assertion still assumed a link where the real keyboard-enabled table exposes a row; the phone exposes a link. Both original and intermediate outputs are retained. No application changes were made to satisfy those assumptions.
## Visual review and limits
The retained desktop workspace shows the approved right-side context and flat section hierarchy. The phone workspace stacks context below content and uses the hybrid bottom navigation. These are full-page captures at the journey's current scroll position: sticky header/bottom navigation appear within the stitched phone image, and the route heading is partly under the header in that capture. This is a capture/scroll review limitation requiring a controlled viewport check, not proof that every screen or header state is accepted. The Bokmål activity entry still displays the server event text `Created`; synthetic company content is English. These captures do not establish complete native-language acceptance or resolve the existing visual discrepancy register.
The fixture advert deadline is historical synthetic data. This package does not exercise live NAV access, provider rights, saved-run ingestion, provider dismissal persistence, extraction/model quality, physical devices, assistive technology, browser zoom, or production. The frozen backend predates the later checklist error-classification correction and analytics aggregate change: combined affected browser validation remains separate.
Exact original/intermediate/final reports, native logs, screenshots, audits, request boundaries, readbacks and LF-normalised source hashes are retained in [evidence receipts](evidence/connected-discovery/SOURCE_RECEIPTS.json). The source test is the rollback unit; no application/data rollback or migration is needed.
AST-only graph refresh passed: 19,963 nodes / 49,440 edges. Existing optional PDF/SQL extractors and symbol-free generated-input warnings remain; no model labeling was run.
@@ -0,0 +1,55 @@
# Native application status, follow-up and calendar connection
18 November 2026. Application baseline `1db5f488f6138e4f0f33749452b7d9f47658f4b0`; roadmap receipt `271d37d1a875256643602db20bbd3c381a291c05`. Isolated branch `codex/a3-connected-followup`. Test/evidence changes only: no application, API, model, provider, data model or scheduling-policy change.
## Missing boundary now exercised
The original 34-route/57-group registers and A3 design/IM10 authority remain unchanged. The existing [controlled follow-up journey](visual-correction/FOLLOWUP_JOURNEY_REVIEW.md) passed eight representative journeys with every response intercepted. It already established the parent refresh-token repair; this package does not repeat that matrix or claim another stale-agenda defect. Existing `phase7-reminders.spec.ts` native tests checked actual reminder dates/history/retry/ownership but did not assert the adjacent calendar's native readback after the user mutation. The separately completed 44-case native package covers other families and is not added to these counts.
Two new cases in the existing `job-tracker-ui/e2e/phase7-reminders.spec.ts` cover EN/light/1440 and Bokmål/dark/390:
- Create a disposable synthetic care-coordinator application, then use the real Applications row menu to set Waiting. Require PATCH204 and durable status readback, preserving the existing follow-up date.
- Open Reminders, schedule three days through the existing control, require PATCH204 and the subsequent actual calendar GET200 with the moved date/recordedAt. The retained policy is absolute-millisecond arithmetic followed by the UTC date slice; no local-calendar/DST reinterpretation.
- Open Month and the populated day, keyboard-open the linked application, require the matching workspace GET200/Waiting, return and retain Month preference.
- Clear the follow-up through the existing control. Require PATCH204, calendar GET200 without that event, the selected day still selected with count zero, unchanged Month mode, empty-day feedback and durable null follow-up with Waiting unchanged.
- Preserve exact status/date payloads and two FollowUpSet history values. No draft/send/model/provider action is issued. Each case records eight reminder GETs from the existing Shell/page/navigation sources, not a claim of one GET per page.
No runtime defect was required to make the new cases pass. The complete affected-file run exposed two inherited verifier failures: both searched for the retired exact header name `Norsk`. Actual snapshots show `Norsk bokmål`. Only those two selector strings changed; existing moved-focus, no-extra-read, explicit retry, captured date and history assertions remain intact. The original negative reports and their source hash are retained.
## Executed results
| Run | Outcome | Accounting |
| --- | --- | --- |
| New focused cases | 2 passed | Initial actual HTTP/browser proof, included again below |
| Affected file before inherited selector repair | 6 passed / 2 failed | Both failures are the obsolete header name, not application behavior |
| Final complete affected file | **8 passed**, zero skipped/unexpected/flaky | Six existing cases plus the two new cases; this is the final total |
Final run retained **21 screenshots and 21 complete all-enabled axe/target-size vectors, zero returned violations**, with incomplete findings preserved. Four screenshots/audits and two native readback records for the new cases are extracted alongside the native receipts. EN desktop and NB phone scheduled-month captures were inspected: recorded date/context, visible selected day and wrapping remain usable in those samples. Full-page sticky navigation can overlay an off-viewport segment in a tall capture; these images do not establish physical-device or comprehensive focus-occlusion acceptance.
Scoped TypeScript compiler API checking the complete spec plus imported types returned zero diagnostics; scoped ESLint and source whitespace checks passed. No full Jest, new application build or backend unit run was performed for this test-only increment.
AST-only `graphify update . --no-cluster` completed exit 0 with 19,930 nodes / 49,369 edges. Generated graph stays local/untracked; missing PDF/SQL extractors and 147 symbol-free inputs (including owned temporary transform-cache data) remain graph limits, not product acceptance gaps.
## Source/runtime identity and isolation
The existing qualified root E-drive frontend export/API DLL were reused read-only through this worktree's own `node_modules`, `out` and API `bin` junctions. Entry comparison found no root working-tree difference from the application baseline under `job-tracker-ui/src` or `JobTrackerApi`. Frontend source tree: `6a8b38361f57f199ebe298d2193de63d90b009e4`. Backend tree: `b7701b2459186f665fe5759a533b6e434cc122b0`, identical at `eb253877` and this baseline, so the previously qualified Release API binary was reused. No installation, shared module/export/binary mutation, rebuild or restore.
The existing Playwright config managed fresh API5302/UI3300, disposable E-drive SQLite, synthetic Identity/CSRF/session accounts and one serial Chromium worker. `PLAYWRIGHT_STATIC_EXPORT=true`, `PLAYWRIGHT_PREBUILT_EXPORT=true`, `PLAYWRIGHT_REUSE_SERVERS=false`; SDK host `C:/Users/Connor/.dotnet/dotnet.exe`; TEMP/TMP and test output remain on E. Model/import/alert workers and delivery remain disabled under the existing fixture contracts. External requests are blocked by the existing owner fixture: final report records zero blocked external attempts. Both owned ports were confirmed closed after the run.
From `job-tracker-ui`, the native test command was:
```text
rtk proxy node node_modules/@playwright/test/cli.js test e2e/phase7-reminders.spec.ts --project chromium --workers=1 --reporter=line,json
```
Exact source, raw/gzip native hashes, original-source derivation, case outcomes and extracted artifacts are bound in [SOURCE_RECEIPTS.json](evidence/connected-calendar/SOURCE_RECEIPTS.json). Traces and disposable credentials stay outside Git.
## Backend log finding remains open
Both affected runs logged `UNIQUE constraint failed: ApplicationChecklistItems.JobApplicationId, ApplicationChecklistItems.SystemKey`. The final log also contains a middleware exception stack naming `JobApplicationsController.GetReminders` at line 689. No backend fix or clean-server claim is made. The focused new-two-case run did not record that uniqueness error; this does not establish absence.
Exact local native log: `E:/Storage/Projects/Active/temp docs/jobjakt-local-build/a3-connected-followup/.artifacts/reminders-qualified.log` (UTF-16LE). Its byte-identical gzip is committed as `evidence/connected-calendar/reminders-qualified.log.gz`. The uniqueness exception chain appears at lines 39/57 following the first existing test marker at line 29. New EN/NB test markers appear at 75/76, followed by the remaining middleware stack through 107 (`GetReminders` at 88). Native EN case start `2026-11-18T12:12:30.248Z`, duration 6,969 ms; NB start `12:12:37.228Z`, duration 7,448 ms; both have empty Playwright error arrays.
Server lines lack request IDs/timestamps, and the existing request-boundary collector records request metadata rather than unsolicited GET response statuses. Therefore this evidence cannot correlate the exception to a specific Shell/page GET or infer its client response status. Selected status/follow-up/calendar/workspace responses are asserted separately. Concurrent Shell/page reminder materialization is a reproduction candidate, not an established cause. Root was notified for independent backend triage.
SQLite migration/Data Protection and Node color-environment warnings remain in raw logs. No warning suppression or database workaround was used. MariaDB/hosted CI, real delivery/providers, timezone/precision/interview scheduling models, native devices/AT/native-language, final owner/A3/Phase10/security/recovery/release acceptance remain separate. No orchestrator, push, main merge or deployment.
@@ -0,0 +1,162 @@
{
"application": "1ec1542936e6f8ce466a8b805f7502ea986f27ab",
"executionBranchHead": "e2629c9d",
"stats": {
"startTime": "2026-11-18T17:57:43.516Z",
"duration": 45413.711,
"expected": 4,
"skipped": 0,
"unexpected": 0,
"flaky": 0
},
"scans": 8,
"screenshots": 8,
"sourcesSha256": {
"JobTrackerApi/Services/AnalyticsService.cs": "0859ad9202bbaf4de810f8b1bc9946cbed061f69105c02993f079715f59aa2b1",
"JobTrackerApi/Services/ApplicationChecklistService.cs": "0c807ab96cbb4a638d3f5ba62b2608cdfb599751df2de4e3d58b6d599b69b5e8",
"JobTrackerApi/bin/Release/net9.0/JobTrackerApi.dll": "c46c42392a544b426db8acaed1ab48d175836069fc9c071c60b6d267bfe29072",
"job-tracker-ui/e2e/phase7-discovery.spec.ts": "bcf2c84d0bc86d6fa6fdf43b62eaa70e066acf3ba1425b9496b6c9ea5ac7de46",
"job-tracker-ui/e2e/phase7-reminders.spec.ts": "dab45b17dcb5963ef45f6ec8b00f5476d2eeb9e14e83776de23235ca94267e45",
"job-tracker-ui/playwright.config.ts": "9252c961ac2779485bb72b24c31d526773d7c09f764eca638c4c1d47235e9f65",
"job-tracker-ui/package-lock.json": "7ebd728f99a1ed9a5334542fb578b30127b4a0c7984efe2913266e89e2fbfbd3",
"job-tracker-ui/out/index.html": "31dfd9b2d2e7ea7d9e696b5485d24d7b8daf0b1e078e6539e94a04955b8ff1f8"
},
"artifacts": [
{
"file": "combined-connected.json.gz",
"bytes": 730768,
"sha256": "469576593c2cd8a03972106f8c4940d0c7370942c26414b66318d8ebe48ef7a8"
},
{
"file": "combined-connected.txt.gz",
"bytes": 1012,
"sha256": "e818d13e41c00f68126935748e3f29a45b8d162c11dab335187c5e75e29280b6"
},
{
"file": "combined-api-build.txt.gz",
"bytes": 195,
"sha256": "2a2b2009fff6684fb11d0de9a34304c802b587d15f9c9f0a619b0717ddc64374"
},
{
"file": "discovery-en-p7-discovery-en-light-1440-connected-fixture-result-return-audit.json",
"bytes": 10841,
"sha256": "abfb946f956a214aa64675ed02508f26ee8b885d9d3f28c87b1a1697e1c38814"
},
{
"file": "discovery-en-p7-discovery-en-light-1440-connected-fixture-result-return.png",
"bytes": 93768,
"sha256": "585938f848e8eb5b8ced8f64fe8fbaa1b61c03e6a6fcb761c474c7d8a7546dac"
},
{
"file": "discovery-en-connected-native-tracker-readbacks.json",
"bytes": 3739,
"sha256": "e0f89c19d78bfcf1f537efc924b87f0647d7949e133f8dd29bbfd65c1265aa3d"
},
{
"file": "discovery-en-p7-discovery-en-light-1440-connected-native-workspace-audit.json",
"bytes": 9267,
"sha256": "3b40499d0a139f6e0fb1e8ad1edc3361c60d8fcbea588c7c85a69c2bc00c9f27"
},
{
"file": "discovery-en-p7-discovery-en-light-1440-connected-native-workspace.png",
"bytes": 122626,
"sha256": "84fd3e413476353bedfe9e7221d1c2140018bd590ad78af5582e30bc8bc4fc38"
},
{
"file": "discovery-en-discovery-request-boundary.json",
"bytes": 1264,
"sha256": "1b566579e51d569be46ed43d6fc8fb8b4cf4959831493bccb0dd67086fe2ed30"
},
{
"file": "discovery-nb-p7-discovery-nb-dark-390-connected-fixture-result-return-audit.json",
"bytes": 11333,
"sha256": "f9a09992219a3a5ff0f9848785227eccb34f336af3281c4343fc6665aab4e52d"
},
{
"file": "discovery-nb-p7-discovery-nb-dark-390-connected-fixture-result-return.png",
"bytes": 41080,
"sha256": "907ab5bba5793caa220a974506b791b28183e1e1b1bde82b26bb8ba3d69634e7"
},
{
"file": "discovery-nb-connected-native-tracker-readbacks.json",
"bytes": 3737,
"sha256": "2b0cb04374867d23b033e542cbd27006f5f25a90dccb7c280c3530faf4f64c5f"
},
{
"file": "discovery-nb-p7-discovery-nb-dark-390-connected-native-workspace-audit.json",
"bytes": 14328,
"sha256": "714231108ce7ee9781e16d3ac6a4780eaada0685e15c2b03ec7e3be713c40614"
},
{
"file": "discovery-nb-p7-discovery-nb-dark-390-connected-native-workspace.png",
"bytes": 81638,
"sha256": "eacdcadd05b014cb45e0038486513fa828a7a099f004c73d3468ebd5d597db1b"
},
{
"file": "discovery-nb-discovery-request-boundary.json",
"bytes": 1264,
"sha256": "1b566579e51d569be46ed43d6fc8fb8b4cf4959831493bccb0dd67086fe2ed30"
},
{
"file": "calendar-en-p7-reminders-en-light-1440-connected-status-scheduled-month-audit.json",
"bytes": 15937,
"sha256": "c5ec062d98a065579d7d90744be53c4d93872e54a5f81facc892cbb4d813ef35"
},
{
"file": "calendar-en-p7-reminders-en-light-1440-connected-status-scheduled-month.png",
"bytes": 108611,
"sha256": "75522112b2266a7c1839dd568425df6a6936c6638daf562e0ac9c7b1e715e302"
},
{
"file": "calendar-en-p7-reminders-en-light-1440-connected-cleared-selected-day-audit.json",
"bytes": 15112,
"sha256": "4cbdca1279d1d34ada9d93edc7a1287cbca1609414f8b83e89d58c17d8d12044"
},
{
"file": "calendar-en-p7-reminders-en-light-1440-connected-cleared-selected-day.png",
"bytes": 103893,
"sha256": "97489a0eac4c270f141c0e443414e91510edbb677e1df14cffe282e1392847a5"
},
{
"file": "calendar-en-connected-calendar-native-readbacks.json",
"bytes": 4543,
"sha256": "6b980f237490ea3adeb2d42e8a7a211046245b240ba5b58f8e25230e6e5f81bd"
},
{
"file": "calendar-en-reminders-request-boundary.json",
"bytes": 2464,
"sha256": "79a6723a8ce0963884787861f4b2a0e794a6164ef07ec1d5d9801bf8ae46c8fb"
},
{
"file": "calendar-nb-p7-reminders-nb-dark-390-connected-status-scheduled-month-audit.json",
"bytes": 16897,
"sha256": "157d6b8b31f076a477ff3be79f203be563b4f69e928d76a6234e4763be21b891"
},
{
"file": "calendar-nb-p7-reminders-nb-dark-390-connected-status-scheduled-month.png",
"bytes": 71335,
"sha256": "cb052d8cbbbd1f947b018fef4a766e5b73d34d9389411d39cac28bbcbc878049"
},
{
"file": "calendar-nb-p7-reminders-nb-dark-390-connected-cleared-selected-day-audit.json",
"bytes": 16099,
"sha256": "d1ea35c624166edceecd80eef7b9443a01e867806cbad96a512cd5947351c93a"
},
{
"file": "calendar-nb-p7-reminders-nb-dark-390-connected-cleared-selected-day.png",
"bytes": 68123,
"sha256": "e1f4dc9eae3ba585e2ae3e0d114fb493da000010453ef70ed95a013e53bab726"
},
{
"file": "calendar-nb-connected-calendar-native-readbacks.json",
"bytes": 4542,
"sha256": "e6ec078dbbed51bc552ee0b9273e70637e27f7a9899ac16dcc8aa9bb36348f31"
},
{
"file": "calendar-nb-reminders-request-boundary.json",
"bytes": 2464,
"sha256": "0bb856c14aecae8dfba9d088858a6662d2ea7346ae73cf4ea20589a71030c8fe"
}
],
"boundary": "Fresh Release API, unchanged frontend export reused; loopback disposable SQLite, external provider/model operations disabled or fixtures. Four cases overlap prior connected evidence."
}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","sample":{"language":"en","theme":"light","width":1440,"height":900},"waiting":{"id":3,"companyId":3,"company":{"id":3,"ownerUserId":"a49a2972-d293-4792-872d-30a20b770881","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T17:58:10.5808212","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":"2026-10-14T00:00:00","feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":2},"scheduledItems":[{"jobApplicationId":3,"jobTitle":"Recorded community care coordinator — æøå","companyName":"Connected synthetic care employer","kind":"follow-up","date":"2026-10-16","recordedAt":"2026-10-16T00:00:00"}],"final":{"id":3,"companyId":3,"company":{"id":3,"ownerUserId":"a49a2972-d293-4792-872d-30a20b770881","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T17:58:10.5808212","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":4},"history":[{"id":5,"type":"FollowUpSet","oldValue":"2026-10-14T00:00:00.0000000","newValue":"2026-10-16T00:00:00.0000000","note":null,"at":"2026-11-18T18:58:13.3698069"},{"id":6,"type":"FollowUpSet","oldValue":"2026-10-16T00:00:00.0000000","newValue":null,"note":null,"at":"2026-11-18T18:58:16.6970157"}],"qualification":"Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model."}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","requests":[{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications","query":{"page":"1","pageSize":"15","includeDeleted":"false","sortBy":"dateApplied","sortDir":"desc"},"body":null},{"method":"PATCH","path":"/api/jobapplications/3/status","query":{},"body":{"status":"Waiting"}},{"method":"GET","path":"/api/jobapplications","query":{"page":"1","pageSize":"15","includeDeleted":"false","sortBy":"dateApplied","sortDir":"desc"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"PATCH","path":"/api/jobapplications/3/followup","query":{},"body":{"followUpAt":"2026-10-16"}},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/3/status-suggestion","query":{},"body":null},{"method":"GET","path":"/api/jobapplications/3/workspace","query":{},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"PATCH","path":"/api/jobapplications/3/followup","query":{},"body":{"followUpAt":null}},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null}],"blockedExternalRequests":[]}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","sample":{"language":"nb","theme":"dark","width":390,"height":844},"waiting":{"id":4,"companyId":4,"company":{"id":4,"ownerUserId":"b5560773-049c-4045-8fdb-9e0eefe17446","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T17:58:19.6056642","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":"2026-10-14T00:00:00","feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":2},"scheduledItems":[{"jobApplicationId":4,"jobTitle":"Recorded community care coordinator — æøå","companyName":"Connected synthetic care employer","kind":"follow-up","date":"2026-10-16","recordedAt":"2026-10-16T00:00:00"}],"final":{"id":4,"companyId":4,"company":{"id":4,"ownerUserId":"b5560773-049c-4045-8fdb-9e0eefe17446","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T17:58:19.6056642","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":4},"history":[{"id":9,"type":"FollowUpSet","oldValue":"2026-10-14T00:00:00.0000000","newValue":"2026-10-16T00:00:00.0000000","note":null,"at":"2026-11-18T18:58:22.4492282"},{"id":10,"type":"FollowUpSet","oldValue":"2026-10-16T00:00:00.0000000","newValue":null,"note":null,"at":"2026-11-18T18:58:25.8603492"}],"qualification":"Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model."}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","requests":[{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications","query":{"page":"1","pageSize":"15","includeDeleted":"false","sortBy":"dateApplied","sortDir":"desc"},"body":null},{"method":"PATCH","path":"/api/jobapplications/4/status","query":{},"body":{"status":"Waiting"}},{"method":"GET","path":"/api/jobapplications","query":{"page":"1","pageSize":"15","includeDeleted":"false","sortBy":"dateApplied","sortDir":"desc"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"PATCH","path":"/api/jobapplications/4/followup","query":{},"body":{"followUpAt":"2026-10-16"}},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"GET","path":"/api/jobapplications/4/status-suggestion","query":{},"body":null},{"method":"GET","path":"/api/jobapplications/4/workspace","query":{},"body":null},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null},{"method":"PATCH","path":"/api/jobapplications/4/followup","query":{},"body":{"followUpAt":null}},{"method":"GET","path":"/api/jobapplications/reminders","query":{"upcomingDays":"14"},"body":null}],"blockedExternalRequests":[]}
@@ -0,0 +1 @@
{"sample":{"language":"en","theme":"light","width":1440,"height":900},"job":{"id":"connected-en","title":"Faglærer i kunst og håndverk — æøå","company":"Synthetic community learning centre","location":"TRONDHEIM","modifiedAt":"2026-10-09T10:00:00Z","deadline":"2026-10-20T23:59:59Z","url":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","source":"nav","sourceName":"NAV Arbeidsplassen","acquisitionType":"searched","retrievedAt":"2026-10-10T10:00:00Z","countryCode":"NO"},"readback":{"id":1,"companyId":1,"company":{"id":1,"ownerUserId":"6c3c000a-f3c7-4fa5-a499-6d01d64e295a","name":"Synthetic community learning centre","location":"Trondheim","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Faglærer i kunst og håndverk — æøå","status":"Saved","dateApplied":null,"savedAt":"2026-11-18T17:57:58.6731019","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","description":"Syntetisk stilling: planlegg aktiviteter og undervisning i kunst og håndverk. Kilden beholdes ordrett — æøå.","translatedDescription":null,"descriptionLanguage":"nb","tags":null,"deadline":"2026-10-20T00:00:00","location":"TRONDHEIM","salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":null,"needsFollowUp":false,"followUpReason":null,"tailoredCvText":null,"workflowSignal":{"actionKey":"follow-up","reason":"No response yet and no follow-up is scheduled.","workspaceTab":"follow-up","followMode":"waiting-update","needsAttention":true,"hasPackageGap":false,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":1},"opportunity":{"source":"nav","countryCode":"NO"},"duplicates":{"hasDuplicates":true,"matches":[{"id":1,"jobTitle":"Faglærer i kunst og håndverk — æøå","company":"Synthetic community learning centre","jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","status":"Saved","dateApplied":null,"reason":"same URL, same company and similar title"}]},"trackerWrites":[{"method":"POST","path":"/api/jobapplications","query":{},"body":{"jobTitle":"Faglærer i kunst og håndverk — æøå","companyId":1,"status":"Saved","location":"TRONDHEIM","salary":"","salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","source":"nav","countryCode":"NO","description":"Syntetisk stilling: planlegg aktiviteter og undervisning i kunst og håndverk. Kilden beholdes ordrett — æøå.","translatedDescription":null,"descriptionLanguage":"nb","tags":null,"deadline":"2026-10-20","notes":"","coverLetterText":null,"dateApplied":"2026-11-18"}}],"searches":1,"previews":1,"detailViews":1,"choosers":[],"qualification":"Search, original-source popup HTML and import preview are explicitly synthetic route fixtures, with no provider fetch. Company setup/job POST/readbacks/duplicate check/foreign denial are actual disposable API. Source/country checked on the linked opportunity through a guarded read-only query of this fixture SQLite only; application DTO does not expose them. No full provider integration, canonical geography, import parser or automatic duplicate blocking claim."}
@@ -0,0 +1 @@
{"providerBoundary":"Saved-search list/create/alert PATCH/delete and readbacks use the real isolated owner API and disposable SQLite. Browser vacancy-provider /search and owner /saved-searches/{id}/run responses are intercepted because the server provider has an external NAV base URL. Intercepted runs do not create SavedJobSearchResults: successful intercepted Dismiss establishes presentation only, never runner/history/dismiss persistence or alert delivery. A real missing-result Dismiss 404 is exercised separately. The unchanged saved-search-repair suite and backend fake-provider SQLite tests retain owner/anonymous and real runner/history contracts. External browser traffic and unregistered provider-dependent requests are blocked.","requests":[{"method":"GET","path":"/api/job-discovery/saved-searches","query":{},"body":null},{"method":"GET","path":"/api/job-discovery/search","query":{"q":"kunstlærer","location":"Trondheim"},"body":null}],"blockedProviderRequests":[],"blockedExternalRequests":[],"qualification":"Browser request log contains only method/path/query/JSON payload, with no cookies or authorization/CSRF/session headers. Direct API fixture reads are verified in individual tests; this log is not a server outbound-traffic measurement."}
@@ -0,0 +1 @@
{"sample":{"language":"nb","theme":"dark","width":390,"height":844},"job":{"id":"connected-nb","title":"Faglærer i kunst og håndverk — æøå","company":"Synthetic community learning centre","location":"TRONDHEIM","modifiedAt":"2026-10-09T10:00:00Z","deadline":"2026-10-20T23:59:59Z","url":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-nb","source":"nav","sourceName":"NAV Arbeidsplassen","acquisitionType":"searched","retrievedAt":"2026-10-10T10:00:00Z","countryCode":"NO"},"readback":{"id":2,"companyId":2,"company":{"id":2,"ownerUserId":"b4e8c1e2-4a80-4b0e-b1b8-7090f4d0a690","name":"Synthetic community learning centre","location":"Trondheim","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Faglærer i kunst og håndverk — æøå","status":"Saved","dateApplied":null,"savedAt":"2026-11-18T17:58:07.3410736","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-nb","description":"Syntetisk stilling: planlegg aktiviteter og undervisning i kunst og håndverk. Kilden beholdes ordrett — æøå.","translatedDescription":null,"descriptionLanguage":"nb","tags":null,"deadline":"2026-10-20T00:00:00","location":"TRONDHEIM","salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":null,"needsFollowUp":false,"followUpReason":null,"tailoredCvText":null,"workflowSignal":{"actionKey":"follow-up","reason":"No response yet and no follow-up is scheduled.","workspaceTab":"follow-up","followMode":"waiting-update","needsAttention":true,"hasPackageGap":false,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":1},"opportunity":{"source":"nav","countryCode":"NO"},"duplicates":{"hasDuplicates":true,"matches":[{"id":2,"jobTitle":"Faglærer i kunst og håndverk — æøå","company":"Synthetic community learning centre","jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-nb","status":"Saved","dateApplied":null,"reason":"same URL, same company and similar title"}]},"trackerWrites":[{"method":"POST","path":"/api/jobapplications","query":{},"body":{"jobTitle":"Faglærer i kunst og håndverk — æøå","companyId":2,"status":"Saved","location":"TRONDHEIM","salary":"","salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-nb","source":"nav","countryCode":"NO","description":"Syntetisk stilling: planlegg aktiviteter og undervisning i kunst og håndverk. Kilden beholdes ordrett — æøå.","translatedDescription":null,"descriptionLanguage":"nb","tags":null,"deadline":"2026-10-20","notes":"","coverLetterText":null,"dateApplied":"2026-11-18"}}],"searches":1,"previews":1,"detailViews":1,"choosers":[],"qualification":"Search, original-source popup HTML and import preview are explicitly synthetic route fixtures, with no provider fetch. Company setup/job POST/readbacks/duplicate check/foreign denial are actual disposable API. Source/country checked on the linked opportunity through a guarded read-only query of this fixture SQLite only; application DTO does not expose them. No full provider integration, canonical geography, import parser or automatic duplicate blocking claim."}
@@ -0,0 +1 @@
{"providerBoundary":"Saved-search list/create/alert PATCH/delete and readbacks use the real isolated owner API and disposable SQLite. Browser vacancy-provider /search and owner /saved-searches/{id}/run responses are intercepted because the server provider has an external NAV base URL. Intercepted runs do not create SavedJobSearchResults: successful intercepted Dismiss establishes presentation only, never runner/history/dismiss persistence or alert delivery. A real missing-result Dismiss 404 is exercised separately. The unchanged saved-search-repair suite and backend fake-provider SQLite tests retain owner/anonymous and real runner/history contracts. External browser traffic and unregistered provider-dependent requests are blocked.","requests":[{"method":"GET","path":"/api/job-discovery/saved-searches","query":{},"body":null},{"method":"GET","path":"/api/job-discovery/search","query":{"q":"kunstlærer","location":"Trondheim"},"body":null}],"blockedProviderRequests":[],"blockedExternalRequests":[],"qualification":"Browser request log contains only method/path/query/JSON payload, with no cookies or authorization/CSRF/session headers. Direct API fixture reads are verified in individual tests; this log is not a server outbound-traffic measurement."}
@@ -0,0 +1,216 @@
{
"baseline": "1db5f488f6138e4f0f33749452b7d9f47658f4b0",
"roadmap": "271d37d1a875256643602db20bbd3c381a291c05",
"sourcePolicy": "LF-normalized UTF8 source; exact raw/gzip evidence bytes",
"test": {
"path": "job-tracker-ui/e2e/phase7-reminders.spec.ts",
"sha256Lf": "dab45b17dcb5963ef45f6ec8b00f5476d2eeb9e14e83776de23235ca94267e45"
},
"original": {
"originalTestSha256Lf": "b3d7281d510d19aedee125f4d2859fcc1631a01761cd0ca9c042ad43c1cd9ed9",
"originalTestSha256Raw": "fd8abe327ebbfd77fa4d62b245bb1b26dc7b34a2d670b327e9286cbf26abb341"
},
"originalSourceDerivation": "Final spec with exactly two inherited header exact-name Norsk bokmål selectors restored to Norsk",
"application": {
"frontendTree": "6a8b38361f57f199ebe298d2193de63d90b009e4",
"backendTree": "b7701b2459186f665fe5759a533b6e434cc122b0",
"backendQualifiedFrom": "eb2538772e1bfabbeb291e4a5efa177c79074de1",
"rootWorkingSourceDiffVsBaseline": "empty for job-tracker-ui/src and JobTrackerApi at entry"
},
"runs": {
"focused": {
"passed": 2,
"total": 2
},
"affectedOriginal": {
"passed": 6,
"failed": 2,
"total": 8
},
"affectedFinal": {
"passed": 8,
"failed": 0,
"total": 8
}
},
"final": {
"screenshots": 21,
"audits": 21,
"violations": 0,
"externalRequests": 0,
"cases": [
{
"title": "[P7-05 Reminders] actual empty and four workflow groups preserve counts, reasons, routes and owner boundaries",
"status": "passed"
},
{
"title": "[P7-05 connected calendar] en/1440 actual application status, follow-up and adjacent agenda stay connected",
"status": "passed"
},
{
"title": "[P7-05 connected calendar] nb/390 actual application status, follow-up and adjacent agenda stay connected",
"status": "passed"
},
{
"title": "[P7-05 Reminders] plus3, plus7 and clear persist actual dates and one history event per write with existing UTC-date semantics",
"status": "passed"
},
{
"title": "[P7-05 Reminders] held single PATCH locks every row action and failed explicit Retry preserves its captured date and moved focus",
"status": "passed"
},
{
"title": "[P7-05 Reminders] committed PATCH204 followed by a failed reload retries only GET and preserves its single history event",
"status": "passed"
},
{
"title": "[P7-05 Reminders] live EN/Bokmal translates status/date controls and generated reasons without a page-triggered refetch",
"status": "passed"
},
{
"title": "[P7-05 Reminders] eight finite bilingual theme widths preserve long rows and keyboard-accessible actions",
"status": "passed"
}
]
},
"native": [
{
"file": "connected-focused.json.gz",
"rawBytes": 581131,
"rawSha256": "226cfb760e2be6cf79bdd2be506c48ac71febcebab50ce61da8d354c4e978e37",
"gzipBytes": 371798,
"gzipSha256": "a37ab9b85aeb974a8f5836038a461c57e6a05d2d69d40cc51e62fc11bc54a553"
},
{
"file": "connected-focused.log.gz",
"rawBytes": 4652,
"rawSha256": "2b4d62119b0c20b3848250f9d80969f17b4df7acfbbae4f3625d6444be31202a",
"gzipBytes": 1366,
"gzipSha256": "c352cfd9219db1cc4f2f087dd405c2412b82d1994781613defeb197b01bd3db4"
},
{
"file": "reminders-final.json.gz",
"rawBytes": 3866522,
"rawSha256": "b2cedf914ea9c444afd67d281bdab5ab4782dfa1c59060d27adcc313b6375293",
"gzipBytes": 2577189,
"gzipSha256": "37c9b12b94ecf6032d083cbbf001a1ed052d8820b288b1840a88e0dc5bee084e"
},
{
"file": "reminders-final.log.gz",
"rawBytes": 34606,
"rawSha256": "4f11eab476bfe91d7793a70776a8e61ecda5e9c67eb3ea757fa821622d6704cc",
"gzipBytes": 4471,
"gzipSha256": "f1fe9acc7a57bf23e0a9d66a5cdfc0d7c285958148732772397565e9628a0e2c"
},
{
"file": "reminders-qualified.json.gz",
"rawBytes": 4229497,
"rawSha256": "f09e019f813f93efbbce3b4b5310cbd6191b85aa4cc2ed7c5ca8250fcfd58db4",
"gzipBytes": 2830947,
"gzipSha256": "412809283630e2690db41eb8c578061703ba9a163e1a4c161c26768766a8371c"
},
{
"file": "reminders-qualified.log.gz",
"rawBytes": 30294,
"rawSha256": "eace58032f3f7dd9c24b5753c01cce3d991036a7559339cedcb62937557f2186",
"gzipBytes": 3990,
"gzipSha256": "3d881db24c75990edadc9a4390a2173d6000409bf916bf6417377f33cb4e7933"
}
],
"limits": [
"Overlapping runs are not additive",
"SQL checklist uniqueness error remains in final raw server log; not clean-backend acceptance",
"No model/provider/delivery/MariaDB/human/device/AT or whole-A3 acceptance"
],
"artifacts": [
{
"file": "connected-calendar-native-readbacks-en-1440.json",
"bytes": 4545,
"sha256": "934daa73ae6753ad8c9655265325a674dc381953cc8388d66d760044130c0104"
},
{
"file": "connected-calendar-native-readbacks-nb-390.json",
"bytes": 4543,
"sha256": "43a1be26d0184eb8f33b08e0bb7e1fc82cc8c2fd9f6913ada69eec952f082fd4"
},
{
"file": "p7-reminders-en-light-1440-connected-cleared-selected-day-audit-en-1440.json",
"bytes": 15112,
"sha256": "660a1c13db578398904dd7070facd083ffa92ef2e6aab9037d17258b4dec8123"
},
{
"file": "p7-reminders-en-light-1440-connected-cleared-selected-day-en-1440.png",
"bytes": 103972,
"sha256": "adee1afeb5b194742c84c42b1f0bcbf96e30e324abdd472992d759148c3a2c6a"
},
{
"file": "p7-reminders-en-light-1440-connected-status-scheduled-month-audit-en-1440.json",
"bytes": 15937,
"sha256": "ea894d8ee02ff583dae5421eb9c718d68547da805c140eb336606f7d3dee0064"
},
{
"file": "p7-reminders-en-light-1440-connected-status-scheduled-month-en-1440.png",
"bytes": 108690,
"sha256": "830881f6f38db9eb88ebeeb515c6c2cb97af759f56097acdce74f472c876e8b2"
},
{
"file": "p7-reminders-nb-dark-390-connected-cleared-selected-day-audit-nb-390.json",
"bytes": 16099,
"sha256": "343f969b6f90aa67b5492cb47baddf7c47da8ab5d4cd70415d091c70a3a521c5"
},
{
"file": "p7-reminders-nb-dark-390-connected-cleared-selected-day-nb-390.png",
"bytes": 68123,
"sha256": "e1f4dc9eae3ba585e2ae3e0d114fb493da000010453ef70ed95a013e53bab726"
},
{
"file": "p7-reminders-nb-dark-390-connected-status-scheduled-month-audit-nb-390.json",
"bytes": 16901,
"sha256": "8b971da8b075a7d071f1cfa0dcbc968a4f310df541c130b8c1342a0c260422cb"
},
{
"file": "p7-reminders-nb-dark-390-connected-status-scheduled-month-nb-390.png",
"bytes": 71335,
"sha256": "cb052d8cbbbd1f947b018fef4a766e5b73d34d9389411d39cac28bbcbc878049"
}
],
"runtimeArtifacts": [
{
"file": "JobTrackerApi/bin/Release/net9.0/JobTrackerApi.dll",
"realPath": "E:\\Storage\\Projects\\Active\\temp docs\\jobjakt-local-build\\next-security-patch\\JobTrackerApi\\bin\\Release\\net9.0\\JobTrackerApi.dll",
"bytes": 11518976,
"sha256": "ac5c11394bcc6fe2272db96fc2f87143c62617120d173e7ae52ce1c15cb16227"
},
{
"file": "job-tracker-ui/out/index.html",
"realPath": "E:\\Storage\\Projects\\Active\\temp docs\\jobjakt-local-build\\next-security-patch\\job-tracker-ui\\out\\index.html",
"bytes": 9260,
"sha256": "31dfd9b2d2e7ea7d9e696b5485d24d7b8daf0b1e078e6539e94a04955b8ff1f8"
}
],
"tools": {
"node": "v24.19.0",
"typescript": "5.9.3",
"playwright": "1.62.1"
},
"checks": {
"specTypecheck": {
"exitCode": 0,
"scope": "complete phase7-reminders spec plus imported source types; no emit/incremental"
},
"scopedLint": {
"exitCode": 0,
"file": "job-tracker-ui/e2e/phase7-reminders.spec.ts"
},
"sourceDiff": {
"exitCode": 0
},
"graph": {
"command": "rtk proxy graphify update . --no-cluster",
"exitCode": 0,
"nodes": 19930,
"edges": 49369,
"scope": "AST only, untracked graph; includes owned transform-cache inputs; no semantic/provider pass"
}
}
}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","sample":{"language":"en","theme":"light","width":1440,"height":900},"waiting":{"id":7,"companyId":3,"company":{"id":3,"ownerUserId":"04543de0-8158-4a05-a3b0-91e709427821","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:30.5335702","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":"2026-10-14T00:00:00","feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":2},"scheduledItems":[{"jobApplicationId":7,"jobTitle":"Recorded community care coordinator — æøå","companyName":"Connected synthetic care employer","kind":"follow-up","date":"2026-10-16","recordedAt":"2026-10-16T00:00:00"}],"final":{"id":7,"companyId":3,"company":{"id":3,"ownerUserId":"04543de0-8158-4a05-a3b0-91e709427821","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:30.5335702","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":4},"history":[{"id":10,"type":"FollowUpSet","oldValue":"2026-10-14T00:00:00.0000000","newValue":"2026-10-16T00:00:00.0000000","note":null,"at":"2026-11-18T13:12:33.0301475"},{"id":11,"type":"FollowUpSet","oldValue":"2026-10-16T00:00:00.0000000","newValue":null,"note":null,"at":"2026-11-18T13:12:35.4187892"}],"qualification":"Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model."}
@@ -0,0 +1 @@
{"boundary":"Actual owner HTTP fixtures, follow-up PATCH204, reloads, history and ownership checks use disposable isolated SQLite. Free account entitlements disable model access; the serial runtime disables AI, follow-up delivery and saved-search alert workers. No provider/model/send endpoint, raw SQL or schema is invoked. Controlled PATCH/GET failure and held requests qualify presentation and recovery, not production reliability. Browser request metadata excludes session/CSRF headers. The Shell independently requests the identical reminders?upcomingDays=14 endpoint initially and every60s; observed counts retain that source and do not claim one total GET per page. Existing absolute-millisecond-to-UTC-date scheduling and followMode route metadata are preserved; no DST/calendar or deferred composer qualification is claimed.","sample":{"language":"nb","theme":"dark","width":390,"height":844},"waiting":{"id":8,"companyId":4,"company":{"id":4,"ownerUserId":"a89a6f7d-1fbd-445e-8749-5f1b5c4eeab8","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:37.6164347","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":"2026-10-14T00:00:00","feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":2},"scheduledItems":[{"jobApplicationId":8,"jobTitle":"Recorded community care coordinator — æøå","companyName":"Connected synthetic care employer","kind":"follow-up","date":"2026-10-16","recordedAt":"2026-10-16T00:00:00"}],"final":{"id":8,"companyId":4,"company":{"id":4,"ownerUserId":"a89a6f7d-1fbd-445e-8749-5f1b5c4eeab8","name":"Connected synthetic care employer","location":"Oslo","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Recorded community care coordinator — æøå","status":"Waiting","dateApplied":"2026-01-01T12:00:00","savedAt":"2026-11-18T12:12:37.6164347","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":null,"description":null,"translatedDescription":null,"descriptionLanguage":null,"tags":null,"deadline":null,"location":null,"salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":321,"needsFollowUp":true,"followUpReason":"Waiting 14d","tailoredCvText":null,"workflowSignal":{"actionKey":"package-work","reason":"Tailored CV and saved application answers still need work.","workspaceTab":"tailored-cv","followMode":null,"needsAttention":true,"hasPackageGap":true,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":4},"history":[{"id":14,"type":"FollowUpSet","oldValue":"2026-10-14T00:00:00.0000000","newValue":"2026-10-16T00:00:00.0000000","note":null,"at":"2026-11-18T13:12:40.7958794"},{"id":15,"type":"FollowUpSet","oldValue":"2026-10-16T00:00:00.0000000","newValue":null,"note":null,"at":"2026-11-18T13:12:43.2443118"}],"qualification":"Actual disposable status/followup/calendar/workspace HTTP. Preserved UTC-slice scheduling only; no delivery/provider, timezone migration or interview appointment model."}
@@ -0,0 +1,110 @@
{
"baseline": "1db5f488f6138e4f0f33749452b7d9f47658f4b0",
"qualification": "Test-only connected journeys against frozen existing export/API, no provider/model execution. Native readbacks and four scoped axe scans, not full visual acceptance.",
"stats": {
"startTime": "2026-11-18T17:40:00.807Z",
"duration": 25672.649,
"expected": 2,
"skipped": 0,
"unexpected": 0,
"flaky": 0
},
"sourcesLfSha256": {
"job-tracker-ui/e2e/phase7-discovery.spec.ts": "bcf2c84d0bc86d6fa6fdf43b62eaa70e066acf3ba1425b9496b6c9ea5ac7de46",
"job-tracker-ui/package-lock.json": "7ebd728f99a1ed9a5334542fb578b30127b4a0c7984efe2913266e89e2fbfbd3",
"job-tracker-ui/playwright.config.ts": "9252c961ac2779485bb72b24c31d526773d7c09f764eca638c4c1d47235e9f65",
"job-tracker-ui/src/i18n/translations.ts": "2b29e81921fc44fba95df62497dba18fb8d91568340aa529f7d25eef93b032ab"
},
"artifacts": [
{
"file": "focused.json.gz",
"bytes": 147829,
"sha256": "1124afe68404328500a5134be29b51b0039efdc035146c147539f03900fb29e8"
},
{
"file": "focused.log.gz",
"bytes": 2437,
"sha256": "62fef0f99dfb844ff1562186e01ca819c7e4014b00aa2b1ccb5b859a0e3fb190"
},
{
"file": "corrected.json.gz",
"bytes": 233327,
"sha256": "8de56092bc1e8f90606293b63e55e84ea5842027790b888c6dfdf2dcec23b9e0"
},
{
"file": "corrected.log.gz",
"bytes": 2273,
"sha256": "7a79a52766d2f1d58a0cea5cfdd539f8f27742cd950555d818aae430b53482c9"
},
{
"file": "final.json.gz",
"bytes": 358425,
"sha256": "866e94ea9dc5043b46e3645afdd82a40434061b1ef1740e418e0f2b14c277c37"
},
{
"file": "final.log.gz",
"bytes": 1384,
"sha256": "e98d65b77b35182f0015c55feaa42429e822bd7a28d6e5845e2d56a6fba0d851"
},
{
"file": "en-p7-discovery-en-light-1440-connected-fixture-result-return-audit.json",
"bytes": 10842,
"sha256": "e4e1d4f32458c44791fca7bd034fe9d45700316c9b6052cb776f197e2929ea22"
},
{
"file": "en-p7-discovery-en-light-1440-connected-fixture-result-return.png",
"bytes": 93797,
"sha256": "bc28e6a338769f4baf7ad7dae14e0516c98a19e312114992b8f9326862e838f7"
},
{
"file": "en-connected-native-tracker-readbacks.json",
"bytes": 3739,
"sha256": "e078245f64ce5513057710f0d3c9395f159b9b72438bf38858ebf21a857b7e98"
},
{
"file": "en-p7-discovery-en-light-1440-connected-native-workspace-audit.json",
"bytes": 9268,
"sha256": "e115a6a6872110091799baa9484906779365bf33d36e70053a858288bbfaa07a"
},
{
"file": "en-p7-discovery-en-light-1440-connected-native-workspace.png",
"bytes": 122650,
"sha256": "556c5e697bc05f1094a183ed9493403971643dbbb26e2dd74c2e35e2a69a24b1"
},
{
"file": "en-discovery-request-boundary.json",
"bytes": 1264,
"sha256": "1b566579e51d569be46ed43d6fc8fb8b4cf4959831493bccb0dd67086fe2ed30"
},
{
"file": "nb-p7-discovery-nb-dark-390-connected-fixture-result-return-audit.json",
"bytes": 11333,
"sha256": "f9a09992219a3a5ff0f9848785227eccb34f336af3281c4343fc6665aab4e52d"
},
{
"file": "nb-p7-discovery-nb-dark-390-connected-fixture-result-return.png",
"bytes": 41080,
"sha256": "907ab5bba5793caa220a974506b791b28183e1e1b1bde82b26bb8ba3d69634e7"
},
{
"file": "nb-connected-native-tracker-readbacks.json",
"bytes": 3737,
"sha256": "88610906a3b65175350b5a83b55795e029b878b90cf5967bcead821ed50991ce"
},
{
"file": "nb-p7-discovery-nb-dark-390-connected-native-workspace-audit.json",
"bytes": 14328,
"sha256": "714231108ce7ee9781e16d3ac6a4780eaada0685e15c2b03ec7e3be713c40614"
},
{
"file": "nb-p7-discovery-nb-dark-390-connected-native-workspace.png",
"bytes": 81638,
"sha256": "eacdcadd05b014cb45e0038486513fa828a7a099f004c73d3468ebd5d597db1b"
},
{
"file": "nb-discovery-request-boundary.json",
"bytes": 1264,
"sha256": "1b566579e51d569be46ed43d6fc8fb8b4cf4959831493bccb0dd67086fe2ed30"
}
]
}
@@ -0,0 +1 @@
{"sample":{"language":"en","theme":"light","width":1440,"height":900},"job":{"id":"connected-en","title":"Faglærer i kunst og håndverk — æøå","company":"Synthetic community learning centre","location":"TRONDHEIM","modifiedAt":"2026-10-09T10:00:00Z","deadline":"2026-10-20T23:59:59Z","url":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","source":"nav","sourceName":"NAV Arbeidsplassen","acquisitionType":"searched","retrievedAt":"2026-10-10T10:00:00Z","countryCode":"NO"},"readback":{"id":1,"companyId":1,"company":{"id":1,"ownerUserId":"c3b9c5f7-7ffe-4e21-8dfc-0b68365e85ed","name":"Synthetic community learning centre","location":"Trondheim","source":"User","recruiterName":null,"recruiterEmail":null,"recruiterLinkedIn":null,"lastContactedAt":null,"nextContactAt":null,"pipelineStage":null},"jobTitle":"Faglærer i kunst og håndverk — æøå","status":"Saved","dateApplied":null,"savedAt":"2026-11-18T17:40:14.1198041","responseReceived":false,"responseDate":null,"notes":null,"coverLetterText":null,"jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","description":"Syntetisk stilling: planlegg aktiviteter og undervisning i kunst og håndverk. Kilden beholdes ordrett — æøå.","translatedDescription":null,"descriptionLanguage":"nb","tags":null,"deadline":"2026-10-20T00:00:00","location":"TRONDHEIM","salary":null,"salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"feedbackRequestedAt":null,"hasResume":false,"hasCoverLetter":false,"hasPortfolio":false,"hasOtherAttachment":false,"isDeleted":false,"deletedAt":null,"daysSince":null,"needsFollowUp":false,"followUpReason":null,"tailoredCvText":null,"workflowSignal":{"actionKey":"follow-up","reason":"No response yet and no follow-up is scheduled.","workspaceTab":"follow-up","followMode":"waiting-update","needsAttention":true,"hasPackageGap":false,"needsInterviewPrep":false,"needsFollowUpAction":true,"hasTailoredCv":false,"hasSavedApplicationAnswerDraft":false,"hasInterviewPrepNotes":false},"shortSummary":null,"fullSummary":null,"version":1},"opportunity":{"source":"nav","countryCode":"NO"},"duplicates":{"hasDuplicates":true,"matches":[{"id":1,"jobTitle":"Faglærer i kunst og håndverk — æøå","company":"Synthetic community learning centre","jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","status":"Saved","dateApplied":null,"reason":"same URL, same company and similar title"}]},"trackerWrites":[{"method":"POST","path":"/api/jobapplications","query":{},"body":{"jobTitle":"Faglærer i kunst og håndverk — æøå","companyId":1,"status":"Saved","location":"TRONDHEIM","salary":"","salaryMin":null,"salaryMax":null,"salaryCurrency":null,"salaryPeriod":null,"nextAction":null,"followUpAt":null,"jobUrl":"https://arbeidsplassen.nav.no/stillinger/stilling/connected-en","source":"nav","countryCode":"NO","description":"Syntetisk stilling: planlegg aktiviteter og undervisning i kunst og håndverk. Kilden beholdes ordrett — æøå.","translatedDescription":null,"descriptionLanguage":"nb","tags":null,"deadline":"2026-10-20","notes":"","coverLetterText":null,"dateApplied":"2026-11-18"}}],"searches":1,"previews":1,"detailViews":1,"choosers":[],"qualification":"Search, original-source popup HTML and import preview are explicitly synthetic route fixtures, with no provider fetch. Company setup/job POST/readbacks/duplicate check/foreign denial are actual disposable API. Source/country checked on the linked opportunity through a guarded read-only query of this fixture SQLite only; application DTO does not expose them. No full provider integration, canonical geography, import parser or automatic duplicate blocking claim."}
@@ -0,0 +1 @@
{"providerBoundary":"Saved-search list/create/alert PATCH/delete and readbacks use the real isolated owner API and disposable SQLite. Browser vacancy-provider /search and owner /saved-searches/{id}/run responses are intercepted because the server provider has an external NAV base URL. Intercepted runs do not create SavedJobSearchResults: successful intercepted Dismiss establishes presentation only, never runner/history/dismiss persistence or alert delivery. A real missing-result Dismiss 404 is exercised separately. The unchanged saved-search-repair suite and backend fake-provider SQLite tests retain owner/anonymous and real runner/history contracts. External browser traffic and unregistered provider-dependent requests are blocked.","requests":[{"method":"GET","path":"/api/job-discovery/saved-searches","query":{},"body":null},{"method":"GET","path":"/api/job-discovery/search","query":{"q":"kunstlærer","location":"Trondheim"},"body":null}],"blockedProviderRequests":[],"blockedExternalRequests":[],"qualification":"Browser request log contains only method/path/query/JSON payload, with no cookies or authorization/CSRF/session headers. Direct API fixture reads are verified in individual tests; this log is not a server outbound-traffic measurement."}

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