def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for row in all_portfolio_rows():
subjects = []
category = None
if nullify(row[u'נושא']) != None:
for subject in html2text(row[u'נושא']).split(','):
if nullify(subject.strip()) != None:
subjects.append((orm.Subject.objects.get_or_create(name_he=subject.strip()))[0])
# subjects = [(orm.Subject.objects.get_or_create(name_he=subject.strip()))[0] for subject in html2text(row[u'נושא']).split(',')]
if nullify(row[u'קטגוריה']) != None:
clean_category = split_languages_from_string(row[u'קטגוריה'])
category = orm.Category.objects.get_or_create(
name_he=clean_category['he'],
defaults={'name_en': clean_category['en']}
)[0]
try:
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
except orm.Work.DoesNotExist:
pass
else:
work.category = category
work.subjects = subjects
work.save()
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for row in all_portfolio_rows():
try:
orm.Work(sidar_id=remove_file_extension(row['Filename'])).save()
except IntegrityError:
pass
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for row in all_portfolio_rows():
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
work.description_he = html2text(row[u'תאור']).strip()
work.description_en = html2text(row[u'Description']).strip()
work.save()
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for row in all_portfolio_rows():
country = nullify(row[u'ארץ'].strip())
if country != None:
matched_country = orm.Country.objects.get_or_create(name_he=country)[0]
else:
matched_country = None
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
work.country = matched_country
work.save()
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
# Build file path hash for importing images
# path_hash = dict()
# for root, dirs, files in os.walk(PORTFOLIO_CSV_ROOT):
# for filename in files:
# if filename.rpartition('.')[-1] == "jpg":
# path_hash[filename] = os.path.join(root, filename)
for row in all_portfolio_rows():
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
work.name_he = row[u'שם העבודה'].strip()
work.name_en = row['Document Title'].strip()
# work.raw_image = File(open(path_hash[row['Filename']]))
work.save()
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for row in all_portfolio_rows():
try:
designer = row[u'מעצב'].strip()
except KeyError:
print "No field called מעצב for the the current file."
designer = None
if designer:
designer = orm.Designer.objects.get_or_create(
name_he=designer,
defaults={'name_en': row['Designer']}
)[0]
try:
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
work.designer = designer
work.save()
except orm.Work.DoesNotExist:
pass
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for row in all_portfolio_rows():
try:
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
except orm.Work.DoesNotExist:
pass
else:
try:
work.size_as_text = clean(row[u'גודל'])
except KeyError:
pass
try:
work.publish_date_as_text = clean(row[u'תאריך'])
except KeyError:
pass
try:
if row[u'לקוח'] != '':
work.client = (orm.Client.objects.get_or_create(
name_he=clean(row[u'לקוח']),
defaults={'name_en': clean(row['Client'])}
))[0]
else:
work.client = None
except KeyError:
pass
try:
if row[u'מילות מפתח'] != '':
keywords = []
for keyword in [keyword.strip() for keyword in html2text(row[u'מילות מפתח']).split(',')]:
if keyword != '':
keywords.append((orm.Keyword.objects.get_or_create(name_he=keyword)[0]))
work.keywords = keywords
except KeyError:
pass
work.save()
def forwards(self, orm):
"Write your forwards methods here."
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
disciplines = orm.Discipline.objects.all()
for row in all_portfolio_rows():
filename = row['Filename']
if len(filename) < 2:
continue
if filename[1] != '-':
continue
matched_discipline = None
for discipline in disciplines:
if discipline.name_en[0] == filename[0]:
matched_discipline = discipline
if matched_discipline is None:
print ('WARNING: Could not find a matching discipline for work "%s".' % filename)
work = orm.Work.objects.get(sidar_id=remove_file_extension(row['Filename']))
work.discipline = matched_discipline
work.save()
