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()