From f35eaf95bd774de6e6a5a79a5dcbd3cccb2748aa Mon Sep 17 00:00:00 2001
From: Administrator <admin@example.com>
Date: 星期二, 12 十一月 2024 00:27:08 +0800
Subject: [PATCH] 新版本板块代码列表
---
utils/kpl_data_db_util.py | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/utils/kpl_data_db_util.py b/utils/kpl_data_db_util.py
index e1fe2fe..4b7f077 100644
--- a/utils/kpl_data_db_util.py
+++ b/utils/kpl_data_db_util.py
@@ -1,4 +1,5 @@
from db.mysql_data_delegate import Mysqldb
+from third_data.history_k_data_util import HistoryKDatasUtils
from utils import tool
@@ -19,3 +20,23 @@
mysqldb = Mysqldb()
results = mysqldb.select_all(sql)
return results
+
+
+if __name__ == '__main__':
+ # 鍒犻櫎涓嶆槸浜ゆ槗鏃ユ湡鐨勬暟鎹�
+ days = HistoryKDatasUtils.get_latest_trading_date(300)
+ for day in days:
+ pass
+ print(days)
+ mysqldb = Mysqldb()
+ results = mysqldb.select_all(f"SELECT _id, _day from kpl_limit_up_record r where r._day>='{days[-1]}'")
+ ids = []
+ for result in results:
+ if result[1] not in days:
+ ids.append(result[0])
+ # print("鍒犻櫎锛�", result)
+ if len(ids) > 10:
+ sql = f"delete from kpl_limit_up_record where " + ' or '.join([f"_id='{x}'" for x in ids])
+ mysqldb.execute(sql)
+ ids.clear()
+ pass
--
Gitblit v1.8.0