[{"_1":2,"_178":-5,"_179":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","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":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_156":157,"_175":176,"_177":-5},"handle","kaleidawave","name","sqlite-client","path","main.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":112,"_113":-5,"_12":114,"_115":-5,"_116":20,"_117":-5,"_118":-5,"_119":33,"_14":120,"_121":122,"_123":124,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":134,"_137":138,"_142":143,"_155":20},"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,"_135":136},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2OMdMDIVzVrD6DdvO4fcLjF8gch.jpeg","org",{"_95":96,"_139":136,"_12":114,"_140":141},"avatar","tier","free","branch",{"_144":145,"_97":45,"_103":146,"_147":104,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},"version",21,"3e5926d8-01b1-11f1-9970-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":158,"_97":100,"_159":160,"_161":-5,"_162":146,"_163":145,"_164":165,"_105":166,"_144":167,"_168":169,"_170":171,"_172":20,"_173":-5,"_99":174},"f9d09430-020d-11f1-b687-42dde27851f2","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",[100],"permalink","https://www.val.town/x/kaleidawave/sqlite-client/code/main.ts","extension","actionData","errors"]