justintsus-experiment Public
// What queries match, run on SQLite with the brief's fixture (BRIEF.md, "Semantics"). Expected// rows are listed in the default order (created-desc) unless the query sorts.import assert from "node:assert/strict";import { describe, test } from "node:test";import { ALICE, ANON, BOB, CTX, fixture, ME, numbers } from "./helpers.mjs";const db = fixture();const issues = (q, ctx = CTX) => numbers(db, q, "issues", ctx);const pulls = (q, ctx = CTX) => numbers(db, q, "pulls", ctx);describe("issues: state, labels, order", () => { test("the empty query lists every issue in scope, newest created first", () => { assert.deepEqual(issues(""), [7, 5, 4, 3, 2, 1, 8, 6]); }); test("is:open, is:closed and -is:open", () => { assert.deepEqual(issues("is:open"), [7, 5, 4, 2, 1]); assert.deepEqual(issues("is:closed"), [3, 8, 6]); assert.deepEqual(issues("-is:open"), [3, 8, 6]); assert.deepEqual(issues("is:open is:closed"), [], "terms are ANDed"); }); test("label:bug, and label:bug -label:wontfix", () => { assert.deepEqual(issues("label:bug"), [3, 2, 1, 8]); assert.deepEqual(issues("label:bug -label:wontfix"), [2, 1, 8]); }); test('label:"needs review" matches the whole label, and label:BUG equals label:bug', () => { assert.deepEqual(issues('label:"needs review"'), [2]); assert.deepEqual(issues("label:needs"), []); assert.deepEqual(issues("label:BUG"), issues("label:bug")); }); test("no:label", () => { assert.deepEqual(issues("no:label"), [4, 6]); }); test("sort:comments-desc and -asc, ties broken by number in the same direction", () => { assert.deepEqual(issues("sort:comments-desc"), [2, 8, 5, 1, 6, 4, 7, 3]); assert.deepEqual(issues("sort:comments-asc"), [3, 7, 4, 6, 1, 5, 8, 2]); }); test("sort:created-asc, sort:updated-asc and sort:updated-desc", () => { assert.deepEqual(issues("sort:created-asc"), [6, 8, 1, 2, 3, 4, 5, 7]); assert.deepEqual(issues("sort:updated-asc"), [6, 8, 3, 1, 2, 5, 4, 7]); assert.deepEqual(issues("sort:updated-desc"), [7, 4, 5, 2, 1, 3, 8, 6]); }); test("#n picks one issue; two numbers match nothing; a missing number matches nothing", () => { assert.deepEqual(issues("#3"), [3]); assert.deepEqual(issues("#3 #4"), []); assert.deepEqual(issues("#99"), []); });});describe("issues: people", () => { test("author:@me is the viewer", () => { assert.deepEqual(issues("author:@me"), [1, 8]); }); test("author:@me with no viewer matches nothing; -author:@me then matches everything", () => { assert.deepEqual(issues("author:@me", ANON), []); assert.deepEqual(issues("-author:@me", ANON), [7, 5, 4, 3, 2, 1, 8, 6]); }); test("author:<uuid>, in any case", () => { assert.deepEqual(issues(`author:${ALICE}`), [3, 2]); assert.deepEqual(issues(`author:${ALICE.toUpperCase()}`), [3, 2]); assert.deepEqual(issues(`-author:${ALICE}`), [7, 5, 4, 1, 8, 6]); }); test("author:<slug> is the agent of the repository's organization only", () => { assert.deepEqual(issues("author:fixer"), [5]); assert.deepEqual(issues("author:FIXER"), [5]); assert.deepEqual(issues("author:nobody-here"), []); });});describe("issues: free text", () => { test("a word matches the title or the body, ASCII case-insensitively", () => { assert.deepEqual(issues("crash"), [1]); assert.deepEqual(issues("STACK"), [1]); }); test("a phrase is one substring; bare words are separate terms", () => { assert.deepEqual(issues('"login fails"'), [7, 2]); assert.deepEqual(issues('"fails login"'), []); assert.deepEqual(issues("fails login"), [7, 2]); }); test("OR is an ordinary word", () => { assert.deepEqual(issues("OR"), [5, 4, 3]); assert.deepEqual(issues("is:closed OR is:open"), []); }); test("% and _ are matched literally", () => { assert.deepEqual(issues("100%"), [2]); assert.deepEqual(issues("a_c"), [4]); }); test("a backslash is matched literally", () => { assert.deepEqual(issues("a\\b"), [6]); assert.deepEqual(issues("Ünïcode"), [4], "unicode matches exactly"); assert.deepEqual(issues("🐛"), [4], "so does an emoji"); }); test("a double quote inside a phrase matches", () => { assert.deepEqual(issues('"say \\"hi\\""'), [5]); }); test("-word excludes issues whose title or body has it", () => { assert.deepEqual(issues("-crash"), [7, 5, 4, 3, 2, 8, 6]); assert.deepEqual(issues('-"login fails"'), [5, 4, 3, 1, 8, 6]); }); test("text and qualifiers combine", () => { assert.deepEqual(issues("is:open label:bug fails"), [2]); assert.deepEqual(issues(`docs -label:wontfix author:${BOB}`), [7]); });});describe("pulls", () => { test("the empty query lists every pull request in scope, newest created first", () => { assert.deepEqual(pulls(""), [6, 2, 1, 4, 3, 5]); }); test("is:open includes drafts; is:closed includes merged (as on GitHub)", () => { assert.deepEqual(pulls("is:open"), [6, 2, 1]); assert.deepEqual(pulls("is:closed"), [4, 3, 5]); assert.deepEqual(pulls("-is:closed"), [6, 2, 1]); }); test("is:merged and -is:merged", () => { assert.deepEqual(pulls("is:merged"), [3]); assert.deepEqual(pulls("-is:merged"), [6, 2, 1, 4, 5]); }); test("is:draft in any state, -is:draft, and is:open -is:draft", () => { assert.deepEqual(pulls("is:draft"), [2, 5]); assert.deepEqual(pulls("-is:draft"), [6, 1, 4, 3]); assert.deepEqual(pulls("is:open -is:draft"), [6, 1]); }); test("author: matches the author or the agent's owner", () => { assert.deepEqual(pulls("author:@me"), [2, 1]); assert.deepEqual(pulls(`author:${BOB}`), [6, 4]); assert.deepEqual(pulls("author:fixer"), [2]); assert.deepEqual(pulls("author:@me", { ...CTX, viewerId: ME.replace(/1/g, "9") }), []); }); test("-author: keeps pull requests whose owner_id is NULL", () => { assert.deepEqual(pulls("-author:@me"), [6, 4, 3, 5]); assert.deepEqual(pulls(`-author:${BOB}`), [2, 1, 3, 5]); }); test("review-requested: looks at this repository's requests only", () => { assert.deepEqual(pulls("review-requested:@me"), [1, 4]); assert.deepEqual(pulls(`review-requested:${ALICE}`), [3]); assert.deepEqual(pulls("-review-requested:@me"), [6, 2, 3, 5]); }); test("review-requested:@me with no viewer matches nothing; its negation matches everything", () => { assert.deepEqual(pulls("review-requested:@me", ANON), []); assert.deepEqual(pulls("-review-requested:@me", ANON), [6, 2, 1, 4, 3, 5]); }); test("free text matches the title, with % and _ literal", () => { assert.deepEqual(pulls("100%"), [3]); assert.deepEqual(pulls("a_b"), [4]); assert.deepEqual(pulls("DRAFT"), [2, 5]); }); test("sort:updated-desc and #n", () => { assert.deepEqual(pulls("sort:updated-desc"), [1, 2, 6, 3, 4, 5]); assert.deepEqual(pulls("#4"), [4]); });});