From 84c1492e824bc26cf8ee962e8cf93d94e86b7c9e Mon Sep 17 00:00:00 2001
From: Administrator <admin@example.com>
Date: 星期三, 25 十月 2023 10:43:04 +0800
Subject: [PATCH] mysql日志
---
db/mysql_data_delegate.py | 8 ++++++--
log_module/log.py | 6 ++++++
2 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/db/mysql_data_delegate.py b/db/mysql_data_delegate.py
index 4a17ee5..d61ac21 100644
--- a/db/mysql_data_delegate.py
+++ b/db/mysql_data_delegate.py
@@ -5,6 +5,7 @@
# 鎶婅繛鎺ュ弬鏁板畾涔夋垚瀛楀吀
import constant
+from log_module.log import logger_mysql_debug
from utils import middle_api_protocol
config = constant.MYSQL_CONFIG
@@ -23,8 +24,11 @@
if args:
data["args"] = args
fdata = middle_api_protocol.load_mysql_cmd(data)
- result = middle_api_protocol.request(fdata)
- return result
+ try:
+ result = middle_api_protocol.request(fdata)
+ return result
+ except Exception as e:
+ logger_mysql_debug.exception(e)
# 鏌ヨsql璇彞杩斿洖鐨勬墍鏈夋暟鎹�
def select_all(self, sql):
diff --git a/log_module/log.py b/log_module/log.py
index eef0406..1789f73 100644
--- a/log_module/log.py
+++ b/log_module/log.py
@@ -40,6 +40,10 @@
filter=lambda record: record["extra"].get("name") == "l2_latest_data",
rotation="00:00", compression="zip", enqueue=True)
+ logger.add(self.get_path("mysql", "mysql_debug"),
+ filter=lambda record: record["extra"].get("name") == "mysql_debug",
+ rotation="00:00", compression="zip", enqueue=True)
+
# 鏄剧ず鍦ㄦ帶鍒跺彴
# logger.add(sys.stdout,
# filter=lambda record: record["extra"].get("name") == "l2_trade", enqueue=True)
@@ -338,6 +342,8 @@
logger_profile = __mylogger.get_logger("profile")
+logger_mysql_debug = __mylogger.get_logger("mysql_debug")
+
# -------------------------------鍗庨懌鏃ュ織---------------------------------
hx_logger_l2_orderdetail = __mylogger.get_logger("hx_l2_orderdetail")
hx_logger_l2_transaction = __mylogger.get_logger("hx_l2_transaction")
--
Gitblit v1.8.0