📊 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}","deleted","label",[98],"permalink","https://www.val.town/x/dianawangui/appInit/code/main.tsx","extension","actionData","errors"]