\n {!username ? (\n

Set Your Username

\n setUsername(e.target.value)}\n placeholder=\"Enter your username\"\n />\n \n

\n ) : (\n <>\n

📄 School Documents

\n \n

\n {documents.map((doc, index) => (\n

{doc.title}

Type: {doc.file_type}

\n Uploaded by: {doc.username}\n \n

\n ))}\n

\n\n {/* Previous assignments and chat sections remain unchanged */}\n

📚 School Assignments

\n setNewAssignment({...newAssignment, title: e.target.value})}\n required \n />\n setNewAssignment({...newAssignment, subject: e.target.value})}\n required \n />\n

setNewAssignment({...newAssignment, description: e.target.value})}\n                required \n              />\n              <button type=\"submit\">Submit Assignment</button>\n            </form>\n            <div>\n              {assignments.map((assignment, index) => (\n                <div key={index} style={styles.assignmentItem}>\n                  <h3>{assignment.title}</h3>\n                  <p>Subject: {assignment.subject}</p>\n                  <p>{assignment.description}</p>\n                  <small>Posted by: {assignment.username}</small>\n                </div>\n              ))}\n            </div>\n          </div>\n\n          <div style={styles.chat}>\n            <h2>💬 School Chat</h2>\n            <div style={styles.messageList}>\n              {messages.map((message, index) => (\n                <div key={index} style={styles.messageItem}>\n                  <strong>{message.username}: </strong>\n                  {message.content}\n                </div>\n              ))}\n            </div>\n            <form onSubmit={handleMessageSubmit} style={styles.chatForm}>\n              <input \n                type=\"text\" \n                value={newMessage}\n                onChange={(e) => setNewMessage(e.target.value)}\n                placeholder=\"Type a message...\"\n                required \n              />\n              <button type=\"submit\">Send</button>\n            </form>\n          </div>\n        </>\n      )}\n      <a \n        href={import.meta.url.replace(\"esm.town\", \"val.town\")} \n        target=\"_top\" \n        style={styles.sourceLink}\n      >\n        View Source\n      </a>\n    </div>\n  );\n}\n\nconst styles = {\n  ...{\n    // Previous styles remain the same\n    container: {\n      fontFamily: 'Arial, sans-serif',\n      maxWidth: '800px',\n      margin: '0 auto',\n      padding: '20px',\n      display: 'flex',\n      flexDirection: 'column',\n      gap: '20px'\n    },\n    // ... other previous styles\n  },\n  documents: {\n    backgroundColor: '#e6f3e6',\n    padding: '20px',\n    borderRadius: '8px'\n  },\n  documentItem: {\n    backgroundColor: 'white',\n    padding: '10px',\n    marginBottom: '10px',\n    borderRadius: '4px',\n    boxShadow: '0 2px 4px rgba(0,0,0,0.1)',\n    display: 'flex',\n    justifyContent: 'space-between',\n    alignItems: 'center'\n  },\n  downloadButton: {\n    backgroundColor: '#4CAF50',\n    color: 'white',\n    border: 'none',\n    padding: '5px 10px',\n    borderRadius: '4px',\n    cursor: 'pointer'\n  }\n};\n\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<App />);\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise<Response> {\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 = \"delightfulHarlequinSilverfish\";\n  const SCHEMA_VERSION = 2;\n\n  // Previous tables remain the same\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_assignments_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      title TEXT NOT NULL,\n      description TEXT NOT NULL,\n      subject TEXT NOT NULL,\n      username TEXT NOT NULL,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_messages_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      content TEXT NOT NULL,\n      username TEXT NOT NULL,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Create documents table\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_documents_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      title TEXT NOT NULL,\n      file_name TEXT NOT NULL,\n      file_type TEXT NOT NULL,\n      file_size INTEGER NOT NULL,\n      username TEXT NOT NULL,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Handle different routes\n  if (request.method === 'GET') {\n    const url = new URL(request.url);\n    \n    if (url.pathname === '/assignments') {\n      const assignments = await sqlite.execute(`\n        SELECT * FROM ${KEY}_assignments_${SCHEMA_VERSION} \n        ORDER BY timestamp DESC \n        LIMIT 50\n      `);\n      return Response.json(assignments.rows);\n    }\n\n    if (url.pathname === '/messages') {\n      const messages = await sqlite.execute(`\n        SELECT * FROM ${KEY}_messages_${SCHEMA_VERSION} \n        ORDER BY timestamp DESC \n        LIMIT 50\n      `);\n      return Response.json(messages.rows);\n    }\n\n    if (url.pathname === '/documents') {\n      const documents = await sqlite.execute(`\n        SELECT * FROM ${KEY}_documents_${SCHEMA_VERSION} \n        ORDER BY timestamp DESC \n        LIMIT 50\n      `);\n      return Response.json(documents.rows);\n    }\n\n    // Download document route\n    if (url.pathname.startsWith('/download-document/')) {\n      const documentId = url.pathname.split('/').pop();\n      const document = await sqlite.execute(`\n        SELECT * FROM ${KEY}_documents_${SCHEMA_VERSION} \n        WHERE id = ?\n      `, [documentId]);\n\n      if (document.rows.length > 0) {\n        const doc = document.rows[0];\n        const fileData = await blob.get(`${KEY}_document_${documentId}`);\n        \n        return new Response(fileData, {\n          headers: {\n            'Content-Type': doc.file_type,\n            'Content-Disposition': `attachment; filename=\"${doc.file_name}\"`\n          }\n        });\n      }\n    }\n  }\n\n  if (request.method === 'POST') {\n    const url = new URL(request.url);\n    \n    if (url.pathname === '/documents') {\n      const formData = await request.formData();\n      const file = formData.get('file') as File;\n      const title = formData.get('title') as string;\n      const username = formData.get('username') as string;\n\n      const fileBuffer = await file.arrayBuffer();\n      \n      const documentResult = await sqlite.execute(`\n        INSERT INTO ${KEY}_documents_${SCHEMA_VERSION} \n        (title, file_name, file_type, file_size, username) \n        VALUES (?, ?, ?, ?, ?)\n      `, [\n        title, \n        file.name, \n        file.type, \n        file.size, \n        username\n      ]);\n\n      const documentId = documentResult.lastInsertRowid;\n      \n      // Store file in blob storage\n      await blob.set(`${KEY}_document_${documentId}`, fileBuffer);\n\n      return Response.json({ success: true, documentId });\n    }\n\n    // Previous POST routes remain the same\n    if (url.pathname === '/assignments') {\n      const body = await request.json();\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_assignments_${SCHEMA_VERSION} \n        (title, description, subject, username) \n        VALUES (?, ?, ?, ?)\n      `, [body.title, body.description, body.subject, body.username]);\n      return Response.json({ success: true });\n    }\n\n    if (url.pathname === '/messages') {\n      const body = await request.json();\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} \n        (content, username) \n        VALUES (?, ?)\n      `, [body.content, body.username]);\n      return Response.json({ success: true });\n    }\n  }\n\n  return new Response(`\n    <html>\n      <head>\n        <title>School Assignment Hub</title>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}","deleted","label",[98],"permalink","https://www.val.town/x/YoungPapi/delightfulHarlequinSilverfish/code/main.tsx","extension","actionData","errors"]
</article></body></html>