[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","0fffb492b08724537e73cd8bc4c3f31babbf0bd5","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_169":170,"_171":-5},"handle","chrisboss","name","offlineexamapp","path","frontend/services/examService.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","874edf9e-352f-11f0-ab34-9e149126039e","createdAt",["D",1747713869830],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","1ead2fb0-ee9c-11ef-94f0-fdf5a27c970d","pinnedFileId","pinPreview","screenshotVersion","likeCount","cd2c2546-14ab-4d21-bb9e-cad44dee4619","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydEZodWNKYk5IQkV6WXdzdGEwVndWR3dINWwifQ","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",19,"874f1112-352f-11f0-ab34-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"905834de-3532-11f0-b8cc-9e149126039e","examService.ts","fileId","905835a6-3532-11f0-b8cc-9e149126039e","parentId","2fee8c6e-2d2e-447c-89ba-61f530c60c2b","branchId","branchVersion",11,"latest",true,["D",1747715173473],"fileType","script","content","import { \n Exam, \n Question, \n ExamQuestion, \n Attempt, \n Answer \n} from \"../../shared/database/schema\";\n\n/**\n * Service for managing exams, questions, attempts, and answers\n */\nexport class ExamService {\n private db: IDBDatabase;\n\n constructor(db: IDBDatabase) {\n this.db = db;\n }\n\n // ==================== Exam Methods ====================\n\n /**\n * Get all exams\n */\n async getAllExams(): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"exams\"], \"readonly\");\n const store = transaction.objectStore(\"exams\");\n const request = store.getAll();\n\n request.onsuccess = () => {\n resolve(request.result);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get exams\"));\n };\n });\n }\n\n /**\n * Get exams created by a specific user\n */\n async getExamsByCreator(userId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"exams\"], \"readonly\");\n const store = transaction.objectStore(\"exams\");\n const index = store.index(\"createdBy\");\n const request = index.getAll(userId);\n\n request.onsuccess = () => {\n resolve(request.result);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get exams by creator\"));\n };\n });\n }\n\n /**\n * Get a specific exam by ID\n */\n async getExamById(examId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"exams\"], \"readonly\");\n const store = transaction.objectStore(\"exams\");\n const request = store.get(examId);\n\n request.onsuccess = () => {\n resolve(request.result || null);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get exam\"));\n };\n });\n }\n\n /**\n * Create a new exam\n */\n async createExam(exam: Omit): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"exams\"], \"readwrite\");\n const store = transaction.objectStore(\"exams\");\n \n const newExam: Exam = {\n ...exam,\n id: `exam-${Date.now()}-${Math.random().toString(36).substr(2, 9)}`,\n createdAt: Date.now()\n };\n \n const request = store.add(newExam);\n\n request.onsuccess = () => {\n resolve(newExam.id);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to create exam\"));\n };\n });\n }\n\n /**\n * Update an existing exam\n */\n async updateExam(examId: string, examData: Partial): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"exams\"], \"readwrite\");\n const store = transaction.objectStore(\"exams\");\n const request = store.get(examId);\n\n request.onsuccess = () => {\n if (!request.result) {\n reject(new Error(\"Exam not found\"));\n return;\n }\n\n const updatedExam: Exam = {\n ...request.result,\n ...examData,\n updatedAt: Date.now()\n };\n\n const updateRequest = store.put(updatedExam);\n\n updateRequest.onsuccess = () => {\n resolve();\n };\n\n updateRequest.onerror = () => {\n reject(new Error(\"Failed to update exam\"));\n };\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get exam for update\"));\n };\n });\n }\n\n /**\n * Delete an exam and all associated exam questions\n */\n async deleteExam(examId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"exams\", \"examQuestions\"], \"readwrite\");\n \n // Delete the exam\n const examsStore = transaction.objectStore(\"exams\");\n const deleteExamRequest = examsStore.delete(examId);\n \n deleteExamRequest.onerror = () => {\n reject(new Error(\"Failed to delete exam\"));\n };\n \n // Delete all exam questions for this exam\n const examQuestionsStore = transaction.objectStore(\"examQuestions\");\n const examQuestionsIndex = examQuestionsStore.index(\"examId\");\n const getExamQuestionsRequest = examQuestionsIndex.getAll(examId);\n \n getExamQuestionsRequest.onsuccess = () => {\n const examQuestions = getExamQuestionsRequest.result;\n \n // Delete each exam question\n examQuestions.forEach((examQuestion: ExamQuestion) => {\n if (examQuestion.id !== undefined) {\n examQuestionsStore.delete(examQuestion.id);\n }\n });\n };\n \n getExamQuestionsRequest.onerror = () => {\n reject(new Error(\"Failed to get exam questions for deletion\"));\n };\n \n transaction.oncomplete = () => {\n resolve();\n };\n \n transaction.onerror = () => {\n reject(new Error(\"Failed to delete exam and associated questions\"));\n };\n });\n }\n\n // ==================== Question Methods ====================\n\n /**\n * Get all questions\n */\n async getAllQuestions(): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"questions\"], \"readonly\");\n const store = transaction.objectStore(\"questions\");\n const request = store.getAll();\n\n request.onsuccess = () => {\n resolve(request.result);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get questions\"));\n };\n });\n }\n\n /**\n * Get questions created by a specific user\n */\n async getQuestionsByCreator(userId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"questions\"], \"readonly\");\n const store = transaction.objectStore(\"questions\");\n const index = store.index(\"createdBy\");\n const request = index.getAll(userId);\n\n request.onsuccess = () => {\n resolve(request.result);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get questions by creator\"));\n };\n });\n }\n\n /**\n * Get a specific question by ID\n */\n async getQuestionById(questionId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"questions\"], \"readonly\");\n const store = transaction.objectStore(\"questions\");\n const request = store.get(questionId);\n\n request.onsuccess = () => {\n resolve(request.result || null);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get question\"));\n };\n });\n }\n\n /**\n * Create a new question\n */\n async createQuestion(question: Omit): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"questions\"], \"readwrite\");\n const store = transaction.objectStore(\"questions\");\n \n const newQuestion: Question = {\n ...question,\n id: `question-${Date.now()}-${Math.random().toString(36).substr(2, 9)}`,\n createdAt: Date.now()\n };\n \n const request = store.add(newQuestion);\n\n request.onsuccess = () => {\n resolve(newQuestion.id);\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to create question\"));\n };\n });\n }\n\n /**\n * Update an existing question\n */\n async updateQuestion(questionId: string, questionData: Partial): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"questions\"], \"readwrite\");\n const store = transaction.objectStore(\"questions\");\n const request = store.get(questionId);\n\n request.onsuccess = () => {\n if (!request.result) {\n reject(new Error(\"Question not found\"));\n return;\n }\n\n const updatedQuestion: Question = {\n ...request.result,\n ...questionData,\n updatedAt: Date.now()\n };\n\n const updateRequest = store.put(updatedQuestion);\n\n updateRequest.onsuccess = () => {\n resolve();\n };\n\n updateRequest.onerror = () => {\n reject(new Error(\"Failed to update question\"));\n };\n };\n\n request.onerror = () => {\n reject(new Error(\"Failed to get question for update\"));\n };\n });\n }\n\n /**\n * Delete a question and remove it from any exams it's part of\n */\n async deleteQuestion(questionId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"questions\", \"examQuestions\"], \"readwrite\");\n \n // Delete the question\n const questionsStore = transaction.objectStore(\"questions\");\n const deleteQuestionRequest = questionsStore.delete(questionId);\n \n deleteQuestionRequest.onerror = () => {\n reject(new Error(\"Failed to delete question\"));\n };\n \n // Delete all exam questions for this question\n const examQuestionsStore = transaction.objectStore(\"examQuestions\");\n const examQuestionsIndex = examQuestionsStore.index(\"questionId\");\n const getExamQuestionsRequest = examQuestionsIndex.getAll(questionId);\n \n getExamQuestionsRequest.onsuccess = () => {\n const examQuestions = getExamQuestionsRequest.result;\n \n // Delete each exam question\n examQuestions.forEach((examQuestion: ExamQuestion) => {\n if (examQuestion.id !== undefined) {\n examQuestionsStore.delete(examQuestion.id);\n }\n });\n };\n \n getExamQuestionsRequest.onerror = () => {\n reject(new Error(\"Failed to get exam questions for deletion\"));\n };\n \n transaction.oncomplete = () => {\n resolve();\n };\n \n transaction.onerror = () => {\n reject(new Error(\"Failed to delete question and associated exam questions\"));\n };\n });\n }\n\n // ==================== Exam Questions Methods ====================\n\n /**\n * Get all questions for a specific exam\n */\n async getQuestionsForExam(examId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"examQuestions\", \"questions\"], \"readonly\");\n \n // Get all exam questions for this exam\n const examQuestionsStore = transaction.objectStore(\"examQuestions\");\n const examQuestionsIndex = examQuestionsStore.index(\"examId\");\n const getExamQuestionsRequest = examQuestionsIndex.getAll(examId);\n \n getExamQuestionsRequest.onsuccess = () => {\n const examQuestions = getExamQuestionsRequest.result as ExamQuestion[];\n \n if (examQuestions.length === 0) {\n resolve([]);\n return;\n }\n \n // Sort exam questions by order\n examQuestions.sort((a, b) => a.order - b.order);\n \n // Get all questions\n const questionsStore = transaction.objectStore(\"questions\");\n const questions: Question[] = [];\n let completed = 0;\n \n examQuestions.forEach((examQuestion) => {\n const getQuestionRequest = questionsStore.get(examQuestion.questionId);\n \n getQuestionRequest.onsuccess = () => {\n if (getQuestionRequest.result) {\n questions.push(getQuestionRequest.result);\n }\n \n completed++;\n \n if (completed === examQuestions.length) {\n // Sort questions by the order in examQuestions\n const orderedQuestions = examQuestions.map(eq => {\n return questions.find(q => q.id === eq.questionId);\n }).filter(Boolean) as Question[];\n \n resolve(orderedQuestions);\n }\n };\n \n getQuestionRequest.onerror = () => {\n reject(new Error(\"Failed to get question\"));\n };\n });\n };\n \n getExamQuestionsRequest.onerror = () => {\n reject(new Error(\"Failed to get exam questions\"));\n };\n });\n }\n\n /**\n * Add a question to an exam\n */\n async addQuestionToExam(examId: string, questionId: string, order: number): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"examQuestions\"], \"readwrite\");\n const store = transaction.objectStore(\"examQuestions\");\n \n const examQuestion: ExamQuestion = {\n examId,\n questionId,\n order\n };\n \n const request = store.add(examQuestion);\n \n request.onsuccess = () => {\n resolve();\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to add question to exam\"));\n };\n });\n }\n\n /**\n * Remove a question from an exam\n */\n async removeQuestionFromExam(examId: string, questionId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"examQuestions\"], \"readwrite\");\n const store = transaction.objectStore(\"examQuestions\");\n const index = store.index(\"examId\");\n const request = index.getAll(examId);\n \n request.onsuccess = () => {\n const examQuestions = request.result as ExamQuestion[];\n const examQuestion = examQuestions.find(eq => eq.questionId === questionId);\n \n if (!examQuestion || examQuestion.id === undefined) {\n resolve(); // Question not found in exam, nothing to do\n return;\n }\n \n const deleteRequest = store.delete(examQuestion.id);\n \n deleteRequest.onsuccess = () => {\n resolve();\n };\n \n deleteRequest.onerror = () => {\n reject(new Error(\"Failed to remove question from exam\"));\n };\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get exam questions\"));\n };\n });\n }\n\n /**\n * Update the order of questions in an exam\n */\n async updateQuestionOrder(examId: string, questionOrders: { questionId: string, order: number }[]): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"examQuestions\"], \"readwrite\");\n const store = transaction.objectStore(\"examQuestions\");\n const index = store.index(\"examId\");\n const request = index.getAll(examId);\n \n request.onsuccess = () => {\n const examQuestions = request.result as ExamQuestion[];\n let completed = 0;\n \n questionOrders.forEach(qo => {\n const examQuestion = examQuestions.find(eq => eq.questionId === qo.questionId);\n \n if (!examQuestion || examQuestion.id === undefined) {\n completed++;\n return;\n }\n \n examQuestion.order = qo.order;\n \n const updateRequest = store.put(examQuestion);\n \n updateRequest.onsuccess = () => {\n completed++;\n \n if (completed === questionOrders.length) {\n resolve();\n }\n };\n \n updateRequest.onerror = () => {\n reject(new Error(\"Failed to update question order\"));\n };\n });\n \n if (questionOrders.length === 0) {\n resolve();\n }\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get exam questions\"));\n };\n });\n }\n\n // ==================== Attempt Methods ====================\n\n /**\n * Start a new exam attempt\n */\n async startAttempt(userId: string, examId: string, totalQuestions: number): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"attempts\"], \"readwrite\");\n const store = transaction.objectStore(\"attempts\");\n \n const attempt: Attempt = {\n id: `attempt-${Date.now()}-${Math.random().toString(36).substr(2, 9)}`,\n userId,\n examId,\n startTime: Date.now(),\n totalQuestions,\n status: \"in-progress\"\n };\n \n const request = store.add(attempt);\n \n request.onsuccess = () => {\n resolve(attempt.id);\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to start attempt\"));\n };\n });\n }\n\n /**\n * Complete an exam attempt\n */\n async completeAttempt(attemptId: string, score: number, correctAnswers: number): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"attempts\"], \"readwrite\");\n const store = transaction.objectStore(\"attempts\");\n const request = store.get(attemptId);\n \n request.onsuccess = () => {\n if (!request.result) {\n reject(new Error(\"Attempt not found\"));\n return;\n }\n \n const attempt = request.result as Attempt;\n \n attempt.endTime = Date.now();\n attempt.score = score;\n attempt.correctAnswers = correctAnswers;\n attempt.status = \"completed\";\n \n const updateRequest = store.put(attempt);\n \n updateRequest.onsuccess = () => {\n resolve();\n };\n \n updateRequest.onerror = () => {\n reject(new Error(\"Failed to complete attempt\"));\n };\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get attempt\"));\n };\n });\n }\n\n /**\n * Get all attempts for a user\n */\n async getAttemptsByUser(userId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"attempts\"], \"readonly\");\n const store = transaction.objectStore(\"attempts\");\n const index = store.index(\"userId\");\n const request = index.getAll(userId);\n \n request.onsuccess = () => {\n resolve(request.result);\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get attempts by user\"));\n };\n });\n }\n\n /**\n * Get all attempts for an exam\n */\n async getAttemptsByExam(examId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"attempts\"], \"readonly\");\n const store = transaction.objectStore(\"attempts\");\n const index = store.index(\"examId\");\n const request = index.getAll(examId);\n \n request.onsuccess = () => {\n resolve(request.result);\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get attempts by exam\"));\n };\n });\n }\n\n /**\n * Get a specific attempt by ID\n */\n async getAttemptById(attemptId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"attempts\"], \"readonly\");\n const store = transaction.objectStore(\"attempts\");\n const request = store.get(attemptId);\n \n request.onsuccess = () => {\n resolve(request.result || null);\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get attempt\"));\n };\n });\n }\n\n // ==================== Answer Methods ====================\n\n /**\n * Save an answer for an attempt\n */\n async saveAnswer(attemptId: string, questionId: string, selectedOption: string, isCorrect: boolean): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"answers\"], \"readwrite\");\n const store = transaction.objectStore(\"answers\");\n \n const answer: Answer = {\n attemptId,\n questionId,\n selectedOption,\n isCorrect\n };\n \n const request = store.add(answer);\n \n request.onsuccess = () => {\n resolve();\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to save answer\"));\n };\n });\n }\n\n /**\n * Get all answers for an attempt\n */\n async getAnswersForAttempt(attemptId: string): Promise {\n return new Promise((resolve, reject) => {\n const transaction = this.db.transaction([\"answers\"], \"readonly\");\n const store = transaction.objectStore(\"answers\");\n const index = store.index(\"attemptId\");\n const request = index.getAll(attemptId);\n \n request.onsuccess = () => {\n resolve(request.result);\n };\n \n request.onerror = () => {\n reject(new Error(\"Failed to get answers for attempt\"));\n };\n });\n }\n\n /**\n * Calculate the score for an attempt\n */\n async calculateScore(attemptId: string): Promise<{ score: number, correctAnswers: number, totalQuestions: number }> {\n return new Promise(async (resolve, reject) => {\n try {\n const attempt = await this.getAttemptById(attemptId);\n \n if (!attempt) {\n reject(new Error(\"Attempt not found\"));\n return;\n }\n \n const answers = await this.getAnswersForAttempt(attemptId);\n const correctAnswers = answers.filter(answer => answer.isCorrect).length;\n const totalQuestions = attempt.totalQuestions;\n const score = (correctAnswers / totalQuestions) * 100;\n \n resolve({\n score,\n correctAnswers,\n totalQuestions\n });\n } catch (error) {\n reject(error);\n }\n });\n }\n}","deleted","label",[167,168,149],"frontend","services","permalink","https://www.val.town/x/chrisboss/offlineexamapp/code/frontend/services/examService.ts","extension","actionData","errors"]