[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","8abab1f3bacc65052d6313ca736f41d897b49791","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_171":172,"_173":-5},"handle","reubenoguta_Valtown","name","Reuben","path","backend/routes/submissions.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","52a66114-3f8d-11f0-9e1b-76b3cceeab13","createdAt",["D",1748853665804],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","e2684160-3f8c-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","ac4fbd36-fbab-4ab3-968f-89f2feacb060","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHdlQWp1Y0xGZ2FJbm9XUzl2d2JhMFVFcHkifQ","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",19,"52a6d0ea-3f8d-11f0-9e1b-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_104":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"01a3cad0-3f8e-11f0-8765-76b3cceeab13","submissions.ts","fileId","01a3cb8e-3f8e-11f0-8765-76b3cceeab13","parentId","6840b1ff-44d6-4963-8554-644a701a0854","branchId","branchVersion",8,"latest",true,["D",1748853959385],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { SubmitExamRequest, ApiResponse, User, ExamSubmission, Question, GradeResult } from \"../../shared/types.ts\";\nimport * as db from \"../database/queries.ts\";\nimport { requireAuth, requireInstructor } from \"./auth.ts\";\n\nconst submissions = new Hono();\n\n// Auto-grading function\nfunction gradeQuestion(question: Question, answer: any): GradeResult {\n const result: GradeResult = {\n question_id: question.id,\n points_earned: 0,\n points_possible: question.points,\n is_correct: false\n };\n\n if (!answer || answer === '') {\n return result; // No answer provided\n }\n\n switch (question.type) {\n case 'multiple_choice':\n if (question.correct_answer !== undefined) {\n const correctIndex = parseInt(question.correct_answer as string);\n const studentAnswer = parseInt(answer);\n result.is_correct = correctIndex === studentAnswer;\n result.points_earned = result.is_correct ? question.points : 0;\n }\n break;\n\n case 'true_false':\n if (question.correct_answer !== undefined) {\n const correctAnswer = question.correct_answer.toString().toLowerCase();\n const studentAnswer = answer.toString().toLowerCase();\n result.is_correct = correctAnswer === studentAnswer;\n result.points_earned = result.is_correct ? question.points : 0;\n }\n break;\n\n case 'short_answer':\n if (question.correct_answer !== undefined) {\n // Simple string comparison (case-insensitive)\n const correctAnswer = question.correct_answer.toString().toLowerCase().trim();\n const studentAnswer = answer.toString().toLowerCase().trim();\n result.is_correct = correctAnswer === studentAnswer;\n result.points_earned = result.is_correct ? question.points : 0;\n }\n break;\n\n case 'essay':\n // Essays require manual grading\n result.feedback = \"Requires manual grading\";\n break;\n }\n\n return result;\n}\n\n// Submit exam answers\nsubmissions.post(\"/exams/:id/submit\", requireAuth, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const examId = parseInt(c.req.param(\"id\"));\n const body: SubmitExamRequest = await c.req.json();\n\n if (isNaN(examId)) {\n return c.json({ success: false, error: \"Invalid exam ID\" }, 400);\n }\n\n if (user.role !== 'student') {\n return c.json({ success: false, error: \"Only students can submit exams\" }, 403);\n }\n\n // Get exam and verify access\n const exam = await db.getExamById(examId);\n if (!exam) {\n return c.json({ success: false, error: \"Exam not found\" }, 404);\n }\n\n if (!exam.is_published) {\n return c.json({ success: false, error: \"Exam is not published\" }, 403);\n }\n\n // Check if student is enrolled\n const enrolled = await db.isUserEnrolled(user.id, exam.course_id);\n if (!enrolled) {\n return c.json({ success: false, error: \"Not enrolled in this course\" }, 403);\n }\n\n // Check if already submitted\n const existingSubmission = await db.getSubmission(examId, user.id);\n if (existingSubmission) {\n return c.json({ success: false, error: \"Exam already submitted\" }, 400);\n }\n\n // Check due date\n if (exam.due_date) {\n const dueDate = new Date(exam.due_date);\n const now = new Date();\n if (now > dueDate) {\n return c.json({ success: false, error: \"Exam deadline has passed\" }, 400);\n }\n }\n\n // Get questions for grading\n const questions = await db.getExamQuestions(examId);\n \n // Convert answers array to object\n const answersObj: Record = {};\n body.answers.forEach(answer => {\n answersObj[answer.question_id] = answer.answer;\n });\n\n // Auto-grade the submission\n let totalScore = 0;\n let maxScore = 0;\n const gradeResults: GradeResult[] = [];\n\n for (const question of questions) {\n const answer = answersObj[question.id];\n const gradeResult = gradeQuestion(question, answer);\n gradeResults.push(gradeResult);\n \n totalScore += gradeResult.points_earned;\n maxScore += gradeResult.points_possible;\n }\n\n // Create submission\n const submission = await db.createSubmission(examId, user.id, answersObj, maxScore);\n\n // Update score if fully auto-gradable\n const hasManualGrading = gradeResults.some(r => r.feedback === \"Requires manual grading\");\n if (!hasManualGrading) {\n await db.updateSubmissionScore(submission.id, totalScore, user.id);\n submission.score = totalScore;\n submission.graded_at = new Date().toISOString();\n }\n\n return c.json>({ \n success: true, \n data: { submission, gradeResults } \n });\n } catch (error) {\n console.error(\"Submit exam error:\", error);\n return c.json({ success: false, error: \"Failed to submit exam\" }, 500);\n }\n});\n\n// Get exam submissions (instructors only)\nsubmissions.get(\"/exams/:id/submissions\", requireAuth, requireInstructor, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const examId = parseInt(c.req.param(\"id\"));\n\n if (isNaN(examId)) {\n return c.json({ success: false, error: \"Invalid exam ID\" }, 400);\n }\n\n // Verify instructor owns this exam's course\n const exam = await db.getExamById(examId);\n if (!exam) {\n return c.json({ success: false, error: \"Exam not found\" }, 404);\n }\n\n const course = await db.getCourseById(exam.course_id);\n if (!course || course.instructor_id !== user.id) {\n return c.json({ success: false, error: \"Access denied\" }, 403);\n }\n\n const submissionList = await db.getExamSubmissions(examId);\n return c.json({ success: true, data: submissionList });\n } catch (error) {\n console.error(\"Get submissions error:\", error);\n return c.json({ success: false, error: \"Failed to get submissions\" }, 500);\n }\n});\n\n// Get specific submission details\nsubmissions.get(\"/:id\", requireAuth, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const submissionId = parseInt(c.req.param(\"id\"));\n\n if (isNaN(submissionId)) {\n return c.json({ success: false, error: \"Invalid submission ID\" }, 400);\n }\n\n // Get submission (we'll need to query directly since we need submission by ID)\n const result = await db.sqlite.execute(\n `SELECT es.*, u.name as user_name, e.course_id \n FROM exam_submissions es \n JOIN users u ON es.user_id = u.id \n JOIN exams e ON es.exam_id = e.id\n WHERE es.id = ?`,\n [submissionId]\n );\n\n if (result.rows.length === 0) {\n return c.json({ success: false, error: \"Submission not found\" }, 404);\n }\n\n const submissionData = result.rows[0] as any;\n submissionData.answers = JSON.parse(submissionData.answers);\n\n // Check access permissions\n if (user.role === 'student') {\n if (submissionData.user_id !== user.id) {\n return c.json({ success: false, error: \"Access denied\" }, 403);\n }\n } else if (user.role === 'instructor') {\n const course = await db.getCourseById(submissionData.course_id);\n if (!course || course.instructor_id !== user.id) {\n return c.json({ success: false, error: \"Access denied\" }, 403);\n }\n }\n\n // Get questions for context\n const questions = await db.getExamQuestions(submissionData.exam_id);\n\n return c.json({ \n success: true, \n data: { \n submission: submissionData, \n questions \n } \n });\n } catch (error) {\n console.error(\"Get submission error:\", error);\n return c.json({ success: false, error: \"Failed to get submission\" }, 500);\n }\n});\n\n// Update submission score (manual grading by instructors)\nsubmissions.post(\"/:id/grade\", requireAuth, requireInstructor, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const submissionId = parseInt(c.req.param(\"id\"));\n const { score } = await c.req.json();\n\n if (isNaN(submissionId)) {\n return c.json({ success: false, error: \"Invalid submission ID\" }, 400);\n }\n\n if (typeof score !== 'number' || score < 0) {\n return c.json({ success: false, error: \"Invalid score\" }, 400);\n }\n\n // Get submission and verify access\n const result = await db.sqlite.execute(\n `SELECT es.*, e.course_id \n FROM exam_submissions es \n JOIN exams e ON es.exam_id = e.id\n WHERE es.id = ?`,\n [submissionId]\n );\n\n if (result.rows.length === 0) {\n return c.json({ success: false, error: \"Submission not found\" }, 404);\n }\n\n const submissionData = result.rows[0] as any;\n const course = await db.getCourseById(submissionData.course_id);\n if (!course || course.instructor_id !== user.id) {\n return c.json({ success: false, error: \"Access denied\" }, 403);\n }\n\n // Validate score doesn't exceed max\n if (score > submissionData.max_score) {\n return c.json({ \n success: false, \n error: `Score cannot exceed maximum of ${submissionData.max_score}` \n }, 400);\n }\n\n await db.updateSubmissionScore(submissionId, score, user.id);\n return c.json({ success: true, data: { message: \"Score updated successfully\" } });\n } catch (error) {\n console.error(\"Grade submission error:\", error);\n return c.json({ success: false, error: \"Failed to update score\" }, 500);\n }\n});\n\nexport default submissions;","deleted","label",[169,170,151],"backend","routes","permalink","https://www.val.town/x/reubenoguta_Valtown/Reuben/code/backend/routes/submissions.ts","extension","actionData","errors"]