def checktid(self, id): dbase = db.DBConnect() query = "select * from trans where tid=%s" values = (self.e1.get(), ) rows = dbase.view(query, values) if len(rows) == 0: return False
def updateqty(self, id): dbase = db.DBConnect() query = "select bid from trans where tid=%s" values = (self.e1.get(), ) bid = dbase.view(query, values) query1 = "update cds set Quantity=Quantity+1 where id=%s" values1 = (bid[0][0], ) dbase.update(query1, values1)
def delete_cdbuyer(self, id): """ Function to delete cdbuyers from cdbuyers table """ self.E_check() usr = u.user_model1(cid=id) query = "delete from cdbuyers where cid=%s" values = (usr.get_cid(), ) db.DBConnect().delete(query, values)
def Add_Animecd(self, id, cd, mangaka, qty): """ Function To insert Data into the Table """ self.E_check() usr = u.user_model(id, cd, mangaka, qty) query = "insert into cds values(%s, %s, %s, %s)" values = (usr.get_id(), usr.get_cd(), usr.get_mangaka(), usr.get_qty()) db.DBConnect().insert(query, values)
def add_cdbuyer(self, cid, cname, pno): """ Function to insert in cdbuyers table """ self.E_check() usr = u.user_model1(cid, cname, pno) query = "insert into cdbuyers values(%s, %s, %s)" values = (usr.get_cid(), usr.get_cname(), usr.get_pno()) db.DBConnect().insert(query, values)
def Delete_CD(self, id): """ Function to delete cd from cds table """ self.E_check() usr = u.user_model(id=id) query = "delete from cds where id=%s" values = (usr.get_id(), ) db.DBConnect().delete(query, values)
def check(self): dbase = db.DBConnect() query = "select * from cds where id=%s" values = (self.e2.get(), ) rows = dbase.view(query, values) query1 = "select * from cdbuyers where cid=%s" values1 = (self.e3.get(), ) rows1 = dbase.view(query1, values1) if len(rows) == 0 or len(rows1) == 0: return False
def update_trans(self, rdate, tid): """ Function to update from trans table """ self.E_check() if self.checktid(self.e1.get()) == False: messagebox.showerror("you have not taken CD", "Baka") return usr = u.user_model2(rdate=rdate, tid=tid) query = "update trans set recd = %s where tid = %s" values = (usr.get_rdate(), usr.get_tid()) db.DBConnect().update(query, values) self.updateqty(self.e1.get())
def insert_trans(self, tid, bid, cid, idate, rdate): """ Function to insert in trans table """ self.E_check() if self.check() == False: messagebox.showerror("Lol", "You Are Not Otaku Bye") return usr = u.user_model2(tid, bid, cid, idate, rdate) query = "insert into trans values(%s, %s, %s, %s, %s)" values = (usr.get_tid(), usr.get_bid(), usr.get_cid(), usr.get_idate(), usr.get_rdate()) db.DBConnect().insert(query, values) self.updateqty(self.e2.get())
def __init__(self, root): """ Function to configure root window """ self.root = root self.root.geometry("700x400+0+0") self.root.title("Bought CD List") self.Bg_pic() self.query = "SELECT * FROM trans" self.w = Listbox(self.canvas, width=35, height=14, bg='#000000', fg="#ffffff") self.w.pack() rows = db.DBConnect().view(self.query) empt_list = [] for row in rows: empt_list.append(row[0]) self.sorted = self.mergesort(empt_list) print(self.sorted) i = 0 for i in self.sorted: for row in rows: if i == row[0]: self.w.insert(i, row) i += 1 self.b1 = Button( self.root, text="Search", font="arial 20 bold", command=lambda: self.search(rows, self.sorted, int(self.e1.get())), bg="#ffffff", fg="#000000") self.e1 = Entry(self.root, width=30) self.b1.place(x=285, y=320) self.e1.place(x=255, y=280)
def updateqty(self, id): self.db = db.DBConnect() query = "update cds set Quantity=Quantity-1 where id=%s" values = (int(self.e2.get()), ) self.db.update(query, values)