Val Town Code SearchReturn to Val Town

45  `);
46
47  console.log('Database migrations completed');
48}
49
206  }
207
208  console.log('Database seeded with sample data');
209}
210

13```
14├── backend/
15│   ├── database/
16│   │   ├── migrations.ts    # Database schema setup
17│   │   └── queries.ts       # Database query functions
18│   ├── routes/
19│   │   ├── jobs.ts         # Job posting API routes
43- `POST /api/chat/messages` - Send a new chat message
44
45## Database Schema
46
47### Jobs Table

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();