🔐 Secure Vault 📝

\n \n \n

\n\n

\n {activeTab === 'passwords' && (\n

🔑 Password Manager

\n \n

\n {passwords.map((p, index) => (\n

\n {p.site} - {p.username}\n

\n handleDelete(p.id, 'password')}\n title=\"Delete\"\n >\n 🗑️\n \n ********\n

\n ))}\n

\n )}\n\n {activeTab === 'notes' && (\n

📓 Notes & Misc

\n setNewNote({...newNote, title: e.target.value})}\n required \n />\n

setNewNote({...newNote, content: e.target.value})}\n                required \n              />\n              <button type=\"submit\" style={styles.submitButton}>Save Note</button>\n            </form>\n            <div style={styles.listContainer}>\n              {notes.map((note, index) => (\n                <div key={index} style={styles.listItem}>\n                  <div>\n                    <strong style={styles.noteTitle}>{note.title}</strong>\n                    <p style={styles.noteContent}>{note.content}</p>\n                  </div>\n                  <span \n                    style={{cursor: 'pointer', padding: '5px'}} \n                    onClick={() => handleDelete(note.id, 'note')}\n                    title=\"Delete\"\n                  >\n                    🗑️\n                  </span>\n                </div>\n              ))}\n            </div>\n          </div>\n        )}\n      </div>\n    </div>\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 KEY = \"manager\";\n  const SCHEMA_VERSION = 8;\n\n  // Create tables for passwords, notes, and trash\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_passwords_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      site TEXT NOT NULL,\n      username TEXT NOT NULL,\n      password TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_notes_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      title TEXT NOT NULL,\n      content TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_trash_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      type TEXT NOT NULL,\n      site TEXT,\n      username TEXT,\n      title TEXT,\n      content TEXT,\n      original_id INTEGER NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Handle different routes\n  if (request.method === 'POST' && new URL(request.url).pathname === '/add-password') {\n    const { site, username, password } = await request.json();\n    const result = await sqlite.execute(\n      `INSERT INTO ${KEY}_passwords_${SCHEMA_VERSION} (site, username, password) VALUES (?, ?, ?)`, \n      [site, username, password]\n    );\n    return Response.json({ success: true, id: result.lastInsertRowid });\n  }\n\n  if (request.method === 'POST' && new URL(request.url).pathname === '/add-note') {\n    const { title, content } = await request.json();\n    const result = await sqlite.execute(\n      `INSERT INTO ${KEY}_notes_${SCHEMA_VERSION} (title, content) VALUES (?, ?)`, \n      [title, content]\n    );\n    return Response.json({ success: true, id: result.lastInsertRowid });\n  }\n\n  if (request.method === 'POST' && new URL(request.url).pathname === '/delete') {\n    const { id, type } = await request.json();\n    if (type === 'password') {\n      const passwordResult = await sqlite.execute(\n        `SELECT * FROM ${KEY}_passwords_${SCHEMA_VERSION} WHERE id = ?`, \n        [id]\n      );\n      const password = passwordResult.rows[0];\n      \n      await sqlite.execute(\n        `INSERT INTO ${KEY}_trash_${SCHEMA_VERSION} (type, site, username, original_id) VALUES (?, ?, ?, ?)`,\n        ['password', password.site, password.username, id]\n      );\n      \n      await sqlite.execute(\n        `DELETE FROM ${KEY}_passwords_${SCHEMA_VERSION} WHERE id = ?`, \n        [id]\n      );\n    } else if (type === 'note') {\n      const noteResult = await sqlite.execute(\n        `SELECT * FROM ${KEY}_notes_${SCHEMA_VERSION} WHERE id = ?`, \n        [id]\n      );\n      const note = noteResult.rows[0];\n      \n      await sqlite.execute(\n        `INSERT INTO ${KEY}_trash_${SCHEMA_VERSION} (type, title, content, original_id) VALUES (?, ?, ?, ?)`,\n        ['note', note.title, note.content, id]\n      );\n      \n      await sqlite.execute(\n        `DELETE FROM ${KEY}_notes_${SCHEMA_VERSION} WHERE id = ?`, \n        [id]\n      );\n    }\n    return Response.json({ success: true });\n  }\n\n  if (request.method === 'GET' && new URL(request.url).pathname === '/data') {\n    const passwordsResult = await sqlite.execute(`SELECT * FROM ${KEY}_passwords_${SCHEMA_VERSION}`);\n    const notesResult = await sqlite.execute(`SELECT * FROM ${KEY}_notes_${SCHEMA_VERSION}`);\n    \n    return Response.json({\n      passwords: passwordsResult.rows || [],\n      notes: notesResult.rows || []\n    });\n  }\n\n  return new Response(`\n    <html>\n      <head>\n        <title>Secure Vault</title>\n        <link href=\"https://fonts.googleapis.com/css2?family=Inter:wght@300;400;600&display=swap\" rel=\"stylesheet\">\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n        <style>\n          body { margin: 0; font-family: 'Inter', system-ui, sans-serif; }\n        </style>\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/EKT/manager/code/main.tsx","extension","actionData","errors"]
</article></body></html>