O'Reilly logo

MySQL for Python by Albert Lukaszewski, PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Project: Implement HAVING

For the project of this chapter, we will introduce support for HAVING under sorting in our basic database administration web application. Basically, a full-fledged web-based administration application should have support for JOIN and, to a certain extent, subqueries. However, this functionality will be left for room to grow.

The goals of this project are straightforward:

  • Implement support for HAVING in the Python back-end of the application
  • Code the HTML front-end to allow HAVING in conjunction with sorting

When we are done, we will also look at some ways that this application could (and should) be dressed up.

Revising the Python backend

Before implementing a user interface for any functionality, one naturally needs to code ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required