[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_201":202,"_203":204},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_71":140,"_40":-7,"_141":-5,"_17":142,"_143":144,"_145":146,"_147":148,"_149":150,"_151":-5,"_152":153,"_154":155,"_156":48,"_157":158,"_159":48,"_160":-5,"_161":-5,"_162":163},"routes/_app.x.$handle.$name.compare.$branch",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":-5},"handle","charmaine","name","sqlite2","branchName","main","project",{"_32":59,"_13":14,"_34":101,"_46":-5,"_102":48,"_49":50,"_103":50,"_104":-5,"_105":-5,"_106":107,"_108":-5,"_109":48,"_110":-5,"_111":-5,"_112":113,"_53":114,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":129,"_130":131,"_132":28,"_47":48},"ahead",2,"behind",26,"diff",{"_64":65,"_66":67,"_68":69},"hasChanges",true,"sourceBranch",{"_40":57,"_13":16,"_32":58,"_38":59,"_42":33,"_43":60,"_61":50,"_62":39,"_63":54,"_55":14,"_51":12},"targetBranch",{"_32":33,"_34":35,"_36":37,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56},"pull","id","ba8d03f8-25fe-11f0-b0b8-569c3dd06744","createdAt",["D",1746043643015],"updatedAt",["D",1789481204080],"projectId","ba8cb204-25fe-11f0-b0b8-569c3dd06744","version",34,"forkedBranchId","forkedBranchVersion","lockfileKey","1789481204302-esm.town_v_std_sqlite@34-main","deletedAt","isOwned",false,"privacy","public","userHandle","std","orgId","c606f87f-4d7e-48c8-9c39-ef5ab94aec49","projectName","sqlite",3,"dc24f868-4ac5-11f0-8873-76b3cceeab13","dc21fb40-4ac5-11f0-8873-76b3cceeab13",8,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","added",[],"deleted",[],"modified",[70],{"_71":72,"_73":74,"_75":76},"path","main.tsx","targetFile",{"_32":94,"_13":72,"_78":95,"_80":-5,"_81":33,"_82":60,"_83":48,"_34":96,"_40":97,"_85":86,"_87":98,"_66":48,"_89":-5,"_90":-7,"_71":99,"_92":100},"sourceFile",{"_32":77,"_13":72,"_78":79,"_80":-5,"_81":58,"_82":57,"_83":26,"_34":84,"_40":20,"_85":86,"_87":88,"_66":48,"_89":-5,"_90":-7,"_71":91,"_92":93},"1a73f204-4ac6-11f0-b981-76b3cceeab13","fileId","41aa81f0-579f-4e2b-977b-65799679847e","parentId","branchId","branchVersion","latest",["D",1750087515615],"fileType","script","content","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`${API_URL}/v2/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nasync function batch(\n statements: InStatement[],\n mode?: TransactionMode,\n): Promise {\n const res = await fetch(`${API_URL}/v2/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statements, mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;\nexport interface ResultSet {\n /** Names of columns.\n *\n * Names of columns can be defined using the `AS` keyword in SQL:\n *\n * ```sql\n * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n * ```\n */\n columns: Array;\n\n /** Types of columns.\n *\n * The types are currently shown for types declared in a SQL table. For\n * column types of function calls, for example, an empty string is\n * returned.\n */\n columnTypes: Array;\n\n /** Rows produced by the statement. */\n rows: Array>;\n\n /** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n *\n * This value is not specified for other SQL statements.\n */\n rowsAffected: number;\n\n /** ROWID of the last inserted row.\n *\n * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n * table.\n */\n lastInsertRowid: bigint | undefined;\n}","label","children",[72],"contentHash","66642ab5126083f0524afd04bfc8e3eadb53d05c99ce4f4a3888d884f42949e4","7a9f6682-4886-11f0-afbd-76b3cceeab13","ba9079c0-25fe-11f0-b0b8-569c3dd06744",["D",1749840286838],7,"import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nasync function batch(\n statements: InStatement[],\n mode?: TransactionMode,\n): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statements, mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;\nexport interface ResultSet {\n /** Names of columns.\n *\n * Names of columns can be defined using the `AS` keyword in SQL:\n *\n * ```sql\n * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n * ```\n */\n columns: Array;\n\n /** Types of columns.\n *\n * The types are currently shown for types declared in a SQL table. For\n * column types of function calls, for example, an empty string is\n * returned.\n */\n columnTypes: Array;\n\n /** Rows produced by the statement. */\n rows: Array>;\n\n /** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n *\n * This value is not specified for other SQL statements.\n */\n rowsAffected: number;\n\n /** ROWID of the last inserted row.\n *\n * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n * table.\n */\n lastInsertRowid: bigint | undefined;\n}",[72],"9d3c136dfc22f63cf18b8751447c60202da221fbe49f5eecd340a87c93022ee1",["D",1750087411044],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_139":135},"org",{"_11":12,"_133":-5,"_134":135,"_106":107,"_136":137,"_138":48},"branch","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":59,"_13":14,"_34":197,"_46":-5,"_102":48,"_49":50,"_103":50,"_104":-5,"_105":-5,"_106":107,"_108":-5,"_109":48,"_110":-5,"_111":-5,"_112":113,"_53":114,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":198,"_130":199,"_132":200,"_47":48},"tree",[190,191],"files",[190,191],"counts",{"_180":113,"_181":176,"_182":113,"_183":184,"_185":186},"contents",[169,170],"file","upstreamProject",{"_32":39,"_13":56,"_104":166,"_105":-5,"_49":50,"_128":167},"upstreamBranch",{"_32":33,"_34":164,"_36":165,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746043643015],["D",1789481204080],"Standard SQLite client for Val Town",{"_11":52,"_139":168},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ",{"_32":173,"_13":174,"_78":175,"_80":-5,"_81":58,"_82":176,"_83":26,"_34":177,"_40":113,"_85":151,"_87":178,"_66":48,"_89":-5,"_71":179},{"_32":77,"_13":72,"_78":79,"_80":-5,"_81":58,"_82":57,"_83":26,"_34":171,"_40":20,"_85":86,"_87":88,"_66":48,"_89":-5,"_71":172},["D",1750087515615],[72],"dc27615c-4ac5-11f0-8873-76b3cceeab13","README.md","af78748f-3314-41a7-bcbb-ce04ee654bf3",1,["D",1750087411044],"# SQLite - [Docs ↗](https://docs.val.town/std/sqlite)\n\n[SQLite](https://www.sqlite.org/) is a lightweight, standard database. Every Val Town account comes with its own private SQLite database that is accessible from any of your vals via [`std/sqlite`](https://www.val.town/v/std/sqlite).\n\nVal Town SQLite is powered by [Turso](https://turso.tech/).\n\n* [Usage](https://docs.val.town/std/sqlite/usage)\n* [Migrations](https://docs.val.town/std/sqlite/migrations)\n* [ORMs](https://docs.val.town/std/sqlite/orms)\n\nWe recommend these admin data viewers for managing your database – viewing or editing data or your database table schema:\n\n* [Outerbase Studio](https://libsqlstudio.com/) **(recommended)** - formely known as LibSQL Studio – see instructions [here](https://libsqlstudio.com/docs/connect-valtown)\n* [SQLite Explorer](https://www.val.town/v/nbbaier/sqliteExplorerApp) (built in Val Town)\n\n## Limits\n\nYou can store 10mb on the free plan and up to 1gb on the paid plan. Contact us if you need more space.\n\n\n[📝 Edit docs](https://github.com/val-town/val-town-docs/edit/main/src/content/docs/std/SQLite/index.mdx)\n\nMigrated from folder: sqlite/sqlite",[174],"pulls","branches","forks","envVars",{"_187":113,"_189":113},"connections",{"_187":113,"_188":113},"count","unfilledCount","emptyCount",{"_32":173,"_13":174,"_78":175,"_80":-5,"_81":58,"_82":176,"_83":26,"_34":194,"_40":113,"_85":151,"_87":178,"_66":48,"_89":-5,"_90":195,"_71":196},{"_32":77,"_13":72,"_78":79,"_80":-5,"_81":58,"_82":57,"_83":26,"_34":84,"_40":20,"_85":86,"_87":88,"_66":48,"_89":-5,"_90":192,"_71":193},[],[72],["D",1750087411044],[],[174],["D",1750087411044],{"_11":12,"_139":135},{"_11":12,"_133":-5,"_134":135,"_106":107,"_136":137,"_138":48},{"_40":57,"_13":16,"_32":58,"_38":59,"_42":33,"_43":60,"_61":50,"_62":39,"_63":54,"_55":14,"_51":12},"ctx",{"_128":-5,"_161":234,"_235":236,"_237":238,"_239":48,"_240":48,"_241":48,"_242":26,"_243":-5,"_244":-7,"_245":-7,"_246":113,"_247":48,"_248":48,"_249":-5,"_250":48,"_251":48,"_252":48,"_253":-5},"ENV",{"_205":206,"_207":208,"_209":16,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233},"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"]

Compare

Mergecharmaine/mainintostd/main

main.tsx+2-2