[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_340":341,"_342":343},"routes/_app.x.$handle.$name",{"_100":99,"_32":51,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",17,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components/app.component.ts","latestPath","fileId","f2cf0eae-3c7a-11f0-9054-9e149126039e","name","app.component.ts","fileType","script","content","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}","createdAt",["D",1748515920576],"branchVersion","branchId","e9ae1a3c-3c79-11f0-8429-9e149126039e",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"frontend/components","3959b96d-2b4a-4185-8376-86d948dab85d","components","directory",["D",1748515920576],"id","e9addfb8-3c79-11f0-8429-9e149126039e","StudyPlanner",["D",1748515475766],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","b8229970-3c79-11f0-8f77-839c97346035","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","83dd4af6-77aa-4df2-8d2b-8580bed66f98","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_49":42,"_91":50,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":51,"_98":99},"isOwned",22,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","angayarb","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeGxiMFQzdnRtRjVYV0lrdXFLNWluWHNKOWkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":336,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":337,"_84":338,"_86":339,"_88":25},"tree",[174,185,193,195],"files",[174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195],"counts",{"_163":66,"_164":165,"_166":66,"_167":168,"_169":170},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":157,"_32":158,"_30":159,"_137":-5,"_41":42,"_40":160,"_139":140,"_38":161,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":162},{"_49":151,"_32":152,"_30":153,"_137":-5,"_41":42,"_40":154,"_139":140,"_38":155,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":156},{"_49":146,"_32":147,"_30":148,"_137":-5,"_41":42,"_40":142,"_139":140,"_38":149,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":150},{"_49":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":140,"_38":141,"_13":142,"_34":21,"_36":143,"_24":25,"_144":-5,"_27":145},"433e5864-3c7a-11f0-8b7c-9e149126039e","README.md","255ada48-3c7a-11f0-8e51-9e149126039e","parentId",4,"latest",true,["D",1748515626026],2,"# Tamil Nadu Exam Preparation App\n\nA comprehensive exam preparation platform for Tamil Nadu competitive exams including TNTET, TRB, TNPSC Group 1, Group 2, and Group 4.\n\n## Features\n\n- **Roadmaps**: Structured study plans for each exam type\n- **Materials**: Curated study materials and resources\n- **Progress Tracker**: Track your preparation progress\n- **Actual Marks**: Record and analyze your test scores\n- **Bookmarks**: Save important resources and notes\n- **Mock Tests**: Practice with exam-like questions\n\n## Exam Types Supported\n\n- **TNTET** (Tamil Nadu Teacher Eligibility Test)\n- **TRB** (Teachers Recruitment Board)\n- **TNPSC Group 1** (Combined Civil Services Examination)\n- **TNPSC Group 2** (Non-Interview Posts)\n- **TNPSC Group 4** (Services)\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── exams.ts # Exam-related endpoints\n│ │ ├── progress.ts # Progress tracking\n│ │ ├── materials.ts # Study materials\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main server entry point\n├── frontend/\n│ ├── components/\n│ │ ├── app.component.ts # Main application component\n│ │ ├── dashboard.component.ts # User dashboard\n│ │ ├── roadmap.component.ts # Study roadmaps\n│ │ ├── materials.component.ts # Study materials\n│ │ ├── tracker.component.ts # Progress tracking\n│ │ └── bookmarks.component.ts # Saved resources\n│ ├── services/\n│ │ ├── exam.service.ts # Exam data service\n│ │ ├── progress.service.ts # Progress tracking service\n│ │ └── api.service.ts # HTTP client service\n│ ├── index.html # Main HTML template\n│ └── main.ts # Angular bootstrap\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The application runs on Val Town\n2. Access the main interface at the root URL\n3. Navigate through different sections using the sidebar\n4. Track your progress and bookmark important resources\n\n## Technology Stack\n\n- **Backend**: Hono.js with SQLite database\n- **Frontend**: Angular with TypeScript\n- **Styling**: TailwindCSS\n- **Storage**: SQLite for user data and progress tracking","label",[135],"2e05362a-3c7a-11f0-9927-9e149126039e","shared","5df56e9d-e3f2-4fe7-b28b-44e63eced28e",["D",1748515590420],[147],"b14eebfc-3c7a-11f0-98eb-9e149126039e","frontend","9ab29de0-4819-41c1-a243-11d55b9c0daa",13,["D",1748515810683],[152],"551860ac-3c7a-11f0-b8b7-9e149126039e","backend","f9132113-a825-4e95-b4fe-c85627bc2073",5,["D",1748515655976],[158],"pulls","branches",1,"forks","envVars",{"_171":66,"_173":66},"connections",{"_171":66,"_172":66},"count","unfilledCount","emptyCount",{"_49":157,"_32":158,"_30":159,"_137":-5,"_41":42,"_40":160,"_139":140,"_38":333,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":334,"_27":335},{"_49":329,"_32":321,"_30":315,"_137":159,"_41":42,"_40":160,"_139":140,"_38":330,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":331,"_27":332},{"_49":322,"_32":323,"_30":324,"_137":315,"_41":42,"_40":160,"_139":140,"_38":325,"_13":66,"_34":35,"_36":326,"_24":25,"_144":-5,"_197":327,"_27":328},{"_49":312,"_32":313,"_30":314,"_137":315,"_41":42,"_40":316,"_139":140,"_38":317,"_13":66,"_34":35,"_36":318,"_24":25,"_144":-5,"_197":319,"_27":320},{"_49":308,"_32":275,"_30":269,"_137":159,"_41":42,"_40":295,"_139":140,"_38":309,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":310,"_27":311},{"_49":300,"_32":301,"_30":302,"_137":269,"_41":42,"_40":303,"_139":140,"_38":304,"_13":66,"_34":35,"_36":305,"_24":25,"_144":-5,"_197":306,"_27":307},{"_49":292,"_32":293,"_30":294,"_137":269,"_41":42,"_40":295,"_139":140,"_38":296,"_13":66,"_34":35,"_36":297,"_24":25,"_144":-5,"_197":298,"_27":299},{"_49":284,"_32":285,"_30":286,"_137":269,"_41":42,"_40":287,"_139":140,"_38":288,"_13":66,"_34":35,"_36":289,"_24":25,"_144":-5,"_197":290,"_27":291},{"_49":276,"_32":277,"_30":278,"_137":269,"_41":42,"_40":279,"_139":140,"_38":280,"_13":66,"_34":35,"_36":281,"_24":25,"_144":-5,"_197":282,"_27":283},{"_49":266,"_32":267,"_30":268,"_137":269,"_41":42,"_40":270,"_139":140,"_38":271,"_13":66,"_34":35,"_36":272,"_24":25,"_144":-5,"_197":273,"_27":274},{"_49":258,"_32":259,"_30":260,"_137":159,"_41":42,"_40":261,"_139":140,"_38":262,"_13":66,"_34":35,"_36":263,"_24":25,"_144":-5,"_197":264,"_27":265},{"_49":151,"_32":152,"_30":153,"_137":-5,"_41":42,"_40":154,"_139":140,"_38":255,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":256,"_27":257},{"_49":251,"_32":46,"_30":45,"_137":153,"_41":42,"_40":14,"_139":140,"_38":252,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":253,"_27":254},{"_49":247,"_32":33,"_30":31,"_137":45,"_41":42,"_40":14,"_139":140,"_38":248,"_13":66,"_34":35,"_36":37,"_24":25,"_144":-5,"_197":249,"_27":250},{"_49":243,"_32":226,"_30":220,"_137":153,"_41":42,"_40":238,"_139":140,"_38":244,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":245,"_27":246},{"_49":235,"_32":236,"_30":237,"_137":220,"_41":42,"_40":238,"_139":140,"_38":239,"_13":66,"_34":35,"_36":240,"_24":25,"_144":-5,"_197":241,"_27":242},{"_49":227,"_32":228,"_30":229,"_137":220,"_41":42,"_40":230,"_139":140,"_38":231,"_13":66,"_34":35,"_36":232,"_24":25,"_144":-5,"_197":233,"_27":234},{"_49":217,"_32":218,"_30":219,"_137":220,"_41":42,"_40":221,"_139":140,"_38":222,"_13":66,"_34":35,"_36":223,"_24":25,"_144":-5,"_197":224,"_27":225},{"_49":210,"_32":211,"_30":212,"_137":153,"_41":42,"_40":154,"_139":140,"_38":213,"_13":66,"_34":21,"_36":214,"_24":25,"_144":-5,"_197":215,"_27":216},{"_49":146,"_32":147,"_30":148,"_137":-5,"_41":42,"_40":142,"_139":140,"_38":207,"_13":66,"_34":47,"_36":-5,"_24":25,"_144":-5,"_197":208,"_27":209},{"_49":200,"_32":201,"_30":202,"_137":148,"_41":42,"_40":142,"_139":140,"_38":203,"_13":66,"_34":35,"_36":204,"_24":25,"_144":-5,"_197":205,"_27":206},{"_49":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":140,"_38":196,"_13":142,"_34":21,"_36":143,"_24":25,"_144":-5,"_197":198,"_27":199},["D",1748515626026],"children",[],[135],"2e052946-3c7a-11f0-9927-9e149126039e","types.ts","2e052a18-3c7a-11f0-9927-9e149126039e",["D",1748515590420],"// Shared types for the exam preparation app\n\nexport type ExamType = 'TNTET' | 'TRB' | 'TNPSC_GROUP1' | 'TNPSC_GROUP2' | 'TNPSC_GROUP4';\n\nexport interface Exam {\n id: string;\n type: ExamType;\n name: string;\n description: string;\n duration: string; // e.g., \"6 months\"\n subjects: string[];\n totalMarks: number;\n passingMarks: number;\n}\n\nexport interface StudyMaterial {\n id: string;\n examType: ExamType;\n subject: string;\n title: string;\n description: string;\n type: 'pdf' | 'video' | 'article' | 'book' | 'website';\n url?: string;\n difficulty: 'beginner' | 'intermediate' | 'advanced';\n estimatedTime: string; // e.g., \"2 hours\"\n tags: string[];\n createdAt: string;\n}\n\nexport interface RoadmapPhase {\n id: string;\n phase: number;\n title: string;\n description: string;\n duration: string;\n subjects: string[];\n materials: string[]; // material IDs\n milestones: string[];\n}\n\nexport interface Roadmap {\n id: string;\n examType: ExamType;\n title: string;\n description: string;\n totalDuration: string;\n phases: RoadmapPhase[];\n prerequisites: string[];\n}\n\nexport interface UserProgress {\n id: string;\n userId: string;\n examType: ExamType;\n roadmapId: string;\n currentPhase: number;\n completedMaterials: string[];\n completedMilestones: string[];\n startDate: string;\n lastUpdated: string;\n progressPercentage: number;\n}\n\nexport interface TestScore {\n id: string;\n userId: string;\n examType: ExamType;\n subject: string;\n testName: string;\n totalMarks: number;\n scoredMarks: number;\n percentage: number;\n testDate: string;\n timeSpent: number; // in minutes\n notes?: string;\n}\n\nexport interface Bookmark {\n id: string;\n userId: string;\n type: 'material' | 'roadmap' | 'external';\n resourceId?: string;\n title: string;\n description?: string;\n url?: string;\n tags: string[];\n createdAt: string;\n examType?: ExamType;\n}\n\nexport interface User {\n id: string;\n name: string;\n email: string;\n targetExams: ExamType[];\n createdAt: string;\n lastLogin: string;\n}\n\n// API Response types\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n message?: string;\n}\n\n// Dashboard data\nexport interface DashboardData {\n user: User;\n activeExams: ExamType[];\n recentProgress: UserProgress[];\n upcomingMilestones: string[];\n recentScores: TestScore[];\n bookmarkCount: number;\n totalStudyTime: number; // in hours\n}",[],[147,201],["D",1748515590420],[194],[147],"b14eca96-3c7a-11f0-98eb-9e149126039e","index.html","b14ecb4a-3c7a-11f0-98eb-9e149126039e",["D",1748515810683],"\n\n\n \n \n Tamil Nadu Exam Preparation\n \n \n 📚\">\n \n\n\n

\n \n

Loading Tamil Nadu Exam Preparation App...

\n\n \n \n \n \n\n",[],[152,211],"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}",[],[152,226,218],"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}",[],[152,226,228],"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}",[],[152,226,236],"be377276-3c7a-11f0-a3d0-9e149126039e",["D",1748515832341],[189,190,191],[152,226],"f2cf0dd2-3c7a-11f0-9054-9e149126039e",["D",1748515920576],[],[152,46,33],"f2cf4310-3c7a-11f0-9054-9e149126039e",["D",1748515920576],[187],[152,46],["D",1748515810683],[186,188,192],[152],"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;",[],[158,259],"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;",[],[158,275,267],"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;",[],[158,275,277],"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;",[],[158,275,285],"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;",[],[158,275,293],"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;",[],[158,275,301],"71cb3b52-3c7a-11f0-bbd0-9e149126039e",["D",1748515704125],[179,180,181,182,183],[158,275],"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}",[],[158,321,313],"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}",[],[158,321,323],"55186250-3c7a-11f0-b8b7-9e149126039e",["D",1748515655976],[176,177],[158,321],["D",1748515655976],[175,178,184],[158],["D",1748515475766],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},{"_13":89,"_32":90,"_49":42,"_91":50,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":51,"_98":99},"ctx",{"_82":-5,"_127":373,"_374":375,"_376":377,"_378":25,"_379":25,"_380":25,"_381":140,"_382":-5,"_383":-7,"_384":-7,"_385":66,"_386":25,"_387":25,"_388":-5,"_389":25,"_390":25,"_391":25,"_392":-5},"ENV",{"_344":345,"_346":347,"_348":90,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372},"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"]

Diff · v17