Nick SzaunigandClaude Opus 5.5
c01a38835a
Platform backbone (plan 2026-10-13-plattform-rueckgrat), reviewed tasks: - run roles api/worker/job/all with shared startup checks (Task 1) - schema and migration for DomainEvent, deliveries, JobRun, ThrottlerHit (Task 2) - audit, notifications and domain events written in the same transaction (Task 3) - dispatcher with SKIP LOCKED claims, retries and stale release (Task 4) - worker building blocks: tick, LISTEN/NOTIFY wake-up, health (Task 5) - worker process and entry points (Task 6) - throttler counters in Postgres (Task 19) - separate keys per purpose with key ring (Task 20) - public origin page without exact location (Task 22) - shop keys split into read and write (Task 23) - Kustomize base, components, overlay encry, CI validation (Task 26) Field capture T3 (plan 2026-10-13-t3-erfassung-am-stand), reviewed tasks: - brood frames, read endpoints, apiary overview and offline pack - network basics, offline queue v3, navigation sheets, form building blocks - new inspection with last-time hints and weather, varroa per day, treatment prefill, apiary page with round - inspection photo (Task 10) is implemented, review pending Not rolled out. Remaining tasks follow in later commits. Co-Authored-By: Claude Opus 5.5 (1M context) <[email protected]>
65 lines
2.0 KiB
TypeScript
65 lines
2.0 KiB
TypeScript
import { Client } from 'pg';
|
|
import { dbSessionConfig } from '../src/prisma/db-session';
|
|
import { PrismaService } from '../src/prisma/prisma.service';
|
|
|
|
/**
|
|
* Prisma fills @default(now()) on the client as UTC wall clock, SQL now()
|
|
* stores the session's wall clock - both in `timestamp without time zone`
|
|
* columns. They only agree if every session runs in UTC, whatever the
|
|
* server or database default is (the local test DB runs Europe/Berlin).
|
|
*/
|
|
describe('Database session time zone (e2e)', () => {
|
|
let prisma: PrismaService;
|
|
const aggregateId = `tz-${Date.now()}-${Math.round(Math.random() * 1e6)}`;
|
|
|
|
beforeAll(() => {
|
|
prisma = new PrismaService();
|
|
});
|
|
|
|
afterAll(async () => {
|
|
await prisma.domainEvent.deleteMany({ where: { aggregateId } });
|
|
await prisma.$disconnect();
|
|
});
|
|
|
|
it('runs a fresh Prisma connection in UTC', async () => {
|
|
const [{ TimeZone }] = await prisma.$queryRaw<
|
|
{ TimeZone: string }[]
|
|
>`SHOW TIME ZONE`;
|
|
|
|
expect(TimeZone).toBe('UTC');
|
|
});
|
|
|
|
it('writes a Prisma default timestamp and SQL now() on the same clock', async () => {
|
|
const seconds = await prisma.$transaction(async (tx) => {
|
|
const event = await tx.domainEvent.create({
|
|
data: {
|
|
type: 'TaskDue',
|
|
aggregateType: 'Task',
|
|
aggregateId,
|
|
payload: { dueOn: '2026-10-13' },
|
|
correlationId: aggregateId,
|
|
},
|
|
});
|
|
const [{ s }] = await tx.$queryRaw<
|
|
{ s: number }[]
|
|
>`SELECT EXTRACT(EPOCH FROM now() - "occurredAt")::float AS s FROM "DomainEvent" WHERE "id" = ${event.id}`;
|
|
return s;
|
|
});
|
|
|
|
expect(Math.abs(seconds)).toBeLessThan(1);
|
|
});
|
|
|
|
it('runs a raw pg connection with the shared session options in UTC (LISTEN client)', async () => {
|
|
const client = new Client(dbSessionConfig(process.env.DATABASE_URL));
|
|
await client.connect();
|
|
try {
|
|
const { rows } = await client.query<{ TimeZone: string }>(
|
|
'SHOW TIME ZONE',
|
|
);
|
|
expect(rows[0].TimeZone).toBe('UTC');
|
|
} finally {
|
|
await client.end();
|
|
}
|
|
});
|
|
});
|