def add_product(): from database import Product, Supplier, Supplier_product #try: p_category = request.form['category'] p_sub_category = request.form['sub_category'] p_name = request.form['name'] p_price = request.form['price'] gst = request.form['gst'] product_base_margin = request.form['base_margin'] p_sale_price = request.form['sale_price'] sid = request.form['suppplier'] pid = Product.query.order_by(desc(Product.pid)).limit(1).all() pid = pid[0] pid = pid.pid prefix = pid[:1] postfix = int(pid[1:]) postfix = postfix + 1 pid = prefix + str(postfix) #Create a product object to insert into the Product table product = Product(pid, p_category, p_sub_category, p_name, p_price,product_base_margin, p_sale_price, sid) #get supplier obj from database supp = Supplier.query.filter_by(sid = sid).first() supplier_product = Supplier_product( product, supp) db.session.add(product) db.session.add(supplier_product) db.session.commit() return 'product record added successfully'
def process_item(self, item: OlxProduct, spider):
product = Product(title=item.get('title'),
olx_id=item.get('id'),
keyword=item.get('keyword'),
description=item.get('description'),
price=item.get('price'),
city=item.get('city'),
zip=item.get('zip'),
region=item.get('region'),
image=item.get('image'),
url=item.get('url'),
date_time=item.get('date_time'),
is_new=not item.get('is_new'))
is_already_registered = session \
.query(func.count(Product.id)) \
.filter(Product.olx_id == product.olx_id) \
.scalar() != 0
if is_already_registered:
logging.warning("Skipping product, already inserted")
raise DropItem()
session.add(product)
session.commit()
return item
def add_product(description, product_id=None, status='in_stock'):
if not product_id:
product_id = uuid4().hex
db.add(
Product(product_id=product_id,
description=description,
creator_id=get_config(key='node_identifier'),
status=status))
db.commit()
def _cmd_add(self, internal_name):
market_name = rlinput("销售品名(打在检验报告上的名字，例如‘8G04建业’的销售名为8G 04):\n >>>")
conf = self._input_kind()
viscosity = self._input_number("粘度值:")
viscosity_width = self._input_number("粘度上下幅度:")
product_obj = Product(internal_name=internal_name,
market_name=market_name,
template=conf['slug'],
viscosity=int(viscosity),
viscosity_width=int(viscosity_width))
db.insert_product(product_obj)
db.insert_product_to_xlsx(product_obj,
'%s/data/database.xlsx' % self.app_path,
'products')
print("已经插入新的条目到products数据表")
return product_obj
def createProduct(self, product, user):
DBSession = sessionmaker(bind=engine)
session = DBSession()
catalog = session.query(Catalog).filter_by(
id=product['catalog_id']).one()
newProduct = Product(images=product['images'],
header=product['header'],
model=product['model'],
price=product['price'],
brand=product['brand'],
description=product['description'],
specs=product['specs'],
catalog_id=catalog.id,
user_id=user)
try:
session.add(newProduct)
session.commit()
return "New product created"
except exc.SQLAlchemyError:
return "Product not created"
def init_product_data(file, sheet):
""" 从 database.xlsx 读取数据 """
wb = load_workbook(filename=file)
ws = wb[sheet]
for row in ws['A2:J{}'.format(ws.max_row)]:
(internal_name, template, viscosity, viscosity_width, market_name,
category, part_a, part_b, ratio,
color) = [cell.value for cell in row]
if internal_name:
product = Product(internal_name=internal_name,
template=template,
viscosity=viscosity,
viscosity_width=viscosity_width,
market_name=market_name,
category=category,
part_a=part_a,
part_b=part_b,
ratio=ratio,
color=color)
db_session.add(product)
db_session.commit()
print("插入了 %s 行数据到data/database.sdb3." % str(ws.max_row - 1))
def post(self):
"""New Shops"""
product = Product(id=str(uuid.uuid4()), **api.payload)
save(product)
return product, 201
def post(self):
self.set_header("Content-Type", "application/json")
to_add = self.json_args["title"]
new_product = Product(title=to_add)
new_product.add()
self.write('{"message":" Added: ' + to_add + '"}')
print(IOError)
# Add products
for product in products_dict:
product_query = session.query(Product).filter_by(
model=product['model']).count()
if product_query:
print("product exists")
continue
else:
try:
catalog_id = session.query(Catalog).filter_by(
name=product['category']).one().id
images = ""
for i in product['images']:
images += i + ","
session.add(
Product(images=images,
header=product['header'],
model=product['model'],
price=product['price'],
brand=product['brand'],
description=product['description'],
specs=product['specs'],
catalog_id=catalog_id,
user_id=1))
session.commit()
print("Model added %s") % product['model']
except IOError:
print(IOError)
