def create(body):
data = (body['codigo'], body['latitud'], body['longitud'],
body['terreno'], body['area'], body['imagen'])
sql = "INSERT INTO Predios(codigo, latitud, longitud, terreno, area, imagen) VALUES(%s, %s, %s, %s, %s, %s)"
cur.execute(sql, data)
con.commit()
return {'estado': "Insertado"}, 200
def set():
global e3, e1, e4, e5, e6
p1 = e1.get()
p3 = e3.get(ACTIVE)
p4 = e4.get()
p5 = e5.get()
con.connect()
cursor.execute("Insert into appointment values(%s,%s,%s,%s)",
(p1, p3, p4, p5))
con.commit()
messagebox.showinfo("DATABASE SYSTEM", "APPOINTMENT SET SUCCSESSFULLY")
def inp():
global e1,e2,e3,e4,var
e1=t1.get()
e2=t2.get()
# e3=str(var.get())
e3=t3.get()
e4=t4.get()
con.connect()
cursor.execute("INSERT INTO doctor VALUES('"+e1+"','"+e2+"','"+e3+"','"+e4+"')")
con.commit()
# cursor.close()
messagebox.showinfo(" DATABASE SYSTEM", "DOCTOR DATA ADDED")
def remove():
global e7, edd
edd = str(e7.get())
v = (cursor.execute("select * from appointment where ap_no='" + edd + "'"))
v = cursor.fetchall()
if (len(v) == 0):
errorD = Label(rootAA, text="PATIENT APPOINTMENT NOT FIXED", fg="red")
errorD.place(x=20, y=420)
else:
cursor.execute("DELETE FROM appointment where ap_no='" + edd + "'")
con.commit()
disd1 = Label(rootAA, text="PATIENT APPOINTMENT DELETED", fg='green')
disd1.place(x=20, y=420)
def delling():
global d1,de,p
de=d1.get()
de = str(de)
con.connect()
p = cursor.execute("select * from doctor where doc_id='"+de+"'")
p = cursor.fetchone()
if p != 0:
cursor.execute("DELETE from doctor where doc_id='"+de+"'")
dme = Label(rootDE, text=" DOCTOR DELETED FROM DATABASE", fg="green")
dme.place(x=20, y=100)
con.commit()
# cursor.close()
# con.close()
else:
error = Label(rootDE, text="DOCTOR DOESN'T EXIST", fg="Red")
error.place(x=20, y=100)
def IN_DRUG():
global pp1, pp2, pp3, pp4, pp5, pp6,ce1,conn
pp1=t_id.get()
pp2=t_name.get()
pp3=t_formula.get()
pp4 = t_drug_cost.get()
drug_data = (
pp1, pp2, pp3, pp4
)
if(pp1 == "" or pp2=="" or pp3=="" or pp4=="" ):
messagebox.showinfo("insert status!", "ALL FIELDS ARE REQUIRED")
else:
con.connect()
res = cursor.execute("insert into drug(drug_id,drug_name,formula,drug_cost) values(%s,%s,%s,%s)",drug_data)
con.commit()
if res:
messagebox.showinfo("Message", "Add success")
else:
messagebox.showinfo("message", " Data Added Successfully")