def create_category(category_name, parent_category_name):
try:
parent_category = Category.objects.filter(name=parent_category_name).get()
category = Category(name=category_name,parent_id=parent_category.id)
category.save()
children_ids = json.loads(parent_category.children_ids)
children_ids.append(category.id)
parent_category.children_ids = json.dumps(children_ids)
parent_category.save()
# print "created category " + category_name.encode("ascii","ignore")
return category
except:
# print " couldn't find parent category "+ parent_category_name
return None
products = Product.objects.all()
for product in products:
product.delete()
attributes = Attribute.objects.all()
for attribute in attributes:
attribute.delete()
categories = Category.objects.all()
for category in categories:
category.delete()
objects = j['categories']
for object in objects:
db_object = Category()
db_object.__dict__.update(object)
db_object.save()
objects = j['products']
for object in objects:
db_object = Product()
db_object.__dict__.update(object)
db_object.name = db_object.name.encode("ascii","ignore")
db_object.save()
objects = j['attributes']
for object in objects:
db_object = Attribute()
db_object.__dict__.update(object)
db_object.save()
for key in products_json.keys():
product = products_json[key]
product["name"] = product["name"].encode('utf8')
categories_json = json.loads(open('categories.json','r').read())
Category.objects.all().delete()
Product.objects.all().delete()
for category in categories_json.keys():
try:
Category.objects.get(name=categories_json[category])
except ObjectDoesNotExist:
c = Category(name = categories_json[category].strip())
c.save()
category_stack = []
for product_key in products_json.keys():
product = products_json[product_key]
prev_category = None
try:
product_categories = product['categories']
for category in product_categories:
try:
c = Category.objects.get(name=category)
except ObjectDoesNotExist:
c = Category(name=category)
c.save()
