First Name	Last Name	Email	Subject	Grade
{person.firstName}	{person.lastName}	{person.email}	{(person as Teacher).subject}	{(person as Pupil).grade}

\n );\n }\n\n return (\n

School Management System

\n \n \n \n

\n {renderPeopleTable()}\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 KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 1;\n\n // Initialize tables\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_teachers_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n firstName TEXT NOT NULL,\n lastName TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n subject TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_pupils_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n firstName TEXT NOT NULL,\n lastName TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n grade INTEGER NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_parents_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n firstName TEXT NOT NULL,\n lastName TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL\n )\n `);\n\n // Handle API routes\n if (request.method === \"GET\" && new URL(request.url).pathname.startsWith(\"/api/\")) {\n const type = new URL(request.url).pathname.split(\"/\").pop();\n\n let query = \"\";\n switch (type) {\n case \"teachers\":\n query = `SELECT * FROM ${KEY}_teachers_${SCHEMA_VERSION}`;\n break;\n case \"pupils\":\n query = `SELECT * FROM ${KEY}_pupils_${SCHEMA_VERSION}`;\n break;\n case \"parents\":\n query = `SELECT * FROM ${KEY}_parents_${SCHEMA_VERSION}`;\n break;\n default:\n return new Response(\"Not Found\", { status: 404 });\n }\n\n const result = await sqlite.execute(query);\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Serve HTML\n return new Response(\n `\n \n \n School Management System\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: Arial, sans-serif; \n max-width: 800px; \n margin: 0 auto; \n padding: 20px;\n}\ntable { \n width: 100%; \n border-collapse: collapse; \n}\nth, td { \n border: 1px solid #ddd; \n padding: 8px; \n text-align: left; \n}\nbutton {\n margin-right: 10px;\n margin-bottom: 20px;\n}\n`;",["D",1739803516977],"version","currentUserHasLiked","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_96":97,"_101":102},"forkedVal","interval","description","@jsxImportSource https://esm.sh/react@18.2.0","latestEvaluation","slug","oke_oma/fascinatingAmaranthStingray","versions",[156,160,163],{"_98":157,"_139":90,"_158":159},["D",1739803516977],"n","1",{"_98":161,"_139":107,"_158":162},["D",1739803478627],"2",{"_98":164,"_139":31,"_158":165},["D",1739803273394],"3","hasNext","filters",{"_169":170,"_171":172,"_128":129},"sort","newest","type","all","routes/_app","actionData","errors"]