[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_216":217,"_218":219},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_113":95,"_33":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":55,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":-5,"_19":61,"_62":-5,"_63":55,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",419,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","c9d6ba6a-ff61-41cb-b46a-243d51494343","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","tests.tsx","latestPath","fileId","7701205e-0f93-11f1-a2bc-42dde27851f2","name","fileType","script","content","import { SQLiteTable } from \"./main.tsx\";\n\n// Test table using object-form schema\nconst _testTable = new SQLiteTable(\n \"_testTable\",\n {\n id: { type: \"integer\", primaryKey: true },\n name: { type: \"text\" },\n score: { type: \"number\" },\n },\n { scope: \"val\" },\n);\n\n// Test table using string-form schema\nconst _testTableStr = new SQLiteTable(\n \"_testTableStr\",\n {\n id: \"integer primary key\",\n label: \"text not null\",\n value: \"real\",\n },\n { scope: \"val\" },\n);\n\ntype TestResult = { name: string; passed: boolean; error?: string };\n\nfunction assert(condition: boolean, message: string) {\n if (!condition) throw new Error(`Assertion failed: ${message}`);\n}\n\nfunction assertEqual(actual: any, expected: any, message: string) {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a !== e) {\n throw new Error(`${message}\\n expected: ${e}\\n actual: ${a}`);\n }\n}\n\nasync function runTest(\n name: string,\n fn: () => Promise,\n): Promise {\n try {\n await fn();\n return { name, passed: true };\n } catch (err) {\n return { name, passed: false, error: String(err) };\n }\n}\n\n// ── Setup / Teardown ────────────────────────────────────────────────────────\n\nasync function setup() {\n // Drop any leftover tables from a previous failed run, then re-create them\n if (await _testTable.exists()) await _testTable.drop();\n await _testTable.create();\n\n if (await _testTableStr.exists()) await _testTableStr.drop();\n await _testTableStr.create();\n}\n\nasync function teardown() {\n if (await _testTable.exists()) await _testTable.drop();\n if (await _testTableStr.exists()) await _testTableStr.drop();\n}\n\n// ── Individual tests ────────────────────────────────────────────────────────\n\nconst tests = [\n // ── Object-form schema ─────────────────────────────────────────────────────\n\n async function tableExists() {\n const result = await _testTable.exists();\n assert(!!result, \"table should exist after create()\");\n },\n\n async function insertAndGetRow() {\n await _testTable.insertRow({ id: 1, name: \"Alice\", score: 42 });\n const row = await _testTable.getRow({ id: 1 }, { json: true });\n assertEqual(row, { id: 1, name: \"Alice\", score: 42 }, \"inserted row mismatch\");\n },\n\n async function getRows() {\n await _testTable.insertRow({ id: 2, name: \"Bob\", score: 99 });\n await _testTable.insertRow({ id: 3, name: \"Charlie\", score: 7 });\n const rows = await _testTable.getRows(undefined, { json: true });\n assert(rows.length === 3, `expected 3 rows, got ${rows.length}`);\n },\n\n async function countRows() {\n const count = await _testTable.countRows();\n assertEqual(count, 3, \"countRows should return 3\");\n },\n\n async function countRowsWithCondition() {\n const count = await _testTable.countRows({ score: { greaterThan: 10 } });\n assertEqual(count, 2, \"rows with score > 10 should be 2\");\n },\n\n async function updateRow() {\n await _testTable.updateRow({ id: 1 }, { score: 100 });\n const row = await _testTable.getRow({ id: 1 }, { json: true });\n assertEqual(row?.score, 100, \"score should be updated to 100\");\n },\n\n async function batchInsert() {\n await _testTable.batchInsert([\n { id: 4, name: \"Dave\", score: 55 },\n { id: 5, name: \"Eve\", score: 60 },\n ]);\n const count = await _testTable.countRows();\n assertEqual(count, 5, \"batchInsert: total rows should be 5\");\n },\n\n async function batchUpsert() {\n // Upsert existing id=1 (update score) and new id=6\n await _testTable.batchUpsert(\n [\n { id: 1, name: \"Alice\", score: 200 },\n { id: 6, name: \"Frank\", score: 11 },\n ],\n \"id\",\n );\n const alice = await _testTable.getRow({ id: 1 }, { json: true });\n assertEqual(alice?.score, 200, \"upserted alice score should be 200\");\n const count = await _testTable.countRows();\n assertEqual(count, 6, \"batchUpsert: total rows should be 6\");\n },\n\n async function getDescending() {\n const rows = await _testTable.getDescending({ by: \"score\", limit: 3 }, { json: true });\n assert(Array.isArray(rows), \"getDescending should return an array\");\n assert(rows.length === 3, `expected 3 rows, got ${rows.length}`);\n assert(\n rows[0].score >= rows[1].score,\n \"rows should be in descending order by score\",\n );\n },\n\n async function getAscending() {\n const rows = await _testTable.getAscending({ by: \"score\", limit: 3 }, { json: true });\n assert(Array.isArray(rows), \"getAscending should return an array\");\n assert(\n rows[0].score <= rows[1].score,\n \"rows should be in ascending order by score\",\n );\n },\n\n async function getInfo() {\n const info = await _testTable.getInfo();\n assert(typeof info === \"object\" && info !== null, \"getInfo should return an object\");\n assert(Array.isArray(info.columns), \"getInfo.columns should be an array\");\n const names = info.columns.map((c: any) => c.name);\n assert(names.includes(\"id\"), \"getInfo should include 'id' column\");\n assert(names.includes(\"name\"), \"getInfo should include 'name' column\");\n assert(names.includes(\"score\"), \"getInfo should include 'score' column\");\n assert(typeof info.rowCount === \"number\", \"getInfo.rowCount should be a number\");\n },\n\n async function addIndexAndGetIndices() {\n await _testTable.addIndex({ name: \"_testTable_score_idx\", column: \"score\" });\n const indices = await _testTable.getIndices();\n assert(Array.isArray(indices), \"getIndices should return an array\");\n const found = indices.some((i: any) => i.name === \"_testTable_score_idx\");\n assert(found, \"created index should appear in getIndices()\");\n },\n\n async function selectColumns() {\n const rows = await _testTable.getRows(undefined, {\n json: true,\n columns: [\"id\", \"name\"],\n });\n assert(rows.length > 0, \"should return rows\");\n assert(!(\"score\" in rows[0]), \"score column should be excluded\");\n assert(\"name\" in rows[0], \"name column should be present\");\n },\n\n // ── deleteRows ─────────────────────────────────────────────────────────────\n\n async function insertRowDuplicateKeyThrows() {\n await _testTable.insertRow({ id: 99, name: \"Unique\", score: 1 });\n let threw = false;\n try {\n await _testTable.insertRow({ id: 99, name: \"Duplicate\", score: 2 });\n } catch (_err) {\n threw = true;\n }\n assert(threw, \"inserting a duplicate primary key should throw\");\n },\n\n async function deleteRowsWithCondition() {\n const before = await _testTable.countRows();\n await _testTable.deleteRows({ id: 6 });\n const after = await _testTable.countRows();\n assertEqual(after, before - 1, \"deleteRows should remove exactly 1 row\");\n const gone = await _testTable.getRow({ id: 6 }, { json: true });\n assertEqual(gone, undefined, \"deleted row should not be retrievable\");\n },\n\n async function deleteAllRows() {\n await _testTable.deleteRows();\n const count = await _testTable.countRows();\n assertEqual(count, 0, \"deleteRows() with no condition should clear the table\");\n },\n\n // ── Raw (non-JSON) output ──────────────────────────────────────────────────\n\n async function getRawRow() {\n await _testTable.insertRow({ id: 1, name: \"Alice\", score: 42 });\n const row = await _testTable.getRow({ id: 1 });\n assert(row !== undefined, \"raw getRow should return a result\");\n // raw rows are objects with column keys (newer sqlite lib)\n assert(\"id\" in row, \"raw row should have 'id' key\");\n },\n\n async function getRawRows() {\n const result = await _testTable.getRows();\n // raw output is the ResultSet object, not a plain array\n assert(result !== undefined, \"raw getRows should return a result\");\n assert(\"rows\" in result, \"raw getRows result should have a 'rows' property\");\n assert(\"columns\" in result, \"raw getRows result should have a 'columns' property\");\n },\n\n // ── getRow miss ────────────────────────────────────────────────────────────\n\n async function getRowMiss() {\n const row = await _testTable.getRow({ id: 9999 }, { json: true });\n assertEqual(row, undefined, \"getRow with no match should return undefined\");\n },\n\n // ── Condition operators ────────────────────────────────────────────────────\n\n async function conditionOperators() {\n // seed a few more rows for operator tests\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 // atLeast (>=)\n const gte = await _testTable.countRows({ score: { atLeast: 55 } });\n assertEqual(gte, 3, \"atLeast 55: expected 3 rows\");\n\n // lessThan\n const lt = await _testTable.countRows({ score: { lessThan: 55 } });\n assertEqual(lt, 2, \"lessThan 55: expected 2 rows\");\n\n // atMost (<=)\n const lte = await _testTable.countRows({ score: { atMost: 55 } });\n assertEqual(lte, 3, \"atMost 55: expected 3 rows\");\n\n // notEqual\n const ne = await _testTable.countRows({ score: { notEqual: 42 } });\n assertEqual(ne, 4, \"notEqual 42: expected 4 rows\");\n\n // like\n const like = await _testTable.getRows({ name: { like: \"A%\" } }, { json: true });\n assertEqual(like.length, 1, \"LIKE 'A%': expected 1 row\");\n assertEqual(like[0].name, \"Alice\", \"LIKE 'A%': expected Alice\");\n\n // in\n const inList = await _testTable.getRows({ id: { in: [1, 3] } }, { json: true });\n assertEqual(inList.length, 2, \"IN [1,3]: expected 2 rows\");\n\n // in with empty array (always-false)\n const inEmpty = await _testTable.countRows({ id: { in: [] } });\n assertEqual(inEmpty, 0, \"IN []: expected 0 rows\");\n },\n\n async function conditionNullEquality() {\n // insert a row with a null score\n await _testTable.insertRow({ id: 10, name: \"Null Score\" });\n const nullRows = await _testTable.getRows({ score: null }, { json: true });\n assertEqual(nullRows.length, 1, \"IS NULL: expected 1 row with null score\");\n assertEqual(nullRows[0].id, 10, \"IS NULL: expected row id=10\");\n },\n\n async function conditionStringFreeform() {\n const rows = await _testTable.getRows(\"score > 50\", { json: true });\n assert(rows.length > 0, \"freeform string condition should return results\");\n assert(rows.every((r: any) => r.score > 50), \"all rows should satisfy score > 50\");\n },\n\n // ── getRows ascendBy / descendBy ──────────────────────────────────────────\n\n async function getRowsAscendBy() {\n const rows = await _testTable.getRows(undefined, { json: true, ascendBy: \"score\" });\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 async function getRowsDescendBy() {\n const rows = await _testTable.getRows(undefined, { json: true, descendBy: \"score\" });\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 async function getRowsAscendByWithLimit() {\n const rows = await _testTable.getRows(undefined, { json: true, ascendBy: \"score\", limit: 2 });\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 async function getRowsDescendByWithCondition() {\n const rows = await _testTable.getRows(\n { score: { greaterThan: 10 } },\n { json: true, descendBy: \"score\" },\n );\n assert(rows.every((r: any) => r.score > 10), \"all rows should satisfy score > 10\");\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 // ── getDescending / getAscending with excludedValue ────────────────────────\n\n async function getDescendingWithExcludedValue() {\n const rows = await _testTable.getDescending(\n { by: \"score\" },\n { excludedValue: 42, json: true },\n );\n assert(Array.isArray(rows), \"should return an array\");\n assert(\n rows.every((r: any) => r.score !== 42),\n \"excluded value 42 should not appear\",\n );\n },\n\n async function getAscendingWithExcludedValue() {\n const rows = await _testTable.getAscending(\n { by: \"score\" },\n { excludedValue: 42, json: true },\n );\n assert(Array.isArray(rows), \"should return an array\");\n assert(\n rows.every((r: any) => r.score !== 42),\n \"excluded value 42 should not appear\",\n );\n },\n\n // ── addColumn / removeColumn ───────────────────────────────────────────────\n\n async function addColumn() {\n await _testTable.addColumn(\"tag\", { type: \"text\" });\n const info = await _testTable.getInfo();\n const colNames = info.columns.map((c: any) => c.name);\n assert(colNames.includes(\"tag\"), \"new 'tag' column should appear in getInfo\");\n },\n\n async function removeColumn() {\n await _testTable.removeColumn(\"tag\");\n const info = await _testTable.getInfo();\n const colNames = info.columns.map((c: any) => c.name);\n assert(!colNames.includes(\"tag\"), \"'tag' column should be gone after removeColumn\");\n },\n\n // ── streamRowBatches ───────────────────────────────────────────────────────\n\n async function streamRowBatches() {\n const batches: any[][] = [];\n await _testTable.streamRowBatches((rows: any[]) => {\n batches.push(rows);\n });\n const totalStreamed = batches.reduce((sum, b) => sum + b.length, 0);\n const count = await _testTable.countRows();\n assertEqual(totalStreamed, count, \"streamed row count should match total rows\");\n },\n\n async function streamRowBatchesStopAt() {\n // With batchSize=1000 and only a handful of rows, stopAt=1 should yield exactly 1 batch\n await _testTable.streamRowBatches(\n (_rows: any[]) => {},\n { stopAt: 1 },\n );\n // No error thrown = pass; just verify it runs without issue\n },\n\n // ── String-form schema ─────────────────────────────────────────────────────\n\n async function stringSchemaTableExists() {\n const result = await _testTableStr.exists();\n assert(!!result, \"string-schema table should exist after create()\");\n },\n\n async function stringSchemaCorrectColumns() {\n const info = await _testTableStr.getInfo();\n const colNames = info.columns.map((c: any) => c.name);\n assert(colNames.includes(\"id\"), \"string-schema table should have 'id' column\");\n assert(colNames.includes(\"label\"), \"string-schema table should have 'label' column\");\n assert(colNames.includes(\"value\"), \"string-schema table should have 'value' column\");\n },\n\n async function stringSchemaInsertAndGetRow() {\n await _testTableStr.insertRow({ id: 1, label: \"alpha\", value: 1.5 });\n const row = await _testTableStr.getRow({ id: 1 }, { json: true });\n assertEqual(row, { id: 1, label: \"alpha\", value: 1.5 }, \"string-schema row mismatch\");\n },\n\n async function stringSchemaNotNullEnforced() {\n // 'label' is defined as \"text not null\" — omitting it should throw\n let threw = false;\n try {\n await _testTableStr.insertRow({ id: 2, value: 3.14 });\n } catch (_err) {\n threw = true;\n }\n assert(threw, \"inserting a row without a NOT NULL column should throw\");\n },\n\n async function stringSchemaPrimaryKeyEnforced() {\n // inserting a duplicate primary key should throw\n let threw = false;\n try {\n await _testTableStr.insertRow({ id: 1, label: \"duplicate\", value: 0 });\n } catch (_err) {\n threw = true;\n }\n assert(threw, \"string-schema: duplicate primary key should throw\");\n },\n];\n\n// ── Runner ──────────────────────────────────────────────────────────────────\n\nasync function runAllTests(): Promise {\n await setup();\n const results: TestResult[] = [];\n\n for (const test of tests) {\n results.push(await runTest(test.name, test));\n }\n\n await teardown();\n\n const passed = results.filter((r) => r.passed).length;\n const failed = results.filter((r) => !r.passed);\n\n console.log(`\\n=== Test Results: ${passed}/${results.length} passed ===\\n`);\n for (const r of results) {\n const icon = r.passed ? \"✅\" : \"❌\";\n console.log(`${icon} ${r.name}`);\n }\n\n if (failed.length > 0) {\n console.log(`\\n=== ${failed.length} test(s) failed ===\\n`);\n for (const r of failed) {\n console.log(`❌ ${r.name}\\n ${r.error}\\n`);\n }\n throw new Error(`${failed.length} test(s) failed`);\n }\n}\n\nawait runAllTests();\n","import { SQLiteTable } from \"./main.tsx\";\n\n// Test table using object-form schema\nconst _testTable = new SQLiteTable(\n \"_testTable\",\n {\n id: { type: \"integer\", primaryKey: true },\n name: { type: \"text\" },\n score: { type: \"number\" },\n },\n { scope: \"val\" },\n);\n\n// Test table using string-form schema\nconst _testTableStr = new SQLiteTable(\n \"_testTableStr\",\n {\n id: \"integer primary key\",\n label: \"text not null\",\n value: \"real\",\n },\n { scope: \"val\" },\n);\n\ntype TestResult = { name: string; passed: boolean; error?: string };\n\nfunction assert(condition: boolean, message: string) {\n if (!condition) throw new Error(`Assertion failed: ${message}`);\n}\n\nfunction assertEqual(actual: any, expected: any, message: string) {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a !== e) {\n throw new Error(`${message}\\n expected: ${e}\\n actual: ${a}`);\n }\n}\n\nasync function runTest(\n name: string,\n fn: () => Promise,\n): Promise {\n try {\n await fn();\n return { name, passed: true };\n } catch (err) {\n return { name, passed: false, error: String(err) };\n }\n}\n\n// ── Setup / Teardown ────────────────────────────────────────────────────────\n\nasync function setup() {\n // Drop any leftover tables from a previous failed run, then re-create them\n if (await _testTable.exists()) await _testTable.drop();\n await _testTable.create();\n\n if (await _testTableStr.exists()) await _testTableStr.drop();\n await _testTableStr.create();\n}\n\nasync function teardown() {\n if (await _testTable.exists()) await _testTable.drop();\n if (await _testTableStr.exists()) await _testTableStr.drop();\n}\n\n// ── Individual tests ────────────────────────────────────────────────────────\n\nconst tests = [\n // ── Object-form schema ─────────────────────────────────────────────────────\n\n async function tableExists() {\n const result = await _testTable.exists();\n assert(!!result, \"table should exist after create()\");\n },\n\n async function insertAndGetRow() {\n await _testTable.insertRow({ id: 1, name: \"Alice\", score: 42 });\n const row = await _testTable.getRow({ id: 1 }, { json: true });\n assertEqual(row, { id: 1, name: \"Alice\", score: 42 }, \"inserted row mismatch\");\n },\n\n async function getRows() {\n await _testTable.insertRow({ id: 2, name: \"Bob\", score: 99 });\n await _testTable.insertRow({ id: 3, name: \"Charlie\", score: 7 });\n const rows = await _testTable.getRows(undefined, { json: true });\n assert(rows.length === 3, `expected 3 rows, got ${rows.length}`);\n },\n\n async function countRows() {\n const count = await _testTable.countRows();\n assertEqual(count, 3, \"countRows should return 3\");\n },\n\n async function countRowsWithCondition() {\n const count = await _testTable.countRows({ score: { greaterThan: 10 } });\n assertEqual(count, 2, \"rows with score > 10 should be 2\");\n },\n\n async function updateRow() {\n await _testTable.updateRow({ id: 1 }, { score: 100 });\n const row = await _testTable.getRow({ id: 1 }, { json: true });\n assertEqual(row?.score, 100, \"score should be updated to 100\");\n },\n\n async function batchInsert() {\n await _testTable.batchInsert([\n { id: 4, name: \"Dave\", score: 55 },\n { id: 5, name: \"Eve\", score: 60 },\n ]);\n const count = await _testTable.countRows();\n assertEqual(count, 5, \"batchInsert: total rows should be 5\");\n },\n\n async function batchUpsert() {\n // Upsert existing id=1 (update score) and new id=6\n await _testTable.batchUpsert(\n [\n { id: 1, name: \"Alice\", score: 200 },\n { id: 6, name: \"Frank\", score: 11 },\n ],\n \"id\",\n );\n const alice = await _testTable.getRow({ id: 1 }, { json: true });\n assertEqual(alice?.score, 200, \"upserted alice score should be 200\");\n const count = await _testTable.countRows();\n assertEqual(count, 6, \"batchUpsert: total rows should be 6\");\n },\n\n async function getInfo() {\n const info = await _testTable.getInfo();\n assert(typeof info === \"object\" && info !== null, \"getInfo should return an object\");\n assert(Array.isArray(info.columns), \"getInfo.columns should be an array\");\n const names = info.columns.map((c: any) => c.name);\n assert(names.includes(\"id\"), \"getInfo should include 'id' column\");\n assert(names.includes(\"name\"), \"getInfo should include 'name' column\");\n assert(names.includes(\"score\"), \"getInfo should include 'score' column\");\n assert(typeof info.rowCount === \"number\", \"getInfo.rowCount should be a number\");\n },\n\n async function addIndexAndGetIndices() {\n await _testTable.addIndex({ name: \"_testTable_score_idx\", column: \"score\" });\n const indices = await _testTable.getIndices();\n assert(Array.isArray(indices), \"getIndices should return an array\");\n const found = indices.some((i: any) => i.name === \"_testTable_score_idx\");\n assert(found, \"created index should appear in getIndices()\");\n },\n\n async function selectColumns() {\n const rows = await _testTable.getRows(undefined, {\n json: true,\n columns: [\"id\", \"name\"],\n });\n assert(rows.length > 0, \"should return rows\");\n assert(!(\"score\" in rows[0]), \"score column should be excluded\");\n assert(\"name\" in rows[0], \"name column should be present\");\n },\n\n // ── deleteRows ─────────────────────────────────────────────────────────────\n\n async function insertRowDuplicateKeyThrows() {\n await _testTable.insertRow({ id: 99, name: \"Unique\", score: 1 });\n let threw = false;\n try {\n await _testTable.insertRow({ id: 99, name: \"Duplicate\", score: 2 });\n } catch (_err) {\n threw = true;\n }\n assert(threw, \"inserting a duplicate primary key should throw\");\n },\n\n async function deleteRowsWithCondition() {\n const before = await _testTable.countRows();\n await _testTable.deleteRows({ id: 6 });\n const after = await _testTable.countRows();\n assertEqual(after, before - 1, \"deleteRows should remove exactly 1 row\");\n const gone = await _testTable.getRow({ id: 6 }, { json: true });\n assertEqual(gone, undefined, \"deleted row should not be retrievable\");\n },\n\n async function deleteAllRows() {\n await _testTable.deleteRows();\n const count = await _testTable.countRows();\n assertEqual(count, 0, \"deleteRows() with no condition should clear the table\");\n },\n\n // ── Raw (non-JSON) output ──────────────────────────────────────────────────\n\n async function getRawRow() {\n await _testTable.insertRow({ id: 1, name: \"Alice\", score: 42 });\n const row = await _testTable.getRow({ id: 1 });\n assert(row !== undefined, \"raw getRow should return a result\");\n // raw rows are objects with column keys (newer sqlite lib)\n assert(\"id\" in row, \"raw row should have 'id' key\");\n },\n\n async function getRawRows() {\n const result = await _testTable.getRows();\n // raw output is the ResultSet object, not a plain array\n assert(result !== undefined, \"raw getRows should return a result\");\n assert(\"rows\" in result, \"raw getRows result should have a 'rows' property\");\n assert(\"columns\" in result, \"raw getRows result should have a 'columns' property\");\n },\n\n // ── getRow miss ────────────────────────────────────────────────────────────\n\n async function getRowMiss() {\n const row = await _testTable.getRow({ id: 9999 }, { json: true });\n assertEqual(row, undefined, \"getRow with no match should return undefined\");\n },\n\n // ── Condition operators ────────────────────────────────────────────────────\n\n async function conditionOperators() {\n // seed a few more rows for operator tests\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 // atLeast (>=)\n const gte = await _testTable.countRows({ score: { atLeast: 55 } });\n assertEqual(gte, 3, \"atLeast 55: expected 3 rows\");\n\n // lessThan\n const lt = await _testTable.countRows({ score: { lessThan: 55 } });\n assertEqual(lt, 2, \"lessThan 55: expected 2 rows\");\n\n // atMost (<=)\n const lte = await _testTable.countRows({ score: { atMost: 55 } });\n assertEqual(lte, 3, \"atMost 55: expected 3 rows\");\n\n // notEqual\n const ne = await _testTable.countRows({ score: { notEqual: 42 } });\n assertEqual(ne, 4, \"notEqual 42: expected 4 rows\");\n\n // like\n const like = await _testTable.getRows({ name: { like: \"A%\" } }, { json: true });\n assertEqual(like.length, 1, \"LIKE 'A%': expected 1 row\");\n assertEqual(like[0].name, \"Alice\", \"LIKE 'A%': expected Alice\");\n\n // in\n const inList = await _testTable.getRows({ id: { in: [1, 3] } }, { json: true });\n assertEqual(inList.length, 2, \"IN [1,3]: expected 2 rows\");\n\n // in with empty array (always-false)\n const inEmpty = await _testTable.countRows({ id: { in: [] } });\n assertEqual(inEmpty, 0, \"IN []: expected 0 rows\");\n },\n\n async function conditionNullEquality() {\n // insert a row with a null score\n await _testTable.insertRow({ id: 10, name: \"Null Score\" });\n const nullRows = await _testTable.getRows({ score: null }, { json: true });\n assertEqual(nullRows.length, 1, \"IS NULL: expected 1 row with null score\");\n assertEqual(nullRows[0].id, 10, \"IS NULL: expected row id=10\");\n },\n\n async function conditionStringFreeform() {\n const rows = await _testTable.getRows(\"score > 50\", { json: true });\n assert(rows.length > 0, \"freeform string condition should return results\");\n assert(rows.every((r: any) => r.score > 50), \"all rows should satisfy score > 50\");\n },\n\n // ── getRows ascendBy / descendBy ──────────────────────────────────────────\n\n async function getRowsAscendBy() {\n const rows = await _testTable.getRows(undefined, { json: true, ascendBy: \"score\" });\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 async function getRowsDescendBy() {\n const rows = await _testTable.getRows(undefined, { json: true, descendBy: \"score\" });\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 async function getRowsAscendByWithLimit() {\n const rows = await _testTable.getRows(undefined, { json: true, ascendBy: \"score\", limit: 2 });\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 async function getRowsDescendByWithCondition() {\n const rows = await _testTable.getRows(\n { score: { greaterThan: 10 } },\n { json: true, descendBy: \"score\" },\n );\n assert(rows.every((r: any) => r.score > 10), \"all rows should satisfy score > 10\");\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 // ── getDescending / getAscending with excludedValue ────────────────────────\n\n async function getDescendingWithExcludedValue() {\n const rows = await _testTable.getDescending(\n { by: \"score\" },\n { excludedValue: 42, json: true },\n );\n assert(Array.isArray(rows), \"should return an array\");\n assert(\n rows.every((r: any) => r.score !== 42),\n \"excluded value 42 should not appear\",\n );\n },\n\n async function getAscendingWithExcludedValue() {\n const rows = await _testTable.getAscending(\n { by: \"score\" },\n { excludedValue: 42, json: true },\n );\n assert(Array.isArray(rows), \"should return an array\");\n assert(\n rows.every((r: any) => r.score !== 42),\n \"excluded value 42 should not appear\",\n );\n },\n\n // ── addColumn / removeColumn ───────────────────────────────────────────────\n\n async function addColumn() {\n await _testTable.addColumn(\"tag\", { type: \"text\" });\n const info = await _testTable.getInfo();\n const colNames = info.columns.map((c: any) => c.name);\n assert(colNames.includes(\"tag\"), \"new 'tag' column should appear in getInfo\");\n },\n\n async function removeColumn() {\n await _testTable.removeColumn(\"tag\");\n const info = await _testTable.getInfo();\n const colNames = info.columns.map((c: any) => c.name);\n assert(!colNames.includes(\"tag\"), \"'tag' column should be gone after removeColumn\");\n },\n\n // ── streamRowBatches ───────────────────────────────────────────────────────\n\n async function streamRowBatches() {\n const batches: any[][] = [];\n await _testTable.streamRowBatches((rows: any[]) => {\n batches.push(rows);\n });\n const totalStreamed = batches.reduce((sum, b) => sum + b.length, 0);\n const count = await _testTable.countRows();\n assertEqual(totalStreamed, count, \"streamed row count should match total rows\");\n },\n\n async function streamRowBatchesStopAt() {\n // With batchSize=1000 and only a handful of rows, stopAt=1 should yield exactly 1 batch\n await _testTable.streamRowBatches(\n (_rows: any[]) => {},\n { stopAt: 1 },\n );\n // No error thrown = pass; just verify it runs without issue\n },\n\n // ── String-form schema ─────────────────────────────────────────────────────\n\n async function stringSchemaTableExists() {\n const result = await _testTableStr.exists();\n assert(!!result, \"string-schema table should exist after create()\");\n },\n\n async function stringSchemaCorrectColumns() {\n const info = await _testTableStr.getInfo();\n const colNames = info.columns.map((c: any) => c.name);\n assert(colNames.includes(\"id\"), \"string-schema table should have 'id' column\");\n assert(colNames.includes(\"label\"), \"string-schema table should have 'label' column\");\n assert(colNames.includes(\"value\"), \"string-schema table should have 'value' column\");\n },\n\n async function stringSchemaInsertAndGetRow() {\n await _testTableStr.insertRow({ id: 1, label: \"alpha\", value: 1.5 });\n const row = await _testTableStr.getRow({ id: 1 }, { json: true });\n assertEqual(row, { id: 1, label: \"alpha\", value: 1.5 }, \"string-schema row mismatch\");\n },\n\n async function stringSchemaNotNullEnforced() {\n // 'label' is defined as \"text not null\" — omitting it should throw\n let threw = false;\n try {\n await _testTableStr.insertRow({ id: 2, value: 3.14 });\n } catch (_err) {\n threw = true;\n }\n assert(threw, \"inserting a row without a NOT NULL column should throw\");\n },\n\n async function stringSchemaPrimaryKeyEnforced() {\n // inserting a duplicate primary key should throw\n let threw = false;\n try {\n await _testTableStr.insertRow({ id: 1, label: \"duplicate\", value: 0 });\n } catch (_err) {\n threw = true;\n }\n assert(threw, \"string-schema: duplicate primary key should throw\");\n },\n];\n\n// ── Runner ──────────────────────────────────────────────────────────────────\n\nasync function runAllTests(): Promise {\n await setup();\n const results: TestResult[] = [];\n\n for (const test of tests) {\n results.push(await runTest(test.name, test));\n }\n\n await teardown();\n\n const passed = results.filter((r) => r.passed).length;\n const failed = results.filter((r) => !r.passed);\n\n console.log(`\\n=== Test Results: ${passed}/${results.length} passed ===\\n`);\n for (const r of results) {\n const icon = r.passed ? \"✅\" : \"❌\";\n console.log(`${icon} ${r.name}`);\n }\n\n if (failed.length > 0) {\n console.log(`\\n=== ${failed.length} test(s) failed ===\\n`);\n for (const r of failed) {\n console.log(`❌ ${r.name}\\n ${r.error}\\n`);\n }\n throw new Error(`${failed.length} test(s) failed`);\n }\n}\n\nawait runAllTests();\n","createdAt",["D",1772479808306],"branchVersion","branchId","29488f20-27b6-11f0-aecd-569c3dd06744","id","29484b28-27b6-11f0-aecd-569c3dd06744","SQLiteTable",["D",1746232377860],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","f129b0f0-09bd-41ac-a51c-c16933d81d65","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","5cdb635f-04df-409e-bb23-93b87a60f6ca","tursoName","29484b2827b611f0aecd569c3dd06744","tursoHostname","29484b2827b611f0aecd569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519256886],"pinned",0,"userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":108},"org",{"_105":104,"_106":-5,"_107":108,"_19":61,"_109":110,"_111":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"isOwned",509,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pql","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJrYUVVM1VyRHRhckNnNGxidGEwUUdaSFRDYSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":211,"_53":-5,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":-5,"_19":61,"_62":-5,"_63":55,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":212,"_76":77,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":213,"_89":214,"_91":215,"_93":31},"tree",[190,191,192,193,194],"files",[190,191,192,193,194],"counts",{"_180":77,"_181":67,"_182":77,"_183":184,"_185":186},"contents",[135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":172,"_38":173,"_36":174,"_143":-5,"_47":48,"_46":175,"_145":31,"_44":176,"_13":177,"_39":26,"_41":178,"_30":31,"_149":-5,"_33":179},{"_49":163,"_38":164,"_36":165,"_143":-5,"_47":48,"_46":166,"_145":55,"_44":167,"_13":168,"_39":169,"_41":170,"_30":31,"_149":-5,"_33":171},{"_49":155,"_38":156,"_36":157,"_143":-5,"_47":48,"_46":158,"_145":31,"_44":159,"_13":160,"_39":40,"_41":161,"_30":31,"_149":-5,"_33":162},{"_49":151,"_38":34,"_36":37,"_143":-5,"_47":48,"_46":14,"_145":31,"_44":152,"_13":153,"_39":40,"_41":43,"_30":31,"_149":-5,"_33":154},{"_49":140,"_38":141,"_36":142,"_143":-5,"_47":48,"_46":144,"_145":31,"_44":146,"_13":147,"_39":40,"_41":148,"_30":31,"_149":-5,"_33":150},"32d9a284-166e-11f1-b835-42dde27851f2","utils","14f88bd6-68bd-11f0-9b48-0224a6c84d84","parentId",418,"latest",["D",1772479798043],20,"import { OpenAI } from \"https://esm.town/v/std/openai\";\n\n// ---- SHARED TYPES ---- //\n\n// Select conditions: key-value equalities (AND-joined) or raw SQL string\nexport type RowSelectCondition = object | string;\n\nexport type SelectOutputOptionsBase = {\n json?: boolean;\n columns?: string[];\n limit?: number;\n};\n\nexport type SelectOutputOptions = SelectOutputOptionsBase & (\n | { ascendBy?: string; descendBy?: never }\n | { descendBy?: string; ascendBy?: never }\n);\n\n\nexport type StreamOptions = {\n tableName?: string;\n batchSize?: number;\n stopAt?: number;\n};\n\n// ---- FUNCTIONS ---- //\n\nexport async function AISuggestCmd(plainText: string, tableName?: string): Promise {\n if (!plainText) return \"No prompt provided\";\n\n const tableSpecificSnippet = tableName ? `for a table named ${tableName}` : \"\";\n\n const decodedPrompt =\n `Give me just the sqlite command ${tableSpecificSnippet}, with no formatting or comments: ${plainText}`;\n\n // Initialize OpenAI\n const openai = new OpenAI();\n\n try {\n // Generate response using OpenAI\n const completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: decodedPrompt },\n ],\n max_tokens: 3000,\n });\n\n const [{ message: { content } }] = completion.choices;\n // Return the response as JSON\n console.log(\"AI suggestion: \", content);\n return content;\n } catch (error) {\n return \"Failed to generate response\";\n }\n}\n\nexport async function SQLiteTableInfo() {\n const { sqlite, name: tableName } = this;\n try {\n // First, verify the table exists\n const tableExists = await sqlite.execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name = ?`,\n [tableName],\n );\n\n if (tableExists.rows.length === 0) {\n throw new Error(`Table ${tableName} does not exist`);\n }\n\n // Get table-specific information\n const tableInfo = await sqlite.execute(`PRAGMA table_info(${tableName})`);\n\n // Count rows in the table\n const { rows: [{ row_count: rowCount }] } = await sqlite.execute(`SELECT COUNT(*) as row_count FROM ${tableName}`);\n\n // Get table size details using SQLite-specific queries\n const { rows: [{ page_size: pageSize }] } = await sqlite.execute(`PRAGMA page_size`);\n\n // Get page count for this specific table\n const { rows: [{ page_count: pageCount }] } = await sqlite.execute(\n `\n SELECT count(*) as page_count \n FROM sqlite_master \n WHERE type='table' AND name=? \n AND rootpage > 0\n `,\n [tableName],\n );\n\n // Estimate table size based on page count and page size\n const estimatedTableBytes = pageCount * pageSize;\n\n return {\n // tableName,\n columns: tableInfo.rows.map(({ name, type }) => ({ name, type })),\n rowCount,\n pageSize,\n pageCount,\n estimatedTableBytes,\n humanReadableSize: formatBytes(estimatedTableBytes),\n // indexes: indexInfoResult.rows.map(index => index.name),\n // indexCount: indexInfoResult.rows.length,\n };\n } catch (error) {\n return {\n error: `Error getting size for table ${tableName}: ${error.message}`,\n tableName,\n };\n }\n}\n\nfunction formatBytes(bytes: number, decimals = 2): string {\n if (bytes === 0) return \"0 Bytes\";\n\n const k = 1024;\n const dm = decimals < 0 ? 0 : decimals;\n const sizes = [\"Bytes\", \"KB\", \"MB\", \"GB\", \"TB\", \"PB\", \"EB\", \"ZB\", \"YB\"];\n\n const i = Math.floor(Math.log(bytes) / Math.log(k));\n\n return parseFloat((bytes / Math.pow(k, i)).toFixed(dm)) + \" \" + sizes[i];\n}\n\n\n// Generates a bulk SQLite INSERT … ON CONFLICT upsert statement that MERGES records by conflictKey:\n// inserts new rows, updates existing rows only for fields explicitly provided, and preserves\n// existing values when incoming fields are missing (undefined). Requires a UNIQUE constraint\n// on conflictKey. Does not perform validation, type coercion, parameter binding, or per-row logic.\n\nexport const assembleBulkUpsertCommand = (\n tableName: string,\n records: object[],\n conflictKey: string,\n) => {\n if (!records || records.length === 0) {\n throw new Error(\"No records provided\");\n }\n\n if (!conflictKey) {\n throw new Error(\"Conflict key must be specified\");\n }\n\n const columns = Array.from(\n new Set(records.flatMap(record => Object.keys(record))),\n );\n\n if (!columns.includes(conflictKey)) {\n throw new Error(`Conflict key '${conflictKey}' not found in records`);\n }\n\n const values = records.map(record => {\n const rowValues = columns.map(col => {\n const value = record[col];\n return value === undefined\n ? \"NULL\"\n : `'${String(value).replace(/'/g, \"''\")}'`;\n });\n return `(${rowValues.join(\", \")})`;\n }).join(\",\\n \");\n\n const nonConflictColumns = columns.filter(col => col !== conflictKey);\n\n return `\n INSERT INTO ${tableName} (${columns.join(\", \")})\n VALUES\n ${values}\n ON CONFLICT(${conflictKey}) DO UPDATE SET\n ${nonConflictColumns\n .map(col => `${col} = COALESCE(excluded.${col}, ${col})`)\n .join(\",\\n \")};\n `.trim();\n};\n\n\nexport const assembleBulkInsertCommand = (tableName: string, records: object[]): string => {\n if (!records || records.length === 0) {\n throw new Error(\"No records provided\");\n }\n\n // Collect all column names from records\n const columns = Array.from(\n new Set(records.flatMap(record => Object.keys(record)))\n );\n\n // Escape and serialize values\n const values = records.map(record => {\n const rowValues = columns.map(col => {\n const value = record[col];\n return value === undefined ? \"NULL\" : `'${String(value).replace(/'/g, \"''\")}'`;\n });\n return `(${rowValues.join(\", \")})`;\n }).join(\",\\n \");\n\n return `\n INSERT INTO ${tableName} (${columns.join(\", \")})\n VALUES\n ${values};\n `.trim();\n};\n\nexport async function streamTableRows(\n processRowFn: (rows: Record[]) => void | Promise,\n options: StreamOptions = {},\n): Promise {\n const { sqlite } = this;\n const {\n tableName,\n batchSize = 1000,\n stopAt = Infinity,\n } = options;\n\n const KEY = \"SQLiteUtils\";\n const effectiveTableName = tableName || `${KEY}_rows`;\n\n try {\n if (!/^[a-zA-Z0-9_]+$/.test(effectiveTableName)) {\n throw new Error(\"Invalid table name. Only alphanumeric characters and underscores allowed.\");\n }\n\n let offset = 0;\n let batchCount = 0;\n\n while (batchCount < stopAt) {\n const query = `\n SELECT * FROM ${effectiveTableName}\n LIMIT ${batchSize}\n OFFSET ${offset}\n `;\n\n const result = await sqlite.execute(query);\n\n if (result.rows.length === 0) {\n break;\n }\n\n await processRowFn(result.rows);\n\n offset += batchSize;\n batchCount += 1;\n }\n\n return true;\n } catch (error) {\n console.error(\"Error streaming rows:\", error);\n throw error;\n }\n}\n\n// ---- HTTP ACCESS ---- //\n\nconst ALLOWED_OPERATIONS = [\n \"getRow\",\n \"getRows\",\n \"countRows\",\n \"getInfo\",\n] as const;\ntype AllowedOperation = typeof ALLOWED_OPERATIONS[number];\n\nexport async function http(req: Request): Promise {\n const url = new URL(req.url);\n console.log(url);\n const pathSegments = url.pathname.split(\"/\")\n .filter((segment) => segment.length > 0);\n\n const operation = pathSegments.at(-1) as AllowedOperation;\n\n if (!ALLOWED_OPERATIONS.includes(operation as AllowedOperation)) {\n return Response.json(\n {\n error: `Unknown operation: ${operation}. Supported operations: ${\n ALLOWED_OPERATIONS.join(\", \")\n }`,\n },\n { status: 400 },\n );\n }\n\n try {\n // Parse query params into select conditions.\n // Reserved params (prefixed with _) are treated as output options, not conditions.\n const conditions: Record = {};\n const outputOptions: SelectOutputOptions = { json: true };\n\n for (const [key, value] of url.searchParams.entries()) {\n if (key === \"_columns\") {\n outputOptions.columns = value.split(\",\").map((c) => c.trim());\n } else {\n // Attempt to coerce numeric strings to numbers\n const coerced = value !== \"\" && !isNaN(Number(value))\n ? Number(value)\n : value;\n conditions[key] = coerced;\n }\n }\n\n const hasConditions = Object.keys(conditions).length > 0;\n const args: any[] = [hasConditions ? conditions : undefined];\n if (operation !== \"countRows\") args.push(outputOptions);\n const result = await (this[operation] as Function)(...args);\n\n return Response.json(result ?? null);\n } catch (error) {\n console.error(`Error in ${operation} operation:`, error);\n return Response.json(\n { error: error.message || \"Internal server error\" },\n { status: 500 },\n );\n }\n}\n","label",[141],"38f7ed6a-166e-11f1-a603-42dde27851f2",["D",1772479808306],9,[34],"259330f4-166e-11f1-b835-42dde27851f2","main.tsx","294acb64-27b6-11f0-aecd-569c3dd06744",415,["D",1772479775766],307,"import valSQLite, {\n sqlite as userSQLite,\n} from \"https://esm.town/v/std/sqlite/main.ts?v=14\";\n\nimport {\n AISuggestCmd,\n assembleBulkInsertCommand,\n assembleBulkUpsertCommand,\n http,\n RowSelectCondition,\n SelectOutputOptions,\n SQLiteTableInfo,\n StreamOptions,\n streamTableRows,\n} from \"./utils\";\n\ntype ColumnDefinition = string | {\n type?: \"integer\" | \"number\" | \"string\" | \"text\";\n primaryKey?: boolean;\n unique?: boolean;\n};\n\ntype TableScheme = { [key: string]: ColumnDefinition };\n\nexport class SQLiteTable {\n constructor(\n tableName: string,\n schema: TableScheme,\n options?: { scope?: \"user\" | \"val\" },\n ) {\n this.name = tableName;\n this.schema = schema;\n this.scope = options?.scope || \"user\";\n this.sqlite = this.scope === \"val\" ? valSQLite : userSQLite;\n return this;\n }\n\n name: string = \"newTable\";\n schema: TableScheme;\n scope: \"user\" | \"val\";\n sqlite: typeof userSQLite;\n\n async create() {\n const { name, schema } = this;\n await this.sqlite.execute(`create table if not exists ${name}(\n ${parseColumnDefinition(schema)}\n )`);\n }\n\n async drop() {\n const { name } = this;\n await this.sqlite.execute(`drop table ${name}`);\n }\n\n async exists() {\n const { name } = this;\n const table = await this.sqlite.execute(\n `SELECT * FROM sqlite_master WHERE type='table' AND name='${name}';`,\n );\n const { rows: [result] } = table;\n return result;\n }\n\n async getInfo() {\n return await SQLiteTableInfo.call(this);\n }\n\n async insertRow(rowData: object) {\n const { name } = this;\n const keys = Object.keys(rowData);\n const sql = `insert into ${name}(${keys.join(\", \")}) values (${\n keys.map((k) => `:${k}`).join(\", \")\n })`;\n return await this.sqlite.execute({\n sql,\n args: rowData,\n });\n }\n\n async updateRow(conditions: RowSelectCondition, rowUpdate: object) {\n const { name } = this;\n const rowUpdateString = stringifyEqualities(rowUpdate)\n .join(\", \\n\");\n const fullString = `UPDATE ${name} SET ${rowUpdateString}${\n formatConditions(conditions)\n }`;\n await this.sqlite.execute(fullString);\n }\n\n async batchInsert(records: object[]) {\n const { name } = this;\n const fullString = assembleBulkInsertCommand(name, records);\n return await this.sqlite.execute(fullString);\n }\n\n async batchUpsert(records: object[], conflictKey: string) {\n const { name } = this;\n const fullString = assembleBulkUpsertCommand(name, records, conflictKey);\n return await this.sqlite.execute(fullString);\n }\n\n // get first matching row\n async getRow(\n conditions?: RowSelectCondition,\n outputOptions?: Pick,\n ) {\n return await this._selectQuery({\n conditions,\n outputOptions,\n single: true,\n });\n }\n\n // get all rows meeting a certain condition. option to return as an array of json objects\n async getRows(\n conditions?: RowSelectCondition,\n outputOptions?: SelectOutputOptions,\n ) {\n return await this._selectQuery({\n conditions,\n outputOptions,\n single: false,\n });\n }\n\n // count rows meeting a condition\n async countRows(conditions?: RowSelectCondition) {\n const { name } = this;\n const { rows: [firstRow] } = await this.sqlite.execute(\n `select count(*) from ${name}${formatConditions(conditions)}`,\n );\n // rows may be objects (newer sqlite) or arrays (older sqlite)\n return Array.isArray(firstRow) ? firstRow[0] : Object.values(firstRow)[0];\n }\n\n // delete all rows meeting a condition\n async deleteRows(conditions?: RowSelectCondition) {\n const { name } = this;\n return await this.sqlite.execute(\n `delete from ${name}${formatConditions(conditions)}`,\n );\n }\n\n async streamRowBatches(onBatch: Function, options?: Pick) {\n const { name } = this;\n return await streamTableRows.call(this, onBatch, {\n tableName: name,\n stopAt: options?.stopAt || Infinity,\n batchSize: 1000,\n });\n }\n\n /**\n * Add a new column to the table.\n * @param columnName name of the new column\n * @param columnScheme type and constraints for the new column\n */\n async addColumn(columnName: string, columnScheme: ColumnDefinition) {\n const { name } = this;\n // parseColumnDefinition will return e.g. \"colName TEXT UNIQUE\"\n const colDef = parseColumnDefinition({ [columnName]: columnScheme });\n await this.sqlite.execute(`ALTER TABLE ${name} ADD COLUMN ${colDef}`);\n }\n\n /**\n * Remove a column from the table.\n * Requires SQLite 3.35.0 or later for native DROP COLUMN support.\n * @param columnName name of the column to drop\n */\n async removeColumn(columnName: string) {\n const { name } = this;\n // SQLite 3.35+ supports: ALTER TABLE ... DROP COLUMN ...\n await this.sqlite.execute(`ALTER TABLE ${name} DROP COLUMN ${columnName}`);\n }\n\n /**\n * Get all indices for the table.\n */\n async getIndices() {\n const result = await this.sqlite.execute(\n `SELECT name, sql FROM sqlite_master WHERE type = 'index' AND tbl_name = '${this.name}'`,\n );\n return formatJSONOutput(result);\n }\n\n /**\n * Add an index to the table.\n * @param name name of the index\n * @param column column to index\n */\n async addIndex({ name, column }: { name: string; column: string }) {\n await this.sqlite.execute(\n `CREATE INDEX ${name} ON ${this.name} (${column})`,\n );\n }\n\n async AISuggestCmd(plainText: string): Promise {\n const { name } = this;\n return await AISuggestCmd(plainText, name);\n }\n\n async http(req: Request): Promise {\n const bound = http.bind(this);\n return await bound(req);\n }\n\n private async _selectQuery({\n conditions,\n outputOptions = {},\n single = false,\n }: {\n conditions?: RowSelectCondition;\n outputOptions?: SelectOutputOptions;\n single?: boolean;\n }) {\n const { name } = this;\n\n const columnL = outputOptions.columns?.length\n ? outputOptions.columns.join(\", \")\n : \"*\";\n\n let query = `select ${columnL} from ${name}${formatConditions(conditions)}`;\n\n if (single) {\n query += ` LIMIT 1`;\n } else {\n if (outputOptions.ascendBy) {\n query += ` ORDER BY ${outputOptions.ascendBy} ASC`;\n } else if (outputOptions.descendBy) {\n query += ` ORDER BY ${outputOptions.descendBy} DESC`;\n }\n\n if (outputOptions.limit != null) {\n query += ` LIMIT ${outputOptions.limit}`;\n }\n }\n\n const rawOutput = await this.sqlite.execute(query);\n\n // Non-JSON output\n if (!outputOptions.json) {\n return single ? (rawOutput.rows?.[0] ?? undefined) : rawOutput;\n }\n\n // JSON output\n const jsonRows = formatJSONOutput(rawOutput);\n return single ? (jsonRows[0] ?? undefined) : jsonRows;\n }\n}\n\nfunction formatJSONOutput(rawOutput) {\n if (!rawOutput) return [];\n const { rows, columns } = rawOutput;\n if (!rows?.length) return [];\n const json = rows.map((row) => {\n // rows may already be objects (newer sqlite lib versions)\n if (!Array.isArray(row)) return row;\n return Object.fromEntries(\n row.map((rowVal, rowValIndex) => [columns[rowValIndex], rowVal]),\n );\n });\n\n return json;\n}\n\nfunction parseColumnDefinition(scheme: TableScheme): string {\n return Object.entries(scheme)\n .map(([columnName, columnScheme]) => {\n // If user passed a raw string, trust it as-is\n if (typeof columnScheme === \"string\") {\n return `${columnName} ${columnScheme}`;\n }\n\n const parts: string[] = [];\n const type = columnScheme.type ?? \"text\";\n parts.push(type.toUpperCase());\n\n if (columnScheme.primaryKey) parts.push(\"PRIMARY KEY\");\n if (columnScheme.unique) parts.push(\"UNIQUE\");\n\n return `${columnName} ${parts.join(\" \")}`;\n })\n .join(\",\\n\");\n}\n\nfunction stringifyEqualities(obj: Object): string[] {\n return Object.entries(obj).map(([key, value]) => {\n // Primitive: default to equality\n if (\n typeof value === \"string\" ||\n typeof value === \"number\" ||\n typeof value === \"boolean\" ||\n value === null\n ) {\n const keyValue = [key, formatValue(value)];\n return keyValue.join(value === null ? \" IS \" : \" = \");\n }\n\n // Operator object\n if (typeof value === \"object\" && value !== null) {\n const clauses = Object.entries(value).map(([op, val]) => {\n const formatted = formatValue(val);\n switch (op) {\n case \"greaterThan\":\n return `${key} > ${formatted}`;\n case \"atLeast\":\n return `${key} >= ${formatted}`;\n case \"lessThan\":\n return `${key} < ${formatted}`;\n case \"atMost\":\n return `${key} <= ${formatted}`;\n case \"notEqual\":\n return `${key} != ${formatted}`;\n case \"like\":\n return `${key} LIKE ${formatted}`;\n case \"in\": {\n if (!Array.isArray(val)) {\n throw new Error(`'in' expects an array for key \"${key}\"`);\n }\n if (val.length === 0) return \"0\"; // IN () is invalid; treat as always-false\n const list = val.map(formatValue).join(\", \");\n return `${key} IN (${list})`;\n }\n\n default:\n throw new Error(`Unsupported operator: ${op}`);\n }\n });\n return clauses.join(\" AND \");\n }\n\n throw new Error(`Invalid condition for key \"${key}\": ${value}`);\n });\n}\n\nfunction formatValue(value: any): string {\n if (typeof value === \"string\") return `'${sanitizeString(value)}'`;\n if (value === null) return \"NULL\";\n return String(value);\n}\n\nfunction formatConditions(conditions?: RowSelectCondition): string {\n if (!conditions) return \"\";\n if (typeof conditions === \"string\") return ` WHERE ${conditions}`;\n\n const conditionsString = stringifyEqualities(conditions)\n .join(\" AND \");\n return ` WHERE ${conditionsString}`;\n}\n\n// Escape single quotes by doubling them\n\nfunction sanitizeString(string: string): string {\n return string.replace(/'/g, \"''\");\n}\n",[156],"aec51b48-0f94-11f1-8531-42dde27851f2","httpDemo.ts","281b626e-0d0a-11f1-a3a9-42dde27851f2",359,["D",1771726668666],7,"http","import { SQLiteTable } from \"./main.tsx\";\n\nconst table = new SQLiteTable(\"selftable\", { scope: \"val\" });\n\n// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return await table.http(req);\n}",[164],"1ea98626-166e-11f1-a145-42dde27851f2","README.md","294ad15e-27b6-11f0-aecd-569c3dd06744",413,["D",1772479764165],28,"# SQLiteTable\n\nA thin abstraction over SQLite, to work with tables via JSON. All methods async.\n\n## Usage\n\n```javascript\nconst table = new SQLiteTable(\"myTable\", {\n id: \"unique primary key\",\n title: \"text\",\n body: \"text\",\n created: \"integer\",\n});\n\nawait table.create();\n```\n\n---\n\n# API\n\n## Basics\n\n#### `new SQLiteTable(name: string, schema: TableScheme, options?)`\n\nStart an instance of SQLiteTable. `schema` is a required object with column\nnames as keys and definitions as values — it is stored on the instance and used\nby `.create()`. See [TableScheme](#tablescheme) below for how to define columns.\n\n`options.scope` controls which SQLite database the table lives in:\n\n| Value | Database | Use when |\n| ------------------ | --------------------------- | --------------------------------------------------------------- |\n| `\"user\"` (default) | Shared across all your vals | Data should persist and be accessible from multiple vals |\n| `\"val\"` | Scoped to this val only | Data is private to this val, or you want isolation between vals |\n\n```javascript\n// User-scoped (default) — table is shared across your account\nconst table = new SQLiteTable(\"posts\", {\n id: \"unique primary key\",\n title: \"text\",\n});\n\n// Val-scoped — table is isolated to this val\nconst table = new SQLiteTable(\"posts\", { id: \"unique primary key\" }, {\n scope: \"val\",\n});\n```\n\n#### `.create()`\n\nCreate this table in your VT SQLite storage using the schema passed to the\nconstructor. Run this only once per table.\n\n#### `.drop()`\n\nDrop this table from your VT SQLite storage.\n\n#### `.exists()`\n\nReturns whether this table exists in storage.\n\n---\n\n## Write operations\n\n### `.insertRow(rowData)`\n\nAdd a new row to your table. `rowData` is a JSON with column names as keys, and\nrow values as values.\n\n```javascript\ntable.insertRow({\n id: 1234,\n title: \"Post title\",\n body: \"Post body\",\n created: 12345678,\n});\n```\n\n### `.deleteRows(conditions?)`\n\nDeletes all rows in the table that match the condition.\n\n### `.updateRow(conditions?, rowData)`\n\nModifies all rows in the table that match the condition. `rowData` is a JSON of\nkey-value pairs to change; it does not affect any columns not mentioned.\n\n```javascript\ntable.updateRow(\n { id: 1234 },\n {\n title:\n \"New title! The existing body text is not mentioned here so it is unaffected\",\n },\n);\n```\n\n---\n\n## Read operations\n\n### `.getInfo()`\n\nReturns metadata about the table:\n\n- `columns`: array of `{ name, type }` for each column\n- `rowCount`: total number of rows\n- `pageSize`, `pageCount`: SQLite page-level storage info\n- `estimatedTableBytes`, `humanReadableSize`: estimated table size on disk\n\n```javascript\nconst info = await table.getInfo();\n// {\n// columns: [{ name: \"id\", type: \"INTEGER\" }, { name: \"title\", type: \"TEXT\" }],\n// rowCount: 42,\n// humanReadableSize: \"4 KB\",\n// ...\n// }\n```\n\n### `.countRows(conditions?)`\n\nReturns a count of all rows in the table that match the condition.\n\nconditions: Either a JSON object of column conditions, or a raw SQL WHERE clause\nas a string. See [Conditions](#conditions) below.\n\n### `.getRow(conditions?, options?)`\n\nReturns the first row matching the given conditions.\n\n`options` is an optional [`SelectOutputOptionsBase`](#selectoutputoptionsbase) object.\n\n```javascript\ntable.getRow({ id: 1234 }, { json: true, columns: [\"id\", \"title\"] });\n```\n\n### `.getRows(conditions?, options?)`\n\nReturns all rows matching the given conditions.\n\n`options` is an optional [`SelectOutputOptions`](#selectoutputoptions) object, which extends `SelectOutputOptionsBase` with ordering.\n\n```javascript\n// Basic fetch\ntable.getRows({ status: \"active\" }, { json: true });\n\n// Sorted descending, limited\ntable.getRows({ status: \"active\" }, { json: true, descendBy: \"created\", limit: 10 });\n\n// Ascending, specific columns only\ntable.getRows(undefined, { json: true, ascendBy: \"score\", columns: [\"id\", \"score\"] });\n```\n\n---\n\n## Output options\n\n### `SelectOutputOptionsBase`\n\nShared options accepted by both `.getRow()` and `.getRows()`:\n\n| Field | Type | Default | Description |\n| --------- | ---------- | ------- | -------------------------------------------------------- |\n| `json` | `boolean` | `false` | Return plain JS objects instead of raw DB output |\n| `columns` | `string[]` | — | Limit which columns are returned (defaults to all) |\n\n### `SelectOutputOptions`\n\nExtends `SelectOutputOptionsBase` with ordering options, accepted by `.getRows()`. `ascendBy` and `descendBy` are mutually exclusive.\n\n| Field | Type | Default | Description |\n| ----------- | -------- | ------- | ---------------------------------------------- |\n| `ascendBy` | `string` | — | Column name to sort by, ascending (`ASC`) |\n| `descendBy` | `string` | — | Column name to sort by, descending (`DESC`) |\n| `limit` | `number` | — | Maximum number of rows to return |\n\n### `.streamRowBatches(onBatch: Function)`\n\nIterate over all rows in batches of 1000, passing each batch to onBatch.\n\n```javascript\nawait table.streamRowBatches((batch) => {\n for (const row of batch) {\n console.log(row);\n }\n});\n```\n\n---\n\n## Indices\n\n### `.getIndices()`\n\nReturns all indices on the table as an array of `{ name, sql }` objects.\n\n```javascript\nconst indices = await table.getIndices();\n// [{ name: \"idx_title\", sql: \"CREATE INDEX idx_title ON posts (title)\" }]\n```\n\n### `.addIndex({ name, column })`\n\nCreates an index on a single column. Note: there is no `IF NOT EXISTS` guard —\ncalling this twice with the same `name` will throw.\n\n```javascript\nawait table.addIndex({ name: \"idx_title\", column: \"title\" });\n```\n\n---\n\n## Web access\n\n### `.http(req: Request): Promise`\n\nExposes read operations (`getRow`, `getRows`, `countRows`, `getInfo`) as an HTTP\nhandler, so your table can be queried directly over the network. Useful for\nbuilding lightweight read APIs on top of your SQLite data without writing custom\nrouting logic.\n\nPass it as the handler in an HTTP val, bound to the table instance:\n\n```typescript\nimport { SQLiteTable } from \"https://esm.town/v/peterqliu/SQLiteTable/main.tsx\";\n\nconst table = new SQLiteTable(\"posts\", {\n id: \"unique primary key\",\n title: \"text\",\n});\n\nexport default (req: Request) => table.http(req);\n```\n\nThen query it via URL. The last path segment selects the operation, and query\nparams become row conditions:\n\n```\nGET /getRows?title=Hello\nGET /getRow?id=1234\nGET /countRows?created=12345678\n```\n\nUse `_columns` to limit which columns are returned:\n\n```\nGET /getRows?_columns=id,title\n```\n\n**Note:** Operators in object form are not available when using `.http()`. HTTP\nquery params only support simple equality conditions.\n\nUtilities\n\n### `.AISuggestCmd(plainText: string): Promise`\n\nUse AI to generate a suggested SQLite command for a given text description of\nyour intent.\n\n```javascript\nconst cmd = await table.AISuggestCmd(\n \"show me all active users sorted by join date\",\n);\n```\n\n---\n\n## TableScheme\n\nA `TableScheme` is a plain object where each key is a column name and each value\nis a column definition. Definitions can be provided in two forms:\n\n### String form\n\nPass a raw SQLite column definition string. The value is used verbatim, so you\nhave full control over type and constraints.\n\n```javascript\n{\n id: \"integer primary key\",\n title: \"text not null\",\n score: \"real default 0\",\n}\n```\n\n### Object form\n\nPass an object with the following optional fields:\n\n| Field | Type | Description |\n| ------------ | --------------------------------------------------- | ---------------------------------- |\n| `type` | `\"text\"` \\| `\"integer\"` \\| `\"number\"` \\| `\"string\"` | Column type (defaults to `\"text\"`) |\n| `primaryKey` | `boolean` | Adds `PRIMARY KEY` constraint |\n| `unique` | `boolean` | Adds `UNIQUE` constraint |\n\n```javascript\n{\n id: { type: \"integer\", primaryKey: true },\n email: { type: \"text\", unique: true },\n score: { type: \"number\" },\n bio: {}, // defaults to TEXT, no constraints\n}\n```\n\nBoth forms can be mixed freely in the same schema:\n\n```javascript\nconst table = new SQLiteTable(\"users\", {\n id: { type: \"integer\", primaryKey: true },\n email: { type: \"text\", unique: true },\n created: \"integer not null\",\n});\n```\n\n---\n\n## Conditions\n\nSome methods use a `conditions` argument to filter which rows are matched.\nConditions can be provided in two forms:\n\n### Object form (recommended)\n\nPass a plain JS object where each key is a column name. Multiple keys are joined\nwith `AND`.\n\n**Equality** (primitive value): matches rows where the column equals the value.\nA `null` value uses `IS NULL`.\n\n```javascript\ntable.getRows({ status: \"active\", score: 42 });\n// WHERE status = 'active' AND score = 42\n\ntable.getRows({ deleted_at: null });\n// WHERE deleted_at IS NULL\n```\n\n**Operator object**: for non-equality comparisons, set the value to an object\nwith one or more of the following operators. Multiple operators on the same key\nare also joined with `AND`.\n\n| Operator | SQL equivalent | Example |\n| ------------- | -------------- | ------------------------------------ |\n| `greaterThan` | `>` | `{ score: { greaterThan: 10 } }` |\n| `atLeast` | `>=` | `{ score: { atLeast: 10 } }` |\n| `lessThan` | `<` | `{ score: { lessThan: 100 } }` |\n| `atMost` | `<=` | `{ score: { atMost: 100 } }` |\n| `notEqual` | `!=` | `{ status: { notEqual: \"banned\" } }` |\n| `like` | `LIKE` | `{ title: { like: \"%hello%\" } }` |\n| `in` | `IN (...)` | `{ id: { in: [1, 2, 3] } }` |\n\n```javascript\n// Rows where score is between 10 and 100 (inclusive), and status is not \"banned\"\ntable.getRows({\n score: { atLeast: 10, atMost: 100 },\n status: { notEqual: \"banned\" },\n});\n\n// Rows where title contains \"hello\" (case-insensitive depends on collation)\ntable.getRows({ title: { like: \"%hello%\" } });\n\n// Rows where id is one of a set of values\ntable.getRows({ id: { in: [1, 2, 3] } });\n```\n\n### Raw SQL form\n\nPass a string to use a raw SQL `WHERE` clause directly. This gives you full\nSQLite expressiveness, but you are responsible for safe formatting.\n\n```javascript\ntable.getRows(\"created > 1700000000 OR pinned = 1\");\n```",[173],"pulls","branches","forks","envVars",{"_187":77,"_189":77},"connections",{"_187":77,"_188":77},"count","unfilledCount","emptyCount",{"_49":172,"_38":173,"_36":174,"_143":-5,"_47":48,"_46":175,"_145":31,"_44":208,"_13":177,"_39":26,"_41":178,"_30":31,"_149":-5,"_196":209,"_33":210},{"_49":163,"_38":164,"_36":165,"_143":-5,"_47":48,"_46":166,"_145":55,"_44":205,"_13":168,"_39":169,"_41":170,"_30":31,"_149":-5,"_196":206,"_33":207},{"_49":155,"_38":156,"_36":157,"_143":-5,"_47":48,"_46":158,"_145":31,"_44":202,"_13":160,"_39":40,"_41":161,"_30":31,"_149":-5,"_196":203,"_33":204},{"_49":151,"_38":34,"_36":37,"_143":-5,"_47":48,"_46":14,"_145":31,"_44":199,"_13":153,"_39":40,"_41":43,"_30":31,"_149":-5,"_196":200,"_33":201},{"_49":140,"_38":141,"_36":142,"_143":-5,"_47":48,"_46":144,"_145":31,"_44":195,"_13":147,"_39":40,"_41":148,"_30":31,"_149":-5,"_196":197,"_33":198},["D",1772479798043],"children",[],[141],["D",1772479808306],[],[34],["D",1772479775766],[],[156],["D",1771726668666],[],[164],["D",1772479764165],[],[173],["D",1746232377860],["D",1789519256886],{"_105":104,"_112":108},{"_105":104,"_106":-5,"_107":108,"_19":61,"_109":110,"_111":31},{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"ctx",{"_87":-5,"_132":249,"_250":251,"_252":253,"_254":31,"_255":31,"_256":31,"_257":55,"_258":-5,"_259":-7,"_260":-7,"_261":77,"_262":31,"_263":31,"_264":-5,"_265":31,"_266":31,"_267":31,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":95,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v419