Pretty Print SQL Queries | Django Project | SQL Inspection Middleware | 9

This tutorial is part of the Django Project Python Package course. This tutorial teaches us how to pretty print the captured SQL queries in the terminal.

Udemy Course:

YouTube Playlist:

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.

[madusan]

from pygments.lexers.sql import SqlLexer (lexer should be plural in the from statement)

[triplestar]

Hi, all of your videos are awesome and useful
We have queries related to the django project how to deploy django projects using filezila server and run. I hope you give me updates on my query.

[madusan]

Pygments is a play on pigments and pronounced as ¨pig'ments¨ meaning colour or colours insoluble in water.