📝 ${roomName}

\n \n\n\n`;\n}",[],[182],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":195,"_99":175,"_160":176,"_162":196,"_164":22,"_165":-5,"_166":197,"_98":198},"a41bd576-420b-11f0-8d29-76b3cceeab13","sqlite.tsx","45690592-4208-11f0-a77a-76b3cceeab13",10,["D",1749127821374],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nasync function getRoom(roomName: string) {\n const result = await sqlite.execute(\n \"SELECT content, lastModified FROM rooms WHERE name = ?\",\n [roomName],\n );\n return result.rows[0] || null;\n}\n\ninterface RoomData {\n content: string;\n lastModified: number;\n}\n\nasync function saveRoom(roomName: string, data: RoomData) {\n await sqlite.execute(\n `\n INSERT OR REPLACE INTO rooms (name, content, lastModified) \n VALUES (?, ?, ?)\n `,\n [roomName, data.content, data.lastModified],\n );\n}\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rooms(\n name TEXT PRIMARY KEY,\n content TEXT,\n lastModified INTEGER\n )\n `);\n}\n\nexport { getRoom, initDb, saveRoom };",[],[192],"files",[148,169,180,190],"counts",{"_203":32,"_204":205,"_206":32,"_207":208},"pulls","branches",1,"forks","envVars",{"_209":32,"_210":32},"count","emptyCount","contents",[213,216,219,222],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":214,"_99":32,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":215},["D",1749130280182],[150],{"_102":170,"_95":171,"_151":172,"_153":-5,"_154":136,"_155":173,"_157":158,"_104":217,"_99":175,"_160":176,"_162":177,"_164":22,"_165":-5,"_98":218},["D",1749130156296],[171],{"_102":181,"_95":182,"_151":183,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":220,"_99":185,"_160":186,"_162":187,"_164":22,"_165":-5,"_98":221},["D",1749134290533],[182],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":223,"_99":175,"_160":176,"_162":196,"_164":22,"_165":-5,"_98":224},["D",1749127821374],[192],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":233,"_207":238},{"_102":103,"_95":96,"_104":234,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":235,"_130":236,"_133":237,"_145":22},["D",1747948253057],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[],"actionData","errors"]

cosmopaolo

notes

Environment variables