From 6daa63c38d0797e1b0ecdb06c508b58d8a91cd40 Mon Sep 17 00:00:00 2001
From: Administrator <admin@example.com>
Date: 星期三, 10 七月 2024 15:47:46 +0800
Subject: [PATCH] 买入调仓到15000

---
 code_attribute/gpcode_manager.py |   15 +++++++++++----
 1 files changed, 11 insertions(+), 4 deletions(-)

diff --git a/code_attribute/gpcode_manager.py b/code_attribute/gpcode_manager.py
index c09906c..3c7a82d 100644
--- a/code_attribute/gpcode_manager.py
+++ b/code_attribute/gpcode_manager.py
@@ -36,7 +36,7 @@
     def get_code_name(cls, code):
         if code in cls.__code_name_dict:
             return cls.__code_name_dict[code]
-        fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = {code}")
+        fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = '{code}'")
         if fresults:
             cls.__code_name_dict[code] = fresults[0]
             return fresults[0]
@@ -45,11 +45,11 @@
     @classmethod
     def add_code_name(cls, code, name):
         cls.__code_name_dict[code] = name
-        fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = {code}")
+        fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = '{code}'")
         if fresults:
-            cls.__mysqldb.execute(f"update code_name set code_name ='{name}', update_time = now() where code= {code}")
+            cls.__mysqldb.execute(f"update code_name set code_name ='{name}', update_time = now() where code= '{code}'")
         else:
-            cls.__mysqldb.execute(f"insert into code_name(code,code_name,update_time ) values({code},'{name}',now())")
+            cls.__mysqldb.execute(f"insert into code_name(code,code_name,update_time ) values('{code}','{name}',now())")
 
     @classmethod
     def add_first_code_name(cls, code, name):
@@ -619,6 +619,13 @@
     return limit_up_price
 
 
+def get_limit_up_price_as_num(code):
+    limit_up_price = get_limit_up_price(code)
+    if limit_up_price:
+        return round(float(limit_up_price), 2)
+    return None
+
+
 def get_limit_up_price_cache(code):
     if code in __limit_up_price_dict:
         return __limit_up_price_dict[code]

--
Gitblit v1.8.0