if __name__ == '__main__':
log = open('/home/thayes/Projects/FiLTH/logs/MovieCrewTest.log', 'w')
movieCrew = None
try:
movieCrew = MovieCrew('/home/thayes/Projects/FiLTH/sql/worked_on.sql', '/home/thayes/Projects/FiLTH/sql/crew_person.sql', log)
movies = [(1063, 'Michael Clayton', 2007), (792, 'Il Postino', 1997), (1460, 'Shawshank', 1994)]
for movie in movies:
movieCrew.promptUserForCrewPerson(movie[0], movie[1], movie[2])
except QuitException:
print '\nQUITTING\n'
except Exception as e:
print '\n***EXCEPTION!***'
traceback.print_exc()
finally:
if movieCrew:
if movieCrew.hasInserts():
while True:
response = raw_input('\nThere are still unwritten sql insert statements. Write them out? ').lower()
if response not in ['y','n']:
print "Only 'y'/'n'\n"
continue
if response == 'y':
movieCrew.writeCrewInsertsToFile(open('/home/thayes/Projects/FiLTH/sql/crew_person.sql', 'a'))
movieCrew.writeWorkedOnInsertsToFile(open('/home/thayes/Projects/FiLTH/sql/worked_on.sql', 'a'))
break
else:
break
movieCrew.close()
log.close()
movieTagger.promptUserForTag(movie['mid'], movie['title'], movie['year'])
crewHandler.promptUserForCrewPerson(movie['mid'], movie['title'], movie['year'])
except QuitException, KeyboardInterrupt:
pass
except Exception:
traceback.print_exc(file=logger)
traceback.print_exc(file=sys.stdout)
finally:
if movieTagger.hasInserts():
while True:
response = raw_input('\n**WARNING: There are still unwritten tag sql insert statements. Write them out? ').lower()
if response not in ['y','n']:
print "Only 'y'/'n'\n"
continue
if response == 'y':
movieTagger.writeTagInsertsToFile(tagFile)
movieTagger.writeTagGivenToInsertsToFile(tagGivenToFile)
break
if crewHandler.hasInserts():
while True:
response = raw_input('\n**WARNING: There are still unwritten crew sql insert statements. Write them out? ').lower()
if response not in ['y','n']:
print "Only 'y'/'n'\n"
continue
if response == 'y':
crewHandler.writeCrewInsertsToFile(crewpersonFile)
crewHandler.writeWorkedOnInsertsToFile(workedOnFile)
break
quit(lastProcessed)
closeFiles()