[{"_1":2,"_267":-5,"_268":-5},"loaderData",{"_3":4,"_93":94,"_232":233},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":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","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_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":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","6050acf0705e6826bb1b68e27572c5b8979c5bd9","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",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":22,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":22,"_92":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",{"_83":22,"_21":22,"_84":74,"_85":86,"_87":74,"_88":47,"_89":22,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":-7,"_100":74,"_101":-7,"_102":103,"_156":157,"_200":201,"_202":203,"_215":216,"_172":-5,"_226":-5,"_227":-5,"_228":22,"_229":22,"_230":231},"handle","kaleidawave","name","sqlite-client","branchName","path","version","project",{"_104":105,"_97":98,"_106":107,"_108":-5,"_109":22,"_110":111,"_112":113,"_114":-5,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":123,"_124":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":135,"_138":139,"_143":144,"_155":22},"id","3e58dd4a-01b1-11f1-9970-42dde27851f2","createdAt",["D",1770199619201],"deletedAt","legacyEnvVars","privacy","public","description","a wrapper for 'https://esm.town/v/std/sqlite'","imageUrl","af37484e-d053-4149-8be7-34ae3fff0459","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","76e92795-d42b-48fa-8fa3-5e72922deaf2","tursoName","3e58dd4a01b111f1997042dde27851f2","tursoHostname","3e58dd4a01b111f1997042dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_136":137},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2OMdMDIVzVrD6DdvO4fcLjF8gch.jpeg","org",{"_95":96,"_140":137,"_14":115,"_141":142},"avatar","tier","free","branch",{"_101":145,"_97":45,"_104":146,"_147":105,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},21,"3e5926d8-01b1-11f1-9970-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[158,180,191],{"_104":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":168,"_106":169,"_101":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_177":178,"_100":179},"b8dd48b4-0209-11f1-8d35-42dde27851f2","README.md","fileId","8d7aa49c-01b3-11f1-921b-42dde27851f2","parentId","branchId","branchVersion",19,"latest",true,["D",1770237620457],4,"fileType","file","content","A wrapper for 'https://esm.town/v/std/sqlite' that turns the value array into objects.\n\n### TODO\n\n- A 1:1 API match with the Bun SQLite API **but** with `Promise` results instead (due to technical differences)?","deleted","label","children",[],[160],{"_104":181,"_97":182,"_161":183,"_163":-5,"_164":146,"_165":184,"_167":168,"_106":185,"_101":186,"_171":187,"_173":188,"_175":22,"_176":-5,"_177":189,"_100":190},"19993150-01b4-11f1-9e48-42dde27851f2","example.ts","34f22be8-01b2-11f1-94fa-42dde27851f2",18,["D",1770200846031],9,"script","import { sqlite as sqlite1 } from \"https://esm.town/v/std/sqlite\";\nimport sqlite2 from \"https://esm.town/v/kaleidawave/sqlite-client/global.ts\"; // TODO how can we drop the `/global.ts`\n\nconsole.dir({\n 1: await sqlite1.execute(\"SELECT 1 as x;\"),\n 2: await sqlite2.execute(\"SELECT 1 as x;\"),\n})",[],[182],{"_104":192,"_97":193,"_161":194,"_163":-5,"_164":146,"_165":145,"_167":168,"_106":195,"_101":196,"_171":187,"_173":197,"_175":22,"_176":-5,"_177":198,"_100":199},"f9d09430-020d-11f1-b687-42dde27851f2","main.ts","3e5b43e6-01b1-11f1-9970-42dde27851f2",["D",1770239447366],5,"import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\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;",[],[193],"files",[158,180,191],"counts",{"_204":33,"_205":206,"_207":33,"_208":209,"_212":213},"pulls","branches",1,"forks","envVars",{"_210":33,"_211":33},"count","emptyCount","connections",{"_210":33,"_214":33},"unfilledCount","contents",[217,220,223],{"_104":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":168,"_106":218,"_101":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_100":219},["D",1770237620457],[160],{"_104":181,"_97":182,"_161":183,"_163":-5,"_164":146,"_165":184,"_167":168,"_106":221,"_101":186,"_171":187,"_173":188,"_175":22,"_176":-5,"_100":222},["D",1770200846031],[182],{"_104":192,"_97":193,"_161":194,"_163":-5,"_164":146,"_165":145,"_167":168,"_106":224,"_101":196,"_171":187,"_173":197,"_175":22,"_176":-5,"_100":225},["D",1770239447366],[193],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_95":96,"_97":98,"_99":-7,"_101":-7,"_102":234,"_215":239,"_246":247,"_250":-5,"_251":-5,"_200":252,"_262":-5,"_263":-5,"_264":-5,"_265":22,"_266":22},{"_104":105,"_97":98,"_106":235,"_108":-5,"_109":22,"_110":111,"_112":113,"_114":-5,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":123,"_124":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":236,"_138":237,"_143":238,"_155":22},["D",1770199619201],{"_95":96,"_136":137},{"_95":96,"_140":137,"_14":115,"_141":142},{"_101":145,"_97":45,"_104":146,"_147":105,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},[240,242,244],{"_104":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":168,"_106":218,"_101":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_100":241},[160],{"_104":181,"_97":182,"_161":183,"_163":-5,"_164":146,"_165":184,"_167":168,"_106":221,"_101":186,"_171":187,"_173":188,"_175":22,"_176":-5,"_100":243},[182],{"_104":192,"_97":193,"_161":194,"_163":-5,"_164":146,"_165":145,"_167":168,"_106":224,"_101":196,"_171":187,"_173":197,"_175":22,"_176":-5,"_100":245},[193],"readme",{"_104":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":168,"_106":248,"_101":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_100":249},["D",1770237620457],[160],"upstream","pull",[253,256,259],{"_104":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":168,"_106":169,"_101":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_177":254,"_100":255},[],[160],{"_104":181,"_97":182,"_161":183,"_163":-5,"_164":146,"_165":184,"_167":168,"_106":185,"_101":186,"_171":187,"_173":188,"_175":22,"_176":-5,"_177":257,"_100":258},[],[182],{"_104":192,"_97":193,"_161":194,"_163":-5,"_164":146,"_165":145,"_167":168,"_106":195,"_101":196,"_171":187,"_173":197,"_175":22,"_176":-5,"_177":260,"_100":261},[],[193],"preview","ahead","behind","showHomeCustomizationHint","showHTTPPreviewSettingsHint","actionData","errors"]