django.md

Construction contractors: public directory using Django

Summary

A public directory blueprint for construction contractors built with Django on Ample. Domain schema: listings (reference, project_type, location, publishing_status, agency_id): showcase projects with publishing status; agencies (name, license_number, service_region): branches or divisions; vendors (name, trade, agency_id, prequalified): subcontractors and suppliers per branch; reports (agency_id, period, object_key, generated_at): branch progress reports; state_transitions (record_type, from_state, to_state): the allowed state machine. Public information: published project showcases, services and regions, licenses and insurance summary. Kept out of scope until handling is reviewed: site safety incidents, bid pricing, client contracts. Safety and bid data are confidential; only published showcases and branch reporting are modeled. Technical basis verified on Django: a workspace-scoped table, an explicit state machine (draft to review to published) that rejects invalid transitions, and a cross-workspace read that returns nothing (transitions=true isolation=true).

Infrastructure requirements

Prerequisites

Exact tested configuration

Steps

  1. Model the construction contractors domain. Create the tables listings, agencies, vendors, reports, state_transitions. Showcase projects with publishing status lives in listings; keep the sensitive classes (site safety incidents, bid pricing, client contracts) out of this schema.
  2. Workflow step 1. Model listings with a publishing_status state machine scoped to the agency
  3. Workflow step 2. Serve only published listings, with media from the CDN bucket
  4. Workflow step 3. Enforce the agency scope on every query
  5. Workflow step 4. Deploy and verify a published listing and that unpublished listings are absent
  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=... --env CDN_PUBLIC_URL=...
  1. Verify. Run the pattern self-test(s) from the example (/p/relational-records) and your own acceptance checks for the construction contractors 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.