def generate_composer(fields, current_row): composer_values = {} t = ws.cell(column=(fields.index('composer')), row=current_row).value fname = t.split(', ')[1] lname = t.split(', ')[0] title = "{0} {1}".format(fname, lname) try: # If Composer exists, skip it Composer.objects.get(title__iexact=title) except Composer.DoesNotExist: # If Composer doesn't exist, make it for field in COMPOSER_FIELDS: cell_value = ws.cell(column=(fields.index(field)), row=current_row).value composer_values[field] = cell_value new_composer = Composer(title=title, first_name=fname, last_name=lname) new_composer.save() print("Composer is not in data set - New Composer created: {0}".format(title)) return return
from mpclorchestration.models import Composer, Movement, Piece beethoven = Composer( title="Ludwig van Beethoven", first_name="Ludwig van", last_name="Beethoven", birth_country=" ", birth_year=0, death_year=1, ) beethoven.save() borodin = Composer( title="Alexander Borodin", first_name="Alexander", last_name="Borodin", birth_country=" ", birth_year=0, death_year=1, ) borodin.save() dindy = Composer( title="Vincent D'Indy", first_name="Vincent", last_name="D'Indy", birth_country=" ", birth_year=0, death_year=1 ) dindy.save() debussy = Composer( title="Claude Debussy", first_name="Claude", last_name="Debussy", birth_country=" ", birth_year=0, death_year=1 ) debussy.save() haydn = Composer( title="Joseph Haydn", first_name="Joseph", last_name="Haydn", birth_country=" ", birth_year=0, death_year=1 )