from Utils.sql_handler import test_env_conn
from TestData.automation.rule_test_data import ruleData

rule_object_select_sql = f'select * from `rule_object` where tpl_id = "{ruleData.rule_parent_template_id}" and status = 1 '
rule_object_select_result = test_env_conn.select_many_value(sql=rule_object_select_sql)

rule_num = len(rule_object_select_result)
rule = rule_object_select_result[0]
rule_name = rule['obj_name']
rule_describe = rule['obj_describe']
rule_type = rule['obj_type']
rule_category = rule['obj_category']
rule_id = rule['rob_id']
rule_value_from = rule['value_from']
rule_show_type = rule['show_type']
rule_show_kind = rule['show_kind']
rule_kind = rule['obj_kind']
rule_parent_rob_id = rule['parent_rob_id']

setattr(ruleData, 'rule_name', rule_name)
setattr(ruleData, 'rule_describe', rule_describe)
setattr(ruleData, 'rule_type', rule_type)
setattr(ruleData, 'rule_category', rule_category)
setattr(ruleData, 'rule_id', rule_id)
setattr(ruleData, 'rule_value_from', rule_value_from)
setattr(ruleData, 'rule_show_type', rule_show_type)
setattr(ruleData, 'rule_show_kind', rule_show_kind)
setattr(ruleData, 'rule_kind', rule_kind)
setattr(ruleData, 'rule_parent_rob_id', rule_parent_rob_id)
setattr(ruleData, 'rule_num', rule_num)