[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"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",7,"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","backend/routes/exams.ts","latestPath","fileId","71cb1f96-3c7a-11f0-bbd0-9e149126039e","name","exams.ts","fileType","script","content","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;","createdAt",["D",1748515704125],"branchVersion","branchId","e9ae1a3c-3c79-11f0-8429-9e149126039e",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"backend/routes","26284929-71f1-41cb-b58f-804bbf62ce21","routes","directory",["D",1748515704125],"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":222,"_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":223,"_84":224,"_86":225,"_88":25},"tree",[167,173,175],"files",[167,168,169,170,171,172,173,174,175],"counts",{"_156":66,"_157":158,"_159":66,"_160":161,"_162":163},"contents",[130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":150,"_32":151,"_30":152,"_136":-5,"_41":42,"_40":153,"_138":139,"_38":154,"_13":66,"_34":47,"_36":-5,"_24":25,"_143":-5,"_27":155},{"_49":145,"_32":146,"_30":147,"_136":-5,"_41":42,"_40":141,"_138":139,"_38":148,"_13":66,"_34":47,"_36":-5,"_24":25,"_143":-5,"_27":149},{"_49":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":139,"_38":140,"_13":141,"_34":21,"_36":142,"_24":25,"_143":-5,"_27":144},"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",[134],"2e05362a-3c7a-11f0-9927-9e149126039e","shared","5df56e9d-e3f2-4fe7-b28b-44e63eced28e",["D",1748515590420],[146],"551860ac-3c7a-11f0-b8b7-9e149126039e","backend","f9132113-a825-4e95-b4fe-c85627bc2073",5,["D",1748515655976],[151],"pulls","branches",1,"forks","envVars",{"_164":66,"_166":66},"connections",{"_164":66,"_165":66},"count","unfilledCount","emptyCount",{"_49":150,"_32":151,"_30":152,"_136":-5,"_41":42,"_40":153,"_138":139,"_38":219,"_13":66,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":220,"_27":221},{"_49":215,"_32":207,"_30":201,"_136":152,"_41":42,"_40":153,"_138":139,"_38":216,"_13":66,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":217,"_27":218},{"_49":208,"_32":209,"_30":210,"_136":201,"_41":42,"_40":153,"_138":139,"_38":211,"_13":66,"_34":35,"_36":212,"_24":25,"_143":-5,"_177":213,"_27":214},{"_49":198,"_32":199,"_30":200,"_136":201,"_41":42,"_40":202,"_138":139,"_38":203,"_13":66,"_34":35,"_36":204,"_24":25,"_143":-5,"_177":205,"_27":206},{"_49":194,"_32":46,"_30":45,"_136":152,"_41":42,"_40":14,"_138":139,"_38":195,"_13":66,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":196,"_27":197},{"_49":190,"_32":33,"_30":31,"_136":45,"_41":42,"_40":14,"_138":139,"_38":191,"_13":66,"_34":35,"_36":37,"_24":25,"_143":-5,"_177":192,"_27":193},{"_49":145,"_32":146,"_30":147,"_136":-5,"_41":42,"_40":141,"_138":139,"_38":187,"_13":66,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":188,"_27":189},{"_49":180,"_32":181,"_30":182,"_136":147,"_41":42,"_40":141,"_138":139,"_38":183,"_13":66,"_34":35,"_36":184,"_24":25,"_143":-5,"_177":185,"_27":186},{"_49":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":139,"_38":176,"_13":141,"_34":21,"_36":142,"_24":25,"_143":-5,"_177":178,"_27":179},["D",1748515626026],"children",[],[134],"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}",[],[146,181],["D",1748515590420],[174],[146],"71cb1f00-3c7a-11f0-bbd0-9e149126039e",["D",1748515704125],[],[151,46,33],"71cb3b52-3c7a-11f0-bbd0-9e149126039e",["D",1748515704125],[172],[151,46],"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}",[],[151,207,199],"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}",[],[151,207,209],"55186250-3c7a-11f0-b8b7-9e149126039e",["D",1748515655976],[169,170],[151,207],["D",1748515655976],[168,171],[151],["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":259,"_260":261,"_262":263,"_264":25,"_265":25,"_266":25,"_267":139,"_268":-5,"_269":-7,"_270":-7,"_271":66,"_272":25,"_273":25,"_274":-5,"_275":25,"_276":25,"_277":25,"_278":-5},"ENV",{"_230":231,"_232":233,"_234":90,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258},"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 · v7