[{"_1":2,"_294":-5,"_295":-5},"loaderData",{"_3":4,"_92":93,"_216":217},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22,"_34":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","cc84c354d468f71f0e60f0bd0f1350df018d772d","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":22,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":22,"_91":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":22,"_21":22,"_83":73,"_84":85,"_86":73,"_87":46,"_88":22,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_94":95,"_96":97,"_98":44,"_99":100,"_101":-7,"_102":103,"_158":159,"_190":191,"_192":193,"_205":206,"_172":207,"_210":-5,"_211":-5,"_212":22,"_213":22,"_214":215},"handle","std","name","sqlite","branchName","path","main.ts","version","project",{"_104":105,"_96":97,"_106":107,"_108":-5,"_109":110,"_111":112,"_113":114,"_115":-5,"_14":116,"_117":-5,"_118":110,"_119":-5,"_120":-5,"_121":122,"_16":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":131,"_133":131,"_134":131,"_135":129,"_136":129,"_23":137,"_140":141,"_145":146,"_157":22},"id","ba8cb204-25fe-11f0-b0b8-569c3dd06744","createdAt",["D",1746043643015],"deletedAt","legacyEnvVars",true,"privacy","public","description","Standard SQLite client for Val Town","imageUrl","c9143560-63b6-444f-8f9f-e2647fabe09f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"c606f87f-4d7e-48c8-9c39-ef5ab94aec49","tursoName","ba8cb20425fe11f0b0b8569c3dd06744","tursoHostname","ba8cb20425fe11f0b0b8569c3dd06744-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","rw","blobPerm","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_138":139},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ","org",{"_94":95,"_142":139,"_14":-5,"_143":144},"avatar","tier","pro","branch",{"_101":147,"_96":44,"_104":148,"_149":105,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":97,"_156":95},15,"ba8d03f8-25fe-11f0-b0b8-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[160,180],{"_104":161,"_96":162,"_163":164,"_165":-5,"_166":148,"_167":147,"_168":110,"_106":169,"_101":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_177":178,"_99":179},"e886994e-f8a9-11f0-8432-42dde27851f2","README.md","fileId","ba907fa6-25fe-11f0-b0b8-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1769206908260],4,"fileType","file","content","# std/sqlite\n\nThis is the interface to the new scoped databases: a database for every val.\nImport this into your vals to interact with SQLite databases. This configures\nand re-exports an instance of the\n[@libsql/client](https://docs.turso.tech/sdk/ts/quickstart) module, so all of\nthe same methods work here: `execute`, `batch` and others.\n\n### Example\n\n```ts\nimport sqlite from \"https://esm.town/v/std/db/main.ts\";\nawait sqlite.execute('CREATE TABLE IF NOT EXISTS \"docs\" (contents TEXT)');\nawait sqlite.execute('INSERT INTO docs (contents) VALUES (\"Hello, world!\")');\n```\n\nLooking for the interface to _user_ databases, the legacy system: check out\n[sqlite2](https://www.val.town/x/std/sqlite2).","deleted","label","children",[],[162],{"_104":181,"_96":100,"_163":182,"_165":-5,"_166":148,"_167":183,"_168":110,"_106":184,"_101":185,"_171":186,"_173":187,"_175":22,"_176":-5,"_177":188,"_99":189},"62a6a508-f89f-11f0-800c-42dde27851f2","ba9079c0-25fe-11f0-b0b8-569c3dd06744",14,["D",1769202388682],10,"script","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { createClient } from \"npm:@libsql/client@0.17.0/web\";\n\nexport const sqlite = createClient({\n url: `${API_URL}/v3/sqlite/scoped/`,\n authToken: Deno.env.get(\"VAL_TOWN_API_KEY\"),\n});\n\nexport default sqlite;",[],[100],"files",[160,180],"counts",{"_194":32,"_195":196,"_197":185,"_198":199,"_202":203},"pulls","branches",2,"forks","envVars",{"_200":32,"_201":32},"count","emptyCount","connections",{"_200":32,"_204":32},"unfilledCount","contents",[],{"_104":181,"_96":100,"_163":182,"_165":-5,"_166":148,"_167":183,"_168":110,"_106":208,"_101":185,"_171":186,"_173":187,"_175":22,"_176":-5,"_99":209},["D",1769202388682],[100],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_94":95,"_96":97,"_98":44,"_99":100,"_102":218,"_172":223,"_226":227,"_277":278,"_291":-7,"_292":32,"_293":22},{"_104":105,"_96":97,"_106":219,"_108":-5,"_109":110,"_111":112,"_113":114,"_115":-5,"_14":116,"_117":-5,"_118":110,"_119":-5,"_120":-5,"_121":122,"_16":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":131,"_133":131,"_134":131,"_135":129,"_136":129,"_23":220,"_140":221,"_145":222,"_157":22},["D",1746043643015],{"_94":95,"_138":139},{"_94":95,"_142":139,"_14":-5,"_143":144},{"_101":147,"_96":44,"_104":148,"_149":105,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":97,"_156":95},{"_104":181,"_96":100,"_163":182,"_165":-5,"_166":148,"_167":183,"_168":110,"_106":224,"_101":185,"_171":186,"_173":187,"_175":22,"_176":-5,"_99":225},["D",1769202388682],[100],"history",[228,230,236,241,246,251,256,260,265,269,273],{"_104":181,"_166":148,"_163":182,"_96":100,"_173":187,"_171":186,"_101":185,"_165":-5,"_106":229,"_167":183,"_176":-5},["D",1769202388682],{"_104":231,"_166":148,"_163":182,"_96":232,"_173":187,"_171":186,"_101":233,"_165":-5,"_106":234,"_167":235,"_176":-5},"d02f0698-f89e-11f0-9501-42dde27851f2","main.tsx",9,["D",1769202142961],12,{"_104":237,"_166":148,"_163":182,"_96":232,"_173":238,"_171":186,"_101":239,"_165":-5,"_106":240,"_167":233,"_176":-5},"fa62f482-7c3f-11f0-95cb-0224a6c84d84","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type TransactionMode } from \"npm:@libsql/client@0.6.0\";\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}",8,["D",1755527467392],{"_104":242,"_166":148,"_163":182,"_96":232,"_173":243,"_171":186,"_101":244,"_165":-5,"_106":245,"_167":239,"_176":-5},"7a9f6682-4886-11f0-afbd-76b3cceeab13","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}",7,["D",1749840286838],{"_104":247,"_166":148,"_163":182,"_96":232,"_173":248,"_171":186,"_101":249,"_165":-5,"_106":250,"_167":244,"_176":-5},"baab7d56-25fe-11f0-b0b8-569c3dd06744","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 ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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}",6,["D",1712175940519],{"_104":252,"_166":148,"_163":182,"_96":232,"_173":253,"_171":186,"_101":254,"_165":-5,"_106":255,"_167":249,"_176":-5},"baa74a1a-25fe-11f0-b0b8-569c3dd06744","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\nexport const sqlite = {\n execute,\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 ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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 sql: string;\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}",5,["D",1710276658820],{"_104":257,"_166":148,"_163":182,"_96":232,"_173":258,"_171":186,"_101":170,"_165":-5,"_106":259,"_167":254,"_176":-5},"baa298d0-25fe-11f0-b0b8-569c3dd06744","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nexport const sqlite = {\n execute,\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 ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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 sql: string;\n args: InArgs;\n} | string;",["D",1700233073835],{"_104":261,"_166":148,"_163":182,"_96":232,"_173":262,"_171":186,"_101":263,"_165":-5,"_106":264,"_167":170,"_176":-5},"ba9e9758-25fe-11f0-b0b8-569c3dd06744","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=42\";\nimport { LibsqlError, type ResultSet, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nexport const sqlite = {\n execute,\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 ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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 sql: string;\n args: InArgs;\n} | string;",3,["D",1700183628954],{"_104":266,"_166":148,"_163":182,"_96":232,"_173":267,"_171":186,"_101":196,"_165":-5,"_106":268,"_167":263,"_176":-5},"ba9a7aec-25fe-11f0-b0b8-569c3dd06744","import { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=42\";\nimport { LibsqlError, type ResultSet, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nexport const sqlite = {\n execute,\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`https://api.val.town/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`https://api.val.town/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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 sql: string;\n args: InArgs;\n} | string;",["D",1700160476497],{"_104":270,"_166":148,"_163":182,"_96":232,"_173":271,"_171":186,"_101":122,"_165":-5,"_106":272,"_167":196,"_176":-5},"ba95bf84-25fe-11f0-b0b8-569c3dd06744","import { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=42\";\nimport { LibsqlError, type ResultSet, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nexport const sqlite = {\n execute,\n batch,\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// ------------\n// Functions\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\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`https://api.val.town/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`https://api.val.town/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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\n// ------------\n// Types\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 sql: string;\n args: InArgs;\n} | string;",["D",1700160339221],{"_104":274,"_166":148,"_163":182,"_96":232,"_173":275,"_171":186,"_101":32,"_165":-5,"_106":276,"_167":122,"_176":-5},"ba9078e4-25fe-11f0-b0b8-569c3dd06744","import _ from \"npm:lodash-es\";\n\nlet numbers = _.range(10);\nexport const untitled_brownMink = numbers.map(n => n * 2);",["D",1700160325624],"versions",[279,281,282,283,284,285,286,287,288,289,290],{"_172":228,"_280":230},"previous",{"_172":230,"_280":236},{"_172":236,"_280":241},{"_172":241,"_280":246},{"_172":246,"_280":251},{"_172":251,"_280":256},{"_172":256,"_280":260},{"_172":260,"_280":265},{"_172":265,"_280":269},{"_172":269,"_280":273},{"_172":273,"_280":-5},"versionNumber","page","hasNext","actionData","errors"]

std

sqlite

History for main.ts