[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_180":181,"_182":183},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_91":-7,"_92":93,"_29":-7,"_94":-5,"_15":95,"_96":97,"_98":99,"_100":101,"_102":103,"_104":-5,"_105":-5,"_106":-5,"_107":38,"_108":109,"_110":38,"_111":-5,"_112":-5,"_113":114},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","kaleidawave","name","sqlite-client","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":72,"_73":74,"_75":76,"_77":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","3e5926d8-01b1-11f1-9970-42dde27851f2","createdAt",["D",1770199619201],"updatedAt",["D",1770239447366],"main","projectId","3e58dd4a-01b1-11f1-9970-42dde27851f2","version",21,"forkedBranchId","forkedBranchVersion","lockfileKey","1770200815243-esm.town_v_kaleidawave_sqlite-client@17-main","deletedAt",["D",1770199619201],"legacyEnvVars",false,"privacy","public","httpPrivacy","description","a wrapper for 'https://esm.town/v/std/sqlite'","imageUrl","userId","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",{"_11":12,"_90":86},"org",{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Ben","avatar","https://images.clerk.dev/oauth_github/img_2OMdMDIVzVrD6DdvO4fcLjF8gch.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_20":28,"_13":14,"_22":175,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_57":58,"_59":176,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":177,"_73":178,"_75":179,"_77":38},"tree",[162,163,164],"files",[162,163,164],"counts",{"_152":52,"_17":153,"_154":52,"_155":156,"_157":158},"contents",[115,116,117],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":144,"_13":145,"_120":146,"_122":-5,"_123":21,"_124":147,"_125":126,"_22":148,"_29":149,"_129":104,"_131":150,"_133":38,"_134":-5,"_92":151},{"_20":136,"_13":137,"_120":138,"_122":-5,"_123":21,"_124":139,"_125":126,"_22":140,"_29":141,"_129":130,"_131":142,"_133":38,"_134":-5,"_92":143},{"_20":118,"_13":119,"_120":121,"_122":-5,"_123":21,"_124":30,"_125":126,"_22":127,"_29":128,"_129":130,"_131":132,"_133":38,"_134":-5,"_92":135},"f9d09430-020d-11f1-b687-42dde27851f2","main.ts","fileId","3e5b43e6-01b1-11f1-9970-42dde27851f2","parentId","branchId","branchVersion","latest",true,["D",1770239447366],5,"fileType","script","content","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;","deleted","label",[119],"19993150-01b4-11f1-9e48-42dde27851f2","example.ts","34f22be8-01b2-11f1-94fa-42dde27851f2",18,["D",1770200846031],9,"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})",[137],"b8dd48b4-0209-11f1-8d35-42dde27851f2","README.md","8d7aa49c-01b3-11f1-921b-42dde27851f2",19,["D",1770237620457],4,"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)?",[145],"pulls",1,"forks","envVars",{"_159":52,"_161":52},"connections",{"_159":52,"_160":52},"count","unfilledCount","emptyCount",{"_20":144,"_13":145,"_120":146,"_122":-5,"_123":21,"_124":147,"_125":126,"_22":172,"_29":149,"_129":104,"_131":150,"_133":38,"_134":-5,"_166":173,"_92":174},{"_20":136,"_13":137,"_120":138,"_122":-5,"_123":21,"_124":139,"_125":126,"_22":169,"_29":141,"_129":130,"_131":142,"_133":38,"_134":-5,"_166":170,"_92":171},{"_20":118,"_13":119,"_120":121,"_122":-5,"_123":21,"_124":30,"_125":126,"_22":165,"_29":128,"_129":130,"_131":132,"_133":38,"_134":-5,"_166":167,"_92":168},["D",1770239447366],"children",[],[119],["D",1770200846031],[],[137],["D",1770237620457],[],[145],["D",1770199619201],["D",1789555289887],{"_11":12,"_90":86},{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"ctx",{"_71":-5,"_112":213,"_214":215,"_216":217,"_218":38,"_219":38,"_220":38,"_221":126,"_222":-5,"_223":-7,"_224":-7,"_225":52,"_226":38,"_227":38,"_228":-5,"_229":38,"_230":38,"_231":38,"_232":-5},"ENV",{"_184":185,"_186":187,"_188":26,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212},"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","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Branches1

Branches
1