[{"_1":2,"_169":-5,"_170":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","notificationCount",0,"flagDenols","ENV",{"_36":37,"_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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2f607f7b74b4e52529fb75176d403d8b5b284eb1","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_148":149,"_166":167,"_168":-5},"handle","postpostscript","name","sqliteUniverse","path","main.tsx","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":107,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":107,"_115":-5,"_116":117,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","6ccf5c0c-2760-11f0-86ff-569c3dd06744","createdAt",["D",1746195554433],"deletedAt","legacyEnvVars",true,"privacy","public","description","imageUrl","4bfb99a9-2008-40e0-bacb-7c7d84227cee","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"1073b191-f665-405d-9530-545465c93575","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJjdlhaRXl0WXVNSlhZcWU0ckI2c1BOMjNhQSJ9","org",{"_93":94,"_133":130},"avatar","branch",{"_136":137,"_95":43,"_101":138,"_139":102,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},"version",60,"6ccfabc6-2760-11f0-86ff-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":150,"_95":98,"_151":152,"_153":-5,"_154":138,"_155":137,"_156":107,"_103":157,"_136":158,"_159":160,"_161":162,"_163":20,"_164":-5,"_97":165},"6e294d7e-2760-11f0-86ff-569c3dd06744","fileId","6cd28b98-2760-11f0-86ff-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1710090423026],59,"fileType","script","content","import { getValEndpointFromName } from \"https://esm.town/v/postpostscript/meta\";\nimport { getTableNames, replaceTableNames } from \"https://esm.town/v/postpostscript/sqliteAST\";\nimport { sqliteFromBlob } from \"https://esm.town/v/postpostscript/sqliteBackup\";\nimport { Statement, StatementInstance } from \"https://esm.town/v/postpostscript/sqliteBuilder\";\nimport { sqliteDump } from \"https://esm.town/v/postpostscript/sqliteDump\";\nimport { sqliteFromAPI } from \"https://esm.town/v/postpostscript/sqliteFromAPI\";\nimport type { SqliteInterface } from \"https://esm.town/v/postpostscript/sqliteTypes\";\nimport { createSqlite } from \"https://esm.town/v/postpostscript/sqliteWasm\";\nimport type { MaybePromise } from \"https://esm.town/v/postpostscript/typeUtils\";\nimport type { InStatement } from \"https://esm.town/v/std/sqlite\";\nimport type { ResultSet } from \"npm:@libsql/client\";\n\nexport const sqliteUniverse = {\n execute,\n batch,\n};\n\nexport function sqliteUniverseWithOptions(options: SqliteUniverseOptions) {\n return {\n execute(statement: InStatement) {\n return execute(statement, options);\n },\n batch(statements: InStatement[]) {\n return batch(statements, options);\n },\n };\n}\n\nasync function execute(\n statement: InStatement,\n options: SqliteUniverseOptions = {},\n): Promise> {\n const [res] = await batch([statement], options);\n return res;\n}\n\nasync function batch(\n statements: InStatement[],\n options: SqliteUniverseOptions = {},\n): Promise[]> {\n const endpointTableMap: EndpointTableMap = {};\n\n const fullTableNames = statements.map(getTableNames).reduce((res, { tables }) => {\n return new Set([...res, ...tables]);\n }, new Set());\n\n fullTableNames.forEach(fullTable => {\n const parts = fullTable.split(\"/\");\n const endpoint = parts.slice(0, -1).join(\"/\");\n const table = parts.slice(-1)[0];\n endpointTableMap[endpoint] ??= new Set();\n endpointTableMap[endpoint].add(table);\n });\n\n const sqlite = await createSqliteFromEndpointTables(endpointTableMap, options);\n const normalized = statements.map(statement => {\n let { sql, args } = typeof statement === \"string\"\n ? new StatementInstance(statement)\n : statement;\n\n let match;\n while (match = sql.match(/\"([^\"]+\\/)sqlite_schema\"/)) {\n const [full, start] = match;\n const index = sql.indexOf(full);\n const numPreviousArgs = sql.slice(0, index).split(\"?\").length - 1;\n if (!args) {\n args = [];\n }\n args.splice(numPreviousArgs, 0, `${start}%`);\n sql = [\n sql.slice(0, index),\n `(SELECT * FROM sqlite_schema WHERE tbl_name LIKE ?)`,\n sql.slice(index + full.length),\n ].join(\"\");\n }\n\n return new StatementInstance(\n sql,\n args,\n );\n });\n return sqlite.batch(normalized);\n}\n\nasync function createSqliteFromEndpointTables(\n endpointTableMap: EndpointTableMap,\n { interfaces = defaultInterfaces }: SqliteUniverseOptions = {},\n) {\n const schemas = Object.entries(endpointTableMap).map(async ([endpoint, tables]) => {\n let sqlite = await interfaces.exact?.[endpoint];\n\n if (sqlite instanceof Function) {\n sqlite = await sqlite({ endpoint, tables });\n }\n\n for (let i = 0; !sqlite && i < interfaces.patterns?.length; i++) {\n const [test, method] = interfaces.patterns[i];\n const match = endpoint.match(test);\n if (match) {\n sqlite = await method({\n endpoint,\n match,\n tables,\n });\n }\n }\n\n if (!sqlite && interfaces.fallback) {\n sqlite = await interfaces.fallback({ endpoint, tables });\n }\n\n if (!sqlite) {\n throw new Error(`interface not valid for ${endpoint}`);\n }\n\n const tableNames = [...tables];\n\n return sqliteDump({\n tables: tableNames.filter(table => table !== \"sqlite_schema\"),\n sqlite,\n allSchemas: !!tableNames.find(table => table.toLowerCase().endsWith(\"sqlite_schema\")),\n transformStatement(statement: StatementInstance, table: string) {\n if (!endpoint) return statement;\n return new StatementInstance(\n replaceTableNames(statement.sql, (name) => {\n return `${endpoint}/${name}`;\n }),\n statement.args,\n );\n },\n });\n });\n\n const sqlite = createSqlite();\n sqlite.batch((await Promise.all(schemas)).flat());\n return sqlite;\n}\n\nexport const patterns = {\n https: [\n /^https:\\/\\//,\n ({ endpoint }) => {\n return sqliteFromAPI(endpoint);\n },\n ] as SqlitePatternTup,\n val: [\n /^@/,\n ({ endpoint }) => {\n return sqliteFromAPI(endpoint);\n },\n ] as SqlitePatternTup,\n blob: [\n /^blob:\\/\\//,\n ({ endpoint }) => {\n return sqliteFromBlob({\n name: endpoint.replace(\"blob://\", \"\"),\n });\n },\n ] as SqlitePatternTup,\n};\n\nexport const defaultPatterns: SqlitePatternTup[] = [\n patterns.https,\n patterns.val,\n];\n\nexport const defaultInterfaces: EndpointSqliteInterfaces = {\n patterns: defaultPatterns,\n};\n\nexport type SqlitePatternTup = [\n RegExp,\n (\n info: { endpoint: string; tables: Set; match: RegExpMatchArray },\n ) => MaybePromise,\n];\nexport type EndpointTableMap = Record>;\nexport type EndpointSqliteInterfaces = {\n fallback?: (info: { endpoint: string; tables: Set }) => MaybePromise;\n patterns?: SqlitePatternTup[];\n exact?: Record<\n string,\n SqliteInterface | ((info: { endpoint: string; tables: Set }) => MaybePromise)\n >;\n};\nexport type SqliteUniverseOptions = {\n interfaces?: EndpointSqliteInterfaces;\n};","deleted","label",[98],"permalink","https://www.val.town/x/postpostscript/sqliteUniverse/code/main.tsx","extension","actionData","errors"]