198```
199โโโ backend/
200โ โโโ database/
201โ โ โโโ migrations.ts # Schema definitions
202โ โ โโโ queries.ts # DB query functions
257 ```
258
259### Database Patterns
260- Run migrations on startup or comment out for performance
261- Change table names when modifying schemas rather than altering
3// Import route modules
4import cobrowse from "./cobrowse.ts";
5import database from "./database.ts";
6import demo from "./demo.ts";
7import page from "./page.ts";
12
13// mount routes
14app.route("/db", database);
15app.route("/page", page);
16app.route("/cobrowse", cobrowse);
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations, seedData } from "./database/migrations.ts";
3import examsRoutes from "./routes/exams.ts";
4import progressRoutes from "./routes/progress.ts";
15});
16
17// Initialize database on startup
18let dbInitialized = false;
19async function initializeDatabase() {
20 if (!dbInitialized) {
21 console.log("Initializing database...");
22 await runMigrations();
23 await seedData();
24 dbInitialized = true;
25 console.log("Database initialized successfully!");
26 }
27}
28
29// Middleware to ensure database is initialized
30app.use("*", async (c, next) => {
31 await initializeDatabase();
32 await next();
33});
5 getUserBookmarks,
6 deleteBookmark
7} from "../database/queries.ts";
8
9const bookmarks = new Hono();
5 getMaterialsBySubject,
6 createStudyMaterial
7} from "../database/queries.ts";
8
9const materials = new Hono();
6 createTestScore,
7 getUserTestScores
8} from "../database/queries.ts";
9
10const progress = new Hono();
6 getMaterialsByExamType,
7 getMaterialsBySubject
8} from "../database/queries.ts";
9
10const exams = new Hono();
1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema for Tamil Nadu Exam Preparation App
4export async function runMigrations() {
5 console.log("Running database migrations...");
6
7 // Users table
113 `);
114
115 console.log("Database migrations completed successfully!");
116}
117
24```
25โโโ backend/
26โ โโโ database/
27โ โ โโโ migrations.ts # Database schema
28โ โ โโโ queries.ts # Database operations
29โ โโโ routes/
30โ โ โโโ exams.ts # Exam-related endpoints
60## Technology Stack
61
62- **Backend**: Hono.js with SQLite database
63- **Frontend**: Angular with TypeScript
64- **Styling**: TailwindCSS
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllItems, addItem } from "../database/queries.ts";
3import type { Item, ApiResponse } from "../../shared/types.ts";
4