def delete_page(profile, bookname, program, specific, db=None):
'''Delete a page from a workbook'''
pagename = name_from_kwrds(profile, bookname, program, specific)
#~ for note in note_references.values():
#~ if note.page.Name == pagename:
#~ note.toplevel.destroy()
condition = "where Name == '{0}'".format(pagename)
dbtools.deleteIt('Pages', condition, db=db)
def delete_workbook(name,
widgettype=False,
profile=None,
db=None): # tbd PROFILE
'''
either user entered name and widget type/archetype or
pass in the book name as name
Tbd give the option to ssave old pages or move to another
workbook or sth...?
'''
assert profile
if widgettype:
bookname = make_bookname(name, widgettype, db=db)
else:
bookname = name
# Close any open windows
# for note in note_references.values():
# if note.page.Bookname == bookname:
# note.toplevel.destroy()
condition = "where Name == '{0}' and Profile == '{1}'"\
.format(bookname, profile)
dbtools.deleteIt('Books', condition, db=db)
condition = "where Bookname == '{0}' and Profile =='{1}'"\
.format(bookname, profile)
# TBD throws no error if name doesn't exist
dbtools.deleteIt('Hotkeys', condition, db=db)
dbtools.deleteIt('Pages', condition, db=db)
def delete_profile(profile, db=None):
condition = "where Name == '{0}'".format(profile)
dbtools.deleteIt('Profiles', condition, db=db)