from TestData.automation.workflow_test_data import workflowData

workflow_select_sql = f'select * from `rule_define` where brand_id = {workflowData.brandId} and status != 3 and tpl_id = "{workflowData.workflow_parent_template_id}" and child_rule = 0 and rule_cate = 1'
workflow_select_result = workflowData.workflow_db.select_many_value(sql=workflow_select_sql)
if workflow_select_result:

    workflow_num = len(workflow_select_result)
    workflow = workflow_select_result[0]
    select_workflow_id = workflow['rule_id']
    select_workflow_name = workflow['rule_name']
    select_workflow_status = workflow['status']
    select_workflow_sort = str(workflow['sorts'])
    select_workflow_describe = workflow['rule_describe']
else:
    insert_rule_raw = '{"ruleId":"%s","tplId":"%s","brandId":%s,"eventId":"%s","ruleName":"%s","ruleDescribe":"%s","status":%s,"ruleLogic":{"logicIf":{"ruleCond":{"condType":2,"robId":"%s","objName":"ChatBotIncomingMessage","objType":"bool","compOperatorType":"eq","compOperatorValue":"true","extendedAttributes":"{\\"x\\":212,\\"y\\":212,\\"nodeId\\":\\"Triggers_35705406543421204\\"}"},"result":[{"extendedAttributes":"{\\"showType\\":\\"next\\",\\"nodeId\\":\\"Actions_7500242750723225\\"}","resultType":2,"inner":[{"ruleId":"cp5ccqct7rnv226qoavg","robId":"cjhg9iuein687habss50","objName":"ChatBotMulReply","objType":"string","objKind":2,"objValue":"{\\"contentList\\":\\"%s\\",\\"attachmentList\\":[]}","showType":"mulInput","showKind":"chatBotReply","extendedAttributes":"{\\"title\\":\\"Message content\\",\\"nodeId\\":\\"Actions_7500242750723225\\",\\"x\\":658.2869318181818,\\"y\\":270.7599431818181}","resultType":1}]}],"index":1}}}'%(workflowData.insert_workflow_id,workflowData.workflow_parent_template_id,workflowData.brandId,workflowData.event_id,workflowData.workflow_name,workflowData.workflow_describe,workflowData.workflow_status,workflowData.event_id,workflowData.workflow_msg)
    workflow_insert_sql = f"""INSERT INTO willdesk.rule_define (rule_id,tpl_id,brand_id,event_id,rule_name,rule_describe,rule_dsl,rule_raw,sorts,parent_ruleid,child_rule,dsl_version,json_version,rule_cate,status,create_at,update_at) VALUES
	 ('{workflowData.insert_workflow_id}','{workflowData.workflow_parent_template_id}',{workflowData.brandId},'{workflowData.event_id}',{workflowData.workflow_name},'{workflowData.workflow_describe}','cnVsZSAiY3A1Y2NxY3Q3cm52MjI2cW9hdmciICJUcmlhZ2UgYnV0dG9uIGFuZCBhc3NpZ24gdG8gZGlmZmVyZW50IHRlYW1zIiBzYWxpZW5jZSAgJFJVTEVfU09SVFNfUExBQ0UkCmJlZ2luCmlmIGNoZWNrUnVsZUluZGV4KGRhdGEuUnVuSW5kZXhzLDEpIHx8ICgoZGF0YS5DaGVja0RhdGEoIkNoYXRCb3RJbmNvbWluZ01lc3NhZ2UiKSAmJiBlcXVhbChkYXRhLkdldERhdGEoIkNoYXRCb3RJbmNvbWluZ01lc3NhZ2UiKSwidHJ1ZSIpKSkgewogIHJldHVybiAiVzNzaWNuVnNaVWxrSWpvaVkzQTFZMk54WTNRM2NtNTJNakkyY1c5aGRtY2lMQ0p5YjJKSlpDSTZJbU5xYUdjNWFYVmxhVzQyT0Rkb1lXSnpjelV3SWl3aWIySnFUbUZ0WlNJNklrTm9ZWFJDYjNSTmRXeFNaWEJzZVNJc0ltOWlhbFI1Y0dVaU9pSnpkSEpwYm1jaUxDSnZZbXBMYVc1a0lqb3lMQ0p2WW1wV1lXeDFaU0k2SW50Y0ltTnZiblJsYm5STWFYTjBYQ0k2WENKSWFmQ2ZrWXQrWENJc1hDSmhkSFJoWTJodFpXNTBUR2x6ZEZ3aU9sdGRmU0lzSW5Ob2IzZFVlWEJsSWpvaWJYVnNTVzV3ZFhRaUxDSnphRzkzUzJsdVpDSTZJbU5vWVhSQ2IzUlNaWEJzZVNJc0ltVjRkR1Z1WkdWa1FYUjBjbWxpZFhSbGN5STZJbnRjSW5ScGRHeGxYQ0k2WENKTlpYTnpZV2RsSUdOdmJuUmxiblJjSWl4Y0ltNXZaR1ZKWkZ3aU9sd2lRV04wYVc5dWMxODNOVEF3TWpReU56VXdOekl6TWpJMVhDSXNYQ0o0WENJNk5qVTRMakk0Tmprek1UZ3hPREU0TVRnc1hDSjVYQ0k2TWpjd0xqYzFPVGswTXpFNE1UZ3hPREY5SWl3aWNtVnpkV3gwVkhsd1pTSTZNWDFkIgp9CnJldHVybiAiVzNzaWJtOWtaVWx1WkdWNElqb3hMQ0p5ZFd4bFNXUWlPaUpqY0RWalkzRmpkRGR5Ym5ZeU1qWnhiMkYyWnlJc0luSnZZa2xrSWpvaVkyMXJPVzB4YmpjemRYWm5hREZ5Wm0xb2J6QWlMQ0p2WW1wT1lXMWxJam9pUTJoaGRFSnZkRWx1WTI5dGFXNW5UV1Z6YzJGblpTSXNJbTlpYWxSNWNHVWlPaUppYjI5c0lpd2liMkpxUzJsdVpDSTZNU3dpY21WemRXeDBWSGx3WlNJNk1YMWQiCmVuZAo=',{insert_rule_raw},35870000,'',0,'v2','v2',1,{workflowData.workflow_status},'2024-05-20 11:41:29','2024-05-20 11:41:29');
"""
    workflowData.workflow_db.execute_sql(sql=workflow_insert_sql)
    select_workflow_id = workflowData.insert_workflow_id
    select_workflow_name = workflowData.workflow_name
    select_workflow_status = workflowData.workflow_status
    workflow_num = 1
    select_workflow_sort = '35870000'
    select_workflow_describe = workflowData.workflow_describe
setattr(workflowData, 'select_workflow_id', select_workflow_id)
setattr(workflowData, 'workflow_num', workflow_num)
setattr(workflowData, 'select_workflow_name', select_workflow_name)
setattr(workflowData, 'select_workflow_status', select_workflow_status)
setattr(workflowData, 'select_workflow_sort', select_workflow_sort)
setattr(workflowData, 'select_workflow_describe', select_workflow_describe)
setattr(workflowData, 'workflow_num_less', workflow_num - 1)
workflowData.workflow_db.close_db()