def update_brand(name, name_e, des_e):
res = dc.execute("SELECT * FROM brands WHERE name = '%s'" % name)
dc.execute(
"UPDATE brands SET name = '%s', description = '%s' WHERE id = %d" %
(name_e, des_e, res[0][0]))
return res
def add_product_to_alias_merchant(product_id, merchant_alias_id, user_id=35, source='mass'):
delete_product_from_alias_merchant_by_product_id(product_id)
insert_product = "INSERT INTO product_merchant_alias (product_id, merchant_alias_id, user_id, created_at, source) \
VALUES \
(%d, %d, %d, '0000-00-00 00:00:00', '%s')" % (product_id, merchant_alias_id, user_id, source)
dc.execute(insert_product)
rows = dc.execute("SELECT * FROM product_merchant_alias WHERE product_id = %d" % product_id)
product_merchant_alias_id = rows[0][0]
return product_merchant_alias_id
def create_alias_merchant(name, merchant_code, user_id=35):
delete_alias_merchant_by_merchant_code(merchant_code)
insert_alias_merchant = "INSERT INTO merchant_alias (name, merchant_code, user_id, created_at) \
VALUES \
('%s', '%s', %d, '0000-00-00 00:00:00')" % (name, merchant_code, user_id)
dc.execute(insert_alias_merchant)
rows = dc.execute("SELECT * FROM merchant_alias WHERE merchant_code = '%s'" % merchant_code)
alias_id = rows[0][0]
return alias_id
def delete_collection_by_category_id(category_id):
rows = dc.execute("SELECT * FROM collections WHERE category_id = '%s'" %
category_id)
if len(rows) == 0:
return
collection_id = rows[0][0]
delete_collection_by_collection_id(collection_id)
def delete_collection_by_collection_id(collection_id):
dc.execute(
"DELETE FROM translates where languagable_id=%d and languagable_type='Collection'"
% collection_id)
dc.execute("DELETE FROM apps_collections WHERE collection_id = %d" %
collection_id)
dc.execute("DELETE FROM collections WHERE id = %d" % collection_id)
dc.execute("DELETE FROM product_collections WHERE collection_id = '%s'" %
collection_id)
def create_collection(parent_id, pkey, name, slug, is_category, category_id,
pds_collection):
delete_collection_by_category_id(category_id)
insert_collections = "INSERT INTO collections (parent_id,pkey,attachment_id,name,slug,is_category,collection_type,category_id,created_at,updated_at,deleted_at,pds_collection) \
VALUES \
(%d, %d, NULL, '%s', '%s', '%s', 'default', '%s', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '%s')" % (
parent_id, pkey, name, slug, is_category, category_id, pds_collection)
dc.execute(insert_collections)
rows = dc.execute("SELECT * FROM collections WHERE category_id = '%s'" %
category_id)
colId = rows[0][0]
insert_translation = "INSERT INTO translates (locale, languagable_id,languagable_type,text,title,name,description,key_feature,body,unit_type,caption,advantage) \
VALUES \
('en_US', %d, 'Collection', NULL, NULL, '%s', NULL, NULL, NULL, NULL, NULL, NULL)" % (
colId, name)
dc.execute(insert_translation)
insert_app_collections = "INSERT INTO apps_collections (collection_id, app_id, `order`) \
VALUES (%d, 1, NULL)" % colId
dc.execute(insert_app_collections)
return colId
def delete_product_from_alias_merchant_by_product_id(product_id):
rows = dc.execute("SELECT * FROM product_merchant_alias WHERE product_id = %d" % product_id)
if len(rows) == 0:
return
product_merchant_alias_id = rows[0][0]
delete_product_from_alias_merchant_by_id(product_merchant_alias_id)
def delete_product_from_alias_merchant_by_id(product_merchant_alias_id):
dc.execute("DELETE FROM product_merchant_alias WHERE id = %d" % product_merchant_alias_id)
def delete_alias_merchant_by_merchant_code(merchant_code):
rows = dc.execute("SELECT * FROM merchant_alias WHERE merchant_code = '%s'" % merchant_code)
if len(rows) == 0:
return
alias_id = rows[0][0]
delete_alias_merchant_by_id(alias_id)
def delete_alias_merchant_by_id(alias_id):
dc.execute("DELETE FROM merchant_alias WHERE id = %d" % alias_id)
def get_alias_merchant():
rows = dc.execute("SELECT id FROM merchant_alias WHERE deleted_at is null")
if len(rows) == 0:
return
alias_id = rows[0][0]
return alias_id
def delete_brand_by_brand_id(brand_id):
dc.execute("DELETE FROM brands where id=%d " % brand_id)