from Utils.sql_handler import test_env_conn
from TestData.setting.email_integration_test_data import emailIntegrationData

email_select_sql = f'select * from `email_config` where brand_id = {emailIntegrationData.brandId} and email = "{emailIntegrationData.append_email_address}"'
email_select_result = test_env_conn.select_one_value(email_select_sql)
if not email_select_result:
    email_insert_sql = f"""INSERT INTO willdesk.email_config (brand_id,email_servicer_id,email,email_name,auth_code,refresh_token,raw_token,code_type,imap_addr,imap_port,imap_ssl,smtp_addr,smtp_port,smtp_ssl,enable_signature,signature_content,auth_folder,connect_status,failed_reason,status,create_at,update_at) VALUES
	 ({emailIntegrationData.brandId},7,'{emailIntegrationData.append_email_address}','{emailIntegrationData.append_email_name}','OJezniff5cTye4CqPyr3KA5F8HwmLiwyTAlBvYRKeWw=','','',0,'imap.com',993,0,'smtp.com',587,0,0,'<p >Best wishes&nbsp;</p><span class="agent-name unique-tags" contenteditable="false">Agent name</span> | <span>Customer Support</span>','1',1,'',{emailIntegrationData.append_email_status},'2024-04-19 17:11:37','2024-04-19 17:11:48');
"""
    test_env_conn.execute_sql(email_insert_sql)
    email_id_select_sql = f'select id from `email_config` where brand_id = {emailIntegrationData.brandId} and email = "{emailIntegrationData.append_email_address}"'
    email_id_select_result = test_env_conn.select_one_value(email_id_select_sql)
    append_email_id = email_id_select_result['id']
    setattr(emailIntegrationData, 'append_email_id', append_email_id)