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
)
