From 794d154fb8dd8aaf2f4a670a59f85302287d5b2b Mon Sep 17 00:00:00 2001 From: Administrator <admin@example.com> Date: 星期二, 03 九月 2024 17:12:02 +0800 Subject: [PATCH] 历史板块判断调整/有效执行位判断 --- utils/kpl_data_db_util.py | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/utils/kpl_data_db_util.py b/utils/kpl_data_db_util.py index 5107280..e1fe2fe 100644 --- a/utils/kpl_data_db_util.py +++ b/utils/kpl_data_db_util.py @@ -4,13 +4,15 @@ class KPLLimitUpDataUtil: @classmethod - def get_latest_block_infos(cls, min_day=tool.date_sub(tool.get_now_date_str(), 180), code=None): + def get_latest_block_infos(cls, min_day=tool.date_sub(tool.get_now_date_str(), 180), code=None, + max_day=tool.get_now_date_str()): """ @param min_day: 榛樿鑾峰彇180澶╀箣鍓嶇殑 @param code: 浠g爜 @return: 鏈�杩戠殑娑ㄥ仠鏉垮潡淇℃伅 """ - sql = f"SELECT r.`_code`, r.`_day`, r.`_hot_block_name`, r.`_blocks` FROM `kpl_limit_up_record` r WHERE r.`_day`>'{min_day}'" + sql = f"SELECT r.`_code`, r.`_day`, r.`_hot_block_name`, r.`_blocks` FROM `kpl_limit_up_record` r WHERE r.`_day`>'{min_day}' and r.`_day` <'{max_day}'" + if code: sql += f" AND _code='{code}'" sql += " order by _create_time" -- Gitblit v1.8.0