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}")
使用python读取excel生成查询语句
最新推荐文章于 2024-08-31 16:44:47 发布