Dish Storage with SQLite

This module provides SQLite storage for the Dish type using Valtown's SQLite functionality.

The dishes table has the following schema:

CREATE TABLE dishes (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  components TEXT NOT NULL
);

• id: Unique identifier for the dish (UUID)
• name: Name of the dish
• components: JSON string containing an array of component objects with id and name fields

The migration runs automatically when the module is imported. It creates the table if it doesn't exist.

• POST /api/dishes - Create or update a dish
• GET /api/dishes - Get all dishes
• GET /api/dishes/:id - Get a specific dish by ID
• DELETE /api/dishes/:id - Delete a dish by ID

{
  id: "123e4567-e89b-12d3-a456-426614174000",
  name: "Caesar Salad",
  components: [
    { id: "comp-1", name: "Romaine Lettuce" },
    { id: "comp-2", name: "Parmesan Cheese" },
    { id: "comp-3", name: "Croutons" }
  ]
}

• storeDish(dish: Dish) - Store a single dish
• storeDishes(dishes: Dish[]) - Bulk store multiple dishes
• getDish(id: UUID) - Retrieve a dish by ID
• getDishes(ids: UUID[]) - Bulk retrieve dishes by IDs
• getAllDishes() - Get all stored dishes
• deleteDish(id: UUID) - Delete a dish by ID
• deleteDishes(ids: UUID[]) - Bulk delete dishes by IDs
• dishesExist(ids: UUID[]) - Check if dishes exist by IDs

Components are stored as JSON strings in the database. This allows for flexible component structures while maintaining the relational database benefits for the main dish data.