Python字典映射到SQL查询字符串

def dict_to_sql_query(dictionary):
    query = "SELECT * FROM table_name WHERE "
    conditions = []
    for key, value in dictionary.items():
        if isinstance(value, str):
            condition = f"{key} = '{value}'"
        else:
            condition = f"{key} = {value}"
        conditions.append(condition)
    query += " AND ".join(conditions)
    return query

dictionary = {"name": "John", "age": 25, "city": "New York"}
query = dict_to_sql_query(dictionary)
print(query)

SELECT * FROM table_name WHERE name = 'John' AND age = 25 AND city = 'New York'