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