def add_product(name, price, picture_link, description): product_object = Product(name=name, price=price, picture_link=picture_link, description=description) session.add(product_object) session.commit()
async def fetch_async(url): async with aiohttp.ClientSession() as session: async with session.get(url) as resp: print(resp.status) data = await resp.text() p = Product() p.parse(data) print(p.__dict__) return p
def add_Product(name, price, Picture_link, Description): session = con() Product_object = Product( name=name, price=price, Picture_link=Picture_link, Description=Description) session.add(Product_object) session.commit()
def add_product(name, price, picture_link, description): session = create_session() product_object = Product(name=name, price=price, picture_link=picture_link, description=description) session.add(product_object) session.commit() session.close()
def generate_add_product(name, price, seller, category, new_count): for product_id, value_products in products.items(): if value_products[0].name == name: value_products[1] += new_count return value_products[0] new_product = Product(name, price, seller, category) products[new_product.id] = [new_product, new_count] return new_product
def add_product(name, price, Picture, Description): product_object = Product( name=name, price=price, Picture =String, Description =Description) session.add(product_object) session.commit()
def create_product(): print('Existing products:') options_list(Product) name = input("\nName: ") price = input("Price: ") product = Product(name=name, price=price) session.add(product) session.commit() print('created!\n')
def add_product(id, name, price, price_link, description ): product_object = Product( ID=id, Name=name, Price=price, price_link=price_link, Description=discription,) session.add(product_object) session.commit()
def add_product(name, price, Picture_Link,Description): product = Product( name=name, price=price, Picture_Link=Picture_Link, Description=Description) session.add(product) session.commit()
def create_product(product_name, session=None): product_name = product_name.upper() products = session.query(Product).filter(Product.id == product_name).all() if len(products): return com.error(com.WARN_EXISTING_CATEGORY) else: p = Product(id=product_name) session.add(p) session.commit() return com.success()
def buy_intent(product_name): products = Product(context.System.apiAccessToken) logger.info("PRODUCT: {}".format(product_name)) buy_card = render_template('buy_card', product=product_name) productId = products.productId(product_name) if productId is not None: session.attributes[PRODUCT_KEY] = productId else: return statement("I didn't find a product {}".format(product_name)) raise NotImplementedError() return buy(productId).simple_card('Welcome', question_text)
def create_product(name, brand, product_categorization, image=''): """Create, add to db, and return a new product.""" product = Product(name=name, brand=brand, product_categorization=product_categorization, image=image) db.session.add(product) db.session.commit() return product
def products_to_db(filename): """Reads the items.json file and stores all the items in the kart database.""" with open(filename, 'r') as filename: for item in json.load(filename): product = Product(name=item) db.session.add(product) print 'Now committing!' db.session.commit() print 'Committed!'
def refund_intent(product_name): refund_card = render_template('refund_card') logger.info("PRODUCT: {}".format(product_name)) products = Product(context.System.apiAccessToken) productId = products.productId(product_name) if productId is not None: session.attributes[PRODUCT_KEY] = productId else: raise NotImplementedError() return refund(productId)
def load_products(self, products_file): items = FileUtil.load_csv(products_file) for pid, name, tname, tid, year, pdf, image in items: self.products.append( Product(product_id=pid, name=name, theme=tid, store_folder=self.store_folder, theme_name=tname, launch_year=year, pdf_locations=[pdf], images=[image]))
def load_products(): """Load products into database""" print "Products" product_id = 0 with open('items.json') as file: for title in file: title = title.rstrip().strip(',') product = Product(product_id=product_id, title=title) product_id += 1 db.session.add(product) db.session.commit()
def create_product(form): try: with create_session() as s: p = Product(form) if _get_products([p.sku], s): return 'Existed' else: s.add(p) return p.sku except: raise return 'Failed'
def create_product(brand, name, category, tag, img_path): """Create and return a new product.""" product = Product(brand=brand, name=name, category=category, tag=tag, img_path=img_path) db.session.add(product) db.session.commit() return product
def completed(payload, name, status, token): products = Product(context.System.apiAccessToken) logger.info('on-purchase-completed {}'.format( request)) logger.info('payload: {} {}'.format(payload.purchaseResult, payload.productId)) logger.info('name: {}'.format(name)) logger.info('token: {}'.format(token)) logger.info('status: {}'.format( status.code == 200)) product_name = products.productName(payload.productId) logger.info('Product name'.format(product_name)) if status.code == '200' and ('ACCEPTED' in payload.purchaseResult): return question('To listen it just say - play {} '.format(product_name)) else: return question('Do you want to buy another product?')
def create_product_entity(link, currency, current, history, meta): product = Product.get_by_id(id=meta["asin"]) if product is not None: return product.key else: product = Product(id=meta["asin"], link=link, currency=currency, current=current, history=history, meta=meta) key = product.put() return key
def post_add_product(): form = AddProductForm() if form.validate_on_submit(): id__ = max(all_products, key=lambda x: x.get('id_'), default={}).get('id_', 0) + 1 product_obj = Product(id__, form.name.data, form.description.data, form.price.data, secure_filename(form.image_file.data.filename)) all_products.append(product_obj.__dict__) f = form.image_file.data f.save(os.path.join(save_img_dir, secure_filename(f.filename))) return redirect(url_for('products.get_all_products')) return render_template('add_product.html', form=form)
def post(self): json_data = request.get_json(force=True) if not json_data: return {'message': 'No input data provided'}, 400 payload = products_schema.load(json_data) for item in payload: product = Product(product_id=item['product_id'], product_price=item['product_price'], product_name=item['product_name'], size=item['size']) db.session.add(product) db.session.commit() products = Product.query.all() return products_schema.dump(products)
def save_product_info(self, productno, link, title, category): if self.get_product_id(productno): session = Session() insert_product = Product(ProductNo=productno, Link=link, Name=title, Category=category, TrainTest='train', Enrolltime=crawltime) session.add(insert_product) session.commit() session.close() else: self.update_product_info(productno, link, title, category)
def get_product(save_db=False): query = """ SELECT id, name, url FROM categories WHERE parent_id BETWEEN 100 AND 113; """ try: cur.execute(query) except Exception as err: print('ERROR BY SELECT TABLE', err) rows = cur.fetchall() for i in rows: id = i[0] name = " ".join(i[1].strip().split()[:-1]) url = i[2].strip() for page in range(1,4): page_url = url + "&page=" + str(page) # print(page_url) page_html = get_url(page_url) try: products_wrapper_div = page_html.find_all('div', class_='product-box-list')[0] except Exception as err: print('ERROR BY DIV FINDALL: ', err) if products_wrapper_div: products_div = products_wrapper_div.find_all('div', class_='product-item') result = [] if len(products_div) > 0: for product_div in products_div: product_id = None title = product_div.a['title'] url = product_div.a['href'] img_url = product_div.img['src'] regular_price = product_div.find('span', class_='price-regular').text final_price = product_div.find('span', class_='final-price').text.split()[0] sale_tag = product_div.find('span', class_='sale-tag').text comment = product_div.find('p', class_='review').text.split()[0] + ' review(s))' if product_div.find('span', class_='rating-content'): rating = product_div.find('span', class_='rating-content').find('span')['style'].split(":")[-1] else: rating = '0%' product = Product(product_id, name, url, img_url, regular_price, final_price, sale_tag, comment, rating, id) if save_db: product.save_into_db() print(f'SAVE {title} INTO DB') result.append(product) else: break
def new_product(): print "\n>> New product:\n" # print host name = raw_input(" Product name: ") # print name alias = raw_input(" Product alias: ") # print pwd pdir = raw_input(" Product dir: ") pd = Product.Product() pd.set("name", name) pd.set("alias", alias) pd.set("dir", pdir) executor.prod_add(pd) print "\n Product created."
def completed(payload, name, status, token): products = Product(context.System.apiAccessToken) logger.info("on-purchase-completed {}".format(request)) logger.info("payload: {} {}".format(payload.purchaseResult, payload.productId)) logger.info("name: {}".format(name)) logger.info("token: {}".format(token)) logger.info("status: {}".format(status.code == 200)) product_name = products.productName(payload.productId) logger.info("Product name".format(product_name)) if status.code == "200" and ("ACCEPTED" in payload.purchaseResult): return question( "To listen it just say - play {} ".format(product_name)) else: return question("Do you want to buy another product?")
def load_products(filename): """Load products from json-like file into database.""" print "==================" print "loading products" f = open(filename) for line in f: # Each line is a dictionary containing info on a product p = eval(line) # categories are stored in double brackets for weird semi-json reasons categories = p['categories'][0] for c in categories: # Loop through each of the product's categories, add to the # categories table if it's not there n_results = Category.query.filter_by(cat_name=c).count() if n_results == 0: category = Category(cat_name=c) db.session.add(category) db.session.commit() # Pull out the product's categories again as a list of Category objects category_objects = Category.query.filter( Category.cat_name.in_(categories)).all() title = p.get('title') if title: title = H.unescape(title) description = p.get('description') if description: description = H.unescape(description) # Instantiate a product object product = Product(asin=p['asin'], title=title, description=description, price=p.get('price'), image=p.get('imUrl'), categories=category_objects) db.session.add(product) db.session.commit()
def read(self): products = [] with open(self.productsFile, 'r') as f: reader = csv.reader(f) try: for productRow in reader: products.append(Product( name=productRow[0], category=productRow[1], price=productRow[2], )) except csv.Error as e: sys.exit( 'file %s, line %d: %s' % ( self.productsFile, reader.line_num, e)) return products
def load_products2(): """Load products from u.products to database""" print('Products') file = open("seed_data/u.products2") for row in file: row = row.rstrip() product_category, product_type, product_route, product_img = row.split( " = ") url = 'https://data.energystar.gov/resource/' + product_route response = requests.get(url) data = response.json() top_3_products = [] #appends the keys & values for three products counter = 0 #ensures only three results index = 0 for product in data: #loops over json string if counter < 3: #if this is the most efficient product and there are less than three products in the list top_3_products.append( product['brand_name']) #add brand to product list top_3_products.append(product['model_number']) top_3_products.append('https://www.google.com/search?q=' + product['brand_name'] + '+' + product['model_number']) counter += 1 ##add one to the counter product_brand = top_3_products[0] product_model = top_3_products[1] product_link = top_3_products[2] product = Product(product_category=product_category, product_type=product_type, product_brand=product_brand, product_model=product_model, product_link=product_link, product_img=product_img) db.session.add(product) db.session.commit() index += 1 db.session.commit()
def create_product(self, to_add): session = self.Session() try: product = Product(product_name=to_add['productName'], description=to_add['description'], price=to_add['price']) self.add_object(product) session.commit() return product.to_json() except Exception as e: logging.error('*** Exception in create_product: %s' % e) session.rollback() raise finally: session.close()