Logbook

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_518":519,"_520":521},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":125,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":55,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",255,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","dashboard/backend/database/queries.js","latestPath","fileId","5aa17086-f692-11f0-bc77-42dde27851f2","name","queries.js","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// toggle the commented out table name to switch between the demo and production tables\n// const tableName = \"memories\";\nconst tableName = \"memories\";\n\n/**\n * If you want runtime “type hints”, here’s the shape:\n * Memory = {\n * id: string,\n * date: string|null,\n * text: string,\n * createdBy: string|null,\n * createdDate: number|null,\n * tags: string|null,\n * }\n */\n\n/** @returns {Promise>} */\nexport async function getAllMemories() {\n const result = await sqlite.execute(\n `SELECT id, date, text, createdBy, createdDate, tags\n FROM ${tableName}\n ORDER BY createdDate DESC`\n );\n\n // Normalize/guard nulls and types (sqlite rows can be loosely typed)\n return (result.rows || []).map((row) => ({\n id: row.id != null ? String(row.id) : \"\",\n date: row.date == null ? null : String(row.date),\n text: row.text != null ? String(row.text) : \"\",\n createdBy: row.createdBy == null ? null : String(row.createdBy),\n createdDate: row.createdDate == null ? null : Number(row.createdDate),\n tags: row.tags == null ? null : String(row.tags),\n }));\n}\n\n/**\n * @param {Object} memory - Memory without id\n * @returns {Promise

Hi

Mr. Bilbo (Discord)

Logbook

Diff · v255