Django Project: Building A Python Package - Sql Middleware

Publishing a Python Django Reusable App on PyPI

What you'll learn

Build a Django project

Build a Django Middleware package to inspect SQL queries executed by the Django application

Prepare a Python app ready for deployment to the Python Package Index PyPI

Test a Django stand-alone app with the Pytest testing framework

Create an automated build and deployment workflow using GitHub actions

Requirements

No Prior programming experience needed but would be advantageous

Description

The Python Package Index (PyPI) is a software repository for the Python programming language. in this course, we teach you how to build and publish a Python package to the PyPI. The package we built and published is centred around a Django middleware tool we developed in this course. We start by learning how to build a Django project and how to inspect SQL queries executed by a Django application. We will learn the basics of Django Middleware and how to build a simple middleware component that will form our package's basic functionality. Once we grasp the fundamentals of Django, Django middleware and how to capture SQL queries executed by Django, we move to the next phase, building a new package. In the first stages, we explore the essential files and configurations required to build a new package. We then incorporate the middleware we have built previously and build our package in preparation for being uploaded to the PyPI. The life cycle of our application does not stop after distribution. Therefore we take the following steps to automate the delivery of our app to the PyPI. We develop GitHub actions to manage the packaging and upload of the package to the PyPI. In this course, we provide an introduction to testing with Pytest, creating stand-alone Django apps to aid the testing process.

Overview

Section 1: Course Introduction

Lecture 1 Introduction

Lecture 2 Course Resources / Source Code

Section 2: Setup Guides

Lecture 3 [Windows] Installing Python

Lecture 4 [Windows] Visual Studio Code Induction

Lecture 5 [Windows ] Creating Virtual Environments

Lecture 6 [macOS] Installing Python

Lecture 7 [macOS] Visual Studio Code Induction

Lecture 8 [macOS] Creating Virtual Environments

Section 3: Django Project Setup

Lecture 9 Initiate a new Django project

Lecture 10 Create Requirements File

Lecture 11 Create a New Django App

Lecture 12 Create a Django Model

Lecture 13 Create a Django View

Lecture 14 Create a Django URL

Lecture 15 Populate database (Factory Boy & Faker)

Lecture 16 Capturing SQL Queries in the Terminal

Lecture 17 Pretty Print SQL Queries

Section 4: Middleware

Lecture 18 Middleware Workflow

Lecture 19 3.2. Building SQL Query Inspector Middleware

Section 5: Creating a Python Package for the PyPI

Lecture 20 PyPI and TestPyPI

Lecture 21 Create a new Python Package

Lecture 22 Package Build

Section 6: Publishing a Package to TestPyPI

Lecture 23 TestPyPI

Lecture 24 Publish Package to TestPyPI

Lecture 25 Installing a Package from TestPyPi with PIP

Section 7: Package Testing

Lecture 26 Pytest Setup

Lecture 27 Testing with a Stand-Alone Django App

Lecture 28 Testing the Standard Output

Section 8: GitHub Actions – Build and Deployment Automation

Lecture 29 Create a New GitHub Repository

Lecture 30 Build and Publish Automation

Section 9: Publishing to PyPI

Lecture 31 Update Readme File to Markdown

Lecture 32 Publish the package to PyPI

Beginners, Developers, Students, and Enthusiasts to Python programming