from Utils.sql_handler import test_env_conn
from TestData.setting.facebook_integration_test_data import facebookIntegrationData

facebook_select_sql = f'select * from `resource_item` where brand_id = {facebookIntegrationData.brandId} and resource_id = 3'
facebook_select_result = test_env_conn.select_many_value(sql=facebook_select_sql)

facebook = facebook_select_result[0]
facebook_name = facebook['name']
setattr(facebookIntegrationData, 'facebook_name', facebook_name)
setattr(facebookIntegrationData, 'facebook_num', len(facebook_select_result))