[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_165":166,"_167":168},"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",11,"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","6cf5c4c2-277f-11f0-b46e-569c3dd06744","name","fileType","script","content","import type { InValue } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { zip as zip2 } from \"npm:lodash-es@4.17.21\";\n\n/**\n * Supported value or SQL instance.\n */\ntype RawValue = InValue | Sql;\n\n/**\n * A SQL instance can be nested within each other to build SQL strings.\n */\nclass Sql {\n readonly values: InValue[];\n readonly strings: string[];\n\n constructor(rawStrings: readonly string[], rawValues: readonly RawValue[]) {\n if (rawStrings.length - 1 !== rawValues.length) {\n if (rawStrings.length === 0) {\n throw new TypeError(\"Expected at least 1 string\");\n }\n\n throw new TypeError(\n `Expected ${rawStrings.length} strings to have ${rawStrings.length - 1} values`,\n );\n }\n\n const valuesLength = rawValues.reduce(\n (len, value) => len + (value instanceof Sql ? value.values.length : 1),\n 0,\n );\n\n this.values = new Array(valuesLength);\n this.strings = new Array(valuesLength + 1);\n\n this.strings[0] = rawStrings[0];\n\n // Iterate over raw values, strings, and children. The value is always\n // positioned between two strings, e.g. `index + 1`.\n let i = 0,\n pos = 0;\n while (i < rawValues.length) {\n const child = rawValues[i++];\n const rawString = rawStrings[i];\n\n // Check for nested `sql` queries.\n if (child instanceof Sql) {\n // Append child prefix text to current string.\n this.strings[pos] += child.strings[0];\n\n let childIndex = 0;\n while (childIndex < child.values.length) {\n this.values[pos++] = child.values[childIndex++];\n this.strings[pos] = child.strings[childIndex];\n }\n\n // Append raw string to current string.\n this.strings[pos] += rawString;\n } else {\n this.values[pos++] = child;\n this.strings[pos] = rawString;\n }\n }\n }\n\n get sql() {\n const len = this.strings.length;\n let i = 1;\n let value = this.strings[0];\n while (i < len) value += `?${this.strings[i++]}`;\n return value;\n }\n\n get args() {\n return this.values;\n }\n\n toJSON() {\n return {\n sql: this.sql,\n args: this.values,\n };\n }\n}\n\n/**\n * Create a SQL query for a list of values.\n */\nexport function join(\n values: readonly RawValue[],\n separator = \",\",\n prefix = \"\",\n suffix = \"\",\n) {\n if (values.length === 0) {\n throw new TypeError(\n \"Expected `join([])` to be called with an array of multiple elements, but got an empty array\",\n );\n }\n\n return new Sql(\n [prefix, ...Array(values.length - 1).fill(separator), suffix],\n values,\n );\n}\n\n/**\n * Create a SQL query for a list of structured values.\n */\nexport function bulk(\n data: ReadonlyArray>,\n separator = \",\",\n prefix = \"\",\n suffix = \"\",\n) {\n const length = data.length && data[0].length;\n\n if (length === 0) {\n throw new TypeError(\n \"Expected `bulk([][])` to be called with a nested array of multiple elements, but got an empty array\",\n );\n }\n\n const values = data.map((item, index) => {\n if (item.length !== length) {\n throw new TypeError(\n `Expected \\`bulk([${index}][])\\` to have a length of ${length}, but got ${item.length}`,\n );\n }\n\n return new Sql([\"(\", ...Array(item.length - 1).fill(separator), \")\"], item);\n });\n\n return new Sql(\n [prefix, ...Array(values.length - 1).fill(separator), suffix],\n values,\n );\n}\n\n/**\n * Create raw SQL statement.\n */\nexport function raw(value: string) {\n return new Sql([value], []);\n}\n\n/**\n * Placeholder value for \"no text\".\n */\nexport const empty = raw(\"\");\n\n/**\n * Create a SQL object from a template string.\n */\nexport function sql(\n strings: readonly string[],\n ...values: readonly RawValue[]\n) {\n return new Sql(strings, values);\n}\n\nexport function zip(res) {\n return res.rows.map(row => Object.fromEntries(zip2(res.columns, row)));\n}","import type { InValue } from \"https://esm.town/v/std/sqlite?v=4\";\nimport type { ResultSet } from \"npm:@libsql/client\";\nimport { zip as zip2 } from \"npm:lodash-es@4.17.21\";\n\n/**\n * Supported value or SQL instance.\n */\ntype RawValue = InValue | Sql;\n\n/**\n * A SQL instance can be nested within each other to build SQL strings.\n */\nclass Sql {\n readonly values: InValue[];\n readonly strings: string[];\n\n constructor(rawStrings: readonly string[], rawValues: readonly RawValue[]) {\n if (rawStrings.length - 1 !== rawValues.length) {\n if (rawStrings.length === 0) {\n throw new TypeError(\"Expected at least 1 string\");\n }\n\n throw new TypeError(\n `Expected ${rawStrings.length} strings to have ${rawStrings.length - 1} values`,\n );\n }\n\n const valuesLength = rawValues.reduce(\n (len, value) => len + (value instanceof Sql ? value.values.length : 1),\n 0,\n );\n\n this.values = new Array(valuesLength);\n this.strings = new Array(valuesLength + 1);\n\n this.strings[0] = rawStrings[0];\n\n // Iterate over raw values, strings, and children. The value is always\n // positioned between two strings, e.g. `index + 1`.\n let i = 0,\n pos = 0;\n while (i < rawValues.length) {\n const child = rawValues[i++];\n const rawString = rawStrings[i];\n\n // Check for nested `sql` queries.\n if (child instanceof Sql) {\n // Append child prefix text to current string.\n this.strings[pos] += child.strings[0];\n\n let childIndex = 0;\n while (childIndex < child.values.length) {\n this.values[pos++] = child.values[childIndex++];\n this.strings[pos] = child.strings[childIndex];\n }\n\n // Append raw string to current string.\n this.strings[pos] += rawString;\n } else {\n this.values[pos++] = child;\n this.strings[pos] = rawString;\n }\n }\n }\n\n get sql() {\n const len = this.strings.length;\n let i = 1;\n let value = this.strings[0];\n while (i < len) value += `?${this.strings[i++]}`;\n return value;\n }\n\n get args() {\n return this.values;\n }\n\n toJSON() {\n return {\n sql: this.sql,\n args: this.values,\n };\n }\n}\n\n/**\n * Create a SQL query for a list of values.\n */\nexport function join(\n values: readonly RawValue[],\n separator = \",\",\n prefix = \"\",\n suffix = \"\",\n) {\n if (values.length === 0) {\n throw new TypeError(\n \"Expected `join([])` to be called with an array of multiple elements, but got an empty array\",\n );\n }\n\n return new Sql(\n [prefix, ...Array(values.length - 1).fill(separator), suffix],\n values,\n );\n}\n\n/**\n * Create a SQL query for a list of structured values.\n */\nexport function bulk(\n data: ReadonlyArray>,\n separator = \",\",\n prefix = \"\",\n suffix = \"\",\n) {\n const length = data.length && data[0].length;\n\n if (length === 0) {\n throw new TypeError(\n \"Expected `bulk([][])` to be called with a nested array of multiple elements, but got an empty array\",\n );\n }\n\n const values = data.map((item, index) => {\n if (item.length !== length) {\n throw new TypeError(\n `Expected \\`bulk([${index}][])\\` to have a length of ${length}, but got ${item.length}`,\n );\n }\n\n return new Sql([\"(\", ...Array(item.length - 1).fill(separator), \")\"], item);\n });\n\n return new Sql(\n [prefix, ...Array(values.length - 1).fill(separator), suffix],\n values,\n );\n}\n\n/**\n * Create raw SQL statement.\n */\nexport function raw(value: string) {\n return new Sql([value], []);\n}\n\n/**\n * Placeholder value for \"no text\".\n */\nexport const empty = raw(\"\");\n\n/**\n * Create a SQL object from a template string.\n */\nexport function sql(\n strings: readonly string[],\n ...values: readonly RawValue[]\n) {\n return new Sql(strings, values);\n}\n\nexport function zip(res: ResultSet) {\n return res.rows.map(row => Object.fromEntries(zip2(res.columns, row)));\n}","createdAt",["D",1709980212286],"branchVersion","branchId","6cf3c726-277f-11f0-b46e-569c3dd06744","id","6cf37cf8-277f-11f0-b46e-569c3dd06744","sql",["D",1746208869069],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","8a86e3e7-cae8-48ea-a1d8-c8cf7b30d88c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",6,"orgId","4b933fb9-e150-4558-9d0a-845e595c8c78","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",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pomdtr","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2RCoAITJZH1QencEgtVjh4Qirj4.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":161,"_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":162,"_79":163,"_81":164,"_83":25},"tree",[152,153],"files",[152,153],"counts",{"_142":139,"_143":137,"_144":139,"_145":146,"_147":148},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":137,"_129":49,"_38":138,"_13":139,"_33":20,"_35":140,"_24":25,"_132":-5,"_27":141},{"_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},"6d3e5bc4-277f-11f0-b46e-569c3dd06744","parentId","latest",["D",1709980212286],10,"label",[28],"6cf5c95e-277f-11f0-b46e-569c3dd06744","README.md","6cf5c9c2-277f-11f0-b46e-569c3dd06744",1,["D",1704415375032],0,"# SQL Template Tag\n\nPort of [blakeembrey/sql-template-tag](https://github.com/blakeembrey/sql-template-tag) for usage in val.town.\n\n## Usage\n\n```typescript\nimport { sqlite } from \"https://esm.town/v/std/sqlite\"\nimport { sql, zip } from \"https://esm.town/v/pomdtr/sql\"\n\nconst query = sql`SELECT * FROM books WHERE author = ${author}`;\nconsole.log(query.sql) // => \"SELECT * FROM books WHERE author = ?\"\nconsole.log(query.args) // => [author]\nconst res = await sqlite.execute(query)\nconsole.table(zip(res))\n```\n\nFor advanced usage (ex: nesting queries), refer to the [project readme](http://github.com/blakeembrey/sql-template-tag).",[135],"pulls","branches","forks","envVars",{"_149":139,"_151":139},"connections",{"_149":139,"_150":139},"count","unfilledCount","emptyCount",{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":137,"_129":49,"_38":158,"_13":139,"_33":20,"_35":140,"_24":25,"_132":-5,"_155":159,"_27":160},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":154,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_155":156,"_27":157},["D",1709980212286],"children",[],[28],["D",1704415375032],[],[135],["D",1746208869069],{"_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":198,"_199":200,"_201":202,"_203":25,"_204":25,"_205":25,"_206":49,"_207":-5,"_208":-7,"_209":-7,"_210":139,"_211":25,"_212":25,"_213":-5,"_214":25,"_215":25,"_216":25,"_217":-5},"ENV",{"_169":170,"_171":172,"_173":85,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v11