from Utils.sql_handler import test_env_conn
from TestData.FAQ.article_opreate_test_data import articleOperateTestData

category_id_select_sql = f"select * from `article_categorie` where brand_id = {articleOperateTestData.brandId} and shop_id = {articleOperateTestData.shopId} and category_name = '{articleOperateTestData.category_name}'"

category_id_select_result = test_env_conn.select_one_value(sql=category_id_select_sql)

if category_id_select_result:
    pass
else:
    category_insert_sql = f"""INSERT INTO `article_categorie` 
    (brand_id,shop_id,category_name,category_level,category_sort,is_publish,is_popular,popular_at,is_delete,icon_type,is_checkout,is_enable_icon,description,category_icon,system_id,create_at,update_at) 
    VALUES ({articleOperateTestData.brandId},{articleOperateTestData.shopId},'{articleOperateTestData.category_name}','',1,1,1,NULL,0,0,'','','{articleOperateTestData.category_description}','{articleOperateTestData.category_icon}',0,'2024-02-19 16:43:20','2024-04-02 12:01:07');"""
    test_env_conn.execute_sql(category_insert_sql)