📊 Student Performance Tracker

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n Student Name:\n setStudentName(e.target.value)}\n style={{ width: '100%', padding: '8px', marginTop: '5px' }}\n placeholder=\"Enter student name\"\n disabled={isLoading}\n />\n

\n \n {assessments.map((assessment, index) => (\n

\n \n {assessmentLabels[index]}:\n \n handleAssessmentChange(index, e.target.value)}\n style={{ width: '100%', padding: '8px', marginTop: '5px' }}\n placeholder={`Enter whole number score out of ${assessmentMaxScores[index]} for ${assessmentLabels[index]}`}\n min=\"0\" \n max={assessmentMaxScores[index]}\n disabled={isLoading}\n />\n

\n ))}\n \n \n

\n\n

Student Records

\n {isLoading ? (\n

Loading students...

\n ) : students.length === 0 ? (\n

No students recorded yet

\n ) : (\n \n \n \n \n {assessmentLabels.map((label, index) => (\n \n ))}\n \n \n \n \n \n {students.map((student, index) => {\n const average = calculateAverage(student.assessments);\n return (\n \n \n {student.assessments.map((score, scoreIndex) => (\n \n ))}\n \n \n \n );\n })}\n \n

Name	\n {label.split(' ')[0]} {label.split(' ')[1] \|\| ''} \n (/{assessmentMaxScores[index]})\n	Average (%)	Grade
{student.name}	\n {score > 0 ? score : '-'}\n	{average}	{calculateGrade(average)}

\n )}\n

\n \n View Source\n \n

\n );\n}\n\nconst tableHeaderStyle = {\n border: '1px solid #ddd',\n padding: '8px',\n textAlign: 'center',\n backgroundColor: '#f2f2f2'\n};\n\nconst tableCellStyle = {\n border: '1px solid #ddd',\n padding: '8px',\n textAlign: 'left'\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 = \"appInit\";\n const SCHEMA_VERSION = 6; // Increment schema version\n\n // Create students table with updated column constraints for whole numbers\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_students_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n assessment1 INTEGER CHECK(assessment1 BETWEEN 0 AND 30),\n assessment2 INTEGER CHECK(assessment2 BETWEEN 0 AND 30),\n assessment3 INTEGER CHECK(assessment3 BETWEEN 0 AND 100),\n assessment4 INTEGER CHECK(assessment4 BETWEEN 0 AND 100),\n assessment5 INTEGER CHECK(assessment5 BETWEEN 0 AND 100),\n assessment6 INTEGER CHECK(assessment6 BETWEEN 0 AND 100)\n )\n `);\n\n // Handle different routes\n if (request.method === 'GET' && new URL(request.url).pathname === '/students') {\n try {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_students_${SCHEMA_VERSION}`);\n const students = result.rows.map(row => ({\n id: row.id,\n name: row.name,\n assessments: [\n row.assessment1 || 0, \n row.assessment2 || 0, \n row.assessment3 || 0, \n row.assessment4 || 0, \n row.assessment5 || 0, \n row.assessment6 || 0\n ]\n }));\n return new Response(JSON.stringify(students), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n return new Response(JSON.stringify({ error: 'Failed to fetch students' }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/add-student') {\n try {\n const { name, assessments } = await request.json();\n await sqlite.execute(`\n INSERT INTO ${KEY}_students_${SCHEMA_VERSION} \n (name, assessment1, assessment2, assessment3, assessment4, assessment5, assessment6) \n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n name, \n assessments[0] || null, \n assessments[1] || null, \n assessments[2] || null, \n assessments[3] || null, \n assessments[4] || null, \n assessments[5] || null\n ]);\n return new Response('Student added', { status: 200 });\n } catch (error) {\n return new Response(JSON.stringify({ error: 'Failed to add student' }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n return new Response(`\n \n \n Student Performance Tracker\n \n \n \n

\n \n \n \n \n `, {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n}",[],[171],"files",[150,169],"counts",{"_183":32,"_184":118,"_185":32,"_186":32},"pulls","branches","forks","envVars","contents",[],{"_103":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":118,"_157":158,"_105":190,"_100":32,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":191},["D",1746261491305],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":200,"_148":205,"_179":212,"_161":213,"_187":215,"_216":-5,"_217":22,"_218":-5,"_219":-5,"_220":-5,"_221":222},{"_103":104,"_95":96,"_105":201,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":118,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":202,"_132":203,"_135":204,"_147":22},["D",1747255106320],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_103":138,"_139":104,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[206,209],{"_103":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":118,"_157":158,"_105":159,"_100":32,"_160":161,"_162":163,"_164":22,"_165":-5,"_166":207,"_98":208},[],[99],{"_103":170,"_95":171,"_152":172,"_154":-5,"_155":138,"_156":137,"_157":158,"_105":173,"_100":174,"_160":175,"_162":176,"_164":22,"_165":-5,"_166":210,"_98":211},[],[171],[206,209],{"_103":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":118,"_157":158,"_105":190,"_100":32,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":214},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]

dianawangui

appInit