[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":25,"_121":-5,"_122":-5,"_123":124},"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":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",51,"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","main.tsx","latestPath","fileId","6cd28b98-2760-11f0-86ff-569c3dd06744","name","fileType","script","content","import { getValEndpointFromName } from \"https://esm.town/v/postpostscript/meta\";\nimport { getTableNames } from \"https://esm.town/v/postpostscript/sqliteAST\";\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 { 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 statements.map(getTableNames).reduce((a, b) => {\n return new Set([...a, ...b]);\n }).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] ??= {};\n endpointTableMap[endpoint][fullTable] = table;\n });\n\n const sqlite = await createSqliteFromEndpointTables(endpointTableMap, options);\n return sqlite.batch(statements);\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 });\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 });\n }\n }\n\n if (!sqlite && interfaces.fallback) {\n sqlite = await interfaces.fallback({ endpoint });\n }\n\n if (!sqlite) {\n throw new Error(`interface not valid for ${endpoint}`);\n }\n\n const tableNames = [...Object.values(tables)];\n\n const schema = await sqliteDump({\n tables: tableNames.filter(table => table !== \"sqlite_schema\"),\n sqlite,\n allSchemas: !!tableNames.find(table => table.toLowerCase() === \"sqlite_schema\"),\n });\n \n if (!endpoint) {\n return schema;\n }\n\n return schema.map(statement => {\n let { sql, args } = statement;\n\n tableNames.forEach(table => {\n sql = sql.replace(new RegExp(table, \"i\"), `\"${endpoint}/${table}\"`);\n });\n\n return new StatementInstance(sql, args);\n });\n });\n\n const sqlite = createSqlite();\n sqlite.batch((await Promise.all(schemas)).flat());\n return sqlite;\n}\n\nexport const defaultPatterns: SqlitePatternTup[] = [\n [\n /^@|^https:\\/\\//,\n ({ endpoint }) => {\n return sqliteFromAPI(endpoint);\n },\n ],\n];\n\nconst defaultInterfaces: EndpointSqliteInterfaces = {\n patterns: defaultPatterns,\n};\n\nexport type SqlitePatternTup = [\n RegExp,\n (info: { endpoint: string; match: RegExpMatchArray }) => MaybePromise,\n];\nexport type EndpointTableMap = Record>;\nexport type SqliteInterface = {\n execute(...args: any[]): any;\n batch(...args: any[]): any;\n};\nexport type EndpointSqliteInterfaces = {\n fallback?: (info: { endpoint: string }) => MaybePromise;\n patterns?: SqlitePatternTup[];\n exact?: Record MaybePromise)>;\n};\nexport type SqliteUniverseOptions = {\n interfaces?: EndpointSqliteInterfaces;\n};","import { getValEndpointFromName } from \"https://esm.town/v/postpostscript/meta\";\nimport { getTableNames } from \"https://esm.town/v/postpostscript/sqliteAST\";\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 { 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((a, b) => {\n return new Set([...a, ...b]);\n });\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] ??= {};\n endpointTableMap[endpoint][fullTable] = table;\n });\n\n console.log(fullTableNames);\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 console.log({\n sql,\n args,\n });\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 });\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 });\n }\n }\n\n if (!sqlite && interfaces.fallback) {\n sqlite = await interfaces.fallback({ endpoint });\n }\n\n if (!sqlite) {\n throw new Error(`interface not valid for ${endpoint}`);\n }\n\n const tableNames = [...Object.values(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 let { sql, args } = statement;\n sql = sql.replace(new RegExp(table, \"i\"), `\"${endpoint}/${table}\"`);\n return new StatementInstance(sql, args);\n },\n });\n });\n\n const sqlite = createSqlite();\n sqlite.batch((await Promise.all(schemas)).flat());\n return sqlite;\n}\n\nexport const defaultPatterns: SqlitePatternTup[] = [\n [\n /^@|^https:\\/\\//,\n ({ endpoint }) => {\n return sqliteFromAPI(endpoint);\n },\n ],\n];\n\nconst defaultInterfaces: EndpointSqliteInterfaces = {\n patterns: defaultPatterns,\n};\n\nexport type SqlitePatternTup = [\n RegExp,\n (info: { endpoint: string; match: RegExpMatchArray }) => MaybePromise,\n];\nexport type EndpointTableMap = Record>;\nexport type SqliteInterface = {\n execute(...args: any[]): any;\n batch(...args: any[]): any;\n};\nexport type EndpointSqliteInterfaces = {\n fallback?: (info: { endpoint: string }) => MaybePromise;\n patterns?: SqlitePatternTup[];\n exact?: Record MaybePromise)>;\n};\nexport type SqliteUniverseOptions = {\n interfaces?: EndpointSqliteInterfaces;\n};","createdAt",["D",1709965164910],"branchVersion","branchId","6ccfabc6-2760-11f0-86ff-569c3dd06744","id","6ccf5c0c-2760-11f0-86ff-569c3dd06744","sqliteUniverse",["D",1746195554433],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","4bfb99a9-2008-40e0-bacb-7c7d84227cee","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","1073b191-f665-405d-9530-545465c93575","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",60,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","postpostscript","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJjdlhaRXl0WXVNSlhZcWU0ckI2c1BOMjNhQSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":160,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":161,"_79":162,"_81":163,"_83":25},"tree",[151,152],"files",[151,152],"counts",{"_141":138,"_142":61,"_143":138,"_144":145,"_146":147},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":61,"_129":49,"_38":137,"_13":138,"_33":20,"_35":139,"_24":25,"_132":-5,"_27":140},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"6def9b42-2760-11f0-86ff-569c3dd06744","parentId","latest",["D",1709965164910],50,"label",[28],"6cd29002-2760-11f0-86ff-569c3dd06744","README.md","6cd2908e-2760-11f0-86ff-569c3dd06744",["D",1709901489406],0,"# sqliteUniverse: make queries against multiple vals or endpoints at the same time!\n\nExample: @postpostscript/sqliteUniverseExample\n\n## Todo\n\n- [ ] tests‼️ \n- [ ] update to support following syntax: `SELECT * FROM \"@example/endpoint\".someTable` or `SELECT * FROM \"@example/endpoint:::someTable\"`",[135],"pulls","branches","forks","envVars",{"_148":138,"_150":138},"connections",{"_148":138,"_149":138},"count","unfilledCount","emptyCount",{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":61,"_129":49,"_38":157,"_13":138,"_33":20,"_35":139,"_24":25,"_132":-5,"_154":158,"_27":159},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":153,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_154":155,"_27":156},["D",1709965164910],"children",[],[28],["D",1709901489406],[],[135],["D",1746195554433],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":197,"_198":199,"_200":201,"_202":25,"_203":25,"_204":25,"_205":49,"_206":-5,"_207":-7,"_208":-7,"_209":138,"_210":25,"_211":25,"_212":-5,"_213":25,"_214":25,"_215":25,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":85,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Diff · v51