def approvelist(username4):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list2 = []
cur.execute(
"select u.username,u.name,u.city from user_details u inner join request_status r on r.friend_username=u.username and r.username=:username and r.status='Pending'",
{"username": username4})
for i, j, k in cur:
user4 = user_details()
user4.set_username(i)
user4.set_name(j)
user4.set_city(k)
list2.append(user4)
return list2
finally:
cur.close()
con.close()
def viewfriends(username3):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list1 = []
cur.execute(
"select u.username,u.name,u.city from user_details u inner join request_status r on r.friend_username=u.username and r.username=:username and r.status='Approved'",
{"username": username3})
for i, j, k in cur:
user3 = user_details()
user3.set_username(i)
user3.set_name(j)
user3.set_city(k)
list1.append(user3)
return list1
finally:
cur.close()
con.close()
def get_profile(username2):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list1 = []
cur.execute(
"select username,name,surname,gender,city,relationship_status from user_details where username=:username",
{"username": username2})
for i, j, k, l, m, n in cur:
user2 = user_details()
user2.set_username(i)
user2.set_name(j)
user2.set_surname(k)
user2.set_gender(l)
user2.set_city(m)
user2.set_relationship_status(n)
list1.append(user2)
return list1
finally:
cur.close()
con.close()
def search_friends(value1):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list2 = []
value1 = value1.lower()
cur.execute(
"select username,name,surname,city from user_details where lower(username) like '%"
+ value1 + "%' or lower(name) like '%" + value1 +
"%' or lower(surname) like '%" + value1 + "%'")
for i, j, k, l in cur:
user5 = user_details()
user5.set_username(i)
user5.set_name(j)
user5.set_surname(k)
user5.set_city(l)
list2.append(user5)
return list2
finally:
cur.close()
con.close()
from Database import insertDB
from Validations import validate_signup
from Classes import user_details
from Database import viewDB
from Exceptions.user_exceptions import Invalid_string
from Database.insertDB import chng_pwd
user = user_details.user_details()
'''-------------------------------------Below function is to edit profile and invoking validate---------------------------------------'''
def profile(username):
list1 = ['Single', 'Divorced', 'Married']
print('----------------------------')
print(' Edit Profile ')
print('----------------------------')
password1 = input('Enter password:')
value1 = viewDB.get_username_password(username, password1)
if value1 == 1:
name1 = input("\nEnter name:")
try:
user.set_name(name1)
validate_signup.name(name1)
except Invalid_string as e:
print(e)
return profile(username)
surname1 = input("\nEnter surname:")
try:
user.set_surname(surname1)
validate_signup.name(surname1)
except Invalid_string as e:
print(e)