Backend - Pastry Shop API

This directory contains the server-side logic for the pastry ordering system.

• index.ts - Main Hono application with routes and static file serving
• routes/orders.ts - Order management API endpoints
• database/ - Database setup and query functions

• POST /api/orders - Create a new order
• GET /api/orders - Get all orders (for admin)
• PATCH /api/orders/:id/status - Update order status

• GET / - Main customer ordering page
• GET /admin - Order management interface

Uses SQLite with the following table:

pastry_orders_v1 (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  customer_name TEXT NOT NULL,
  customer_email TEXT NOT NULL,
  customer_phone TEXT NOT NULL,
  customer_address TEXT,
  pickup_time TEXT NOT NULL,
  special_instructions TEXT,
  items TEXT NOT NULL, -- JSON array of cart items
  total REAL NOT NULL,
  status TEXT DEFAULT 'pending',
  created_at TEXT NOT NULL
)

1. pending - Order just placed
2. confirmed - Order confirmed by bakery
3. ready - Order ready for pickup
4. completed - Order picked up by customer

• Input validation for all API endpoints
• Proper HTTP status codes
• Detailed error messages for debugging