[{"_1":2,"_181":-5,"_182":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","9d6c1783bea8575660da505e921aa115b9856783","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_157":158,"_178":179,"_180":-5},"handle","pql","name","SQLiteTable","path","tests/query-options.test.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_12":114,"_115":-5,"_116":109,"_117":-5,"_118":-5,"_119":33,"_14":120,"_121":122,"_123":124,"_125":-5,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":135,"_138":139,"_143":144,"_156":20},"id","29484b28-27b6-11f0-aecd-569c3dd06744","createdAt",["D",1746232377860],"deletedAt","legacyEnvVars",true,"privacy","public","description","imageUrl","f129b0f0-09bd-41ac-a51c-c16933d81d65","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","5cdb635f-04df-409e-bb23-93b87a60f6ca","tursoName","29484b2827b611f0aecd569c3dd06744","tursoHostname","29484b2827b611f0aecd569c3dd06744-val-town.aws-us-east-2.turso.io","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_136":137},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJrYUVVM1VyRHRhckNnNGxidGEwUUdaSFRDYSJ9","org",{"_95":96,"_140":137,"_12":114,"_141":142},"avatar","tier","pro","branch",{"_145":146,"_97":45,"_103":147,"_148":104,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":98,"_155":96},"version",495,"29488f20-27b6-11f0-aecd-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":159,"_97":160,"_161":162,"_163":164,"_165":147,"_166":167,"_168":109,"_105":169,"_145":33,"_170":171,"_172":173,"_174":20,"_175":-5,"_99":176},"47c0ba52-1768-11f1-8d8b-42dde27851f2","query-options.test.ts","fileId","47c0bb1a-1768-11f1-8d8b-42dde27851f2","parentId","01db20b8-1768-11f1-aed8-42dde27851f2","branchId","branchVersion",440,"latest",["D",1772587207297],"fileType","script","content","// Tests for SelectOutputOptions passed to getRow() and getRows():\n// • No condition (return any row / all rows)\n// • Column projection via the `columns` option\n// • Ordering via `ascendBy` / `descendBy`\n// • Row cap via `limit`\n// • Combining options (columns + ordering, condition + ordering, etc.)\n// • Edge case: empty table returns [] / empty ResultSet\n//\n// NOTE: At entry the table may contain rows with null scores from the\n// conditions suite. getRowsEmptyTable() clears and re-seeds a clean set of\n// five rows that subsequent tests in this file rely on.\n\nimport { assert, assertEqual } from \"./helpers.ts\";\nimport { _testTable } from \"./fixtures.ts\";\n\nexport const queryOptionTests = [\n\n // ── getRow options ────────────────────────────────────────────────────────\n\n async function getRowNoCondition() {\n // Omitting a condition should return the first available row, not throw.\n const row = await _testTable.getRow(undefined, { json: true });\n assert(row !== undefined, \"getRow with no condition should return a row\");\n assert(\"id\" in row, \"returned row should have an 'id' field\");\n },\n\n async function getRowColumns() {\n // The `columns` option should limit which fields appear in the result.\n const row = await _testTable.getRow({ id: 1 }, {\n json: true,\n columns: [\"id\", \"name\"],\n });\n assert(row !== undefined, \"getRow with columns should return a row\");\n assert(\"id\" in row, \"row should have 'id'\");\n assert(\"name\" in row, \"row should have 'name'\");\n assert(!(\"score\" in row), \"row should not have 'score' when excluded via columns\");\n },\n\n // ── getRows edge cases ────────────────────────────────────────────────────\n\n async function getRowsEmptyTable() {\n // JSON output on an empty table should be an empty array.\n // Raw output should have a rows array of length 0.\n await _testTable.deleteRows();\n const rows = await _testTable.getRows(undefined, { json: true });\n assertEqual(rows, [], \"getRows on empty table should return []\");\n const raw = await _testTable.getRows();\n assert(raw.rows.length === 0, \"raw getRows on empty table should have 0 rows\");\n\n // Re-seed five rows for the remaining tests in this file.\n await _testTable.insertRow({ id: 1, name: \"Alice\", score: 42 });\n await _testTable.insertRow({ id: 2, name: \"Bob\", score: 99 });\n await _testTable.insertRow({ id: 3, name: \"Charlie\", score: 7 });\n await _testTable.insertRow({ id: 4, name: \"Dave\", score: 55 });\n await _testTable.insertRow({ id: 5, name: \"Eve\", score: 60 });\n },\n\n // ── limit ─────────────────────────────────────────────────────────────────\n\n async function getRowsLimitOnly() {\n // `limit` should cap the number of returned rows regardless of ordering.\n const rows = await _testTable.getRows(undefined, { json: true, limit: 2 });\n assertEqual(rows.length, 2, \"limit alone should cap results to 2 rows\");\n },\n\n // ── columns + ordering ────────────────────────────────────────────────────\n\n async function getRowsColumnsWithOrdering() {\n // Combining `columns` and `ascendBy` should both filter fields and sort.\n const rows = await _testTable.getRows(undefined, {\n json: true,\n ascendBy: \"score\",\n columns: [\"id\", \"score\"],\n });\n assert(rows.length > 1, \"should return multiple rows\");\n assert(!(\"name\" in rows[0]), \"name should be excluded via columns\");\n assert(\"score\" in rows[0], \"score should be present\");\n for (let i = 1; i < rows.length; i++) {\n assert(\n rows[i].score >= rows[i - 1].score,\n \"rows should be in ascending order by score\",\n );\n }\n },\n\n // ── freeform condition + ordering ─────────────────────────────────────────\n\n async function getRowsFreeformConditionWithOrdering() {\n // A raw SQL condition string and `descendBy` should compose correctly.\n const rows = await _testTable.getRows(\"score > 10\", {\n json: true,\n descendBy: \"score\",\n });\n assert(\n rows.every((r: any) => r.score > 10),\n \"all rows should satisfy score > 10\",\n );\n for (let i = 1; i < rows.length; i++) {\n assert(\n rows[i].score <= rows[i - 1].score,\n \"rows should be in descending order by score\",\n );\n }\n },\n\n // ── ascendBy ─────────────────────────────────────────────────────────────\n\n async function getRowsAscendBy() {\n // `ascendBy` should return all rows sorted lowest → highest.\n const rows = await _testTable.getRows(undefined, {\n json: true,\n ascendBy: \"score\",\n });\n assert(Array.isArray(rows) && rows.length > 1, \"ascendBy should return multiple rows\");\n for (let i = 1; i < rows.length; i++) {\n assert(\n rows[i].score >= rows[i - 1].score,\n `row ${i} score (${rows[i].score}) should be >= row ${i - 1} score (${rows[i - 1].score})`,\n );\n }\n },\n\n // ── descendBy ────────────────────────────────────────────────────────────\n\n async function getRowsDescendBy() {\n // `descendBy` should return all rows sorted highest → lowest.\n const rows = await _testTable.getRows(undefined, {\n json: true,\n descendBy: \"score\",\n });\n assert(Array.isArray(rows) && rows.length > 1, \"descendBy should return multiple rows\");\n for (let i = 1; i < rows.length; i++) {\n assert(\n rows[i].score <= rows[i - 1].score,\n `row ${i} score (${rows[i].score}) should be <= row ${i - 1} score (${rows[i - 1].score})`,\n );\n }\n },\n\n // ── ascendBy + limit ──────────────────────────────────────────────────────\n\n async function getRowsAscendByWithLimit() {\n // `ascendBy` combined with `limit` should return the N lowest-scored rows.\n const rows = await _testTable.getRows(undefined, {\n json: true,\n ascendBy: \"score\",\n limit: 2,\n });\n assertEqual(rows.length, 2, \"ascendBy with limit 2 should return 2 rows\");\n assert(rows[0].score <= rows[1].score, \"rows should be in ascending order\");\n },\n\n // ── descendBy + condition ─────────────────────────────────────────────────\n\n async function getRowsDescendByWithCondition() {\n // An operator condition and `descendBy` should both be applied together.\n const rows = await _testTable.getRows(\n { score: { greaterThan: 10 } },\n { json: true, descendBy: \"score\" },\n );\n assert(\n rows.every((r: any) => r.score > 10),\n \"all rows should satisfy score > 10\",\n );\n for (let i = 1; i < rows.length; i++) {\n assert(\n rows[i].score <= rows[i - 1].score,\n \"rows should be in descending order by score\",\n );\n }\n },\n];\n","deleted","label",[177,160],"tests","permalink","https://www.val.town/x/pql/SQLiteTable/code/tests/query-options.test.ts","extension","actionData","errors"]