from TestData.automation.orderflow_test_data import orderflowData

orderflow_select_sql = f'select * from `rule_define` where brand_id = {orderflowData.brandId} and status != 3 and tpl_id = "{orderflowData.orderflow_parent_template_id}" and child_rule = 0 and rule_cate = 2'
orderflow_select_result = orderflowData.orderflow_db.select_many_value(sql=orderflow_select_sql)
if orderflow_select_result:
    orderflow_num = len(orderflow_select_result)
    orderflow = orderflow_select_result[0]
    select_orderflow_id = orderflow['rule_id']
    select_orderflow_name = orderflow['rule_name']
    select_orderflow_status = orderflow['status']
    select_orderflow_sort = str(orderflow['sorts'])
    select_orderflow_describe = orderflow['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}}}'%(orderflowData.insert_orderflow_id,orderflowData.orderflow_parent_template_id,orderflowData.brandId,orderflowData.event_id,orderflowData.orderflow_name,orderflowData.orderflow_describe,orderflowData.orderflow_status,orderflowData.event_id,orderflowData.orderflow_msg)
    orderflow_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
	 ('{orderflowData.insert_orderflow_id}','{orderflowData.orderflow_parent_template_id}',{orderflowData.brandId},'{orderflowData.event_id}',{orderflowData.orderflow_name},'{orderflowData.orderflow_describe}','cnVsZSAiY3A1Y2NxY3Q3cm52MjI2cW9hdmciICJUcmlhZ2UgYnV0dG9uIGFuZCBhc3NpZ24gdG8gZGlmZmVyZW50IHRlYW1zIiBzYWxpZW5jZSAgJFJVTEVfU09SVFNfUExBQ0UkCmJlZ2luCmlmIGNoZWNrUnVsZUluZGV4KGRhdGEuUnVuSW5kZXhzLDEpIHx8ICgoZGF0YS5DaGVja0RhdGEoIkNoYXRCb3RJbmNvbWluZ01lc3NhZ2UiKSAmJiBlcXVhbChkYXRhLkdldERhdGEoIkNoYXRCb3RJbmNvbWluZ01lc3NhZ2UiKSwidHJ1ZSIpKSkgewogIHJldHVybiAiVzNzaWNuVnNaVWxrSWpvaVkzQTFZMk54WTNRM2NtNTJNakkyY1c5aGRtY2lMQ0p5YjJKSlpDSTZJbU5xYUdjNWFYVmxhVzQyT0Rkb1lXSnpjelV3SWl3aWIySnFUbUZ0WlNJNklrTm9ZWFJDYjNSTmRXeFNaWEJzZVNJc0ltOWlhbFI1Y0dVaU9pSnpkSEpwYm1jaUxDSnZZbXBMYVc1a0lqb3lMQ0p2WW1wV1lXeDFaU0k2SW50Y0ltTnZiblJsYm5STWFYTjBYQ0k2WENKSWFmQ2ZrWXQrWENJc1hDSmhkSFJoWTJodFpXNTBUR2x6ZEZ3aU9sdGRmU0lzSW5Ob2IzZFVlWEJsSWpvaWJYVnNTVzV3ZFhRaUxDSnphRzkzUzJsdVpDSTZJbU5vWVhSQ2IzUlNaWEJzZVNJc0ltVjRkR1Z1WkdWa1FYUjBjbWxpZFhSbGN5STZJbnRjSW5ScGRHeGxYQ0k2WENKTlpYTnpZV2RsSUdOdmJuUmxiblJjSWl4Y0ltNXZaR1ZKWkZ3aU9sd2lRV04wYVc5dWMxODNOVEF3TWpReU56VXdOekl6TWpJMVhDSXNYQ0o0WENJNk5qVTRMakk0Tmprek1UZ3hPREU0TVRnc1hDSjVYQ0k2TWpjd0xqYzFPVGswTXpFNE1UZ3hPREY5SWl3aWNtVnpkV3gwVkhsd1pTSTZNWDFkIgp9CnJldHVybiAiVzNzaWJtOWtaVWx1WkdWNElqb3hMQ0p5ZFd4bFNXUWlPaUpqY0RWalkzRmpkRGR5Ym5ZeU1qWnhiMkYyWnlJc0luSnZZa2xrSWpvaVkyMXJPVzB4YmpjemRYWm5hREZ5Wm0xb2J6QWlMQ0p2WW1wT1lXMWxJam9pUTJoaGRFSnZkRWx1WTI5dGFXNW5UV1Z6YzJGblpTSXNJbTlpYWxSNWNHVWlPaUppYjI5c0lpd2liMkpxUzJsdVpDSTZNU3dpY21WemRXeDBWSGx3WlNJNk1YMWQiCmVuZAo=',{insert_rule_raw},35870000,'',0,'v2','v2',1,{orderflowData.orderflow_status},'2024-05-20 11:41:29','2024-05-20 11:41:29');
"""
    orderflowData.orderflow_db.execute_sql(sql=orderflow_insert_sql)
    select_orderflow_id = orderflowData.insert_orderflow_id
    select_orderflow_name = orderflowData.orderflow_name
    select_orderflow_status = orderflowData.orderflow_status
    orderflow_num = 1
    select_orderflow_sort = '35870000'
    select_orderflow_describe = orderflowData.orderflow_describe
setattr(orderflowData, 'select_orderflow_id', select_orderflow_id)
setattr(orderflowData, 'orderflow_num', orderflow_num)
setattr(orderflowData, 'select_orderflow_name', select_orderflow_name)
setattr(orderflowData, 'select_orderflow_status', select_orderflow_status)
setattr(orderflowData, 'select_orderflow_sort', select_orderflow_sort)
setattr(orderflowData, 'select_orderflow_describe', select_orderflow_describe)
setattr(orderflowData, 'orderflow_num_less', orderflow_num - 1)
orderflowData.orderflow_db.close_db()