D&D Guild Hall Simulator

\n \n

Characters

\n \n

Available Quests

Guild Hall

\n \n

\n \n\n\n`;","createdAt",["D",1740061986985],"version",12,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","gigmx","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybnBtekRodDdiRDdIQmJqQXNJY0hiQmhyNEoifQ","forkedVal","interval","slug","gigmx/punctualIndigoMeerkat","description","// Initialize database","versions",[141,144,148,152,156,160,164,168,172,176,180,183,186],{"_117":118,"_142":-5,"_115":143,"_112":110},"prId",["D",1740061986985],{"_117":145,"_142":-5,"_115":146,"_112":147},11,["D",1739557402456],"c5eafed2-eb00-11ef-8bd2-e6cdfca9ef9f",{"_117":149,"_142":-5,"_115":150,"_112":151},10,["D",1739557225104],"5c351e96-eb00-11ef-8123-e6cdfca9ef9f",{"_117":153,"_142":-5,"_115":154,"_112":155},9,["D",1739557147394],"2de2b0f8-eb00-11ef-807a-e6cdfca9ef9f",{"_117":157,"_142":-5,"_115":158,"_112":159},8,["D",1739556395462],"6db394ce-eafe-11ef-897d-e6cdfca9ef9f",{"_117":161,"_142":-5,"_115":162,"_112":163},7,["D",1739556386122],"68229d3e-eafe-11ef-b456-e6cdfca9ef9f",{"_117":165,"_142":-5,"_115":166,"_112":167},6,["D",1739556372263],"5fdf41c2-eafe-11ef-abe4-e6cdfca9ef9f",{"_117":169,"_142":-5,"_115":170,"_112":171},5,["D",1739556336084],"4a4db334-eafe-11ef-a51a-e6cdfca9ef9f",{"_117":173,"_142":-5,"_115":174,"_112":175},4,["D",1739556307728],"3968ca68-eafe-11ef-b8e2-e6cdfca9ef9f",{"_117":177,"_142":-5,"_115":178,"_112":179},3,["D",1739556171729],"e858adbe-eafd-11ef-bb1f-e6cdfca9ef9f",{"_117":90,"_142":-5,"_115":181,"_112":182},["D",1739555938842],"5d874bd2-eafd-11ef-ad81-e6cdfca9ef9f",{"_117":124,"_142":-5,"_115":184,"_112":185},["D",1739555604373],"962d593c-eafc-11ef-b0e3-e6cdfca9ef9f",{"_117":31,"_142":-5,"_115":187,"_112":188},["D",1739555524473],"668ba620-eafc-11ef-9029-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_196":197,"_255":124,"_256":136,"_257":31,"_94":258},"dependenciesList",[198],{"_100":199,"_200":201},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":202,"_95":203,"_100":199,"_102":204,"_103":-5,"_104":105,"_106":205,"_107":206,"_109":207,"_111":26,"_112":207,"_113":208,"_115":209,"_117":210,"_119":26,"_120":149,"_122":211,"_123":124,"_125":124,"_121":212,"_126":31,"_127":-5,"_20":213,"_133":216,"_134":-7,"_137":220,"_221":-5,"_135":222,"_139":223},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;",["D",1737987404484],13,13487,21,{"_129":214,"_131":215},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_112":217,"_129":218,"_98":202,"_117":165,"_219":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std","prDisabledHint","LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[224,228,231,234,237,240,243,246,249,252],{"_115":225,"_117":210,"_226":227},["D",1737987404484],"n","1",{"_115":229,"_117":118,"_226":230},["D",1724087412304],"2",{"_115":232,"_117":145,"_226":233},["D",1724087404512],"3",{"_115":235,"_117":149,"_226":236},["D",1723494410142],"4",{"_115":238,"_117":153,"_226":239},["D",1723494389876],"5",{"_115":241,"_117":157,"_226":242},["D",1723494345363],"6",{"_115":244,"_117":161,"_226":245},["D",1723494323065],"7",{"_115":247,"_117":165,"_226":248},["D",1719604370206],"8",{"_115":250,"_117":169,"_226":251},["D",1719604260994],"9",{"_115":253,"_117":173,"_226":254},["D",1719604144103],"10","dependenciesCount","valname","page",{"_112":110,"_98":99,"_129":130,"_11":96,"_117":118,"_100":101,"_113":114,"_104":105,"_111":26,"_135":136},"routes/_app","actionData","errors"]

The Adventurer's Rest

Characters

Available Quests

Guild Hall