Val Town Code SearchReturn to Val Town

16```
17├── backend/
18│   ├── database/
19│   │   ├── migrations.ts    # Database schema setup
20│   │   └── queries.ts       # Database query functions
21│   ├── routes/
22│   │   ├── students.ts      # Student CRUD operations
441. The backend API runs on the main HTTP endpoint
452. Frontend is served at the root path
463. All data is stored in SQLite database
474. Real-time updates via API polling
48

21## Further resources
22
23- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a bigger example project, with a SQLite database table, queries, client-side CSS, a favicon, and shared code that runs on both client and server.

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, seedInitialData } from "./database/migrations.ts";
4import menuRoutes from "./routes/menu.ts";
5import ordersRoutes from "./routes/orders.ts";
13});
14
15// Initialize database on startup
16let dbInitialized = false;
17async function initializeDatabase() {
18  if (!dbInitialized) {
19    await runMigrations();
20    await seedInitialData();
21    dbInitialized = true;
22    console.log('Database initialized successfully');
23  }
24}
34    status: "ok", 
35    timestamp: new Date().toISOString(),
36    database: dbInitialized ? "initialized" : "pending"
37  });
38});
44// Admin panel route
45app.get("/admin", async c => {
46  await initializeDatabase();
47  let html = await readFile("/frontend/index.html", import.meta.url);
48  
59// Customer order page
60app.get("/order", async c => {
61  await initializeDatabase();
62  const tableQR = c.req.query("table");
63  
77// Root route - redirect to admin for now
78app.get("/", async c => {
79  await initializeDatabase();
80  return new Response(null, { 
81    status: 302, 

150            <div className="flex items-center">
151              <div className="w-3 h-3 bg-green-500 rounded-full mr-3"></div>
152              <span className="text-sm text-gray-700">Database Connection</span>
153            </div>
154            <span className="text-sm font-medium text-green-600">Active</span>

5  getTableByQRCode, 
6  createTable 
7} from "../database/queries.ts";
8import type { CreateTableRequest } from "../../shared/types.ts";
9

6  updateOrderStatus,
7  getOrdersByStatus 
8} from "../database/queries.ts";
9import type { CreateOrderRequest, UpdateOrderStatusRequest, OrderStatus } from "../../shared/types.ts";
10

6  updateMenuItem, 
7  deleteMenuItem 
8} from "../database/queries.ts";
9import type { CreateMenuItemRequest } from "../../shared/types.ts";
10

1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database table names with versioning for schema changes
4export const TABLES = {
5  MENU_ITEMS: 'canteen_menu_items_v1',
10
11export async function runMigrations() {
12  console.log('Running database migrations...');
13
14  // Create menu_items table
67  `);
68
69  console.log('Database migrations completed');
70}
71

23- **Frontend**: React 18 with TypeScript
24- **Backend**: Hono.js API framework
25- **Database**: SQLite for data persistence
26- **Styling**: TailwindCSS
27- **QR Codes**: QR code generation and scanning
32```
33├── backend/
34│   ├── database/
35│   │   ├── migrations.ts    # Database schema setup
36│   │   └── queries.ts       # Database query functions
37│   ├── routes/
38│   │   ├── admin.ts         # Admin panel routes
54## Getting Started
55
561. The system will automatically set up the database on first run
572. Access the admin panel at `/admin` to set up menu items and tables
583. Generate QR codes for tables from the admin panel
78- `GET /api/tables/:id/qr` - Get QR code for table
79
80## Database Schema
81
82### Tables

1// Authentication middleware for the GYM Management System
2
3import { auth } from "../database/firebase.ts";
4import { userModel } from "../database/models.ts";
5import { logger } from "../utils/logger.ts";
6import { UserRole } from "../../shared/types.ts";
54}
55
56// Get user data from database
57async function getUserData(uid: string): Promise<AuthenticatedUser | null> {
58  try {
59    const user = await userModel.findById(uid);
60    if (!user) {
61      logger.warn(`User not found in database: ${uid}`);
62      return null;
63    }
102    const decodedToken = await verifyFirebaseToken(token);
103    
104    // Get user data from database
105    const userData = await getUserData(decodedToken.uid);
106    
107    if (!userData) {
108      logger.security('User not found in database', { 
109        uid: decodedToken.uid,
110        path: c.req.path,