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)