from Utils.sql_handler import test_env_conn
from TestData.inbox.channel_test_data import channelData

channel_select_sql = f'select * from `resource_item` where brand_id = {channelData.brandId} and resource_id in (7,2,3,4,6)' #2:livechat 3:facebook 4:email 6:ins 7:whatsapp
channel_select_result = test_env_conn.select_many_value(sql=channel_select_sql)
channel_id = channel_select_result[0]['id']
channel_name = channel_select_result[0]['name']
channel_rel_id = channel_select_result[0]['rel_id']
channel_resource_id = channel_select_result[0]['resource_id']
setattr(channelData, 'channel_id', channel_id)
setattr(channelData, 'channel_name', channel_name)
setattr(channelData, 'channel_resource_id', channel_resource_id)

channel_open_room_select_sql = f'select * from `im_room` where site_id = {channel_rel_id} and status = 1'
channel_open_room_select_result = test_env_conn.select_many_value(sql=channel_open_room_select_sql)
setattr(channelData, 'channel_open_room_num', len(channel_open_room_select_result))