Django Conditional Expressions in Queries - Coding

The conditional expressions allow developers to make decisions and manipulate data within queries, templates, and Python code, making it easier to create complex and dynamic web applications. In this article, we’ll delve into the world of conditional expressions in Django and explore how they can be used to enhance your web development projects.

Setting up the Project

Installation: To install Django follow these steps.

Creating the Project

Create the project by using the command

Django-admin startproject projectdemo
cd projectdemo

Create an application named ‘gfg’ by using the command:

python3 manage.py startapp gfg

Now add this app to the ‘INSTALLED_APPS’ in the settings file.

Screenshot-from-2023-09-17-17-25-54

Structuring Our Project

Organize your project directory with a clear file structure.

model.py

The model has three fields: “name” (a character field with a maximum length of 100 characters), “quantity” (an integer field), and “price” (a decimal field with a maximum of 10 digits and 2 decimal places).

Python3

# gfg/models.py
 
from django.db import models
 
class Product(models.Model):
    name = models.CharField(max_length=100)
    quantity = models.IntegerField()
    price = models.DecimalField(max_digits=10, decimal_places=2)
 
    def __str__(self):
        return self.name

forms.py

This code defines a Django form called ‘ProductForm’ in a file named forms.py within a Django app called ‘products’. The form is used to create and update instances of the Product model.

Python3

# gfg/forms.py
from django import forms
from .models import Product
 
class ProductForm(forms.ModelForm):
    class Meta:
        model = Product
        fields = ['name', 'quantity', 'price']

views.py

The code handles product listing and addition. The ‘product_list’ view annotates products to determine their stock status, while the ‘add_product’ view handles the submission of a form to add new products to the database. The HTML templates ‘myapp/index2.html’ and ‘myapp/index.html’ likely contain the presentation and form rendering for these views.

Python3

# gfg/views.py
from django.shortcuts import render
from django.http import HttpResponse
from django.shortcuts import redirect, render
from .forms import ProductForm
 
def home(request):
    return HttpResponse('Home Function is redirected to destination_view function')
# products/views.py
 
from django.shortcuts import render
from django.db.models import Case, When, Value, BooleanField
from .models import Product
 
def product_list(request):
    products = Product.objects.annotate(
        in_stock=Case(
            When(quantity__gt=0, then=Value(True)),
            default=Value(False),
            output_field=BooleanField()
        )
    )
    return render(request, 'myapp/index2.html', {'products': products})
 
def add_product(request):
    if request.method == 'POST':
        form = ProductForm(request.POST)
        if form.is_valid():
            form.save()
            return redirect('product_list')
    else:
        form = ProductForm()
        print("hh")
    return render(request, 'myapp/index.html', {'form': form})

product_form.html

This HTML code represents a simple web page for adding a product.

HTML

<!-- templates/product_form.html -->
 
<!DOCTYPE html>
<html>
<head>
    <title>Add Product</title>
</head>
<body>
    <h1>Add Product</h1>
    <form method="post" action="{% url 'add_product' %}">
        {% csrf_token %}
        <label for="name">Product Name:</label>
        <input type="text" id="name" name="name" required><br><br>
 
        <label for="quantity">Quantity:</label>
        <input type="number" id="quantity" name="quantity" required><br><br>
 
        <label for="price">Price:</label>
        <input type="number" id="price" name="price" step="0.01" required><br><br>
 
        <input type="submit" value="Add Product">
    </form>
</body>
</html>

product_list.html

This HTML template is used to display a list of products in a Django web application. It iterates through the “products” list, displaying each product’s name, price, and stock status (in stock or out of stock). Additionally, it includes a link for users to add new products to the list.

HTML

<!-- templates/product_list.html -->
 
<!DOCTYPE html>
<html>
<head>
    <title>Product List</title>
</head>
<body>
    <h1>Product List</h1>
    <ul>
        {% for product in products %}
            <li>
                {{ product.name }} -
                Price: ${{ product.price }} -
                {% if product.in_stock %}
                    In Stock
                {% else %}
                    Out of Stock
                {% endif %}
            </li>
        {% endfor %}
    </ul>
</body>
</html>
 
 
<p><a href="{% url 'add_product' %}">Add a Product</a></p>

app/urls.py

This code defines URL patterns for a Django web application in the “pdfapp” module. It uses the Django urls.py file to map URLs to views in the application.

Python3

# gfg/urls.py
from django.urls import path
from . import views
 
urlpatterns = [
    path('', views.home, name='home'),
    path('products/', views.product_list, name='product_list'),
    path('add/', views.add_product, name='add_product'),
]

urls.py

This code defines URL patterns for a Django web application of the project.

Python3

# pdfgenerator/urls.py
from django.contrib import admin
from django.urls import path, include
 
urlpatterns = [
    path('admin/', admin.site.urls),
    path('', include('mini.urls')),
]

Deployement of the Project

Run these commands to apply the migrations:

python3 manage.py makemigrations
python3 manage.py migrate

Run the server with the help of following command:

python3 manage.py runserver

Output

Screenshot-from-2023-09-19-23-57-48

Screenshot-from-2023-09-19-23-57-30

Reffered: https://www.geeksforgeeks.org

Geeks Premier League

Related
Django Query Set - get
Python Django Handling Custom Error Page
how to use validate_ipv4_address in django
Difference between Falcon and Flask
PyCharm Introduction - A Beginner's Guide

Type:	Geek
Category:	Coding
Sub Category:	Tutorial
Uploaded by:	Admin
Views:	12