from Utils.sql_handler import test_env_conn
from TestData.FAQ.article_info_test_data import articleInfoTestData

# all_article_list_select_sql = f'select * from `article` where brand_id = {articleInfoTestData.brandId} and is_delete = 0'
# all_article_list_select_result = test_env_conn.select_many_value(all_article_list_select_sql)
# all_article_num = len(all_article_list_select_result)
shop_article_list_select_sql = f'select * from `article` where brand_id = {articleInfoTestData.brandId} and shop_id = {articleInfoTestData.shopId} and is_delete = 0'
shop_article_list_select_result = test_env_conn.select_many_value(shop_article_list_select_sql)
shop_article_num = len(shop_article_list_select_result)
# setattr(articleInfoTestData,'all_article_num',all_article_num)
setattr(articleInfoTestData,'shop_article_num',shop_article_num)
article = shop_article_list_select_result[0]
article_id = article['id']
article_category_id = article['article_category_id']
article_title = article['title']
article_title = article_title.replace("'","\\'")
article_sort = article['sort']
article_content = article['content']
article_content = article_content.replace("'","\\'")
article_content = article_content.replace("\n","\\n'")
article_is_published = article['is_publish']
article_is_popular = article['is_popular']
article_meta_title = article['meta_title'] if article['meta_title'] else ''
article_meta_description = article['meta_description'] if article['meta_description'] else ''
article_view_count = article['views']
article_evaluate_good = article['article_evaluate_good']
article_evaluate_bad = article['article_evaluate_bad']
setattr(articleInfoTestData,'article_id',article_id)
setattr(articleInfoTestData,'article_category_id',article_category_id)
setattr(articleInfoTestData,'article_title',article_title)
setattr(articleInfoTestData,'article_sort',article_sort)
setattr(articleInfoTestData,'article_content',article_content)
setattr(articleInfoTestData,'article_is_published',article_is_published)
setattr(articleInfoTestData,'article_is_popular',article_is_popular)
setattr(articleInfoTestData,'article_meta_title',article_meta_title)
setattr(articleInfoTestData,'article_meta_description',article_meta_description)
setattr(articleInfoTestData,'article_view_count',article_view_count)
setattr(articleInfoTestData,'article_view_count_add',article_view_count + 1)
setattr(articleInfoTestData,'article_evaluate_good',article_evaluate_good)
setattr(articleInfoTestData,'article_evaluate_good_add',article_evaluate_good + 1)
setattr(articleInfoTestData,'article_evaluate_bad',article_evaluate_bad)
setattr(articleInfoTestData,'article_evaluate_bad_add',article_evaluate_bad + 1)