[{"_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",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"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",14,"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, sqlite } 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\ntype ResultSet = Awaited>;\n\nexport function zip(res: ResultSet) {\n return res.rows.map(row => Object.fromEntries(zip2(res.columns, row)));\n}","import type { InValue, sqlite } from \"https://esm.town/v/std/sqlite\";\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\ntype ResultSet = Awaited>;\n\nexport function zip(res: ResultSet) {\n return res.rows.map(row => Object.fromEntries(zip2(res.columns, row)));\n}","createdAt",["D",1711877836104],"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",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":55,"_98":99,"_100":25},"branch",{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned","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":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":136,"_143":138,"_144":145,"_146":147},"contents",[124,125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":133,"_32":134,"_30":135,"_127":-5,"_41":42,"_40":136,"_128":49,"_38":137,"_13":138,"_33":20,"_35":139,"_24":25,"_131":-5,"_27":140},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":49,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"6d52a93a-277f-11f0-b46e-569c3dd06744","parentId","latest",["D",1711877836104],13,"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).",[134],"pulls","branches","forks","envVars",{"_148":138,"_150":138},"connections",{"_148":138,"_149":138},"count","unfilledCount","emptyCount",{"_43":133,"_32":134,"_30":135,"_127":-5,"_41":42,"_40":136,"_128":49,"_38":157,"_13":138,"_33":20,"_35":139,"_24":25,"_131":-5,"_154":158,"_27":159},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":49,"_38":153,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_154":155,"_27":156},["D",1711877836104],"children",[],[28],["D",1704415375032],[],[134],["D",1746208869069],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":55,"_98":99,"_100":25},{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_77":-5,"_121":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":84,"_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","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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 · v14