Ali's Photography Space…

[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]

In this part we will continue write the Functions in Maintenance Request Service. Here we will write the Function to Delete a Maintenance Request.

This is very easy and short Function, first we will list all the requests by calling the def show_maintenance_request, after that we will ask the user to Select the ID of the request to be Delete.

Validation
We will use simple validation code on the User input for the following aspects:

• If the user input E to Exit.
• If the user input digits or Not.
• If the ID is available in the system/Database.
• If the user input Y to confirm the Deleting prosses.

So if the user input pass all the Validations, and he confirm the Deleting, the Record will be Deleting using the following SQL Command:
c.execute (“delete from maint_request_t where m_r_id ={}”.format(int(delete_this)))
db_conn.commit()

We done with this part, Next we will write a code to change a request status.

:: PMS Parts ::

..:: Have Fun with Coding ::.. 🙂

To Download my Python code (.py) files Click-Here

Follow me on Twitter..

By: Ali Radwani