def welcome():
print(
"Please select\n1. Login as Elder \n2. Login as Younger\n3. Register\n4. View all youngers who are taking care\n5. View who is taking care of older couple\n6. Exit"
)
task = int(input())
if task == 1:
mobile = input("Welcome Elder\nEnter Your Email: ")
password = input("Enter Your Password: "******"Welcome younger\nEnter Your Email: ")
password = input("Enter Your Password: "******"Register Yourself\nEnter Your Full Name: ")
email = input("Enter your email: ")
mobile = input("Enter Your Mobile Number: ")
password = input("Enter Your Password: "******"select your role:\n1. Elder\n2. Younger\n"))
try:
if role == 1:
role = "elder"
break
elif role == 2:
role = "younger"
break
except:
print(f'option not Valid! Please try again')
user_signup = User(name, email, password, mobile, role)
user_signup.user_registration()
# display name of youngers who are taking care of
elif task == 4:
sql = '''SELECT `name` FROM users WHERE `PK_user_id` IN
(SELECT FK_user_id FROM `youngers` WHERE `PK_younger_id` IN
(SELECT `FK_younger_id` FROM elders))'''
mycursor.execute(sql)
user_data = mycursor.fetchall()
for data in user_data:
print(data)
# pass
# enter elder's mobile number of email both are unique here and display their take care name
elif task == 5:
print("Enter elders email id to check their take cares name")
email_id = input()
sql1 = "SELECT `FK_user_id` FROM elders WHERE `FK_user_id` IN (SELECT `PK_user_id` FROM users WHERE email = %s);"
val = (email_id)
mycursor.execute(sql1, val)
elder_id = mycursor.fetchall()
if not elder_id:
print("No Elder or User found with this mail id")
welcome()
return
sql2 = "SELECT `FK_younger_id` FROM request WHERE `request_status` = 1 AND `FK_elder_id` = %d;"
val2 = (elder_id)
mycursor.execute(sql2, val2)
names = mycursor.fetchall()
for name in names:
print(name)
elif task == 6:
exit()
def welcome():
print(
"Please select\n1. Login as Elder \n2. Login as Younger\n3. Register\n4. View all youngers who are taking care\n5. View who is taking care of older couple\n6. Exit"
)
task = int(input())
if task == 1:
mobile = input("Welcome Elder\nEnter Your Email: ")
password = input("Enter Your Password: "******"Welcome younger\nEnter Your Email: ")
password = input("Enter Your Password: "******"Register Yourself\nEnter Your Full Name: ")
email = input("Enter your email: ")
mobile = input("Enter Your Mobile Number: ")
password = input("Enter Your Password: "******"select your role:\n1. Elder\n2. Younger\n"))
try:
if role == 1:
role = "elder"
break
elif role == 2:
role = "younger"
break
except:
print(f'option not Valid! Please try again')
user_signup = User(name.lower(), email, password, mobile, role)
user_signup.user_registration()
print("\n\n")
welcome()
# display name of youngers who are taking care of
elif task == 4:
sql = f'SELECT * FROM users,youngers where PK_user_id = FK_user_id'
mycursor.execute(sql)
younger_info = mycursor.fetchall()
print("{:25} {:25} {:15} {:5}".format("name", "Email", "Contact",
"Rating"))
for younger in younger_info:
print("{:25} {:25} {:15} {}".format(younger[1], younger[2],
younger[4], younger[7]))
elder_info(younger[0])
print("\n")
print("\n\n")
welcome()
# enter elder's mobile number of email boh are unique here and display their take care name
elif task == 5:
sql = f'select a.name,a.email,a.mobile,b.name from users a,users b,elders e where a.PK_user_id = e.FK_user_id and b.name in (select name from users,youngers where PK_user_id = FK_user_id and PK_younger_id in (select FK_younger_id from elders,youngers where FK_younger_id = PK_younger_id and a.PK_user_id = elders.FK_user_id))'
mycursor.execute(sql)
care_info = mycursor.fetchall()
print("{:25} {:25} {:15} {:25}".format("Elder Name", "Email", "Mobile",
"Care taker Name"))
for care in care_info:
print("{:25} {:25} {:15} {:25}".format(care[0], care[1], care[2],
care[3]))
print("\n\n")
welcome()
elif task == 6:
exit()
def welcome():
print(
"Please select\n1. Login as Elder \n2. Login as Younger\n3. Register\n4. View all youngers who are taking care\n5. View who is taking care of older couple\n6. Exit"
)
task = int(input())
if task == 1:
mobile = input("Welcome Elder\nEnter Your Email: ")
password = input("Enter Your Password: "******"Welcome younger\nEnter Your Email: ")
password = input("Enter Your Password: "******"Register Yourself\nEnter Your Full Name: ")
email = input("Enter your email: ")
mobile = input("Enter Your Mobile Number: ")
password = input("Enter Your Password: "******"select your role:\n1. Elder\n2. Younger\n"))
try:
if role == 1:
role = "elder"
break
elif role == 2:
role = "younger"
break
except:
print(f'option not Valid! Please try again')
user_signup = User(name, email, password, mobile, role)
user_signup.user_registration()
# display name of youngers who are taking care of
elif task == 4:
sql = 'select name from users where PK_user_id = (select FK_user_id from youngers where PK_younger_id = (select FK_younger_id from elders where FK_younger_id >= 1))'
mycursor.execute(sql)
print(mycursor.fetchone())
# enter elder's mobile number of email boh are unique here and display their take care name
elif task == 5:
print(
"Enter Email or mobile number to find who is taking of the respective elder\n1.Email\n2.Mobile Number"
)
choice = int(input())
if choice == 1:
email = str(input('Enter the Email :'))
sql = f'SELECT name FROM users WHERE PK_user_id = (SELECT FK_user_id FROM youngers where FK_user_id = (SELECT FK_younger_id FROM elders where FK_user_id = (SELECT PK_user_id FROM users where email = "{email}")))'
mycursor.execute(sql)
print(mycursor.fetchone())
elif choice == 2:
mobile_no = str(input('Mobile No :'))
sql = f'SELECT name FROM users WHERE PK_user_id = (SELECT FK_user_id FROM youngers where FK_user_id = (SELECT FK_younger_id FROM elders where FK_user_id = (SELECT PK_user_id FROM users where mobile = "{mobile_no}")))'
mycursor.execute(sql)
print(mycursor.fetchone())
#It will come out from the application, Run the application again if you want to go inside
elif task == 6:
return "\n\n\nWelcome to CareAll\n\n\n"
def welcome():
print(
"Please select\n1. Login as Elder \n2. Login as Younger\n3. Register\n4. View all youngers who are taking care\n5. View who is taking care of older couple\n6. Exit"
)
task = int(input())
if task == 1:
mobile = input("Welcome Elder\nEnter Your Email: ")
password = input("Enter Your Password: "******"Welcome younger\nEnter Your Email: ")
password = input("Enter Your Password: "******"Register Yourself\nEnter Your Full Name: ")
email = input("Enter your email: ")
mobile = input("Enter Your Mobile Number: ")
password = input("Enter Your Password: "******"select your role:\n1. Elder\n2. Younger\n"))
try:
if role == 1:
role = "elder"
break
elif role == 2:
role = "younger"
break
except:
print(f'option not Valid! Please try again')
user_signup = User(name, email, password, mobile, role)
user_signup.user_registration()
elif task == 4:
sql = f'SELECT name from users where PK_user_id in (select FK_younger_ID from elders)'
mycursor.execute(sql)
younger_info = mycursor.fetchall()
print(younger_info)
print("This all youngeFolks are taking care of some older")
for i in range(len(younger_info)):
print(f'{i+1}. {younger_info[i][0]}')
welcome()
elif task == 5:
elder_number = int(input("Please enter elder's mobile number.\n"))
sql = f'SELECT PK_user_id from users where mobile={elder_number}'
mycursor.execute(sql)
user_id = mycursor.fetchone()
sql = f'SELECT FK_younger_id, available from elders WHERE FK_user_id={user_id[0]}'
mycursor.execute(sql)
elder_detail = mycursor.fetchone()
print(elder_detail)
if elder_detail[1] == 0:
sql = f'select name from users where PK_user_id={elder_detail[0]}'
val = (elder_detail[0])
mycursor.execute(sql, val)
younger_name = mycursor.fetchone()
print(f'{younger_name[0]} is taking care of {elder_detail[0]}.')
else:
print(f'No one is taking care of {elder_detail[0]}')
welcome()
elif task == 6:
exit()