[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_171":172,"_173":174},"routes/_app.x.$handle.$name",{"_98":97,"_33":45,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":25,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_33":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":30},"file",{"_31":32,"_33":28,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_31":32,"_33":30,"_34":35,"_36":37},"deleted",false,"deletedHere","path","global.ts","latestPath","main.ts","fileId","3e5b43e6-01b1-11f1-9970-42dde27851f2","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\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\t/**\n\t * The SQL statement to execute.\n\t */\n\tsql: string;\n\n\t/**\n\t * The arguments to bind to the SQL statement.\n\t */\n\targs: InArgs;\n} | string;\n\nexport interface ResultSet {\n\t/** Names of columns.\n\t *\n\t * Names of columns can be defined using the `AS` keyword in SQL:\n\t *\n\t * ```sql\n\t * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n\t * ```\n\t */\n\tcolumns: Array;\n\n\t/** Types of columns.\n\t *\n\t * The types are currently shown for types declared in a SQL table. For\n\t * column types of function calls, for example, an empty string is\n\t * returned.\n\t */\n\tcolumnTypes: Array;\n\n\t/** Rows produced by the statement. */\n\t// TODO real value rows: Array>;\n\trows: Array;\n\n\t/** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n\t *\n\t * This value is not specified for other SQL statements.\n\t */\n\trowsAffected: number;\n\n\t/** ROWID of the last inserted row.\n\t *\n\t * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n\t * table.\n\t */\n\tlastInsertRowid: bigint | undefined;\n}\n\nexport type TransactionMode = \"write\" | \"read\" | \"deferred\";\n\nexport interface SQLClient {\n\texecute(statement: InStatement): Promise;\n\tbatch(\n\t\tstatements: InStatement[],\n\t\tmode?: TransactionMode,\n\t): Promise\n}\n\nconst valTownSQLClient: SQLClient = {\n\tasync execute(statement) {\n\t\tconst out = await sqlite.execute(statement);\n\t\treturn { ...out, rows: out.rows.map((row: Array) => buildObject(row, out.columns)) }\n\t},\n\tasync batch(_statements, _mode) {\n\t\tthrow new Error(\"TODO batch\");\n\t},\n}\n\n/** For SQL client */\nexport function buildObject(row: Array, headers: Array, kindHeaders: Array = []) {\n\tconst object = {};\n\tfor (let i = 0; i < headers.length; i++) {\n\t\tReflect.set(object, headers[i], row[i]);\n\t}\n\treturn object;\n}\n\nexport default valTownSQLClient;","createdAt",["D",1770200423906],"branchVersion","branchId","3e5926d8-01b1-11f1-9970-42dde27851f2","id","3e58dd4a-01b1-11f1-9970-42dde27851f2","sqlite-client",["D",1770199619201],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","a wrapper for 'https://esm.town/v/std/sqlite'","imageUrl","af37484e-d053-4149-8be7-34ae3fff0459","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","76e92795-d42b-48fa-8fa3-5e72922deaf2","tursoName","3e58dd4a01b111f1997042dde27851f2","tursoHostname","3e58dd4a01b111f1997042dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789555289887],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_33":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kaleidawave","handle","displayName","Ben","avatar","https://images.clerk.dev/oauth_github/img_2OMdMDIVzVrD6DdvO4fcLjF8gch.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_33":45,"_38":166,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":167,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":168,"_82":169,"_84":170,"_86":25},"tree",[157,158],"files",[157,158],"counts",{"_146":61,"_147":148,"_149":61,"_150":151,"_152":153},"contents",[129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":138,"_33":139,"_31":140,"_132":-5,"_41":42,"_40":141,"_133":25,"_38":142,"_13":143,"_34":35,"_36":144,"_24":25,"_136":-5,"_27":145},{"_43":131,"_33":28,"_31":32,"_132":-5,"_41":42,"_40":14,"_133":25,"_38":134,"_13":135,"_34":35,"_36":37,"_24":25,"_136":-5,"_27":137},"1dfe7e2c-01b3-11f1-bda8-42dde27851f2","parentId","latest",["D",1770200423906],3,"label",[28],"9711ff88-01b2-11f1-872e-42dde27851f2","example.ts","34f22be8-01b2-11f1-94fa-42dde27851f2",9,["D",1770200197542],6,"import { sqlite as sqlite1 } from \"https://esm.town/v/std/sqlite\";\nimport sqlite2 from \"https://esm.town/v/kaleidawave/sqlite-client/main.ts\";\n\nconsole.dir({\n 1: await sqlite1.execute(\"SELECT 1 as x;\"),\n // 2: await sqlite2.execute(\"SELECT 1 as x;\"),\n})",[139],"pulls","branches",1,"forks","envVars",{"_154":61,"_156":61},"connections",{"_154":61,"_155":61},"count","unfilledCount","emptyCount",{"_43":138,"_33":139,"_31":140,"_132":-5,"_41":42,"_40":141,"_133":25,"_38":163,"_13":143,"_34":35,"_36":144,"_24":25,"_136":-5,"_160":164,"_27":165},{"_43":131,"_33":28,"_31":32,"_132":-5,"_41":42,"_40":14,"_133":25,"_38":159,"_13":135,"_34":35,"_36":37,"_24":25,"_136":-5,"_160":161,"_27":162},["D",1770200423906],"children",[],[28],["D",1770200197542],[],[139],["D",1770199619201],["D",1789555289887],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_33":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":204,"_205":206,"_207":208,"_209":25,"_210":25,"_211":25,"_212":213,"_214":-5,"_215":-7,"_216":-7,"_217":61,"_218":25,"_219":25,"_220":-5,"_221":25,"_222":25,"_223":25,"_224":-5},"ENV",{"_175":176,"_177":178,"_179":88,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11