From 663fd14df951defdc8b0bf833ed5e798c2ff52cd Mon Sep 17 00:00:00 2001
From: Administrator <admin@example.com>
Date: 星期五, 07 六月 2024 18:37:04 +0800
Subject: [PATCH] 环境信息添加自由流通量

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

diff --git a/code_attribute/gpcode_manager.py b/code_attribute/gpcode_manager.py
index c09906c..3776155 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):

--
Gitblit v1.8.0