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`;","createdAt",["D",1739803516977],"version","currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","oke_oma","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0QVZBNTV2aDJmSkJaSk5oMW1tU0g0ejE5RyJ9","forkedVal","interval","slug","oke_oma/fascinatingAmaranthStingray","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[140,143,146],{"_117":90,"_141":-5,"_115":142,"_112":110},"prId",["D",1739803516977],{"_117":123,"_141":-5,"_115":144,"_112":145},["D",1739803478627],"b6bccfdc-ed3d-11ef-9a1c-e6cdfca9ef9f",{"_117":31,"_141":-5,"_115":147,"_112":148},["D",1739803273394],"3c68b3ae-ed3d-11ef-be96-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":156,"_157":158,"_94":159},"single","redirect","/v/oke_oma/fascinatingAmaranthStingray/versions",{"_112":145,"_113":160,"_117":123,"_115":161,"_162":99,"_100":101,"_107":108,"_128":129,"_11":96,"_163":-5,"_164":-5,"_165":-5,"_153":26,"_134":135},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\ntype Person = {\n id?: number;\n firstName: string;\n lastName: string;\n email: string;\n};\n\ntype Teacher = Person & {\n subject: string;\n classesTeaching: string[];\n};\n\ntype Pupil = Person & {\n grade: number;\n parentIds: number[];\n teacherIds: number[];\n};\n\ntype Parent = Person & {\n childrenIds: number[];\n};\n\nfunction App() {\n const [view, setView] = useState<'teachers' | 'pupils' | 'parents'>('teachers');\n const [people, setPeople] = useState([]);\n\n useEffect(() => {\n fetchPeople();\n }, [view]);\n\n async function fetchPeople() {\n try {\n const response = await fetch(`/api/${view}`);\n const data = await response.json();\n setPeople(data);\n } catch (error) {\n console.error(`Error fetching ${view}:`, error);\n }\n }\n\n function renderPeopleTable() {\n return (\n \n \n \n \n \n \n {view === 'teachers' && }\n {view === 'pupils' && }\n \n \n \n {people.map((person) => (\n \n \n \n \n {view === 'teachers' && }\n {view === 'pupils' && }\n \n ))}\n \n

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 School Management System\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\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",1739803478627],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

fascinatingAmaranthStingray

Version 1