mirror of
https://github.com/MBombeck/HealthLog.git
synced 2026-11-07 04:12:04 +00:00
Marc-André Bombeck
9cc77c79fc
The summaries slice and the comprehensive aggregator took their JS windows (the DAY-bucket bounds, the rollup slope anchors, lastSeen staleness) from the process clock and their SQL windows (avg7, avg30, the month before, the median, the 90-day canonical pick, the cold-path slope evidence) from NOW(), the database's clock. One response mixed two clocks, so a reading on a window's edge fell in or out with whichever host answered, and with the process clock pinned the analytics parity walk changed its avg7 with the hour it ran at. Each read now takes one `now` and binds it into its statements (`request-clock-sql.ts`): `$N::timestamp`, which keeps the driver's offset-free UTC string as written in any session zone. The canonical-pick helper takes its window as an instant plus an interval instead of reading NOW(); the series and calendar readers anchor it on their own `since`, the BP-in-target read on its 365-day start. The window-mean and live-slope columns the two aggregates each spelled out now come from one builder. The streak's local day series read its bounds through `::timestamptz`, which follows the session zone: outside a UTC session today's reading fell out of the streak. It reads them as UTC first. The parity walks for analytics, the dashboard summary and the comprehensive overview pin a fixed day instead of today: their records are laid out from the anchor day, so the chronotype's work and free nights and the weight-by-weekday points moved with the weekday the walk ran on. The snapshots are unchanged. A new suite pins the clock to four times of day, far from the database clock, with readings ten minutes either side of every edge, on both read paths, in a UTC and an Auckland session.
21 lines
719 B
TypeScript
21 lines
719 B
TypeScript
/**
|
|
* The summary windows count from the request's clock, in the UTC session
|
|
* every connection runs in (see `request-clock-windows.cases.ts`).
|
|
*/
|
|
import { describe, vi } from "vitest";
|
|
|
|
// The read path's fire-and-forget refresh would build the rollup tier behind
|
|
// the live case; the cases build it themselves when they mean to.
|
|
vi.mock("@/lib/rollups/measurement-rollups", async (importOriginal) => ({
|
|
...(await importOriginal<
|
|
typeof import("@/lib/rollups/measurement-rollups")
|
|
>()),
|
|
ensureUserRollupsFresh: async () => {},
|
|
}));
|
|
|
|
import { defineRequestClockCases } from "./request-clock-windows.cases";
|
|
|
|
describe("summary windows on the request's clock", () => {
|
|
defineRequestClockCases("UTC");
|
|
});
|