| | |
|---|
| | | elif url.path == "/get_codes_by_jx_plates": |
|---|
| | | # 根据精选板块获取代码 |
|---|
| | | plates = ps_dict.get("plates") |
|---|
| | | date = ps_dict.get("date") |
|---|
| | | plates = set(json.loads(plates)) |
|---|
| | | sql = " select code, jx_blocks from kpl_code_blocks where " + " and ".join( |
|---|
| | | sql = f" select code, jx_blocks from kpl_code_blocks where day = '{date}' and " + " and ".join( |
|---|
| | | [f"jx_blocks like '%{p}%'" for p in plates]) |
|---|
| | | datas = Mysqldb().select_all(sql) |
|---|
| | | fdatas = [(x[0], "、".join([ f"<red>{dd}</red>" if dd in plates else dd for dd in json.loads(x[1])])) for x in datas if len(set(json.loads(x[1])) & plates) == len(plates)] |
|---|
