def shredTTOTMs(Session): TTOTMlist = sheetpull() session = Session() delete_count = 0 for tband in TTOTMlist: name = cleanup(tband[0]) bands = session.query(band).filter(band.cleanname == name) gigs = session.query(gig).filter(gig.cleanname == name) for i in bands: session.delete(i) session.commit() delete_count += 1 for i in gigs: session.delete(i) session.commit() return delete_count
def get_TTOTM_bands(): TTOTMbands = sheetpull() print ('{0} total TTOTM tracks'.format(len(TTOTMbands))) return TTOTMbands