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)