Python - convert_value() and escape_sql_string()

 

import json
from datetime import date, datetime

def escape_sql_string(s: str) -> str:
    """
    转义SQL字符串中的引号:
    - 单引号 ' -> ''
    """
    return s.replace("'", "''")def convert_value(v):
    if v is None:
        return "NULL"
    elif isinstance(v, str):
        return f"'{escape_sql_string(v)}'"
    elif isinstance(v, date) and not isinstance(v, datetime):
        return f"'{v.strftime('%Y-%m-%d')}'"
    elif isinstance(v, datetime):
        return f"'{v.strftime('%Y-%m-%d %H:%M:%S')}'"
    elif isinstance(v, dict):
        if not v:
            return "NULL"
        else:
            json_str = json.dumps(v, ensure_ascii=False)
            return f"'{escape_sql_string(json_str)}'"
    else:
        return str(v)