| | |
|---|
| | | 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] |
|---|
| | |
|---|
| | | @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): |
|---|
