def insert_product_attribute_shop(c,
product_attribute_shop,
db=None,
default_on_value=None,
product_attribute_id=None,
mom_id=None):
product_shop_fields_with_id = m.PRODUCT_ATTRIBUTE_SHOP_FIELDS.copy()
product_shop_sql_fields_without_id = str(
queries.PRODUCT_ATTRIBUTE_SHOP_FIELDS_SQL_INSERT).replace(
'p_atr_shop.', '')
values = t.to_db_values(product_attribute_shop,
product_shop_fields_with_id,
defaults={
'unit_price_impact': 0,
'default_on': default_on_value,
'id_product_attribute': product_attribute_id,
'id_product': mom_id,
'price': 0
})
q = queries.INSERT_PRODUCT_ATTRIBUTE_SHOP_QUERY.format(
product_shop_sql_fields_without_id, values)
c.execute(q)
if db != None:
db.commit()
return c.lastrowid
def insert_product_shop(c, product_shop, db=None):
product_shop_fields_with_id = m.PRODUCT_SHOP_FIELDS.copy()
product_shop_sql_fields_without_id = str(queries.PRODUCT_SHOP_FIELDS_SQL_INSERT).replace('p_shop.', '')
values = t.to_db_values(product_shop, product_shop_fields_with_id)
q = queries.INSERT_PRODUCT_SHOP_QUERY.format(product_shop_sql_fields_without_id, values)
c.execute(q)
if db != None:
db.commit()
return c.lastrowid
def insert_product_lang(c, product_lang, db=None):
product_lang_fields_with_id = m.PRODUCT_LANG_FIELDS.copy()
product_lang_fields_with_id.append('id_product')
product_lang_sql_fields_without_id = str(queries.PRODUCT_LANG_FIELDS_SQL_INSERT).replace('p_lang.', '')
values = t.to_db_values(product_lang, product_lang_fields_with_id)
q = queries.INSERT_PRODUCT_LANG_QUERY.format(product_lang_sql_fields_without_id, values)
c.execute(q)
if db != None:
db.commit()
return c.lastrowid
def insert_product(c, product, db=None):
product_fields_without_id = m.PRODUCT_FIELDS.copy()
product_fields_without_id.remove('id_product')
product_sql_fields_without_id = str(queries.PRODUCT_FIELDS_SQL_INSERT).replace('`p.id_product`,', '').replace('p.', '')
values = t.to_db_values(product, product_fields_without_id)
q = queries.INSERT_PRODUCT_QUERY.format(product_sql_fields_without_id, values)
c.execute(q)
if db != None:
db.commit()
return c.lastrowid