Archive

Archive for February 27, 2022

Python Project: Properties Maintenance System P12

February 27, 2022 Leave a comment

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.

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

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