\n \n

Loading Tamil Nadu Exam Preparation App...

\n\n \n \n \n \n\n",[],[138,202],"d9af1e14-3c7a-11f0-81ee-9e149126039e","progress.service.ts","d9af1ee6-3c7a-11f0-81ee-9e149126039e","1044ff83-cc23-4f9d-b6dd-7b607c7500bb",16,["D",1748515878423],"import { Injectable } from '@angular/core';\nimport { BehaviorSubject, Observable, map } from 'rxjs';\nimport { ApiService } from './api.service.ts';\nimport type { UserProgress, TestScore, ExamType } from '../../shared/types.ts';\n\n@Injectable({\n providedIn: 'root'\n})\nexport class ProgressService {\n private progressSubject = new BehaviorSubject<{ [key: string]: UserProgress }>({});\n private scoresSubject = new BehaviorSubject([]);\n\n progress$ = this.progressSubject.asObservable();\n scores$ = this.scoresSubject.asObservable();\n\n constructor(private apiService: ApiService) {}\n\n loadUserProgress(userId: string, examType: ExamType): Observable {\n return this.apiService.getUserProgress(userId, examType).pipe(\n map(response => {\n if (response.success && response.data) {\n const currentProgress = this.progressSubject.value;\n currentProgress[`${userId}-${examType}`] = response.data;\n this.progressSubject.next(currentProgress);\n return response.data;\n }\n return null;\n })\n );\n }\n\n updateProgress(userId: string, examType: ExamType, updates: Partial): Observable {\n return this.apiService.updateProgress(userId, examType, updates).pipe(\n map(response => {\n if (response.success && response.data) {\n const currentProgress = this.progressSubject.value;\n currentProgress[`${userId}-${examType}`] = response.data;\n this.progressSubject.next(currentProgress);\n return response.data;\n }\n return null;\n })\n );\n }\n\n startProgress(userId: string, examType: ExamType, roadmapId: string): Observable {\n const progressData = {\n roadmapId,\n currentPhase: 1,\n completedMaterials: [],\n completedMilestones: [],\n progressPercentage: 0\n };\n\n return this.apiService.createProgress(userId, examType, progressData).pipe(\n map(response => {\n if (response.success && response.data) {\n const currentProgress = this.progressSubject.value;\n currentProgress[`${userId}-${examType}`] = response.data;\n this.progressSubject.next(currentProgress);\n return response.data;\n }\n return null;\n })\n );\n }\n\n markMaterialCompleted(userId: string, examType: ExamType, materialId: string): Observable {\n const currentProgress = this.progressSubject.value[`${userId}-${examType}`];\n if (!currentProgress) return new Observable(observer => observer.next(null));\n\n const completedMaterials = [...currentProgress.completedMaterials];\n if (!completedMaterials.includes(materialId)) {\n completedMaterials.push(materialId);\n }\n\n const updates = {\n completedMaterials,\n progressPercentage: this.calculateProgressPercentage(currentProgress, completedMaterials)\n };\n\n return this.updateProgress(userId, examType, updates);\n }\n\n markMilestoneCompleted(userId: string, examType: ExamType, milestone: string): Observable {\n const currentProgress = this.progressSubject.value[`${userId}-${examType}`];\n if (!currentProgress) return new Observable(observer => observer.next(null));\n\n const completedMilestones = [...currentProgress.completedMilestones];\n if (!completedMilestones.includes(milestone)) {\n completedMilestones.push(milestone);\n }\n\n const updates = {\n completedMilestones,\n progressPercentage: this.calculateProgressPercentage(currentProgress, undefined, completedMilestones)\n };\n\n return this.updateProgress(userId, examType, updates);\n }\n\n advancePhase(userId: string, examType: ExamType): Observable {\n const currentProgress = this.progressSubject.value[`${userId}-${examType}`];\n if (!currentProgress) return new Observable(observer => observer.next(null));\n\n const updates = {\n currentPhase: currentProgress.currentPhase + 1,\n progressPercentage: this.calculateProgressPercentage(currentProgress)\n };\n\n return this.updateProgress(userId, examType, updates);\n }\n\n private calculateProgressPercentage(\n progress: UserProgress, \n completedMaterials?: string[], \n completedMilestones?: string[]\n ): number {\n // Simple calculation based on completed materials and milestones\n const materials = completedMaterials || progress.completedMaterials;\n const milestones = completedMilestones || progress.completedMilestones;\n \n // Assume 10 materials and 5 milestones per exam for calculation\n const totalItems = 15;\n const completedItems = materials.length + milestones.length;\n \n return Math.min(100, Math.round((completedItems / totalItems) * 100));\n }\n\n loadTestScores(userId: string, examType?: ExamType): Observable {\n return this.apiService.getTestScores(userId, examType).pipe(\n map(response => {\n if (response.success && response.data) {\n this.scoresSubject.next(response.data);\n return response.data;\n }\n return [];\n })\n );\n }\n\n addTestScore(userId: string, score: Omit): Observable {\n return this.apiService.addTestScore(userId, score).pipe(\n map(response => {\n if (response.success && response.data) {\n const currentScores = this.scoresSubject.value;\n this.scoresSubject.next([response.data, ...currentScores]);\n return response.data;\n }\n return null;\n })\n );\n }\n\n getProgressAnalytics(userId: string, examType?: ExamType): Observable {\n return this.apiService.getProgressAnalytics(userId, examType).pipe(\n map(response => response.success ? response.data : null)\n );\n }\n\n getProgressForExam(userId: string, examType: ExamType): UserProgress | null {\n return this.progressSubject.value[`${userId}-${examType}`] || null;\n }\n\n getRecentScores(limit: number = 5): TestScore[] {\n return this.scoresSubject.value.slice(0, limit);\n }\n\n getScoresBySubject(subject: string): TestScore[] {\n return this.scoresSubject.value.filter(score => score.subject === subject);\n }\n\n getAverageScore(examType?: ExamType): number {\n const scores = examType \n ? this.scoresSubject.value.filter(score => score.examType === examType)\n : this.scoresSubject.value;\n \n if (scores.length === 0) return 0;\n \n const total = scores.reduce((sum, score) => sum + score.percentage, 0);\n return Math.round(total / scores.length);\n }\n\n getBestScore(examType?: ExamType): number {\n const scores = examType \n ? this.scoresSubject.value.filter(score => score.examType === examType)\n : this.scoresSubject.value;\n \n if (scores.length === 0) return 0;\n \n return Math.max(...scores.map(score => score.percentage));\n }\n\n getStudyStreak(userId: string): number {\n // Calculate study streak based on progress updates\n // This is a simplified implementation\n const allProgress = Object.values(this.progressSubject.value);\n if (allProgress.length === 0) return 0;\n\n // Count consecutive days with progress updates\n let streak = 0;\n const today = new Date();\n \n for (let i = 0; i < 30; i++) {\n const checkDate = new Date(today);\n checkDate.setDate(today.getDate() - i);\n const dateStr = checkDate.toISOString().split('T')[0];\n \n const hasProgress = allProgress.some(progress => \n progress.lastUpdated.startsWith(dateStr)\n );\n \n if (hasProgress) {\n streak++;\n } else if (i > 0) {\n break;\n }\n }\n \n return streak;\n }\n}",[],[138,217,209],"services","c91f81ba-3c7a-11f0-9ba5-9e149126039e","exam.service.ts","c91f8264-3c7a-11f0-9ba5-9e149126039e",15,["D",1748515850639],"import { Injectable } from '@angular/core';\nimport { BehaviorSubject, Observable, map } from 'rxjs';\nimport { ApiService } from './api.service.ts';\nimport type { Exam, ExamType, StudyMaterial } from '../../shared/types.ts';\n\n@Injectable({\n providedIn: 'root'\n})\nexport class ExamService {\n private selectedExamSubject = new BehaviorSubject(null);\n private examsSubject = new BehaviorSubject([]);\n\n selectedExam$ = this.selectedExamSubject.asObservable();\n exams$ = this.examsSubject.asObservable();\n\n constructor(private apiService: ApiService) {\n this.loadExams();\n }\n\n private loadExams(): void {\n this.apiService.getAllExams().subscribe({\n next: (response) => {\n if (response.success && response.data) {\n this.examsSubject.next(response.data);\n }\n },\n error: (error) => {\n console.error('Failed to load exams:', error);\n }\n });\n }\n\n selectExam(examType: ExamType): void {\n this.selectedExamSubject.next(examType);\n }\n\n getSelectedExam(): ExamType | null {\n return this.selectedExamSubject.value;\n }\n\n getExamDetails(examType: ExamType): Observable {\n return this.apiService.getExamByType(examType).pipe(\n map(response => response.success ? response.data || null : null)\n );\n }\n\n getExamSubjects(examType: ExamType): Observable {\n return this.apiService.getExamSubjects(examType).pipe(\n map(response => response.success ? response.data || [] : [])\n );\n }\n\n getMaterials(examType: ExamType, subject?: string): Observable {\n return this.apiService.getMaterials(examType, subject).pipe(\n map(response => response.success ? response.data || [] : [])\n );\n }\n\n searchMaterials(examType: ExamType, query: string): Observable {\n return this.apiService.searchMaterials(examType, query).pipe(\n map(response => response.success ? response.data || [] : [])\n );\n }\n\n getExamInfo(): { [key in ExamType]: { name: string; icon: string; color: string; description: string } } {\n return {\n TNTET: {\n name: 'TNTET',\n icon: '👨‍🏫',\n color: 'bg-green-500',\n description: 'Teacher Eligibility Test'\n },\n TRB: {\n name: 'TRB',\n icon: '🎓',\n color: 'bg-blue-500',\n description: 'Teachers Recruitment Board'\n },\n TNPSC_GROUP1: {\n name: 'TNPSC Group 1',\n icon: '🏛️',\n color: 'bg-purple-500',\n description: 'Civil Services Examination'\n },\n TNPSC_GROUP2: {\n name: 'TNPSC Group 2',\n icon: '📋',\n color: 'bg-indigo-500',\n description: 'Non-Interview Posts'\n },\n TNPSC_GROUP4: {\n name: 'TNPSC Group 4',\n icon: '📝',\n color: 'bg-teal-500',\n description: 'Entry Level Services'\n }\n };\n }\n\n getDifficultyInfo(): { [key: string]: { color: string; label: string } } {\n return {\n beginner: { color: 'text-green-600', label: 'Beginner' },\n intermediate: { color: 'text-yellow-600', label: 'Intermediate' },\n advanced: { color: 'text-red-600', label: 'Advanced' }\n };\n }\n\n getMaterialTypeInfo(): { [key: string]: { icon: string; label: string } } {\n return {\n pdf: { icon: '📄', label: 'PDF Document' },\n video: { icon: '🎥', label: 'Video' },\n article: { icon: '📰', label: 'Article' },\n book: { icon: '📚', label: 'Book' },\n website: { icon: '🌐', label: 'Website' }\n };\n }\n}",[],[138,217,219],"be376524-3c7a-11f0-a3d0-9e149126039e","api.service.ts","be3765ec-3c7a-11f0-a3d0-9e149126039e",14,["D",1748515832341],"import { Injectable } from '@angular/core';\nimport { HttpClient } from '@angular/common/http';\nimport { Observable } from 'rxjs';\nimport type { \n ApiResponse, \n Exam, \n StudyMaterial, \n UserProgress, \n TestScore, \n Bookmark, \n ExamType,\n User \n} from '../../shared/types.ts';\n\n@Injectable({\n providedIn: 'root'\n})\nexport class ApiService {\n private baseUrl = '/api';\n\n constructor(private http: HttpClient) {}\n\n // Exam endpoints\n getAllExams(): Observable> {\n return this.http.get>(`${this.baseUrl}/exams`);\n }\n\n getExamByType(type: ExamType): Observable> {\n return this.http.get>(`${this.baseUrl}/exams/${type}`);\n }\n\n getExamSubjects(type: ExamType): Observable> {\n return this.http.get>(`${this.baseUrl}/exams/${type}/subjects`);\n }\n\n // Materials endpoints\n getMaterials(examType: ExamType, subject?: string): Observable> {\n const params = subject ? `?subject=${subject}` : '';\n return this.http.get>(`${this.baseUrl}/materials/${examType}${params}`);\n }\n\n searchMaterials(examType: ExamType, query: string): Observable> {\n return this.http.get>(`${this.baseUrl}/materials/${examType}/search?q=${query}`);\n }\n\n getMaterialsByTag(examType: ExamType, tag: string): Observable> {\n return this.http.get>(`${this.baseUrl}/materials/${examType}/tags/${tag}`);\n }\n\n getPopularTags(examType: ExamType): Observable>> {\n return this.http.get>>(`${this.baseUrl}/materials/${examType}/tags`);\n }\n\n createMaterial(material: Omit): Observable> {\n return this.http.post>(`${this.baseUrl}/materials`, material);\n }\n\n // Progress endpoints\n getUserProgress(userId: string, examType: ExamType): Observable> {\n return this.http.get>(`${this.baseUrl}/progress/${userId}/${examType}`);\n }\n\n updateProgress(userId: string, examType: ExamType, progress: Partial): Observable> {\n return this.http.put>(`${this.baseUrl}/progress/${userId}/${examType}`, progress);\n }\n\n createProgress(userId: string, examType: ExamType, progress: Partial): Observable> {\n return this.http.post>(`${this.baseUrl}/progress/${userId}/${examType}`, progress);\n }\n\n // Test scores endpoints\n addTestScore(userId: string, score: Omit): Observable> {\n return this.http.post>(`${this.baseUrl}/progress/${userId}/scores`, score);\n }\n\n getTestScores(userId: string, examType?: ExamType): Observable> {\n const params = examType ? `?examType=${examType}` : '';\n return this.http.get>(`${this.baseUrl}/progress/${userId}/scores${params}`);\n }\n\n getProgressAnalytics(userId: string, examType?: ExamType): Observable> {\n const params = examType ? `?examType=${examType}` : '';\n return this.http.get>(`${this.baseUrl}/progress/${userId}/analytics${params}`);\n }\n\n // Bookmarks endpoints\n getBookmarks(userId: string, examType?: ExamType): Observable> {\n const params = examType ? `?examType=${examType}` : '';\n return this.http.get>(`${this.baseUrl}/bookmarks/${userId}${params}`);\n }\n\n createBookmark(userId: string, bookmark: Omit): Observable> {\n return this.http.post>(`${this.baseUrl}/bookmarks/${userId}`, bookmark);\n }\n\n deleteBookmark(userId: string, bookmarkId: string): Observable> {\n return this.http.delete>(`${this.baseUrl}/bookmarks/${userId}/${bookmarkId}`);\n }\n\n searchBookmarks(userId: string, query: string, examType?: ExamType): Observable> {\n const params = examType ? `?q=${query}&examType=${examType}` : `?q=${query}`;\n return this.http.get>(`${this.baseUrl}/bookmarks/${userId}/search${params}`);\n }\n\n getBookmarkStats(userId: string): Observable> {\n return this.http.get>(`${this.baseUrl}/bookmarks/${userId}/stats`);\n }\n\n // Demo user for testing\n getDemoUser(): Observable> {\n return this.http.get>(`${this.baseUrl}/demo-user`);\n }\n\n // Health check\n healthCheck(): Observable {\n return this.http.get(`${this.baseUrl}/health`);\n }\n}",[],[138,217,227],"be377276-3c7a-11f0-a3d0-9e149126039e",["D",1748515832341],[179,180,181],[138,217],"5ca49cae-3c7b-11f0-b6a8-9e149126039e","tracker.component.ts","5ca49d58-3c7b-11f0-b6a8-9e149126039e","3959b96d-2b4a-4185-8376-86d948dab85d",21,["D",1748516098138],"import { Component, Input, OnInit } from '@angular/core';\nimport { CommonModule } from '@angular/common';\nimport { FormsModule } from '@angular/forms';\nimport { ProgressService } from '../services/progress.service.ts';\nimport { ExamService } from '../services/exam.service.ts';\nimport type { User, ExamType, TestScore } from '../../shared/types.ts';\n\n@Component({\n selector: 'app-tracker',\n standalone: true,\n imports: [CommonModule, FormsModule],\n template: `\n

\n \n

Add Test Score

\n\n \n

Average Score

{{ averageScore }}%

Across all tests

\n \n

Best Score

{{ bestScore }}%

Personal best

\n \n

Total Tests

Tests completed

\n\n \n

Recent Test Scores

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Test Name	Subject	Score	Percentage	Date	Time
{{ score.testName }}	{{ score.subject }}	{{ score.scoredMarks }}/{{ score.totalMarks }}	\n \n {{ score.percentage }}%\n \n	{{ formatDate(score.testDate) }}	{{ score.timeSpent }}m

\n \n

No test scores recorded yet

Add your first test score above

\n\n \n

0\" class=\"bg-white rounded-lg p-6 shadow-sm border\">\n

Subject-wise Performance

\n {{ subject.name }}\n {{ subject.average }}%\n

\n {{ subject.count }} tests\n

\n `\n})\nexport class TrackerComponent implements OnInit {\n @Input() user: User | null = null;\n @Input() selectedExam: ExamType | null = null;\n\n testScores: TestScore[] = [];\n subjects: string[] = [];\n averageScore = 0;\n bestScore = 0;\n totalTests = 0;\n subjectPerformance: Array<{ name: string; average: number; count: number }> = [];\n isSubmitting = false;\n\n newScore = {\n testName: '',\n subject: '',\n totalMarks: 0,\n scoredMarks: 0,\n timeSpent: 0,\n testDate: new Date().toISOString().split('T')[0],\n notes: ''\n };\n\n constructor(\n private progressService: ProgressService,\n private examService: ExamService\n ) {}\n\n ngOnInit(): void {\n this.loadData();\n this.subscribeToProgress();\n }\n\n private loadData(): void {\n if (this.selectedExam) {\n this.examService.getExamSubjects(this.selectedExam).subscribe(subjects => {\n this.subjects = subjects;\n });\n }\n\n if (this.user) {\n this.progressService.loadTestScores(this.user.id, this.selectedExam).subscribe(scores => {\n this.testScores = scores;\n this.calculateSubjectPerformance();\n });\n }\n }\n\n private subscribeToProgress(): void {\n this.progressService.scores$.subscribe(scores => {\n this.testScores = this.selectedExam \n ? scores.filter(score => score.examType === this.selectedExam)\n : scores;\n this.averageScore = this.progressService.getAverageScore(this.selectedExam);\n this.bestScore = this.progressService.getBestScore(this.selectedExam);\n this.totalTests = this.testScores.length;\n this.calculateSubjectPerformance();\n });\n }\n\n private calculateSubjectPerformance(): void {\n const subjectMap = new Map();\n \n this.testScores.forEach(score => {\n const existing = subjectMap.get(score.subject) || { total: 0, count: 0 };\n existing.total += score.percentage;\n existing.count += 1;\n subjectMap.set(score.subject, existing);\n });\n\n this.subjectPerformance = Array.from(subjectMap.entries()).map(([name, data]) => ({\n name,\n average: Math.round(data.total / data.count),\n count: data.count\n }));\n }\n\n addTestScore(): void {\n if (!this.user || !this.selectedExam) return;\n\n this.isSubmitting = true;\n \n const scoreData = {\n ...this.newScore,\n examType: this.selectedExam\n };\n\n this.progressService.addTestScore(this.user.id, scoreData).subscribe({\n next: (score) => {\n if (score) {\n this.resetForm();\n }\n this.isSubmitting = false;\n },\n error: (error) => {\n console.error('Failed to add test score:', error);\n this.isSubmitting = false;\n }\n });\n }\n\n private resetForm(): void {\n this.newScore = {\n testName: '',\n subject: '',\n totalMarks: 0,\n scoredMarks: 0,\n timeSpent: 0,\n testDate: new Date().toISOString().split('T')[0],\n notes: ''\n };\n }\n\n getScoreColor(percentage: number): string {\n if (percentage >= 80) return 'text-green-600 font-semibold';\n if (percentage >= 60) return 'text-yellow-600 font-semibold';\n return 'text-red-600 font-semibold';\n }\n\n formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', { \n month: 'short', \n day: 'numeric',\n year: 'numeric'\n });\n }\n}",[],[138,247,239],"components","42e78542-3c7b-11f0-9abc-9e149126039e","roadmap.component.ts","42e785ec-3c7b-11f0-9abc-9e149126039e",20,["D",1748516054956],"import { Component, Input, OnInit } from '@angular/core';\nimport { CommonModule } from '@angular/common';\nimport { ExamService } from '../services/exam.service.ts';\nimport type { ExamType } from '../../shared/types.ts';\n\n@Component({\n selector: 'app-roadmap',\n standalone: true,\n imports: [CommonModule],\n template: `\n

\n \n

Study Roadmap

\n Structured study plan for {{ getExamName(selectedExam) }}\n Select an exam to view its study roadmap\n

\n\n \n

\n \n

Foundation Phase

Duration: 4-6 weeks

\n \n

\n \n Complete basic concepts and fundamentals\n

\n \n Study core subjects and syllabus overview\n

\n \n Take diagnostic tests to identify weak areas\n

\n\n \n

Intermediate Phase

Duration: 8-10 weeks

\n \n

\n \n Deep dive into advanced topics\n

\n \n Practice previous year questions\n

\n \n Subject-wise mock tests\n

\n\n \n

Advanced Phase

Duration: 6-8 weeks

\n \n

\n \n Full-length mock tests\n

\n \n Time management and speed improvement\n

\n \n Revision and weak area improvement\n

\n\n \n

Final Preparation

Duration: 2-4 weeks

\n \n

\n \n Final revision of all topics\n

\n \n Exam strategy and time management\n

\n \n Stress management and confidence building\n

\n\n \n

🗺️

Select an Exam

Choose your target exam to view the detailed study roadmap

\n `\n})\nexport class RoadmapComponent implements OnInit {\n @Input() selectedExam: ExamType | null = null;\n\n constructor(private examService: ExamService) {}\n\n ngOnInit(): void {}\n\n getExamName(examType: ExamType): string {\n const examInfo = this.examService.getExamInfo();\n return examInfo[examType]?.name || examType;\n }\n}",[],[138,247,249],"308d9062-3c7b-11f0-9cbc-9e149126039e","materials.component.ts","308d9116-3c7b-11f0-9cbc-9e149126039e",19,["D",1748516024167],"import { Component, Input, OnInit, OnChanges } from '@angular/core';\nimport { CommonModule } from '@angular/common';\nimport { FormsModule } from '@angular/forms';\nimport { ExamService } from '../services/exam.service.ts';\nimport { ApiService } from '../services/api.service.ts';\nimport type { ExamType, StudyMaterial } from '../../shared/types.ts';\n\n@Component({\n selector: 'app-materials',\n standalone: true,\n imports: [CommonModule, FormsModule],\n template: `\n

\n \n

\n \n \n \n \n \n

\n\n \n

0\" class=\"bg-white rounded-lg p-6 shadow-sm border\">\n

Popular Tags

\n \n {{ tag.tag }} ({{ tag.count }})\n \n

\n\n \n

0\" class=\"grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6\">\n

\n {{ getMaterialIcon(material.type) }}\n

\n \n {{ material.difficulty }}\n \n

\n \n

\n 📚\n {{ material.subject }}\n

\n ⏱️\n {{ material.estimatedTime }}\n

\n \n

\n \n {{ tag }}\n \n 3\" class=\"text-xs text-gray-500\">\n +{{ material.tags.length - 3 }} more\n \n

\n \n

\n \n \n

\n\n \n

📚

No materials found

\n Select an exam to view study materials\n Try adjusting your search or filters\n No materials available for this exam yet\n

\n \n

\n\n \n

\n \n

\n\n \n

Add Study Material

\n `\n})\nexport class MaterialsComponent implements OnInit, OnChanges {\n @Input() selectedExam: ExamType | null = null;\n\n materials: StudyMaterial[] = [];\n subjects: string[] = [];\n popularTags: Array<{ tag: string; count: number }> = [];\n \n searchQuery = '';\n selectedSubject = '';\n selectedDifficulty = '';\n selectedType = '';\n \n isLoading = false;\n showAddMaterial = false;\n isSubmitting = false;\n\n newMaterial = {\n title: '',\n description: '',\n subject: '',\n type: '',\n difficulty: '',\n url: '',\n estimatedTime: ''\n };\n\n constructor(\n private examService: ExamService,\n private apiService: ApiService\n ) {}\n\n ngOnInit(): void {\n this.loadMaterials();\n }\n\n ngOnChanges(): void {\n this.loadMaterials();\n }\n\n private loadMaterials(): void {\n if (!this.selectedExam) {\n this.materials = [];\n return;\n }\n\n this.isLoading = true;\n \n // Load subjects\n this.examService.getExamSubjects(this.selectedExam).subscribe(subjects => {\n this.subjects = subjects;\n });\n\n // Load materials\n this.examService.getMaterials(this.selectedExam, this.selectedSubject).subscribe(materials => {\n this.materials = materials;\n this.isLoading = false;\n });\n\n // Load popular tags\n this.apiService.getPopularTags(this.selectedExam).subscribe(response => {\n if (response.success && response.data) {\n this.popularTags = response.data;\n }\n });\n }\n\n onSearch(): void {\n if (!this.selectedExam) return;\n\n if (this.searchQuery.trim()) {\n this.isLoading = true;\n this.examService.searchMaterials(this.selectedExam, this.searchQuery).subscribe(materials => {\n this.materials = materials;\n this.isLoading = false;\n });\n } else {\n this.loadMaterials();\n }\n }\n\n onFilterChange(): void {\n this.loadMaterials();\n }\n\n filterByTag(tag: string): void {\n if (!this.selectedExam) return;\n\n this.isLoading = true;\n this.apiService.getMaterialsByTag(this.selectedExam, tag).subscribe(response => {\n if (response.success && response.data) {\n this.materials = response.data;\n }\n this.isLoading = false;\n });\n }\n\n clearFilters(): void {\n this.searchQuery = '';\n this.selectedSubject = '';\n this.selectedDifficulty = '';\n this.selectedType = '';\n this.loadMaterials();\n }\n\n getMaterialIcon(type: string): string {\n const icons = this.examService.getMaterialTypeInfo();\n return icons[type]?.icon || '📄';\n }\n\n getMaterialTypeLabel(type: string): string {\n const types = this.examService.getMaterialTypeInfo();\n return types[type]?.label || type;\n }\n\n getDifficultyClass(difficulty: string): string {\n const classes = {\n beginner: 'bg-green-100 text-green-800',\n intermediate: 'bg-yellow-100 text-yellow-800',\n advanced: 'bg-red-100 text-red-800'\n };\n return classes[difficulty as keyof typeof classes] || 'bg-gray-100 text-gray-800';\n }\n\n openMaterial(url: string): void {\n window.open(url, '_blank');\n }\n\n bookmarkMaterial(material: StudyMaterial): void {\n // This would typically call the bookmark service\n console.log('Bookmark material:', material.title);\n }\n\n markAsCompleted(material: StudyMaterial): void {\n // This would typically update progress\n console.log('Mark as completed:', material.title);\n }\n\n addMaterial(): void {\n if (!this.selectedExam) return;\n\n this.isSubmitting = true;\n \n const materialData = {\n ...this.newMaterial,\n examType: this.selectedExam,\n tags: []\n };\n\n this.apiService.createMaterial(materialData).subscribe({\n next: (response) => {\n if (response.success) {\n this.showAddMaterial = false;\n this.resetNewMaterial();\n this.loadMaterials();\n }\n this.isSubmitting = false;\n },\n error: (error) => {\n console.error('Failed to add material:', error);\n this.isSubmitting = false;\n }\n });\n }\n\n private resetNewMaterial(): void {\n this.newMaterial = {\n title: '',\n description: '',\n subject: '',\n type: '',\n difficulty: '',\n url: '',\n estimatedTime: ''\n };\n }\n}",[],[138,247,257],"0ec423a6-3c7b-11f0-a0f3-9e149126039e","dashboard.component.ts","0ec42450-3c7b-11f0-a0f3-9e149126039e",18,["D",1748515967483],"import { Component, Input, OnInit, OnChanges } from '@angular/core';\nimport { CommonModule } from '@angular/common';\nimport { ExamService } from '../services/exam.service.ts';\nimport { ProgressService } from '../services/progress.service.ts';\nimport type { User, ExamType, Exam, TestScore, UserProgress } from '../../shared/types.ts';\n\n@Component({\n selector: 'app-dashboard',\n standalone: true,\n imports: [CommonModule],\n template: `\n

\n \n

Welcome back, {{ user?.name }}! 👋

Ready to continue your exam preparation journey?

\n\n \n

📊

Average Score

{{ averageScore }}%

\n\n

🎯

Best Score

{{ bestScore }}%

\n\n

🔥

Study Streak

{{ studyStreak }} days

\n\n

📝

Tests Taken

\n\n \n

Your Target Exams

\n {{ getExamIcon(examType) }}\n

\n \n

\n Progress\n {{ getExamProgress(examType) }}%\n

\n\n

\n \n

Recent Test Scores

{{ score.subject }} • {{ formatDate(score.testDate) }}

\n {{ score.scoredMarks }}/{{ score.totalMarks }}\n

{{ score.percentage }}%

\n \n

No test scores yet

Take your first practice test to see results here

\n\n \n

Study Progress

\n Current Phase\n Phase {{ currentProgress?.currentPhase || 1 }}\n

\n \n

\n Materials Completed\n {{ currentProgress?.completedMaterials.length || 0 }}/10\n

\n \n

\n Milestones Achieved\n {{ currentProgress?.completedMilestones.length || 0 }}/5\n

\n \n

Select an exam to view progress

\n\n \n

Quick Actions

\n \n \n \n \n \n \n \n

\n `\n})\nexport class DashboardComponent implements OnInit, OnChanges {\n @Input() user: User | null = null;\n @Input() selectedExam: ExamType | null = null;\n\n recentScores: TestScore[] = [];\n currentProgress: UserProgress | null = null;\n averageScore = 0;\n bestScore = 0;\n studyStreak = 0;\n totalTests = 0;\n\n constructor(\n private examService: ExamService,\n private progressService: ProgressService\n ) {}\n\n ngOnInit(): void {\n this.loadDashboardData();\n this.subscribeToProgress();\n }\n\n ngOnChanges(): void {\n this.loadDashboardData();\n }\n\n private loadDashboardData(): void {\n if (!this.user) return;\n\n // Load test scores\n this.progressService.loadTestScores(this.user.id).subscribe(scores => {\n this.recentScores = scores.slice(0, 5);\n this.totalTests = scores.length;\n });\n\n // Load progress for selected exam\n if (this.selectedExam) {\n this.progressService.loadUserProgress(this.user.id, this.selectedExam).subscribe(progress => {\n this.currentProgress = progress;\n });\n }\n }\n\n private subscribeToProgress(): void {\n this.progressService.scores$.subscribe(scores => {\n this.averageScore = this.progressService.getAverageScore();\n this.bestScore = this.progressService.getBestScore();\n this.recentScores = this.progressService.getRecentScores(5);\n this.totalTests = scores.length;\n });\n\n if (this.user) {\n this.studyStreak = this.progressService.getStudyStreak(this.user.id);\n }\n }\n\n selectExam(examType: ExamType): void {\n this.examService.selectExam(examType);\n }\n\n getExamName(examType: ExamType): string {\n const examInfo = this.examService.getExamInfo();\n return examInfo[examType]?.name || examType;\n }\n\n getExamIcon(examType: ExamType): string {\n const examInfo = this.examService.getExamInfo();\n return examInfo[examType]?.icon || '📝';\n }\n\n getExamDescription(examType: ExamType): string {\n const examInfo = this.examService.getExamInfo();\n return examInfo[examType]?.description || '';\n }\n\n getExamProgress(examType: ExamType): number {\n if (!this.user) return 0;\n const progress = this.progressService.getProgressForExam(this.user.id, examType);\n return progress?.progressPercentage || 0;\n }\n\n getMaterialProgress(): number {\n if (!this.currentProgress) return 0;\n return Math.min(100, (this.currentProgress.completedMaterials.length / 10) * 100);\n }\n\n getMilestoneProgress(): number {\n if (!this.currentProgress) return 0;\n return Math.min(100, (this.currentProgress.completedMilestones.length / 5) * 100);\n }\n\n getScoreColor(percentage: number): string {\n if (percentage >= 80) return 'text-green-600';\n if (percentage >= 60) return 'text-yellow-600';\n return 'text-red-600';\n }\n\n formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', { \n month: 'short', \n day: 'numeric' \n });\n }\n\n navigateTo(section: string): void {\n // This would typically emit an event to the parent component\n // For now, we'll just log the navigation intent\n console.log(`Navigate to: ${section}`);\n }\n}",[],[138,247,265],"7aad24d2-3c7b-11f0-a6d9-9e149126039e","bookmarks.component.ts","7aad2590-3c7b-11f0-a6d9-9e149126039e",["D",1748516148525],"import { Component, Input, OnInit } from '@angular/core';\nimport { CommonModule } from '@angular/common';\nimport { FormsModule } from '@angular/forms';\nimport { ApiService } from '../services/api.service.ts';\nimport type { User, ExamType, Bookmark } from '../../shared/types.ts';\n\n@Component({\n selector: 'app-bookmarks',\n standalone: true,\n imports: [CommonModule, FormsModule],\n template: `\n

\n \n

\n \n \n \n

\n\n \n

🔖

Total Bookmarks

\n\n

📚

Study Materials

\n\n

🗺️

Roadmaps

\n\n

🌐

External Links

\n\n \n

\n {{ getBookmarkIcon(bookmark.type) }}\n

\n \n {{ bookmark.examType }}\n \n

\n \n

\n {{ bookmark.description }}\n

\n \n

\n 📅 {{ formatDate(bookmark.createdAt) }}\n 🔗 {{ getDomain(bookmark.url) }}\n

\n \n

0\" class=\"flex flex-wrap gap-1\">\n \n {{ tag }}\n \n

\n \n

\n \n \n

\n \n

🔖

No bookmarks found

\n Try adjusting your search or filters\n Start bookmarking important resources\n

\n \n

\n\n \n

Add Bookmark

\n `\n})\nexport class BookmarksComponent implements OnInit {\n @Input() user: User | null = null;\n @Input() selectedExam: ExamType | null = null;\n\n bookmarks: Bookmark[] = [];\n filteredBookmarks: Bookmark[] = [];\n bookmarkStats: any = null;\n \n searchQuery = '';\n selectedType = '';\n showAddBookmark = false;\n isSubmitting = false;\n\n newBookmark = {\n title: '',\n description: '',\n type: '',\n url: '',\n tagsInput: ''\n };\n\n constructor(private apiService: ApiService) {}\n\n ngOnInit(): void {\n this.loadBookmarks();\n this.loadBookmarkStats();\n }\n\n private loadBookmarks(): void {\n if (!this.user) return;\n\n this.apiService.getBookmarks(this.user.id, this.selectedExam).subscribe(response => {\n if (response.success && response.data) {\n this.bookmarks = response.data;\n this.filteredBookmarks = this.bookmarks;\n }\n });\n }\n\n private loadBookmarkStats(): void {\n if (!this.user) return;\n\n this.apiService.getBookmarkStats(this.user.id).subscribe(response => {\n if (response.success && response.data) {\n this.bookmarkStats = response.data;\n }\n });\n }\n\n onSearch(): void {\n this.applyFilters();\n }\n\n onFilterChange(): void {\n this.applyFilters();\n }\n\n private applyFilters(): void {\n let filtered = this.bookmarks;\n\n if (this.searchQuery.trim()) {\n const query = this.searchQuery.toLowerCase();\n filtered = filtered.filter(bookmark => \n bookmark.title.toLowerCase().includes(query) ||\n (bookmark.description && bookmark.description.toLowerCase().includes(query)) ||\n bookmark.tags.some(tag => tag.toLowerCase().includes(query))\n );\n }\n\n if (this.selectedType) {\n filtered = filtered.filter(bookmark => bookmark.type === this.selectedType);\n }\n\n this.filteredBookmarks = filtered;\n }\n\n addBookmark(): void {\n if (!this.user) return;\n\n this.isSubmitting = true;\n \n const bookmarkData = {\n title: this.newBookmark.title,\n description: this.newBookmark.description,\n type: this.newBookmark.type,\n url: this.newBookmark.url,\n tags: this.newBookmark.tagsInput.split(',').map(tag => tag.trim()).filter(tag => tag),\n examType: this.selectedExam\n };\n\n this.apiService.createBookmark(this.user.id, bookmarkData).subscribe({\n next: (response) => {\n if (response.success) {\n this.showAddBookmark = false;\n this.resetNewBookmark();\n this.loadBookmarks();\n this.loadBookmarkStats();\n }\n this.isSubmitting = false;\n },\n error: (error) => {\n console.error('Failed to add bookmark:', error);\n this.isSubmitting = false;\n }\n });\n }\n\n deleteBookmark(bookmark: Bookmark): void {\n if (!this.user || !confirm('Are you sure you want to delete this bookmark?')) return;\n\n this.apiService.deleteBookmark(this.user.id, bookmark.id).subscribe({\n next: (response) => {\n if (response.success) {\n this.loadBookmarks();\n this.loadBookmarkStats();\n }\n },\n error: (error) => {\n console.error('Failed to delete bookmark:', error);\n }\n });\n }\n\n openBookmark(url: string): void {\n window.open(url, '_blank');\n }\n\n getBookmarkIcon(type: string): string {\n const icons = {\n material: '📚',\n roadmap: '🗺️',\n external: '🌐'\n };\n return icons[type as keyof typeof icons] || '🔖';\n }\n\n getDomain(url: string): string {\n try {\n return new URL(url).hostname;\n } catch {\n return url;\n }\n }\n\n formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', { \n month: 'short', \n day: 'numeric',\n year: 'numeric'\n });\n }\n\n private resetNewBookmark(): void {\n this.newBookmark = {\n title: '',\n description: '',\n type: '',\n url: '',\n tagsInput: ''\n };\n }\n}",[],[138,247,273],"f2cf0dd2-3c7a-11f0-9054-9e149126039e","app.component.ts","f2cf0eae-3c7a-11f0-9054-9e149126039e",17,["D",1748515920576],"import { Component, OnInit } from '@angular/core';\nimport { CommonModule } from '@angular/common';\nimport { ApiService } from '../services/api.service.ts';\nimport { ExamService } from '../services/exam.service.ts';\nimport { ProgressService } from '../services/progress.service.ts';\nimport { DashboardComponent } from './dashboard.component.ts';\nimport { RoadmapComponent } from './roadmap.component.ts';\nimport { MaterialsComponent } from './materials.component.ts';\nimport { TrackerComponent } from './tracker.component.ts';\nimport { BookmarksComponent } from './bookmarks.component.ts';\nimport type { User, ExamType } from '../../shared/types.ts';\n\n@Component({\n selector: 'app-root',\n standalone: true,\n imports: [\n CommonModule,\n DashboardComponent,\n RoadmapComponent,\n MaterialsComponent,\n TrackerComponent,\n BookmarksComponent\n ],\n template: `\n

\n \n

📚 TN Exam Prep

\n \n \n \n\n \n

Target Exams

\n \n

\n\n \n

\n Study Streak\n {{ studyStreak }} days\n

\n Avg Score\n {{ averageScore }}%\n

\n Best Score\n {{ bestScore }}%\n

\n\n \n

\n \n

\n {{ getExamIcon(selectedExam) }}\n {{ getExamName(selectedExam) }}\n

\n \n

\n\n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Select a section to get started

\n\n \n

\n `\n})\nexport class AppComponent implements OnInit {\n activeView = 'dashboard';\n selectedExam: ExamType | null = null;\n currentUser: User | null = null;\n targetExams: ExamType[] = [];\n isLoading = false;\n studyStreak = 0;\n averageScore = 0;\n bestScore = 0;\n\n navigationItems = [\n { id: 'dashboard', label: 'Dashboard', icon: '🏠' },\n { id: 'roadmap', label: 'Roadmaps', icon: '🗺️' },\n { id: 'materials', label: 'Materials', icon: '📚' },\n { id: 'tracker', label: 'Progress', icon: '📊' },\n { id: 'bookmarks', label: 'Bookmarks', icon: '🔖' }\n ];\n\n constructor(\n private apiService: ApiService,\n private examService: ExamService,\n private progressService: ProgressService\n ) {}\n\n ngOnInit(): void {\n this.loadInitialData();\n this.subscribeToProgress();\n }\n\n private async loadInitialData(): Promise {\n this.isLoading = true;\n \n try {\n // Load demo user\n const userResponse = await this.apiService.getDemoUser().toPromise();\n if (userResponse?.success && userResponse.data) {\n this.currentUser = userResponse.data;\n this.targetExams = userResponse.data.targetExams;\n \n // Select first exam by default\n if (this.targetExams.length > 0) {\n this.selectExam(this.targetExams[0]);\n }\n }\n } catch (error) {\n console.error('Failed to load initial data:', error);\n } finally {\n this.isLoading = false;\n }\n }\n\n private subscribeToProgress(): void {\n this.progressService.scores$.subscribe(scores => {\n this.averageScore = this.progressService.getAverageScore();\n this.bestScore = this.progressService.getBestScore();\n });\n }\n\n setActiveView(view: string): void {\n this.activeView = view;\n }\n\n selectExam(examType: ExamType): void {\n this.selectedExam = examType;\n this.examService.selectExam(examType);\n \n // Load progress data for selected exam\n if (this.currentUser) {\n this.progressService.loadTestScores(this.currentUser.id, examType).subscribe();\n this.progressService.loadUserProgress(this.currentUser.id, examType).subscribe();\n this.studyStreak = this.progressService.getStudyStreak(this.currentUser.id);\n }\n }\n\n getActiveViewTitle(): string {\n const titles: { [key: string]: string } = {\n dashboard: 'Dashboard',\n roadmap: 'Study Roadmaps',\n materials: 'Study Materials',\n tracker: 'Progress Tracker',\n bookmarks: 'Bookmarks'\n };\n return titles[this.activeView] || 'Tamil Nadu Exam Preparation';\n }\n\n getActiveViewDescription(): string {\n const descriptions: { [key: string]: string } = {\n dashboard: 'Overview of your exam preparation journey',\n roadmap: 'Structured study plans for your target exams',\n materials: 'Curated study resources and materials',\n tracker: 'Track your progress and test scores',\n bookmarks: 'Your saved resources and important links'\n };\n return descriptions[this.activeView] || '';\n }\n\n getExamName(examType: ExamType): string {\n const examInfo = this.examService.getExamInfo();\n return examInfo[examType]?.name || examType;\n }\n\n getExamIcon(examType: ExamType): string {\n const examInfo = this.examService.getExamInfo();\n return examInfo[examType]?.icon || '📝';\n }\n\n refreshData(): void {\n if (this.currentUser && this.selectedExam) {\n this.isLoading = true;\n \n Promise.all([\n this.progressService.loadTestScores(this.currentUser.id, this.selectedExam).toPromise(),\n this.progressService.loadUserProgress(this.currentUser.id, this.selectedExam).toPromise()\n ]).finally(() => {\n this.isLoading = false;\n });\n }\n }\n}",[],[138,247,280],"f2cf4310-3c7a-11f0-9054-9e149126039e",["D",1748515920576],[172,173,174,175,176,177],[138,247],["D",1748515810683],[171,178,182],[138],"a5ecfe2a-3c7a-11f0-96f1-9e149126039e","index.ts","a5ecfed4-3c7a-11f0-96f1-9e149126039e",12,["D",1748515791590],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations, seedData } from \"./database/migrations.ts\";\nimport examsRoutes from \"./routes/exams.ts\";\nimport progressRoutes from \"./routes/progress.ts\";\nimport materialsRoutes from \"./routes/materials.ts\";\nimport bookmarksRoutes from \"./routes/bookmarks.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Application error:\", err);\n throw err;\n});\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n console.log(\"Initializing database...\");\n await runMigrations();\n await seedData();\n dbInitialized = true;\n console.log(\"Database initialized successfully!\");\n }\n}\n\n// Middleware to ensure database is initialized\napp.use(\"*\", async (c, next) => {\n await initializeDatabase();\n await next();\n});\n\n// CORS headers for API routes\napp.use(\"/api/*\", async (c, next) => {\n c.header(\"Access-Control-Allow-Origin\", \"*\");\n c.header(\"Access-Control-Allow-Methods\", \"GET, POST, PUT, DELETE, OPTIONS\");\n c.header(\"Access-Control-Allow-Headers\", \"Content-Type, Authorization\");\n \n if (c.req.method === \"OPTIONS\") {\n return c.text(\"\", 200);\n }\n \n await next();\n});\n\n// API Routes\napp.route(\"/api/exams\", examsRoutes);\napp.route(\"/api/progress\", progressRoutes);\napp.route(\"/api/materials\", materialsRoutes);\napp.route(\"/api/bookmarks\", bookmarksRoutes);\n\n// Health check endpoint\napp.get(\"/api/health\", (c) => {\n return c.json({\n status: \"healthy\",\n timestamp: new Date().toISOString(),\n version: \"1.0.0\"\n });\n});\n\n// Demo user endpoint for testing\napp.get(\"/api/demo-user\", (c) => {\n const demoUser = {\n id: \"demo-user-123\",\n name: \"Demo User\",\n email: \"demo@example.com\",\n targetExams: [\"TNTET\", \"TNPSC_GROUP4\"],\n createdAt: new Date().toISOString(),\n lastLogin: new Date().toISOString()\n };\n \n return c.json({\n success: true,\n data: demoUser\n });\n});\n\n// Static file serving and main app\napp.route(\"/\", staticRoutes);\n\n// 404 handler for API routes\napp.notFound((c) => {\n if (c.req.path.startsWith(\"/api/\")) {\n return c.json({\n success: false,\n error: \"API endpoint not found\",\n path: c.req.path\n }, 404);\n }\n \n // For non-API routes, redirect to main app\n return c.redirect(\"/\");\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[144,295],"9dab7d5e-3c7a-11f0-83b1-9e149126039e","static.ts","9dab7e12-3c7a-11f0-83b1-9e149126039e","26284929-71f1-41cb-b58f-804bbf62ce21",11,["D",1748515777736],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve shared files\nstaticRoutes.get(\"/shared/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve the main application\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const initialData = {\n timestamp: new Date().toISOString(),\n version: \"1.0.0\"\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.html(`\n \n Error\n \n

Application Error

Failed to load the application. Please try again later.

\n \n \n `, 500);\n }\n});\n\nexport default staticRoutes;",[],[144,311,303],"routes","7f4a808a-3c7a-11f0-9254-9e149126039e","progress.ts","7f4a8198-3c7a-11f0-9254-9e149126039e",8,["D",1748515726771],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ExamType, ApiResponse, UserProgress, TestScore } from \"../../shared/types.ts\";\nimport { \n getUserProgress, \n updateUserProgress, \n createTestScore, \n getUserTestScores \n} from \"../database/queries.ts\";\n\nconst progress = new Hono();\n\n// Get user progress for specific exam\nprogress.get(\"/:userId/:examType\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const examType = c.req.param(\"examType\") as ExamType;\n \n const userProgress = await getUserProgress(userId, examType);\n \n return c.json({\n success: true,\n data: userProgress\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch progress\"\n } as ApiResponse, 500);\n }\n});\n\n// Update user progress\nprogress.put(\"/:userId/:examType\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const examType = c.req.param(\"examType\") as ExamType;\n const progressData = await c.req.json();\n \n const updatedProgress: UserProgress = {\n ...progressData,\n userId,\n examType,\n lastUpdated: new Date().toISOString()\n };\n \n await updateUserProgress(updatedProgress);\n \n return c.json({\n success: true,\n data: updatedProgress,\n message: \"Progress updated successfully\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to update progress\"\n } as ApiResponse, 500);\n }\n});\n\n// Create new progress entry\nprogress.post(\"/:userId/:examType\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const examType = c.req.param(\"examType\") as ExamType;\n const progressData = await c.req.json();\n \n const newProgress: UserProgress = {\n id: crypto.randomUUID(),\n userId,\n examType,\n roadmapId: progressData.roadmapId,\n currentPhase: 1,\n completedMaterials: [],\n completedMilestones: [],\n startDate: new Date().toISOString(),\n lastUpdated: new Date().toISOString(),\n progressPercentage: 0,\n ...progressData\n };\n \n await updateUserProgress(newProgress);\n \n return c.json({\n success: true,\n data: newProgress,\n message: \"Progress tracking started\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to create progress entry\"\n } as ApiResponse, 500);\n }\n});\n\n// Add test score\nprogress.post(\"/:userId/scores\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const scoreData = await c.req.json();\n \n const testScore: Omit = {\n userId,\n examType: scoreData.examType,\n subject: scoreData.subject,\n testName: scoreData.testName,\n totalMarks: scoreData.totalMarks,\n scoredMarks: scoreData.scoredMarks,\n percentage: (scoreData.scoredMarks / scoreData.totalMarks) * 100,\n testDate: scoreData.testDate || new Date().toISOString(),\n timeSpent: scoreData.timeSpent,\n notes: scoreData.notes\n };\n \n const scoreId = await createTestScore(testScore);\n \n return c.json({\n success: true,\n data: { id: scoreId, ...testScore },\n message: \"Test score recorded successfully\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to record test score\"\n } as ApiResponse, 500);\n }\n});\n\n// Get user test scores\nprogress.get(\"/:userId/scores\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const examType = c.req.query(\"examType\") as ExamType | undefined;\n \n const scores = await getUserTestScores(userId, examType);\n \n return c.json({\n success: true,\n data: scores\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch test scores\"\n } as ApiResponse, 500);\n }\n});\n\n// Get progress analytics\nprogress.get(\"/:userId/analytics\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const examType = c.req.query(\"examType\") as ExamType | undefined;\n \n const scores = await getUserTestScores(userId, examType);\n \n // Calculate analytics\n const analytics = {\n totalTests: scores.length,\n averageScore: scores.length > 0 ? scores.reduce((sum, score) => sum + score.percentage, 0) / scores.length : 0,\n bestScore: scores.length > 0 ? Math.max(...scores.map(s => s.percentage)) : 0,\n recentTrend: scores.slice(0, 5).map(s => ({ date: s.testDate, score: s.percentage })),\n subjectWisePerformance: scores.reduce((acc, score) => {\n if (!acc[score.subject]) {\n acc[score.subject] = { total: 0, count: 0, average: 0 };\n }\n acc[score.subject].total += score.percentage;\n acc[score.subject].count += 1;\n acc[score.subject].average = acc[score.subject].total / acc[score.subject].count;\n return acc;\n }, {} as Record)\n };\n \n return c.json({\n success: true,\n data: analytics\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch analytics\"\n } as ApiResponse, 500);\n }\n});\n\nexport default progress;",[],[144,311,313],"8b406c2e-3c7a-11f0-a75b-9e149126039e","materials.ts","8b406d5a-3c7a-11f0-a75b-9e149126039e",9,["D",1748515746837],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ExamType, ApiResponse, StudyMaterial } from \"../../shared/types.ts\";\nimport { \n getMaterialsByExamType, \n getMaterialsBySubject, \n createStudyMaterial \n} from \"../database/queries.ts\";\n\nconst materials = new Hono();\n\n// Get materials by exam type\nmaterials.get(\"/:examType\", async (c) => {\n try {\n const examType = c.req.param(\"examType\") as ExamType;\n const subject = c.req.query(\"subject\");\n const difficulty = c.req.query(\"difficulty\");\n const type = c.req.query(\"type\");\n \n let materialsList;\n if (subject) {\n materialsList = await getMaterialsBySubject(examType, subject);\n } else {\n materialsList = await getMaterialsByExamType(examType);\n }\n \n // Apply filters\n if (difficulty) {\n materialsList = materialsList.filter(m => m.difficulty === difficulty);\n }\n \n if (type) {\n materialsList = materialsList.filter(m => m.type === type);\n }\n \n return c.json({\n success: true,\n data: materialsList\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch materials\"\n } as ApiResponse, 500);\n }\n});\n\n// Create new study material\nmaterials.post(\"/\", async (c) => {\n try {\n const materialData = await c.req.json();\n \n const newMaterial: Omit = {\n examType: materialData.examType,\n subject: materialData.subject,\n title: materialData.title,\n description: materialData.description,\n type: materialData.type,\n url: materialData.url,\n difficulty: materialData.difficulty,\n estimatedTime: materialData.estimatedTime,\n tags: materialData.tags || [],\n createdAt: new Date().toISOString()\n };\n \n const materialId = await createStudyMaterial(newMaterial);\n \n return c.json({\n success: true,\n data: { id: materialId, ...newMaterial },\n message: \"Study material created successfully\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to create study material\"\n } as ApiResponse, 500);\n }\n});\n\n// Get materials by tags\nmaterials.get(\"/:examType/tags/:tag\", async (c) => {\n try {\n const examType = c.req.param(\"examType\") as ExamType;\n const tag = c.req.param(\"tag\");\n \n const allMaterials = await getMaterialsByExamType(examType);\n const filteredMaterials = allMaterials.filter(material => \n material.tags.includes(tag)\n );\n \n return c.json({\n success: true,\n data: filteredMaterials\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch materials by tag\"\n } as ApiResponse, 500);\n }\n});\n\n// Get popular tags for an exam\nmaterials.get(\"/:examType/tags\", async (c) => {\n try {\n const examType = c.req.param(\"examType\") as ExamType;\n \n const allMaterials = await getMaterialsByExamType(examType);\n const tagCounts = allMaterials.reduce((acc, material) => {\n material.tags.forEach(tag => {\n acc[tag] = (acc[tag] || 0) + 1;\n });\n return acc;\n }, {} as Record);\n \n const popularTags = Object.entries(tagCounts)\n .sort(([, a], [, b]) => b - a)\n .slice(0, 20)\n .map(([tag, count]) => ({ tag, count }));\n \n return c.json({\n success: true,\n data: popularTags\n } as ApiResponse>);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch tags\"\n } as ApiResponse, 500);\n }\n});\n\n// Search materials\nmaterials.get(\"/:examType/search\", async (c) => {\n try {\n const examType = c.req.param(\"examType\") as ExamType;\n const query = c.req.query(\"q\")?.toLowerCase();\n \n if (!query) {\n return c.json({\n success: false,\n error: \"Search query is required\"\n } as ApiResponse, 400);\n }\n \n const allMaterials = await getMaterialsByExamType(examType);\n const searchResults = allMaterials.filter(material => \n material.title.toLowerCase().includes(query) ||\n material.description.toLowerCase().includes(query) ||\n material.subject.toLowerCase().includes(query) ||\n material.tags.some(tag => tag.toLowerCase().includes(query))\n );\n \n return c.json({\n success: true,\n data: searchResults\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to search materials\"\n } as ApiResponse, 500);\n }\n});\n\nexport default materials;",[],[144,311,321],"71cb1f00-3c7a-11f0-bbd0-9e149126039e","exams.ts","71cb1f96-3c7a-11f0-bbd0-9e149126039e",7,["D",1748515704125],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ExamType, ApiResponse } from \"../../shared/types.ts\";\nimport { \n getAllExams, \n getExamByType, \n getMaterialsByExamType, \n getMaterialsBySubject \n} from \"../database/queries.ts\";\n\nconst exams = new Hono();\n\n// Get all available exams\nexams.get(\"/\", async (c) => {\n try {\n const allExams = await getAllExams();\n return c.json({\n success: true,\n data: allExams\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch exams\"\n } as ApiResponse, 500);\n }\n});\n\n// Get specific exam by type\nexams.get(\"/:type\", async (c) => {\n try {\n const examType = c.req.param(\"type\") as ExamType;\n const exam = await getExamByType(examType);\n \n if (!exam) {\n return c.json({\n success: false,\n error: \"Exam not found\"\n } as ApiResponse, 404);\n }\n \n return c.json({\n success: true,\n data: exam\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch exam\"\n } as ApiResponse, 500);\n }\n});\n\n// Get study materials for an exam\nexams.get(\"/:type/materials\", async (c) => {\n try {\n const examType = c.req.param(\"type\") as ExamType;\n const subject = c.req.query(\"subject\");\n \n let materials;\n if (subject) {\n materials = await getMaterialsBySubject(examType, subject);\n } else {\n materials = await getMaterialsByExamType(examType);\n }\n \n return c.json({\n success: true,\n data: materials\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch materials\"\n } as ApiResponse, 500);\n }\n});\n\n// Get exam subjects\nexams.get(\"/:type/subjects\", async (c) => {\n try {\n const examType = c.req.param(\"type\") as ExamType;\n const exam = await getExamByType(examType);\n \n if (!exam) {\n return c.json({\n success: false,\n error: \"Exam not found\"\n } as ApiResponse, 404);\n }\n \n return c.json({\n success: true,\n data: exam.subjects\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch subjects\"\n } as ApiResponse, 500);\n }\n});\n\nexport default exams;",[],[144,311,329],"97edd290-3c7a-11f0-8f06-9e149126039e","bookmarks.ts","97edd40c-3c7a-11f0-8f06-9e149126039e",10,["D",1748515768105],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ExamType, ApiResponse, Bookmark } from \"../../shared/types.ts\";\nimport { \n createBookmark, \n getUserBookmarks, \n deleteBookmark \n} from \"../database/queries.ts\";\n\nconst bookmarks = new Hono();\n\n// Get user bookmarks\nbookmarks.get(\"/:userId\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const examType = c.req.query(\"examType\") as ExamType | undefined;\n const type = c.req.query(\"type\");\n \n let userBookmarks = await getUserBookmarks(userId, examType);\n \n // Filter by bookmark type if specified\n if (type) {\n userBookmarks = userBookmarks.filter(bookmark => bookmark.type === type);\n }\n \n return c.json({\n success: true,\n data: userBookmarks\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch bookmarks\"\n } as ApiResponse, 500);\n }\n});\n\n// Create new bookmark\nbookmarks.post(\"/:userId\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const bookmarkData = await c.req.json();\n \n const newBookmark: Omit = {\n userId,\n type: bookmarkData.type,\n resourceId: bookmarkData.resourceId,\n title: bookmarkData.title,\n description: bookmarkData.description,\n url: bookmarkData.url,\n tags: bookmarkData.tags || [],\n createdAt: new Date().toISOString(),\n examType: bookmarkData.examType\n };\n \n const bookmarkId = await createBookmark(newBookmark);\n \n return c.json({\n success: true,\n data: { id: bookmarkId, ...newBookmark },\n message: \"Bookmark created successfully\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to create bookmark\"\n } as ApiResponse, 500);\n }\n});\n\n// Delete bookmark\nbookmarks.delete(\"/:userId/:bookmarkId\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const bookmarkId = c.req.param(\"bookmarkId\");\n \n await deleteBookmark(bookmarkId, userId);\n \n return c.json({\n success: true,\n message: \"Bookmark deleted successfully\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to delete bookmark\"\n } as ApiResponse, 500);\n }\n});\n\n// Get bookmarks by tags\nbookmarks.get(\"/:userId/tags/:tag\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const tag = c.req.param(\"tag\");\n const examType = c.req.query(\"examType\") as ExamType | undefined;\n \n const allBookmarks = await getUserBookmarks(userId, examType);\n const filteredBookmarks = allBookmarks.filter(bookmark => \n bookmark.tags.includes(tag)\n );\n \n return c.json({\n success: true,\n data: filteredBookmarks\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch bookmarks by tag\"\n } as ApiResponse, 500);\n }\n});\n\n// Search bookmarks\nbookmarks.get(\"/:userId/search\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n const query = c.req.query(\"q\")?.toLowerCase();\n const examType = c.req.query(\"examType\") as ExamType | undefined;\n \n if (!query) {\n return c.json({\n success: false,\n error: \"Search query is required\"\n } as ApiResponse, 400);\n }\n \n const allBookmarks = await getUserBookmarks(userId, examType);\n const searchResults = allBookmarks.filter(bookmark => \n bookmark.title.toLowerCase().includes(query) ||\n (bookmark.description && bookmark.description.toLowerCase().includes(query)) ||\n bookmark.tags.some(tag => tag.toLowerCase().includes(query))\n );\n \n return c.json({\n success: true,\n data: searchResults\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to search bookmarks\"\n } as ApiResponse, 500);\n }\n});\n\n// Get bookmark statistics\nbookmarks.get(\"/:userId/stats\", async (c) => {\n try {\n const userId = c.req.param(\"userId\");\n \n const allBookmarks = await getUserBookmarks(userId);\n \n const stats = {\n total: allBookmarks.length,\n byType: allBookmarks.reduce((acc, bookmark) => {\n acc[bookmark.type] = (acc[bookmark.type] || 0) + 1;\n return acc;\n }, {} as Record),\n byExam: allBookmarks.reduce((acc, bookmark) => {\n if (bookmark.examType) {\n acc[bookmark.examType] = (acc[bookmark.examType] || 0) + 1;\n }\n return acc;\n }, {} as Record),\n recentlyAdded: allBookmarks\n .sort((a, b) => new Date(b.createdAt).getTime() - new Date(a.createdAt).getTime())\n .slice(0, 5)\n };\n \n return c.json({\n success: true,\n data: stats\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch bookmark statistics\"\n } as ApiResponse, 500);\n }\n});\n\nexport default bookmarks;",[],[144,311,337],"71cb3b52-3c7a-11f0-bbd0-9e149126039e",["D",1748515704125],[164,165,166,167,168],[144,311],"69f16384-3c7a-11f0-b173-9e149126039e","queries.ts","69f16438-3c7a-11f0-b173-9e149126039e","f7e4a4f5-6c40-4cf5-9d91-3f10192eebb9",6,["D",1748515690953],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n Exam, \n StudyMaterial, \n Roadmap, \n UserProgress, \n TestScore, \n Bookmark, \n User,\n ExamType \n} from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute(`\n INSERT INTO users_v1 (id, name, email, target_exams, created_at, last_login)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [id, user.name, user.email, JSON.stringify(user.targetExams), user.createdAt, user.lastLogin]);\n return id;\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM users_v1 WHERE id = ?`, [id]);\n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n email: row.email,\n targetExams: JSON.parse(row.target_exams),\n createdAt: row.created_at,\n lastLogin: row.last_login\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM users_v1 WHERE email = ?`, [email]);\n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n email: row.email,\n targetExams: JSON.parse(row.target_exams),\n createdAt: row.created_at,\n lastLogin: row.last_login\n };\n}\n\n// Exam queries\nexport async function getAllExams(): Promise {\n const result = await sqlite.execute(`SELECT * FROM exams_v1`);\n return result.map(row => ({\n id: row.id,\n type: row.type as ExamType,\n name: row.name,\n description: row.description,\n duration: row.duration,\n subjects: JSON.parse(row.subjects),\n totalMarks: row.total_marks,\n passingMarks: row.passing_marks\n }));\n}\n\nexport async function getExamByType(type: ExamType): Promise {\n const result = await sqlite.execute(`SELECT * FROM exams_v1 WHERE type = ?`, [type]);\n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n type: row.type as ExamType,\n name: row.name,\n description: row.description,\n duration: row.duration,\n subjects: JSON.parse(row.subjects),\n totalMarks: row.total_marks,\n passingMarks: row.passing_marks\n };\n}\n\n// Study material queries\nexport async function getMaterialsByExamType(examType: ExamType): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM study_materials_v1 WHERE exam_type = ? ORDER BY created_at DESC\n `, [examType]);\n \n return result.map(row => ({\n id: row.id,\n examType: row.exam_type as ExamType,\n subject: row.subject,\n title: row.title,\n description: row.description,\n type: row.type as any,\n url: row.url,\n difficulty: row.difficulty as any,\n estimatedTime: row.estimated_time,\n tags: JSON.parse(row.tags),\n createdAt: row.created_at\n }));\n}\n\nexport async function getMaterialsBySubject(examType: ExamType, subject: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM study_materials_v1 WHERE exam_type = ? AND subject = ? ORDER BY difficulty, created_at\n `, [examType, subject]);\n \n return result.map(row => ({\n id: row.id,\n examType: row.exam_type as ExamType,\n subject: row.subject,\n title: row.title,\n description: row.description,\n type: row.type as any,\n url: row.url,\n difficulty: row.difficulty as any,\n estimatedTime: row.estimated_time,\n tags: JSON.parse(row.tags),\n createdAt: row.created_at\n }));\n}\n\nexport async function createStudyMaterial(material: Omit): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute(`\n INSERT INTO study_materials_v1 \n (id, exam_type, subject, title, description, type, url, difficulty, estimated_time, tags, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [id, material.examType, material.subject, material.title, material.description, \n material.type, material.url, material.difficulty, material.estimatedTime, \n JSON.stringify(material.tags), material.createdAt]);\n return id;\n}\n\n// Progress tracking queries\nexport async function getUserProgress(userId: string, examType: ExamType): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM user_progress_v1 WHERE user_id = ? AND exam_type = ?\n `, [userId, examType]);\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n userId: row.user_id,\n examType: row.exam_type as ExamType,\n roadmapId: row.roadmap_id,\n currentPhase: row.current_phase,\n completedMaterials: JSON.parse(row.completed_materials),\n completedMilestones: JSON.parse(row.completed_milestones),\n startDate: row.start_date,\n lastUpdated: row.last_updated,\n progressPercentage: row.progress_percentage\n };\n}\n\nexport async function updateUserProgress(progress: UserProgress): Promise {\n await sqlite.execute(`\n INSERT OR REPLACE INTO user_progress_v1 \n (id, user_id, exam_type, roadmap_id, current_phase, completed_materials, completed_milestones, \n start_date, last_updated, progress_percentage)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [progress.id, progress.userId, progress.examType, progress.roadmapId, progress.currentPhase,\n JSON.stringify(progress.completedMaterials), JSON.stringify(progress.completedMilestones),\n progress.startDate, progress.lastUpdated, progress.progressPercentage]);\n}\n\n// Test scores queries\nexport async function createTestScore(score: Omit): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute(`\n INSERT INTO test_scores_v1 \n (id, user_id, exam_type, subject, test_name, total_marks, scored_marks, percentage, test_date, time_spent, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [id, score.userId, score.examType, score.subject, score.testName, score.totalMarks,\n score.scoredMarks, score.percentage, score.testDate, score.timeSpent, score.notes]);\n return id;\n}\n\nexport async function getUserTestScores(userId: string, examType?: ExamType): Promise {\n let query = `SELECT * FROM test_scores_v1 WHERE user_id = ?`;\n const params = [userId];\n \n if (examType) {\n query += ` AND exam_type = ?`;\n params.push(examType);\n }\n \n query += ` ORDER BY test_date DESC`;\n \n const result = await sqlite.execute(query, params);\n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n examType: row.exam_type as ExamType,\n subject: row.subject,\n testName: row.test_name,\n totalMarks: row.total_marks,\n scoredMarks: row.scored_marks,\n percentage: row.percentage,\n testDate: row.test_date,\n timeSpent: row.time_spent,\n notes: row.notes\n }));\n}\n\n// Bookmark queries\nexport async function createBookmark(bookmark: Omit): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute(`\n INSERT INTO bookmarks_v1 \n (id, user_id, type, resource_id, title, description, url, tags, created_at, exam_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [id, bookmark.userId, bookmark.type, bookmark.resourceId, bookmark.title,\n bookmark.description, bookmark.url, JSON.stringify(bookmark.tags), \n bookmark.createdAt, bookmark.examType]);\n return id;\n}\n\nexport async function getUserBookmarks(userId: string, examType?: ExamType): Promise {\n let query = `SELECT * FROM bookmarks_v1 WHERE user_id = ?`;\n const params = [userId];\n \n if (examType) {\n query += ` AND exam_type = ?`;\n params.push(examType);\n }\n \n query += ` ORDER BY created_at DESC`;\n \n const result = await sqlite.execute(query, params);\n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n type: row.type as any,\n resourceId: row.resource_id,\n title: row.title,\n description: row.description,\n url: row.url,\n tags: JSON.parse(row.tags),\n createdAt: row.created_at,\n examType: row.exam_type as ExamType\n }));\n}\n\nexport async function deleteBookmark(id: string, userId: string): Promise {\n await sqlite.execute(`DELETE FROM bookmarks_v1 WHERE id = ? AND user_id = ?`, [id, userId]);\n}",[],[144,357,349],"database","551849e6-3c7a-11f0-b8b7-9e149126039e","migrations.ts","55184a9a-3c7a-11f0-b8b7-9e149126039e",["D",1748515655976],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database schema for Tamil Nadu Exam Preparation App\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users_v1 (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n target_exams TEXT NOT NULL, -- JSON array of exam types\n created_at TEXT NOT NULL,\n last_login TEXT NOT NULL\n )\n `);\n\n // Exams table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS exams_v1 (\n id TEXT PRIMARY KEY,\n type TEXT NOT NULL,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n duration TEXT NOT NULL,\n subjects TEXT NOT NULL, -- JSON array\n total_marks INTEGER NOT NULL,\n passing_marks INTEGER NOT NULL\n )\n `);\n\n // Study materials table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS study_materials_v1 (\n id TEXT PRIMARY KEY,\n exam_type TEXT NOT NULL,\n subject TEXT NOT NULL,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n type TEXT NOT NULL, -- pdf, video, article, book, website\n url TEXT,\n difficulty TEXT NOT NULL, -- beginner, intermediate, advanced\n estimated_time TEXT NOT NULL,\n tags TEXT NOT NULL, -- JSON array\n created_at TEXT NOT NULL\n )\n `);\n\n // Roadmaps table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS roadmaps_v1 (\n id TEXT PRIMARY KEY,\n exam_type TEXT NOT NULL,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n total_duration TEXT NOT NULL,\n phases TEXT NOT NULL, -- JSON array of phases\n prerequisites TEXT NOT NULL -- JSON array\n )\n `);\n\n // User progress table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS user_progress_v1 (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n exam_type TEXT NOT NULL,\n roadmap_id TEXT NOT NULL,\n current_phase INTEGER NOT NULL,\n completed_materials TEXT NOT NULL, -- JSON array\n completed_milestones TEXT NOT NULL, -- JSON array\n start_date TEXT NOT NULL,\n last_updated TEXT NOT NULL,\n progress_percentage REAL NOT NULL,\n FOREIGN KEY (user_id) REFERENCES users_v1(id)\n )\n `);\n\n // Test scores table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS test_scores_v1 (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n exam_type TEXT NOT NULL,\n subject TEXT NOT NULL,\n test_name TEXT NOT NULL,\n total_marks INTEGER NOT NULL,\n scored_marks INTEGER NOT NULL,\n percentage REAL NOT NULL,\n test_date TEXT NOT NULL,\n time_spent INTEGER NOT NULL, -- in minutes\n notes TEXT,\n FOREIGN KEY (user_id) REFERENCES users_v1(id)\n )\n `);\n\n // Bookmarks table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bookmarks_v1 (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n type TEXT NOT NULL, -- material, roadmap, external\n resource_id TEXT,\n title TEXT NOT NULL,\n description TEXT,\n url TEXT,\n tags TEXT NOT NULL, -- JSON array\n created_at TEXT NOT NULL,\n exam_type TEXT,\n FOREIGN KEY (user_id) REFERENCES users_v1(id)\n )\n `);\n\n console.log(\"Database migrations completed successfully!\");\n}\n\n// Seed data for initial setup\nexport async function seedData() {\n console.log(\"Seeding initial data...\");\n\n // Insert exam types\n const exams = [\n {\n id: \"tntet\",\n type: \"TNTET\",\n name: \"Tamil Nadu Teacher Eligibility Test\",\n description: \"Eligibility test for teaching positions in Tamil Nadu schools\",\n duration: \"6 months\",\n subjects: JSON.stringify([\"Child Development & Pedagogy\", \"Language I (Tamil)\", \"Language II (English)\", \"Mathematics\", \"Environmental Studies\"]),\n total_marks: 150,\n passing_marks: 90\n },\n {\n id: \"trb\",\n type: \"TRB\",\n name: \"Teachers Recruitment Board\",\n description: \"Recruitment exam for graduate and postgraduate teachers\",\n duration: \"8 months\",\n subjects: JSON.stringify([\"Subject Knowledge\", \"Educational Methodology\", \"General Knowledge\", \"Current Affairs\"]),\n total_marks: 300,\n passing_marks: 180\n },\n {\n id: \"tnpsc_group1\",\n type: \"TNPSC_GROUP1\",\n name: \"TNPSC Group 1 - Combined Civil Services\",\n description: \"Premier civil services examination for administrative positions\",\n duration: \"12 months\",\n subjects: JSON.stringify([\"General Studies\", \"General Tamil\", \"General English\", \"Aptitude & Mental Ability\"]),\n total_marks: 1800,\n passing_marks: 900\n },\n {\n id: \"tnpsc_group2\",\n type: \"TNPSC_GROUP2\",\n name: \"TNPSC Group 2 - Non-Interview Posts\",\n description: \"Examination for various non-interview government positions\",\n duration: \"8 months\",\n subjects: JSON.stringify([\"General Studies\", \"Aptitude & Mental Ability\", \"General Tamil\", \"General English\"]),\n total_marks: 600,\n passing_marks: 300\n },\n {\n id: \"tnpsc_group4\",\n type: \"TNPSC_GROUP4\",\n name: \"TNPSC Group 4 - Services\",\n description: \"Entry-level government service positions\",\n duration: \"6 months\",\n subjects: JSON.stringify([\"General Studies\", \"General Tamil\", \"General English\", \"Aptitude\"]),\n total_marks: 300,\n passing_marks: 150\n }\n ];\n\n for (const exam of exams) {\n await sqlite.execute(`\n INSERT OR IGNORE INTO exams_v1 \n (id, type, name, description, duration, subjects, total_marks, passing_marks)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [exam.id, exam.type, exam.name, exam.description, exam.duration, exam.subjects, exam.total_marks, exam.passing_marks]);\n }\n\n // Insert sample study materials\n const materials = [\n {\n id: \"tntet_cdp_1\",\n exam_type: \"TNTET\",\n subject: \"Child Development & Pedagogy\",\n title: \"Child Psychology Fundamentals\",\n description: \"Basic concepts of child development and learning theories\",\n type: \"article\",\n url: \"https://example.com/cdp-fundamentals\",\n difficulty: \"beginner\",\n estimated_time: \"2 hours\",\n tags: JSON.stringify([\"psychology\", \"development\", \"learning\"]),\n created_at: new Date().toISOString()\n },\n {\n id: \"tnpsc_gs_1\",\n exam_type: \"TNPSC_GROUP1\",\n subject: \"General Studies\",\n title: \"Indian Polity and Constitution\",\n description: \"Comprehensive guide to Indian political system\",\n type: \"pdf\",\n difficulty: \"intermediate\",\n estimated_time: \"10 hours\",\n tags: JSON.stringify([\"polity\", \"constitution\", \"governance\"]),\n created_at: new Date().toISOString()\n }\n ];\n\n for (const material of materials) {\n await sqlite.execute(`\n INSERT OR IGNORE INTO study_materials_v1 \n (id, exam_type, subject, title, description, type, url, difficulty, estimated_time, tags, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [material.id, material.exam_type, material.subject, material.title, material.description, \n material.type, material.url, material.difficulty, material.estimated_time, material.tags, material.created_at]);\n }\n\n console.log(\"Initial data seeded successfully!\");\n}",[],[144,357,359],"55186250-3c7a-11f0-b8b7-9e149126039e",["D",1748515655976],[161,162],[144,357],["D",1748515655976],[160,163,169],[144],["D",1748515475766],{"_11":12,"_84":80},{"_11":12,"_78":-5,"_79":80,"_43":44,"_81":82,"_83":37},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_73":-5,"_74":-5,"_75":-5,"_76":14,"_77":12},"ctx",{"_66":-5,"_106":409,"_410":411,"_412":413,"_414":37,"_415":37,"_416":37,"_417":122,"_418":-5,"_419":-7,"_420":-7,"_421":50,"_422":37,"_423":37,"_424":-5,"_425":37,"_426":37,"_427":37,"_428":-5},"ENV",{"_380":381,"_382":383,"_384":26,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Add Test Score

Average Score

Best Score

Total Tests

Recent Test Scores

Subject-wise Performance

Study Roadmap

Foundation Phase

Intermediate Phase

Advanced Phase

Final Preparation

Select an Exam

Popular Tags

{{ material.title }}

No materials found

Add Study Material

Welcome back, {{ user?.name }}! 👋

Your Target Exams

{{ getExamName(examType) }}

Recent Test Scores

Study Progress

Quick Actions

{{ bookmark.title }}

No bookmarks found

Add Bookmark

📚 TN Exam Prep

Target Exams

{{ getActiveViewTitle() }}

Application Error

Branches1

Branches
1