使用python读取excel生成查询语句

最新推荐文章于 2024-07-12 19:06:42 发布

ShaTaLiu_YLJ

最新推荐文章于 2024-07-12 19:06:42 发布

阅读量199

点赞数

文章标签： python

本文链接：https://blog.csdn.net/ShaTaLiu_YLJ/article/details/131930459

版权

import pandas as pd

def generate_select_query(table_name, columns):
    # 生成SQL查询语句
    select_query = f"SELECT {', '.join(columns)} FROM {table_name};"
    return select_query

# 指定Excel文件路径
excel_file_path = "data.xlsx"

# 读取Excel文件
data = pd.read_excel(excel_file_path)

# 按照数据库表名进行分组，并生成查询语句
query_list = []
for table_name, table_data in data.groupby('数据库表名'):
    columns = table_data['字段名'].tolist()
    select_query = generate_select_query(table_name, columns)
    query_list.append(select_query)

# 将查询语句保存到.sql文件
output_file_path = "output_queries.sql"
with open(output_file_path, 'w') as f:
    for query in query_list:
        f.write(query + "\n")

print(f"查询语句已保存到文件: {output_file_path}")