Django Middleware to log every time a user hits a page

Viewed 214

As the title states I am trying to create a middleware that will record every time a user hits a page.

Here's my model.py I'll be working with:

class UserPageTracking(models.Model):
    """ Page hits with user info """
    id = models.AutoField(db_column='ID', primary_key=True)
    user_id = models.CharField(db_column='USER_ID', max_length=8, default="")
    url = models.URLField(db_column='URL')
    date_visited = models.DateTimeField(db_column='DATE_VISITED', auto_now_add=True)

    class Meta:
        managed = True
        db_table = 'page_views'

Here's what's in my middleware:

from .models import UserPageTracking


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

    def __call__(self, request):
        response = self.get_response(request)
        user_id = request.user.username
        # not every request will have a http_referer, so when it doesn't just ignore it and don't save anything
        to_url = request.META.get('HTTP_REFERER')
        if to_url:

            user_page_tracking = UserPageTracking.objects.create(
                 url=to_url, user_id=user_id
            )
            user_page_tracking.save()
        return response

my settings.py

MIDDLEWARE = [
    'django.middleware.security.SecurityMiddleware',
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',
    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
    'app.middleware.user.UserMiddleware',
    'app.middleware.user_page_tracking.UserPageTrackingMiddleware'
]

This works alright the only issue is every time I load a page/go to a page it'll hit this middleware multiple times (at least twice, sometimes like 3 or 4). When I check the db I'll have 3 - 4 entries that are a about 40 - 50 ms apart from each other.

Am I doing something wrong, or is this something I can't do via middleware and I have to do something else to log user activity.

0 Answers
Related