Python Project: Properties Maintenance System P8
Subject: Writing a Full Application for Properties Maintenance System [Property: Delete a Record]
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 write a Function to Delete a record from the database, first we will call the def show_property(inside) to display all the records on the screen and ask the user to Select [enter] the ID of the Property to be Deleted. Next we will Display the Record again on the screen and ask the user to Confirm the Deleting by entering [Y] and any things else will be as [Don’t Delete]. Here is the code ..
![]() |
.. End of Part 8 ..
NOTE: If you Download this Part you MUST Run the Option 82 (82. Delete the Data-Base and Start Again.) from the Main Menu to do the following Updates:
- Update the properties_t Table (Adding the number of BathRooms)
- Update on create_tables Function.
- Update on insert_zero_records Function.
If you did this in last part (6) then you don’t need to do it again
In Part-9 In the Next Part, we will write the Function to Edit a record of a selected Property.
:: PMS Parts ::
Part 1 | Part 2 | Part 3 | Part 4 |
Part 5 | Part 6 | Part 7 | Part 8 |
..:: Have Fun with Coding ::.. 🙂
To Download my Python code (.py) files Click-Here
By: Ali Radwani
-
January 5, 2022 at 7:05 amPython Project: Properties Maintenance System P9 | Ali's Photography Space...
-
February 13, 2022 at 7:07 amPython Project: Properties Maintenance System P10 | Ali's Photography Space...
-
February 20, 2022 at 7:10 amPython Project: Properties Maintenance System P11 | Ali's Photography Space...
-
February 27, 2022 at 7:13 amPython Project: Properties Maintenance System P12 | Ali's Photography Space...