{% extends 'base.html' %} {% block title %}Execute simple JOIN queries{% endblock %} {% block content %}

Demo: Executing simple JOIN queries

Use the input field to search for photos using the following queries:
Photo.objects.filter(user__first_name=form.cleaned_data['first_name'],
                     user__last_name=form.cleaned_data['last_name'])
{% csrf_token %} {{ user_search_form }}
Photo.objects.filter(popularity=2, user__first_name=form.cleaned_data['first_name'],
                     user__last_name=form.cleaned_data['last_name'])
{% csrf_token %} {{ user_popular_search_form }}
Photo.objects.filter(popularity=2, published__month=form.cleaned_data['month'],
                     user__first_name___iexact=form.cleaned_data['first_name'],
                     user__last_name___iexact=form.cleaned_data['last_name'])
{% csrf_token %} {{ user_month_search_form }}

Create new photo your own photo to test non-standard queries.

Create new user.

Corresponding post: Get SQL features on NoSQL with django-dbindexer.

{% endblock %}