| | |
| | | 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): |
| | |
| | | # 设置收盘价 |
| | | @classmethod |
| | | def set_price_pre(cls, code, price, force=False): |
| | | codes = get_gp_list() |
| | | if code not in codes and not FirstCodeManager().is_in_first_record_cache(code) and not force: |
| | | if code in cls.__price_pre_cache and not force: |
| | | return |
| | | price = round(float(price), 2) |
| | | logger_pre_close_price.info(f"{code}-{price}") |
| | |
| | | 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] |