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