13 lines
366 B
Python
13 lines
366 B
Python
from typing import Optional, Dict
|
|
|
|
def get_classement_by_tag(cur, classement_table: str, tag: str) -> Optional[Dict]:
|
|
pattern = f"%*{tag}*%"
|
|
sql = f"""
|
|
SELECT cla_info_dossard, con_id, cla_list_tag
|
|
FROM `{classement_table}`
|
|
WHERE cla_list_tag LIKE %s
|
|
LIMIT 1
|
|
"""
|
|
cur.execute(sql, (pattern,))
|
|
return cur.fetchone()
|