from django.db import connections
from django.conf import settings
from django.utils import timezone

class SQLloggingMiddleware(object):
    def __init__(self, get_response):
        self.get_response = get_response

    def __call__(self, request):
        response = self.get_response(request)
        print(f'[{timezone.now()}] {request.user} -> {request.path}')
        for connection in connections:
            con = connections[connection]
            if len(con.queries) > 0 and settings.DEBUG:
                total_time = 0.0
                for query in con.queries:
                    nice_sql = query['sql'].replace('"', '')
                    time = query['time']
                    total_time = total_time + float(time)
                    print(f'[{time}] {nice_sql}')
                print(f'[TOTAL TIME: {total_time} seconds.]')

        return response