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")