def refresh(event):
"""
Dynamically update table as user type in the query
:param event:
KeyRelease event binded to Entry widget
"""
mc.table_data = show_within(entry.get())
def delete_button_func():
"""
delete item from database
"""
delete_vehicle = []
for val in mc.selected_rows:
result = delete_item(val[0])
delete_vehicle.append(result)
if result is not None:
messagebox.showinfo(
"Deleted item",
"An item has been succesfully deleted : {}".format(delete_vehicle))
mc.table_data = show_within(entry.get())
def callback():
"""
update database with boolean values.
currently partially managed by model.py
"""
try:
update = update_checks(vehicle, expiry, informed.get(),
inspected.get(), renewed.get())
if update is not None:
show_info(update)
mc.table_data = show_within(entry.get())
except ValueError:
show_info("Invalid input, Number only la!!!")
update.config(state=NORMAL)
pass
def callback():
"""
update database with boolean values.
currently partially managed by model.py
"""
try:
update = update_checks(
vehicle, expiry, informed.get(), inspected.get(), renewed.get())
if update is not None:
messagebox.showinfo("Update","Some informations have been updated : {}".format(update))
mc.table_data = show_within(entry.get())
except ValueError:
messagebox.showerror("Invalid input","The value you entered in incorrect. It must be a number")
update.config(state=NORMAL)
pass
def callback():
"""
update database with boolean values.
currently partially managed by model.py
"""
try:
updated_vehicle = []
for val in mc.selected_rows:
update = update_checks(val[0], val[1], val[2], val[3], val[4])
updated_vehicle.append(update)
if update is not None:
messagebox.showinfo(
"Update", "Some informations have been updated : {}".format(
updated_vehicle))
mc.table_data = show_within(entry.get())
except ValueError:
messagebox.showerror(
"Invalid input",
"The value you entered in incorrect. It must be a number")
update.config(state=NORMAL)
pass
select_mode="extended", #browse
cell_anchor="center",
height=20)
scrollbar = Scrollbar(bodyframe)
scrollbar.config(command=mc.interior.yview, activebackground=btn_colour)
scrollbar.grid(row=1, column=7, sticky=N + S)
mc.interior.config(yscrollcommand=scrollbar.set)
mc.interior.grid(row=1, column=0, columnspan=6, sticky=N + S + E + W)
entry = Entry(bodyframe)
entry.insert(0, "30")
entry.focus_set()
mc.table_data = show_within(entry.get())
chkbox1 = Checkbutton(bodyframe,
text="Informed",
variable=informed,
bg=bg_colour)
chkbox2 = Checkbutton(bodyframe,
text="Inspected",
variable=inspected,
bg=bg_colour)
chkbox3 = Checkbutton(bodyframe,
text="Renewed",
variable=renewed,
bg=bg_colour)