Rebasely Beta: data may be purged

justintsus-experiment Public

JavaScript · 179 lines · 6.8 KiB · at 8e57616

// 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]);  });});