def evDeleteMember(self):
indices = self.memberList.curselection()
index = int(indices[0]) if indices else 0
mbr = self.members[index]
data.delete_member(mbr[0])
self.members = data.get_members()
self.populateMemberList()
def ev_delete_member(self):
indices = self.member_list.curselection()
index = int(indices[0]) if indices else 0
mbr = self.members[index]
data.delete_member(mbr[0])
self.members = data.get_members()
self.populate_member_list()
###
# this should not have worked..... BUT IT DID. WTF PRAGMA?!>!?
###
ld.insert_member('Alan','*****@*****.**')
print(ld.get_members())
ld.insert_item('Python Projects','Book',6,30,'Excellent')
ld.get_items()
ld.update_item(7,Price=25)
ld.get_item_details(7)
ld.get_member_name(6)
ld.update_member(6,Name='Alan Gould')
ld.get_member_details(6)
ld.delete_member(6) # this also shouldn't work due to referential integrity, but does...
ld.delete_item(7)
ld.delete_member(6)
ld.cursor.execute("""
select * from item
where OwnerID in (select id from member where name like '%e%')
""").fetchall()
ld.cursor.execute("""
select * from item
where ownerid not in (select id from member where name like '%e%')
""").fetchall()
ld.get_member_name(4)
