def addNewProduct():
current_id = get_jwt_identity()
img = request.json.get("image", None)
sellerid = request.json.get("sellerid", None)
productName = request.json.get("productname", None)
description = request.json.get("description", None)
category = request.json.get("category", None)
price = request.json.get("price", None)
item_status = request.json.get("itemstatus", None)
if not img:
return jsonify({"msg": "No image was uploaded!."}), 400
if not description:
return jsonify({"msg": "Please enter a valid description"}), 400
if not category:
return jsonify({"msg": "Please enter a valid category"}), 400
if not price:
return jsonify({"msg": "Please enter a valid price"}), 400
if not item_status:
return jsonify({"msg": "Please enter a valid item status"}), 400
else:
new_product = Product()
new_product.productName = productName
new_product.fk_id = sellerid
new_product.description = description
new_product.category = category
new_product.price = price
new_product.item_status = item_status
new_product.img = img
db.session.add(new_product)
db.session.commit()
return jsonify(
{"msg": "The product has being successfully registered."}), 200
def handle(self, *args, **options):
if len(ProductCount.objects.all()) < 1:
p = ProductCount.objects.create()
p.save()
with open(options["input"],"r") as f:
line = f.readline()
while line:
arr = line.split(";")
p = Product()
p.categoryId = int(arr[0])
p.name = arr[1]
p.description = arr[2]
p.price = int(arr[3]) * 20
p.image = arr[4]
p.cpu = arr[5]
p.camera = arr[6]
p.size = arr[7]
p.weight = arr[8]
p.display = arr[9]
p.battery = arr[10]
p.memory = arr[11]
p.rating = randint(35, 50)/10
p.reviews = randint(2, 5)
p.save()
line = f.readline()
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 get(self, request, *args, **kwargs):
if not Product.objects.all() or not Product.objects.all():
with open(settings.JSON_FILE) as f:
dict_data = json.load(f)
str_data = json.dumps(dict_data, ensure_ascii=False)
shop_names = []
# Get the first shop
first_split = str_data.split('{"')
second_split = first_split[1].split('": [')
first_shop = second_split[0]
shop_names.append(first_shop)
# Loop to get all the shop names and save to the database
shops_split = str_data.split('"}], "')
for shop in shops_split:
head, sep, tail = shop.partition('"')
if len(head) > 2:
shop_names.append(head)
for shop_name in shop_names:
shop_db = Shop()
shop_db.title = shop_name
shop_db.save()
print('Shop saved: ' + str(shop_db.title))
for product in dict_data[shop_name]:
product_db = Product()
product_db.shop_name = shop_db
product_db.title = product['title']
product_db.link = product['link']
product_db.description = product['description']
product_db.image_link = product['image_link']
product_db.save()
print('Product saved: ' + str(product_db.title))
return Response('Database migrated')
else:
return Response('Error')
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)
