ExamHoot
29 / 30Django Middleware and Request ProcessingHardPython - Django Framework

Database Connection Management in Middleware

from django.db import connection

class DatabaseMiddleware:
    def __init__(self, get_response):
        self.get_response = get_response

    def __call__(self, request):
        request.db_queries_start = len(connection.queries)
        response = self.get_response(request)
        request.db_queries_end = len(connection.queries)
        response['X-DB-Queries'] = str(request.db_queries_end - request.db_queries_start)
        return response

  1. The middleware correctly tracks database queries executed during request processing

  2. connection.queries is not available in production mode due to security restrictions

  3. The middleware should use django.db.signals instead of direct connection access

  4. Database query tracking should only be done in development environment

Show answer & explanation

Correct answer

The middleware correctly tracks database queries executed during request processing

Explanation

The middleware tracks database query count before and after view execution by accessing Django's connection.queries, useful for performance monitoring.

Written by ExamHoot EditorialPublished · Updated

All 30 Django Middleware and Request Processing questions

  1. 1.What is the primary purpose of Django Middleware?
  2. 2.In which setting in Django is middleware configured?
  3. 3.What is the order of execution for middleware methods during request processing?
  4. 4.Which middleware method is called when an exception occurs in a view?
  5. 5.What does returning a response object from process_request() do?
  6. 6.Which built-in Django middleware handles Cross-Site Request Forgery (CSRF) protection?
  7. 7.What is the purpose of the SessionMiddleware in Django?
  8. 8.What does the CommonMiddleware middleware do?
  9. 9.In Django middleware, what does returning None from process_request() indicate?
  10. 10.Which middleware is responsible for adding User object to the request?
  11. 11.Understanding Django Middleware Execution Order
  12. 12.Middleware Methods and Request Processing Flow
  13. 13.Scenario:
  14. 14.Understanding process_exception() Middleware Method
  15. 15.Coding:
  16. 16.Scenario:
  17. 17.Understanding Middleware Short-Circuiting with Early Response
  18. 18.Scenario:
  19. 19.Understanding Middleware Exception Handling
  20. 20.Scenario:
  21. 21.Middleware Execution Order and Request Processing Pipeline
  22. 22.Custom Middleware Implementation for Request Logging
  23. 23.Exception Handling in Django Middleware
  24. 24.Request/Response Modification in Middleware - Hari's Scenario
  25. 25.Middleware Short-Circuiting and Early Response - Prasath's Scenario
  26. 26.CORS Middleware Implementation
  27. 27.Conditional Middleware Processing Based on URL Pattern
  28. 28.Middleware and Template Context Processing
  29. 29.Database Connection Management in Middleware
  30. 30.Middleware Initialization with Settings - Hari's Configuration Scenario