def main():
# read the json data
with open('data.json') as json_data:
data = json.load(json_data)
cats = {}
i = 1
# find the categories, and replace them with the
# new category id (created below)
for prod in data['data'].values():
if prod['category'] not in cats:
cats[prod['category']] = i
i += 1
prod['category'] = cats[prod['category']]
# create the categories
for cat_name, cat_id in cats.items():
new_cat = Category()
new_cat.id = cat_id
new_cat.title = cat_name
new_cat.save()
# create the products
for prod in data['data'].values():
p = Product()
p.name = prod['name']
p.description = prod['description']
p.price = prod['price']
p.filename = prod['filename']
p.category = Category.objects.get(id=prod['category'])
p.save()
def main():
with open('products.json') as json_file:
data = json.load(json_file)
products = data['products']
for p in products:
print(p['name'])
# category
cat, created = Category.objects.get_or_create(title=p['category'])
# product
if Product.objects.filter(name=['name']).count() == 0:
product = Product()
product.category = cat
product.name = p['name']
product.filename = p['filename']
product.id = int(p['id'])
product.description = p['description']
product.price = p['price']
product.save()
def main():
with open('products.json') as json_file:
data = json.load(json_file)
products = data['products']
cats = []
for prod in products:
if prod["category"] in cats:
dbcat = Category.objects.get(title=prod["category"])
print('skip')
else:
dbcat = Category()
dbcat.title = prod["category"]
dbcat.save()
cats.append(dbcat.title)
dbprod = Product()
dbprod.category = dbcat
dbprod.name = prod["name"]
dbprod.description = prod["description"]
dbprod.price = prod["price"]
dbprod.filename = prod["filename"]
dbprod.save()
def main():
with open('products.json') as json_file:
data = json.load(json_file)
products = data['products']
cats = []
for prod in products:
if prod['category'] not in cats:
cats.append(prod['category'])
for c in cats:
dbcat = Category()
dbcat.title = c
dbcat.save()
for prod in products:
dbprod = Product()
dbprod.name = prod['name']
dbprod.description = prod['description']
dbprod.filename = prod['filename']
dbprod.price = prod['price']
dbprod.category = Category.objects.get(title=prod['category'])
dbprod.save()
def main():
with open('products.json') as json_file:
data = json.load(json_file)
products = data['products']
cats = []
# Set up categories
for prod in products:
#dbcat = Category()
if prod['category'] not in cats:
cats.append(prod['category'])
for cat in cats:
dbcat = Category()
dbcat.title = cat
dbcat.save()
for prod in products:
#dbcat = Category()
dbprod = Product()
dbprod.name = prod['name']
dbprod.description = prod['description']
dbprod.price = prod['price']
dbprod.filename = prod['filename']
dbprod.category = Category.object.get(title=prod['category'])
# for cat in Category.object.all():
# if cat.title == prod['category']:
# dbprod.category = cat
dbprod.save()
for cat in Category.object.all():
print(cat.id, cat.title)
for prod in Product.object.all():
print(prod.id, prod.name, prod.category)
