-
Book Overview & Buying
-
Table Of Contents
MySQL for Python
By :
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.
Before implementing a user interface for any functionality, one naturally needs to code support into the program itself. In the case of HAVING, we need to do the following in pymyadmin.py:
Revise the qaction function to insert HAVING into the MySQL statement that it passes to execute()
Revise the qaction function call in main()
Code support...
Change the font size
Change margin width
Change background colour