def delete_request(name):
try:
oid=get_olie_id_by_name(name)
query="DELETE FROM REQUEST_APPROVE WHERE OID="+oid
cur.execute(query)
except:
print("CANNOT DELETE NOW PLEASE TRY AGAIN LATER")
def insert_to_young(name,age,address):
data=[name,age,address]
try:
cur.execute("""INSERT INTO YOUNG(ID,NAME,AGE,ADDRESS) VALUES(NULL,?,?,?);""",data)
conn.commit()
except:
print("can not insert please try again later")
def insert_care(oid,yid):
dat=[oid,yid]
try:
cur.execute("""INSERT INTO CARE(OID<YID) VALUES(?,?);""",data)
conn.commit()
except:
print("can not insert please try again later")
def yfeedback(name,feedback,ratings):
try:
query="SELECT ID FROM CARE WHERE OID="+get_olie_id_by_name(name)[0]
yid=next(cur.execute(query))
dat=[yid,oid,feedback,rating]
cur.execute(""""INSERT INTO Y_FEEDBACK(YID,OID,FEEDBACK) VALUES(?,?,?,?);""",data)
except:
print("can not insert please try again later")
def ofeedback(yname,oname,feedback,ratings):
try:
yid=get_young_id_by_name(yname)
oid=get_olie_id_by_name(name)
data=[oid,yid,feedback,rating]
cur.execute(""""INSERT INTO O_FEEDBACK(OID,YID,FEEDBACK) VALUES(?,?,?,?);""",data)
except:
print("can not insert please try again later")
def approve_request(oname,yname):
try:
yid=get_young_id_by_name(yname)
oid=get_olie_id_by_name(oname)
query="UPDATE REQUEST_APPROVE SET REQUEST=1 WHERE OID="+oid+"&& YID="+yid
cur.execute(query)
conn.commit()
except:
print("can not insert please try again later")
def make_request(yname,oname):
yid=get_young_id_by_name(yname)
oid=get_olie_id_by_name(oname)
query="SELECT COUNT(YID) FROM CARE WHERE YID="+str(yid[0])
data=[oid[0],yid[0]]
if(next(cur.execute(query))[0]<4):
cur.execute("""INSERT INTO REQUEST_APPROVE(OID,YID,REQUEST) VALUES(?,?,0);""",data)
conn.commit()
else:
print("YOU CANNOT TAKE CARE OF MORE THAN 4 PEOPLE")
def list_request(name):
try:
query = "SELECT NAME,AGE,ADDRESS FROM YOUNG Y,REQUEST_APPROVE R WHERE R.YID,OID=" + ins.get_olie_id_by_name(
name)
return (cur.execute(query))
except:
print("NO REQUESTS YET")
def list_all_oldies():
return (cur.execute("SELECT * FROM OLD"))
def retrieve_oldies_feedback(name):
try:
query = "SELECT FEEDBACK,RATING FROM O_FEEDBACK WHERE OID=(SELECT ID FROM OLD WHERE NAME=" + name + ")"
return (cur.execute(query))
except:
print("NO RECORDS FOUND")
def retrieve_young_feedback(name):
try:
query = "SELECT FEEDBACK,RATING FROM Y_FEEDBACK WHERE YID=(SELECT ID FROM YOUNG WHERE NAME=" + name + ")"
return (cur.execute(query))
except:
print("NO RECORDS FOUND")
def retrieve_oldies_caretaker(name):
try:
query = "SELECT NAME FROM YOUNG WHERE ID=(SELECT YID FROM CARE WHERE OID=(SELECT ID FROM OLD WHERE NAME=" + name + "))"
return (cur.execute(query))
except:
print("NO RECORDS FOUND")
def list_all_young():
return (cur.execute("SELECT * FROM YOUNG"))
def insert_to_old(data):
try:
cur.execute("""INSERT INTO OLD(ID,NAME,AGE,ADDRESS,FUND) VALUES(NULL,?,?,?,?);""",data)
conn.commit()
except:
print("can not insert please try again later")
def get_young_id_by_name(name):
query="SELECT ID FROM YOUNG WHERE NAME='"+name+"'"
return(next(cur.execute(query)))
def get_olie_id_by_name(name):
query="SELECT ID FROM OLD WHERE NAME='"+name+"'"
return(next(cur.execute(query)))
