如何在python中捕获sql文件执行的输出

import pymysql

# 或者其他数据库连接库

# MySQL连接示例
conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')

cursor = conn.cursor()

# 读取SQL文件内容
with open('sql_file.sql', 'r') as file:
    sql_statements = file.read()

# 执行SQL语句
cursor.execute(sql_statements)

# 获取所有结果
results = cursor.fetchall()

# 遍历结果
for row in results:
    print(row)

cursor.close()
conn.close()