def ev_delete_item(self):
indices = self.item_list.curselection()
index = int(indices[0]) if indices else 0
item = self.items[index]
data.delete_item(item[0])
self.items = data.get_items()
self.populate_item_list()
def evDeleteItem(self):
indices = self.itemList.curselection()
index = int(indices[0]) if indices else 0
item = self.items[index]
data.delete_item(item[0])
self.items = data.get_items()
self.populateItemList()
def show_inventory():
lendydata.initDB()
allItems = lendydata.get_items()
inventory = [dict(zip(['name','description'],[item[1],item[2]]))
for item in allItems]
return render_template('items.html', items=inventory)
def show_inventory():
lendydata.initDB()
allItems = lendydata.get_items()
inventory = [dict(zip(['name', 'description'], [item[1], item[2]]))
for item in allItems]
return render_template('items.html', items=inventory)
def show_inventory():
get_db()
all_items = lendydata.get_items()
# 创建了一个在网站中使用的字段名和值的字典,将这个字典传入模版中并填充内容.
inventory = [
dict(zip(["name", "description"], [item[1], item[2]]))
for item in all_items
]
return render_template("items.html", items=inventory)
def evNewItem(self):
dlg = od.OptionsDialog(
top, (["Name", ""], ["Description", ""], ["Owner", ""],
["Price", ""], ["Condition", ""]))
if dlg.changed:
ownerID = self.get_member_id(dlg.options[2][1])
data.insert_item(dlg.options[0][1], dlg.options[1][1], ownerID,
int(dlg.options[3][1]), dlg.options[4][1])
self.items = data.get_items()
self.populateItemList()
def __init__(self, root):
self.isDirty = False
self.top = root
root['menu'] = self.buildMenus(root)
mainWin = self.buildNoteBook(root)
mainWin.pack(fill='both', expand=True)
self.top.protocol('WM_DELETE_WINDOW', self.evClose)
self.top.title('Lending Library')
data.initDB() # use default file
self.items = data.get_items()
self.members = data.get_members()
self.populateItemList()
self.populateMemberList()
def __init__(self, root):
self.is_dirty = False
self.top = root
root["menu"] = self.build_menus(root)
main_win = self.build_notebook(root)
main_win.pack(fill="both", expand=True)
self.top.protocol("WM_DELETE_WINDOW", self.ev_close)
self.top.title("Lending Libaray")
data.init_db() # use default file
self.items = data.get_items()
self.members = data.get_members()
self.populate_item_list()
self.populate_member_list()
def __init__(self, root):
self.isDirty = False
self.top = root
root['menu'] = self.buildMenus(root)
mainWin = self.buildNoteBook(root)
mainWin.pack(fill='both', expand=True)
self.top.protocol('WM_DELETE_WINDOW', self.evClose)
self.top.title('Lending Library')
data.initDB() # use default file
self.items = data.get_items()
self.members = data.get_members()
self.populateItemList()
self.populateMemberList()
def __init__(self, root):
self.is_dirty = False
self.top = root
root["menu"] = self.build_menus(root)
main_win = self.build_notebook(root)
main_win.pack(fill="both", expand=True)
self.top.protocol("WM_DELETE_WINDOW", self.ev_close)
self.top.title("Lending Libaray")
data.init_db() # use default file
self.items = data.get_items()
self.members = data.get_members()
self.populate_item_list()
self.populate_member_list()
def ev_new_item(self):
dlg = od.OptionsDialog(top, (
["Name", ""],
["Description", ""],
["Owner", ""],
["Price", ""],
["Condition", ""]
))
if dlg.changed:
owner_id = self.get_member_id(dlg.options[2][1])
data.insert_item(dlg.options[0][1], dlg.options[1][1], owner_id, int(dlg.options[3][1]), dlg.options[4][1])
self.items = data.get_items()
self.populate_item_list()
def evEditItem(self, event=None):
# get selected member
indices = self.itemList.curselection()
index = int(indices[0]) if indices else 0
item = self.items[index]
ownerID = item[3]
ownerName = data.get_member_name(ownerID)
dlg = od.OptionsDialog(top, (["Name", item[1]], [
"Description", item[2]
], ["Owner", ownerName], ["Price", item[4]], ["Condition", item[5]]))
if dlg.changed:
if dlg.options[2][1] != ownerName: # its changed
ownerID = self.get_member_id(dlg.options[2][1])
data.update_item(item[0],
dlg.options[0][1], dlg.options[1][1], ownerID,
int(dlg.options[3][1]), dlg.options[4][1])
self.items = data.get_items()
self.populateItemList()
def ev_edit_item(self, event=None):
# get selected member
indices = self.item_list.curselection()
index = int(indices[0]) if indices else 0
item = self.items[index]
owner_id = item[3]
owner_name = data.get_member_name(owner_id)
dlg = od.OptionsDialog(top, (
["Name", item[1]],
["Description", item[2]],
["Owner", owner_name],
["Price", item[4]],
["Condition", item[5]]))
if dlg.changed:
if dlg.options[2][1] != owner_name: # its changed
owner_id = self.get_member_id(dlg.options[2][1])
data.update_item(item[0], dlg.options[0][1], dlg.options[1][1], owner_id, int(dlg.options[3][1]),
dlg.options[4][1])
self.items = data.get_items()
self.populate_item_list()
def show_inventory():
get_db()
all_items = lendydata.get_items()
# 创建了一个在网站中使用的字段名和值的字典,将这个字典传入模版中并填充内容.
inventory = [dict(zip(["name", "description"], [item[1], item[2]])) for item in all_items]
return render_template("items.html", items=inventory)
__author__ = 'Stuart'
"""
any time there is a print, if in console don't print
it would just return normally
"""
import lendydata as ld
ld.initDB()
print(ld.get_members())
print(ld.get_items())
ld.insert_item('Python Projects','Book',6,30,'Excellent')
###
# 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)
