1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema setup for the tutoring platform
4export async function runMigrations() {
5 console.log("Running database migrations...");
6
7 // Users table
129 `);
130
131 console.log("Database migrations completed successfully!");
132}
15```
16โโโ backend/
17โ โโโ database/
18โ โ โโโ migrations.ts # Database schema setup
19โ โ โโโ queries.ts # Database query functions
20โ โโโ routes/
21โ โ โโโ auth.ts # Authentication routes
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations, seedProducts } from "./database/migrations.ts";
4import { getAllProducts } from "./database/queries.ts";
5import products from "./routes/products.ts";
6import cart from "./routes/cart.ts";
16});
17
18// Initialize database
19await runMigrations();
20await seedProducts();
6 getCartItems,
7 clearCart
8} from "../database/queries.ts";
9
10const orders = new Hono();
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { saveContactMessage } from "../database/queries.ts";
3
4const contact = new Hono();
7 removeFromCart,
8 clearCart
9} from "../database/queries.ts";
10
11const cart = new Hono();
5 getProductsByCategory,
6 searchProducts
7} from "../database/queries.ts";
8import { SHOE_CATEGORIES } from "../../shared/types.ts";
9
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getCookie, setCookie, deleteCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import { createUser, getUserByEmail, verifyUserPassword } from "../database/queries.ts";
4
5const auth = new Hono();
8 getAttendanceReport,
9 getAllStudents
10} from "../database/queries.ts";
11import { formatDate, getTodayDate } from "../../shared/utils.ts";
12
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations } from "./database/migrations.ts";
4import jobs from "./routes/jobs.ts";
5import chat from "./routes/chat.ts";
12});
13
14// Initialize database
15await runMigrations();
16