from component import mymysql
from component.mymysql import execute
mymysql.init({
'host': "192.168.121.133",
'port': 3306,
'database': 'laashub',
'user': '******',
'password': '******',
'charset': 'utf8mb4',
})
if __name__ == '__main__':
target_id = 38
# 查询多条
print(execute("""
select * from designer_data_directory
"""))
# 查询一条
print(execute("""
select * from designer_data_directory where id = %(id)s
""", {
"id": target_id
}))
# 新增
print(execute("""
insert into designer_data_directory(pid, name) values (%(pid)s,%(name)s)
""", {
"pid": target_id,
"name": "test2"
}))
return custom_res
return e
@app.before_request
def global_interceptor():
try:
auth.wrap_authentication()
except MyServiceException as e:
custom_res = make_response(e.msg)
custom_res.status = "401"
return custom_res # 暂时只做粗略的是否登录权限验证, 不做精细权限
# return redirect("/login")
mymysql.init(config.app_conf["mysql"])
if not os.path.exists("logs"):
os.mkdir("logs")
if not os.path.exists("temp"):
os.mkdir("temp")
formatter = logging.Formatter(
"[%(asctime)s][%(filename)s:%(lineno)d][%(levelname)s][%(thread)d] - %(message)s"
)
handler = TimedRotatingFileHandler("logs/flask.log",
when="D",
interval=1,
backupCount=15,
encoding="UTF-8",
delay=False,
utc=True)
import datetime
import logging
import time
from __init__ import init
from component import mymysql, my_async, request_dingding_webhook
from config import app_conf
init()
target_db_pool = mymysql.init(app_conf["mysql"]["target"])
self_db_pool = mymysql.init(app_conf["mysql"]["self"])
logger = logging.getLogger('sync_polardb_slow_log')
logger.setLevel(logging.DEBUG)
local_cache_sql_template_id_2_text = {}
grafana_base_url = app_conf["grafana"]["base_url"]
def post_alarm(msg_content, at_mobiles):
dingding_webhook_access_token = app_conf["dingding_webhook_access_token"][
0]
dingding_resp = request_dingding_webhook.request_dingding_webhook(
dingding_webhook_access_token, "慢SQL", msg_content, at_mobiles)
logger.debug(dingding_resp)
def select_sql_template_id_by_text(db_name, sql_template_text):
# 在本地查询
global local_cache_sql_template_id_2_text
if local_cache_sql_template_id_2_text.__contains__(db_name):
local_cache_sql_template_id_2_text_db_level = local_cache_sql_template_id_2_text[