def status(engine_data, cur_status):
print("Data: ", "status: ", "engine_data: ", str(engine_data),
"cur_status: ", cur_status)
mymysql.execute(
"""
insert into engine_data_logic_trigger_data_status(data_id, data_data_id, data_event_type, logic_id, func_name, status)
values(%(data_id)s, %(data_data_id)s, %(data_event_type)s, %(logic_id)s, %(func_name)s, %(status)s)
""", {
"data_id": engine_data["data_id"],
"data_data_id": engine_data["data_data_id"],
"data_event_type": engine_data["data_event_type"],
"logic_id": engine_data["logic_id"],
"func_name": engine_data["func_name"],
"status": cur_status,
})
def select_engine_data_logic_trigger_status_details_log():
request_data = form.check(['data_id', 'data_data_id', 'data_event'])
data_event = request_data['data_event']
sql = """
select log
from engine_data_logic_trigger_data_log
where 1=1
and data_id = %(data_id)s
and data_data_id = %(data_data_id)s
"""
if 'tree' == data_event:
pass
elif 'data_event' == data_event:
sql += 'and data_event_type = %(data_event_type)s'
elif 'logic' == data_event:
sql += """
and data_event_type = %(data_event_type)s
and logic_id = %(logic_id)s
and func_name = %(func_name)s
"""
elif 'data_status' == data_event:
sql += """
and data_event_type = %(data_event_type)s
and logic_id = %(logic_id)s
and func_name = %(func_name)s
and create_time >= str_to_date(%(create_time_str)s, '%%Y-%%m-%%d %%T')
"""
return json.dumps(mymysql.execute(sql, request_data))
def log(engine_data, log_level="TRACE", log_content=""):
print("log: ", "engine_data: ", str(engine_data), "log_level: ",
log_level, "log_content: ", log_content)
mymysql.execute(
"""
insert into engine_data_logic_trigger_data_log(data_id, data_data_id, data_event_type, logic_id, func_name, log_level, log)
values(%(data_id)s, %(data_data_id)s, %(data_event_type)s, %(logic_id)s, %(func_name)s, %(log_level)s, %(log)s)
""", {
"data_id": engine_data["data_id"],
"data_data_id": engine_data["data_data_id"],
"data_event_type": engine_data["data_event_type"],
"logic_id": engine_data["logic_id"],
"func_name": engine_data["func_name"],
"log_level": log_level,
"log": log_content,
})
def select_engine_data_logic_trigger_status_details_status():
request_data = form.check(['data_id', 'data_data_id'])
return json.dumps(
mymysql.execute(
"""
select id,
data_id,
data_data_id,
data_event_type,
logic_id,
func_name,
DATE_FORMAT(create_time, '%%Y-%%m-%%d %%T') as create_time_str,
status
from engine_data_logic_trigger_data_status
where data_id = %(data_id)s and data_data_id = %(data_data_id)s
order by id asc
""", request_data))
def load_logic_2_local(self):
parameters = {
"logic_id": self.logic_id,
}
sql_result = mymysql.execute(
"""
select ded.update_time, ellfv.version
from designer_logic_data ded
left join engine_local_logic_file_version ellfv on ded.id = ellfv.logic_id
where ded.id = %(logic_id)s
;
""", parameters)
sql_result = sql_result[0]
update_time = sql_result["update_time"]
version = sql_result["version"]
parameters["version"] = update_time
if os.path.exists(self.local_logic_file_path):
if update_time == version:
return
sql_result = mymysql.execute(
"""
select file
from designer_logic_data
where id = %(logic_id)s;
""", parameters)
sql_result = sql_result[0]
logic_file = sql_result["file"]
with open(self.local_logic_file_path, "w") as file:
file.write(logic_file)
if not version:
mymysql.execute(
"""
insert into engine_local_logic_file_version(logic_id, version)
values(%(logic_id)s, %(version)s);
""", parameters)
else:
mymysql.execute(
"""
update engine_local_logic_file_version
set version = %(version)s
where logic_id = %(logic_id)s;
""", parameters)
def get(sql, parameters={}):
print("Data: ", "sql: ", sql, "parameters: ", parameters)
return mymysql.execute(sql, parameters)