from Utils.sql_handler import test_env_conn
from TestData.homepage.homepage_test_data import homepageTestData

homepage_banner_ad_select_sql = f'select * from `banner` where group_id = 1 and status = 1 order by sort desc'
homepage_banner_ad_select_result = test_env_conn.select_many_value(sql=homepage_banner_ad_select_sql)

ad_1 = homepage_banner_ad_select_result[0]
ad_2 = homepage_banner_ad_select_result[1]
ad_3 = homepage_banner_ad_select_result[2]

ad_1_title = ad_1['title']
ad_1_url = ad_1['url']
ad_1_pic = ad_1['pic']
ad_1_target = ad_1['target']
ad_2_title = ad_2['title']
ad_2_url = ad_2['url']
ad_2_pic = ad_2['pic']
ad_2_target = ad_2['target']
ad_3_title = ad_3['title']
ad_3_url = ad_3['url']
ad_3_pic = ad_3['pic']
ad_3_target = ad_3['target']

setattr(homepageTestData, 'ad_1_title', ad_1_title)
setattr(homepageTestData, 'ad_1_url', ad_1_url)
setattr(homepageTestData, 'ad_1_pic', ad_1_pic)
setattr(homepageTestData, 'ad_1_target', ad_1_target)
setattr(homepageTestData, 'ad_2_title', ad_2_title)
setattr(homepageTestData, 'ad_2_url', ad_2_url)
setattr(homepageTestData, 'ad_2_pic', ad_2_pic)
setattr(homepageTestData, 'ad_2_target', ad_2_target)
setattr(homepageTestData, 'ad_3_title', ad_3_title)
setattr(homepageTestData, 'ad_3_url', ad_3_url)
setattr(homepageTestData, 'ad_3_pic', ad_3_pic)
setattr(homepageTestData, 'ad_3_target', ad_3_target)