📖 Literary Commons

\n\n

Upload Your Work

\n\n

Literary Works

\n setSearchTerm(e.target.value)}\n className=\"search-input\"\n />\n {filteredWorks.map((work, index) => (\n

{work.title}

By {work.author}

\n {work.genre}\n

{work.content.substring(0, 200)}...

\n \n

\n ))}\n

\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 5;\n\n // Create works table with more fields\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_works_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n author TEXT NOT NULL,\n genre TEXT NOT NULL,\n content TEXT NOT NULL,\n file_key TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle different routes\n const url = new URL(request.url);\n\n // GET works\n if (request.method === \"GET\" && url.pathname === \"/works\") {\n const works = await sqlite.execute(`\n SELECT * FROM ${KEY}_works_${SCHEMA_VERSION} \n ORDER BY created_at DESC \n LIMIT 50\n `);\n return new Response(JSON.stringify(works.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Download work\n if (request.method === \"GET\" && url.pathname.startsWith(\"/download/\")) {\n const workId = url.pathname.split(\"/\").pop();\n const work = await sqlite.execute(\n `\n SELECT * FROM ${KEY}_works_${SCHEMA_VERSION} \n WHERE id = ?\n `,\n [workId],\n );\n\n if (work.rows.length > 0 && work.rows[0].file_key) {\n const fileContent = await blob.get(work.rows[0].file_key);\n return new Response(fileContent, {\n headers: {\n \"Content-Type\": \"text/plain\",\n \"Content-Disposition\": `attachment; filename=\"${work.rows[0].title}.txt\"`,\n },\n });\n }\n\n return new Response(\"File not found\", { status: 404 });\n }\n\n // POST works with file upload\n if (request.method === \"POST\" && url.pathname === \"/works\") {\n const formData = await request.formData();\n const title = formData.get(\"title\");\n const author = formData.get(\"author\");\n const genre = formData.get(\"genre\");\n const content = formData.get(\"content\");\n const file = formData.get(\"file\");\n\n let fileKey = null;\n if (file && file instanceof File) {\n const fileContent = await file.text();\n fileKey = `${KEY}_${Date.now()}_${file.name}`;\n await blob.set(fileKey, fileContent);\n }\n\n await sqlite.execute(\n `INSERT INTO ${KEY}_works_${SCHEMA_VERSION} \n (title, author, genre, content, file_key) \n VALUES (?, ?, ?, ?, ?)`,\n [title, author, genre, content, fileKey],\n );\n\n return new Response(\"Work published\", { status: 200 });\n }\n\n return new Response(\n `\n \n \n Literary Commons\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: 'Georgia', serif;\n max-width: 1000px;\n margin: 0 auto;\n padding: 20px;\n line-height: 1.6;\n background-color: #f9f5f0;\n color: #333;\n}\n\n.container {\n display: grid;\n grid-template-columns: 1fr 1fr;\n gap: 30px;\n}\n\n.upload-section, .library-section {\n background: white;\n padding: 25px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\nform {\n display: flex;\n flex-direction: column;\n gap: 15px;\n}\n\ninput, textarea, select {\n padding: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n font-family: 'Georgia', serif;\n}\n\n.search-input {\n width: 100%;\n margin-bottom: 15px;\n}\n\nbutton {\n background-color: #4a4a4a;\n color: white;\n border: none;\n padding: 12px;\n border-radius: 4px;\n cursor: pointer;\n transition: background-color 0.3s ease;\n font-family: 'Georgia', serif;\n}\n\nbutton:hover {\n background-color: #666;\n}\n\n.work-listing {\n background: #f4f4f4;\n border: 1px solid #e0e0e0;\n padding: 20px;\n margin-bottom: 15px;\n border-radius: 6px;\n position: relative;\n}\n\n.genre-tag {\n position: absolute;\n top: 15px;\n right: 15px;\n background: #e0e0e0;\n padding: 5px 10px;\n border-radius: 15px;\n font-size: 0.8em;\n}\n\n.work-actions {\n margin-top: 15px;\n display: flex;\n justify-content: flex-end;\n}\n\nh1, h2 {\n color: #2c3e50;\n font-family: 'Georgia', serif;\n}\n`;",["D",1739829738834],"version",3,"currentUserHasLiked","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_96":97,"_101":102},"forkedVal","interval","description","@jsxImportSource https://esm.sh/react@18.2.0","latestEvaluation","slug","alphareigns/writingheart","versions",[158,162,165,168],{"_98":159,"_140":141,"_160":161},["D",1739829738834],"n","1",{"_98":163,"_140":90,"_160":164},["D",1739829138740],"2",{"_98":166,"_140":107,"_160":167},["D",1739816552234],"3",{"_98":169,"_140":31,"_160":170},["D",1739816012675],"4","hasNext","routes/_app","actionData","errors"]