diek

Django and PostgreSQL 15, the rules have changed

Postgres 15 is just out, and while there is a lot to love about this new release, you're in for a surprise if you try to set it up with Django following tutorials like this one.

The reason is stated in the release announcement:

Remove PUBLIC creation permission on the public schema (Noah Misch) The new default is one of the secure schema usage patterns that Section 5.9.6 has recommended...

Provided your web app doesn't access your database as a superuser (it shouldn't) and uses a dedicated user, it is not allowed to use the public schema anymore. You have to create one for this specific user, and the next section will

diek

from django.db import models
from django.utils import timezone
""" Source: https://twitter.com/JackDLinke/status/1578435998492475392/photo/1"""

class ItemQuerySet(self):
    """Used to return a QuerySet that has been filtered"""

    def expired_items(self):
        return self.filter(expired_isnull=True)

diek

diek

# This file must be saved in app/management/commands/upload_csv.py
# https://docs.djangoproject.com/en/3.2/howto/custom-management-commands/
from chinook.models import Playlist, PlaylistTrack, Track
from django.core.management import BaseCommand


def get_playlisttrack():
    data = []
    with open('PlaylistTrack.csv') as infile:
        next(infile)

diek

Django Deployment to Ubuntu 18.04

In this guide I will go through all the steps to create a VPS, secure it and deploy a Django application. This is a summarized document from this digital ocean doc

Any commands with "$" at the beginning run on your local machine and any "#" run when logged into the server

Create A Digital Ocean Droplet

Use this link and get $10 free. Just select the $5 plan unless this a production app.

diek

from functools import partial


def placeholderify(form=None, fields=None):
    """
    A decorator for Django forms that sets a `placeholder` attribute to all
    fields. Each field's label is used as a placeholder.
    
    Use it like so:
    

diek

from .models import Post, Category
from .decorators import action_form


class PostCategoryForm(forms.Form):
    title = 'Update category for the selected posts'
    category = forms.ModelChoiceField(queryset=Category.objects.all())


@admin.register(Post)

diek

import random
from datetime import datetime, timedelta

min_year=1900
max_year=datetime.now().year

start = datetime(min_year, 1, 1, 00, 00, 00)
years = max_year - min_year+1
end = start + timedelta(days=365 * years)

diek

from datetime import datetime
from random import randint

import pytz
from django.contrib.auth import get_user_model
from django.core.management.base import BaseCommand
from django.utils import timezone
from faker import Faker

fake = Faker(["en_CA"])

diek

{% extends "base.html" %}

{% block content %}
<form method="post">{% csrf_token %}
    {{ forms.subscription }}
    <input type="submit" value="Subscribe">
</form>
<form method="post">{% csrf_token %}
    {{ forms.contact }}
    <input type="submit" value="Send">