justintsus-experiment Public
// Date filters: UTC days, operators, ranges, relative ages and validation (BRIEF.md, "Date filters").// Fixture times sit on the boundaries: issue 1 was created at 2026-09-30T23:59:59.999Z, issue 2 at// 2026-10-01T00:00Z, issue 3 at 2026-10-01T23:59:59.999Z, issue 4 at 2026-10-02T00:00Z; issues 1,// 2 and 3 were updated exactly 7 days, 7 days minus 1 ms and 7 days plus 1 ms before now.import assert from "node:assert/strict";import { describe, test } from "node:test";import { CTX, DAY, canon, codes, fixture, numbers } from "./helpers.mjs";const db = fixture();const issues = (q, ctx = CTX) => numbers(db, q, "issues", ctx);describe("dates: absolute", () => { test("a bare day is that UTC day, both ends exact", () => { assert.deepEqual(issues("created:2026-10-01"), [3, 2]); }); test("> a day starts the next day; >= a day includes the day", () => { assert.deepEqual(issues("created:>2026-10-01"), [7, 5, 4]); assert.deepEqual(issues("created:>=2026-10-01"), [7, 5, 4, 3, 2]); }); test("< a day ends before it; <= a day includes all of it", () => { assert.deepEqual(issues("created:<2026-10-01"), [1, 8, 6]); assert.deepEqual(issues("created:<=2026-10-01"), [3, 2, 1, 8, 6]); }); test("a range includes both days whole", () => { assert.deepEqual(issues("created:2026-09-30..2026-10-01"), [3, 2, 1]); assert.deepEqual(issues("created:2026-10-01..2026-10-01"), [3, 2]); }); test("open-ended ranges with *", () => { assert.deepEqual(issues("created:2026-10-02..*"), [7, 5, 4]); assert.deepEqual(issues("created:*..2026-09-30"), [1, 8, 6]); }); test("a leap day exists in 2024", () => { assert.deepEqual(issues("created:2024-02-29"), [6]); }); test("two date terms are ANDed", () => { assert.deepEqual(issues("created:>=2026-10-01 created:<2026-10-02"), [3, 2]); }); test("pulls filter on created_at and updated_at too", () => { assert.deepEqual(numbers(db, "created:>=2026-10-01", "pulls"), [6, 2, 1]); assert.deepEqual(numbers(db, "updated:>7d", "pulls"), [4, 3, 5]); });});describe("dates: relative ages", () => { test("<7d: younger than 7 days (exactly 7 days old is not); <=7d: at most 7 days old", () => { assert.deepEqual(issues("updated:<7d"), [7, 5, 4, 2]); assert.deepEqual(issues("updated:<=7d"), [7, 5, 4, 2, 1]); }); test(">7d: older than 7 days; >=7d: at least 7 days old", () => { assert.deepEqual(issues("updated:>7d"), [3, 8, 6]); assert.deepEqual(issues("updated:>=7d"), [3, 1, 8, 6]); }); test("1w and 168h are 7d", () => { assert.deepEqual(issues("updated:<1w"), [7, 5, 4, 2]); assert.deepEqual(issues("updated:<168h"), [7, 5, 4, 2]); }); test("hours: <2h and <1h (exactly an hour old is not younger than 1h)", () => { assert.deepEqual(issues("updated:<2h"), [7, 4]); assert.deepEqual(issues("updated:<1h"), [7]); }); test("relative dates use ctx.now, not the clock", () => { assert.deepEqual(issues("updated:<7d", { ...CTX, now: CTX.now + DAY }), [7, 5, 4]); assert.deepEqual(issues("updated:<7d", { ...CTX, now: CTX.now - DAY }), [7, 5, 4, 3, 2, 1]); }); test("relative and absolute on created: together", () => { assert.deepEqual(issues("created:<30d created:<2026-10-10"), [4, 3, 2, 1]); });});describe("dates: validation", () => { test("impossible or malformed days are bad_date", () => { for (const q of ["created:2026-02-29", "created:2026-13-01", "created:2026-00-10", "created:2026-04-31", "created:2026-1-01", "created:26-10-01", "created:1969-12-31", "created:2026-10-01T00:00", "created:2026/10/01", "created:yesterday"]) { assert.deepEqual(codes(q), ["bad_date"], q); } }); test("operators: = is not one, and an operator needs a date", () => { for (const q of ["created:=2026-10-01", "created:>=", "created:<", "created:>>2026-10-01", "created:=>2026-10-01"]) assert.deepEqual(codes(q), ["bad_date"], q); }); test("ranges: reversed, *..*, missing sides and relative sides are bad_date", () => { for (const q of ["created:2026-10-01..2026-09-30", "created:*..*", "created:..2026-10-01", "created:2026-10-01..", "created:7d..*", "created:>2026-10-01..*"]) { assert.deepEqual(codes(q), ["bad_date"], q); } }); test("relative values: an operator is required, N is 1 to 9999, units are h, d, w", () => { for (const q of ["updated:7d", "updated:<0d", "updated:<10000d", "updated:<7m", "updated:<7y", "updated:<d", "updated:<1.5d", "updated:<-1d"]) { assert.deepEqual(codes(q), ["bad_date"], q); } assert.equal(canon("updated:<9999d updated:<1h updated:>=0007W"), "updated:<9999d updated:<1h updated:>=7w"); });});