Home > Learning, Lesson, Problem, Projects/Experiments, Python > Python Project: Properties Maintenance System P12

Python Project: Properties Maintenance System P12

Subject: Writing a Full Application for Properties Maintenance System [Delete Maintenance Request]
Learning : Python, Math, SQL, Logeic

[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.

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)))

python project code SQL ali radwani

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

:: PMS Parts ::

Part 1 Part 2 Part 3 Part 4 Part 5 Part 6 Part 7
Part 8 Part 9 Part 10 Part 11 Part 12 Part 13 Part 14

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

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

ali radwani ahradwani.com python projects codeFollow me on Twitter..

By: Ali Radwani

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s