[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":83,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":116,"_117":118,"_119":25,"_120":121,"_122":25,"_123":-5,"_124":-5,"_125":126},"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":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",4,"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","0198cd2d-caa1-732f-a853-e6d27069e91d","name","fileType","script","content","import { type SqliteInterface } from \"https://esm.town/v/postpostscript/sqliteTypes\";\nimport { MaybePromise } from \"https://esm.town/v/postpostscript/typeUtils\";\nimport {\n type InStatement,\n type InValue,\n sqlite,\n} from \"https://esm.town/v/std/sqlite\";\nimport { LibsqlError, type Row } from \"npm:@libsql/client@0.6.0\";\nexport { LibsqlError } from \"npm:@libsql/client@0.6.0\";\n\nexport type ExecuteOptions<\n T extends Record,\n I extends SqliteInterface,\n> = {\n fallback?: (\n stmt: StatementInstance,\n options: ExecuteOptions,\n error: Error,\n ) => MaybePromise;\n sqlite?: I;\n};\n\nexport class StatementInstance {\n public sql: string;\n public args: InValue[];\n public log: boolean;\n\n constructor(sql: string, args: InValue[] = []) {\n this.sql = sql;\n this.args = args;\n this.log = false;\n }\n\n combineWith(instance: StatementInstance, sep = \"\") {\n return new StatementInstance(\n this.sql + sep + instance.sql,\n this.args.concat(instance.args),\n );\n }\n\n execute, I extends SqliteInterface>(\n options: ExecuteOptions = {},\n ): MaybePromise {\n if (this.log) {\n console.log(\"executing\", {\n sql: this.sql,\n args: this.args,\n });\n }\n\n const callback = ({ columns, rows }) => {\n return rows.map((row) => {\n return Object.fromEntries(columns.map((key, i) => {\n return [key, row[i]];\n }));\n });\n };\n const errorHandle = (e: Error) => {\n if (options.fallback) {\n return options.fallback(this, {\n ...options,\n fallback: undefined,\n }, e);\n }\n throw e;\n };\n\n try {\n const queryResult = (options.sqlite ?? sqlite).execute(this);\n\n if (!(queryResult instanceof Promise)) {\n return callback(queryResult);\n }\n\n return queryResult.then(callback).catch(errorHandle);\n } catch (e) {\n return errorHandle(e);\n }\n }\n\n toJSON() {\n return {\n sql: this.sql,\n args: this.args,\n };\n }\n\n async debug() {\n const result = await this.execute();\n const { default: Table } = await import(\"npm:easy-table\");\n console.debug(Table.print(result));\n return result;\n }\n}\n\nexport function Statement(\n strings: TemplateStringsArray,\n ...replacements: (InValue | StatementInstance)[]\n) {\n return strings.reduce((statement, string, index) => {\n const stringInstance = new StatementInstance(string);\n if (replacements.length >= index + 1) {\n const replacement = replacements[index];\n return statement\n .combineWith(stringInstance)\n .combineWith(\n replacement instanceof StatementInstance\n ? replacement\n : new StatementInstance(\"?\", [replacement]),\n );\n }\n return statement.combineWith(stringInstance);\n }, new StatementInstance(\"\"));\n}","import { type SqliteInterface } from \"https://esm.town/v/postpostscript/sqliteTypes\";\nimport { MaybePromise } from \"https://esm.town/v/postpostscript/typeUtils\";\nimport { type InValue, sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport type ExecuteOptions<\n T extends Record,\n I extends SqliteInterface,\n> = {\n fallback?: (\n stmt: StatementInstance,\n options: ExecuteOptions,\n error: Error,\n ) => MaybePromise;\n sqlite?: I;\n};\n\nexport class StatementInstance {\n public sql: string;\n public args: InValue[];\n public log: boolean;\n\n constructor(sql: string, args: InValue[] = []) {\n this.sql = sql;\n this.args = args;\n this.log = false;\n }\n\n combineWith(instance: StatementInstance, sep = \"\") {\n return new StatementInstance(\n this.sql + sep + instance.sql,\n this.args.concat(instance.args),\n );\n }\n\n execute, I extends SqliteInterface>(\n options: ExecuteOptions = {},\n ): MaybePromise {\n if (this.log) {\n console.log(\"executing\", {\n sql: this.sql,\n args: this.args,\n });\n }\n\n const callback = ({ columns, rows }) => {\n return rows.map((row) => {\n return Object.fromEntries(columns.map((key, i) => {\n return [key, row[i]];\n }));\n });\n };\n const errorHandle = (e: Error) => {\n if (options.fallback) {\n return options.fallback(this, {\n ...options,\n fallback: undefined,\n }, e);\n }\n throw e;\n };\n\n try {\n const queryResult = (options.sqlite ?? sqlite).execute(this);\n\n if (!(queryResult instanceof Promise)) {\n return callback(queryResult);\n }\n\n return queryResult.then(callback).catch(errorHandle);\n } catch (e) {\n return errorHandle(e);\n }\n }\n\n toJSON() {\n return {\n sql: this.sql,\n args: this.args,\n };\n }\n\n async debug() {\n const result = await this.execute();\n const { default: Table } = await import(\"npm:easy-table\");\n console.debug(Table.print(result));\n return result;\n }\n}\n\nexport function Statement(\n strings: TemplateStringsArray,\n ...replacements: (InValue | StatementInstance)[]\n) {\n return strings.reduce((statement, string, index) => {\n const stringInstance = new StatementInstance(string);\n if (replacements.length >= index + 1) {\n const replacement = replacements[index];\n return statement\n .combineWith(stringInstance)\n .combineWith(\n replacement instanceof StatementInstance\n ? replacement\n : new StatementInstance(\"?\", [replacement]),\n );\n }\n return statement.combineWith(stringInstance);\n }, new StatementInstance(\"\"));\n}","createdAt",["D",1755789055691],"branchVersion","branchId","e038bcc8-7ea0-11f0-bbbe-0224a6c84d84","id","d8f26a7c-7ea0-11f0-b285-0224a6c84d84","sqliteBuilder",["D",1755788974773],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","8acb974a-4b91-4d4a-b000-6f28827b7e16","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","b74060f0-0f1d-44f1-bee2-bdb9c9cf72e4","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":54,"_99":100,"_101":25},"branch",{"_13":14,"_32":83,"_43":42,"_84":44,"_85":86,"_87":88,"_89":50,"_90":44,"_91":62,"_92":45,"_93":94},"isOwned","pinlibsql","projectId","forkedBranchId","d8f685bc-7ea0-11f0-b285-0224a6c84d84","forkedBranchVersion",2,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","neverstew","handle","displayName","avatar","https://secure.gravatar.com/avatar/109fa713caf4e083c57622b7c6dad365.jpg?s=200&d=identicon","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":174,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":175,"_78":176,"_80":177,"_82":25},"tree",[165,166],"files",[165,166],"counts",{"_155":60,"_156":88,"_157":60,"_158":159,"_160":161},"contents",[139,140],"upstreamProject",{"_43":135,"_32":45,"_52":-5,"_53":-5,"_49":50,"_76":136},"upstreamBranch",{"_43":86,"_38":127,"_128":129,"_32":130,"_84":44,"_13":131,"_85":132,"_87":133,"_134":-5,"_47":-5,"_82":25,"_49":50,"_93":94,"_61":62,"_92":45},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1755788974773],"updatedAt",["D",1755891290078],"main",3,"298f5eb0-2760-11f0-86ff-569c3dd06744",38,"lockfileKey","298f0eba-2760-11f0-86ff-569c3dd06744",{"_95":137,"_102":138},"postpostscript","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJjdlhaRXl0WXVNSlhZcWU0ckI2c1BOMjNhQSJ9",{"_43":148,"_32":149,"_30":150,"_142":-5,"_41":42,"_40":151,"_143":144,"_38":152,"_13":60,"_33":20,"_35":153,"_24":25,"_146":-5,"_27":154},{"_43":141,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_143":144,"_38":145,"_13":131,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":147},"092935fe-7ea1-11f0-8ae4-0224a6c84d84","parentId","latest",true,["D",1755789055691],"label",[28],"e03df71a-7ea0-11f0-bbbe-0224a6c84d84","README.md","0198cd2d-caa1-732f-a853-e00348357e82",1,["D",1755788987043],"# sqliteBuilder: Opinionated safe(r) query builder using tagged templates\n\n```ts\nimport { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder\";\n\nconst unsafeId = \"1234 or TRUE\"\n\nconsole.log(Statement`\nSELECT *\nFROM table\nWHERE id = ${unsafeId}\n${Statement`AND otherCondition`}\n`)\n// StatementInstance {\n// sql: \"\\nSELECT *\\nFROM table\\nWHERE id = ?\\nAND otherCondition\\n\",\n// args: [ \"1234 or TRUE\" ],\n// log: false\n// }\n\n\nconst results = await Statement`SELECT ...`.execute()\n// [ { key: \"value\", anotherKey: \"anotherValue\" }, ... ] \n```\n\nOr you can pass it directly to `@std/sqlite.execute`:\n\n```ts\nimport { sqlite } from \"https://esm.town/v/std/sqlite\"\n\nawait sqlite.execute(Statement`Select ...`) \n```\n\nYou can combine multiple statements using `Statement.prototype.combineWith`:\n\n```ts\nStatement`...`.combineWith(Statement`...`, \" AND \")\n[\n Statement`fieldA`,\n Statement`fieldB`,\n Statement`fieldC`,\n].reduce((a, b) => a.combineWith(b, \", \"))\n```\n\nMigrated from folder: Utils/sqliteBuilder",[149],"pulls","branches","forks","envVars",{"_162":60,"_164":60},"connections",{"_162":60,"_163":60},"count","unfilledCount","emptyCount",{"_43":148,"_32":149,"_30":150,"_142":-5,"_41":42,"_40":151,"_143":144,"_38":171,"_13":60,"_33":20,"_35":153,"_24":25,"_146":-5,"_168":172,"_27":173},{"_43":141,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_143":144,"_38":167,"_13":131,"_33":34,"_35":37,"_24":25,"_146":-5,"_168":169,"_27":170},["D",1755789055691],"children",[],[28],["D",1755788987043],[],[149],["D",1755788974773],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":14,"_32":83,"_43":42,"_84":44,"_85":86,"_87":88,"_89":50,"_90":44,"_91":62,"_92":45,"_93":94},"ctx",{"_76":-5,"_124":211,"_212":213,"_214":215,"_216":25,"_217":25,"_218":25,"_219":144,"_220":-5,"_221":-7,"_222":-7,"_223":60,"_224":25,"_225":25,"_226":-5,"_227":25,"_228":25,"_229":25,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":130,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v4