Implementing CRUD#

🔥 Hot Tips

• Attach CRUD to any DatabaseResult from queries or ORM models.
• Use to_crud(request) to auto-register REST routes and render interactive HTML.
• Assumes lightweight ORM support; define models extending a base for select().

Example Usage {#example}#

Define a route to fetch data and generate CRUD:

from tina4_python import get​@get("/users/dashboard")async def dashboard(request, response):    users = User().select("id, name, email")  # ORM query returning DatabaseResult    return response.render("users/dashboard.twig", {"crud": users.to_crud(request)})

Render in Twig template (users/dashboard.twig):

{{ crud }}  {# Outputs full CRUD HTML: table, search, pagination #}

How It Works {#how-it-works}#

• User().select(...): Executes query via ORM, returns DatabaseResult with .crud property.
• to_crud(request):
  • Detects table ("users").
  • Registers routes: GET/POST/DELETE under /users/dashboard/users.
  • Renders src/templates/crud/users.twig with data (auto-copies default if missing).
• Twig: {{ crud }} inserts the generated HTML interface.
• AJAX/JSON: Handles ?search=...&limit=...&offset=... for data refresh.

Customization {#customization}#

• Pass options: to_crud(request, {"primary_key": "user_id", "limit": 50}).
• Edit crud/users.twig for table-specific UI tweaks.