diff options
| author | Rishi-k-s <rishikrishna.sr@gmail.com> | 2023-01-04 01:05:04 +0530 |
|---|---|---|
| committer | Rishi-k-s <rishikrishna.sr@gmail.com> | 2023-01-04 01:05:04 +0530 |
| commit | 9ac3fa01ffbebedd1792c8161469cba3aa24b9b1 (patch) | |
| tree | 873c20f8644780aad0241456d2bbba822eeb60fc | |
| parent | cad78df173f413df937044fd88b9bf81d49d388c (diff) | |
First Completed point reached
| -rw-r--r-- | HousekeepingMngmnt.session.sql | 3 | ||||
| -rw-r--r-- | main.py | 7 |
2 files changed, 9 insertions, 1 deletions
diff --git a/HousekeepingMngmnt.session.sql b/HousekeepingMngmnt.session.sql index d195c05..6f6e38c 100644 --- a/HousekeepingMngmnt.session.sql +++ b/HousekeepingMngmnt.session.sql @@ -142,3 +142,6 @@ DELETE FROM reviews; --@block
DELETE FROM hslocations;
+
+--@block
+SELECT place_name FROM hslocations WHERE hk_uid = '1062b0ca-8b8f-11ed-ab30-5811227fcdd6';
\ No newline at end of file @@ -409,7 +409,12 @@ def hs_kep_dashboard(): headers = ['User','Date and time',"Room facilities","Meal","Friendliness","washroom","overall","remarks"]
print(tabulate.tabulate(fullReviewFromDB, headers, tablefmt="rounded_grid"))
elif(getHkMenuStuff == "3"):
- sql_cursor.fetchall("SELECT place_name FROM hslocations WHERE hk_uid = '{}'".format(listedGetDetailsFromUser[1]))
+ sql_cursor.execute("SELECT place_name FROM hslocations WHERE hk_uid = '{}';".format(listedGetDetailsFromUser[1]))
+ getRoomNameFromDB = sql_cursor.fetchall()[0][0]
+ print("---Your assigned Room is----")
+ print(getRoomNameFromDB)
+ print("----------------------------")
+
else:
viewHkDashboard = False
#super admin dashboard
|