[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_183":184,"_185":186},"routes/_app.x.$handle.$name",{"_98":97,"_32":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,"_32":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",17,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","example.ts","latestPath","fileId","34f22be8-01b2-11f1-94fa-42dde27851f2","name","fileType","script","content","import { sqlite as sqlite1 } from \"https://esm.town/v/std/sqlite\";\nimport sqlite2 from \"https://esm.town/v/kaleidawave/sqlite-client/global.ts\";\n\nconsole.dir({\n 1: await sqlite1.execute(\"SELECT 1 as x;\"),\n 2: await sqlite2.execute(\"SELECT 1 as x;\"),\n})","import { sqlite as sqlite1 } from \"https://esm.town/v/std/sqlite\";\nimport sqlite2 from \"https://esm.town/v/kaleidawave/sqlite-client\";\n\nconsole.dir({\n 1: await sqlite1.execute(\"SELECT 1 as x;\"),\n 2: await sqlite2.execute(\"SELECT 1 as x;\"),\n})","createdAt",["D",1770200812932],"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,"_32":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,"_32":45,"_38":178,"_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":179,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":180,"_82":181,"_84":182,"_86":25},"tree",[165,166,167],"files",[165,166,167],"counts",{"_154":61,"_155":156,"_157":61,"_158":159,"_160":161},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":147,"_32":148,"_30":149,"_135":-5,"_41":42,"_40":150,"_137":25,"_38":151,"_13":139,"_33":20,"_35":152,"_24":25,"_141":-5,"_27":153},{"_43":143,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":144,"_13":145,"_33":34,"_35":37,"_24":25,"_141":-5,"_27":146},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":25,"_38":138,"_13":139,"_33":34,"_35":140,"_24":25,"_141":-5,"_27":142},"1dfe7e2c-01b3-11f1-bda8-42dde27851f2","global.ts","3e5b43e6-01b1-11f1-9970-42dde27851f2","parentId",11,"latest",["D",1770200423906],3,"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;","label",[133],"05ded2d2-01b4-11f1-9801-42dde27851f2",["D",1770200812932],8,[28],"017f5d7e-01b4-11f1-bce0-42dde27851f2","README.md","8d7aa49c-01b3-11f1-921b-42dde27851f2",16,["D",1770200805596],"A wrapper for 'https://esm.town/v/std/sqlite' that turns the value array into objects.\n\nIdeally will be 1:1 API match with the Bun SQLite API **but** with `Promise` results instead due to technical differences.",[148],"pulls","branches",1,"forks","envVars",{"_162":61,"_164":61},"connections",{"_162":61,"_163":61},"count","unfilledCount","emptyCount",{"_43":147,"_32":148,"_30":149,"_135":-5,"_41":42,"_40":150,"_137":25,"_38":175,"_13":139,"_33":20,"_35":152,"_24":25,"_141":-5,"_169":176,"_27":177},{"_43":143,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":172,"_13":145,"_33":34,"_35":37,"_24":25,"_141":-5,"_169":173,"_27":174},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":25,"_38":168,"_13":139,"_33":34,"_35":140,"_24":25,"_141":-5,"_169":170,"_27":171},["D",1770200423906],"children",[],[133],["D",1770200812932],[],[28],["D",1770200805596],[],[148],["D",1770199619201],["D",1789555289887],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":216,"_217":218,"_219":220,"_221":25,"_222":25,"_223":25,"_224":225,"_226":-5,"_227":-7,"_228":-7,"_229":61,"_230":25,"_231":25,"_232":-5,"_233":25,"_234":25,"_235":25,"_236":-5},"ENV",{"_187":188,"_189":190,"_191":88,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215},"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 · v17