django.md

Restaurants: inventory manager using Django

Summary

A inventory manager blueprint for restaurants built with Django on Ample. Domain schema: menu_items (sku, name, section, price, allergens, active): the menu as a SKU catalog; stock_movements (sku, delta, reason, moved_at): ingredient and prepared-item stock; orders (order_no, service_type, status, placed_at): dine-in, pickup and delivery orders; order_lines (order_no, sku, qty, modifiers): order contents; events (seq, record_type, record_id, kind, at): application-owned history written in the same transaction. Public information: menu with allergens and prices, locations, hours and reservations contact, catering information. Allergen information must be kept accurate by the operator; nothing here validates food-safety claims. Technical basis verified on Django: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected).

Infrastructure requirements

Prerequisites

Exact tested configuration

Steps

  1. Model the restaurants domain. Create the tables menu_items, stock_movements, orders, order_lines, events. The menu as a sku catalog lives in menu_items; keep the sensitive classes (customer contact and payment details, staff schedules) out of this schema.

  2. Workflow step 1. Model SKUs and stock movements; derive stock from movements.

  3. Workflow step 2. Apply movements transactionally with an optimistic version check on the SKU.

  4. Workflow step 3. Record an event per movement for history.

  5. Workflow step 4. Deploy and verify history and rejected stale updates.

  6. Deploy. Run the synchronous deploy once and read the result. Re-running with no change is a no-op.

    ample deploy . --name <app-name> --public --start "python3 run.py" --env S3_ENDPOINT=... --env S3_REGION=... --env S3_BUCKET=... --env S3_ACCESS_KEY_ID=... --env S3_SECRET_ACCESS_KEY=...
    
  7. Verify. Run the pattern self-test(s) from the example (/p/transactional-workflows) and your own acceptance checks for the restaurants workflow.

    ample logs <deployment_id> --kind build
    

Tested examples

Success checks

Limitations

Cost estimate

Estimated 10.00 USD per month (size prices from pricing.toml at build revision a1b8c38919e59cd035ebabaced73cf84ece24371).

Always-on monthly price of the tested sizes; apps and databases auto-pause when idle. Buckets are allocation-priced per quota and not included.

Verification evidence

Last verified: 2026-09-20T03:31:44Z

Execution binding

MCP tool ample_deploy (registry mcp:ample_deploy), schema hash 876465fce906da0c observed 2026-09-21T03:19:59.461917+00:00 at revision 49962bcade4f, binding state current, required scopes: servers:write, databases:read, buckets:read.