pymysql使用可变数量的参数选择

import pymysql

def dynamic_query(table_name, *args, **kwargs):
    connection = pymysql.connect(host='localhost', user='user', password='password', db='database')
    try:
        with connection.cursor() as cursor:
            # 构建基本的 SELECT 查询
            sql = f"SELECT * FROM {table_name}"
            
            # 如果有位置参数，添加 WHERE 子句
            if args:
                conditions = " AND ".join(f"{key} = %s" for key in args[0].keys())
                sql += f" WHERE {conditions}"
                cursor.execute(sql, list(args[0].values()))
            # 如果有关键字参数，添加 WHERE 子句
            elif kwargs:
                conditions = " AND ".join(f"{key} = %s" for key in kwargs.keys())
                sql += f" WHERE {conditions}"
                cursor.execute(sql, list(kwargs.values()))
            else:
                cursor.execute(sql)
            
            result = cursor.fetchall()
            return result
    finally:
        connection.close()

# 使用示例
data = dynamic_query('users', {'name': 'Alice', 'age': 30})
print(data)