我正在尝试使用下面的代码创建一个python可执行文件。
import pandas as pd
import pyodbc as po
import os
#variables
server = 'DESKTOP-9B94UPJ'
database = 'DB1'
username = 'etluser'
password = 'password'
rawfile_directory='E:\\Projects\\Ebay\\ETLApp\\'
cnxn = po.connect('DRIVER={SQL
Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
df=pd.read_csv(rawfile_directory+"SPSS_Files\\"+filename,usecols=var_filteredCols)
cnxn = po.connect('DRIVER={SQL
Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
sql_stmt = "INSERT INTO "+var_table+" ("+var_DBCols+") values("+var_placeholder+")"
cursor = cnxn.cursor()
cursor.fast_executemany = True
cursor.executemany(sql_stmt, df.values.tolist())
# print(f'{len(df)} rows inserted to the {MY_TABLE} table')
cursor.commit()
cursor.close()
cnxn.close()
我使用pyinstaller创建了一个exe
pyinstaller --onefile etl.py
我想在运行时将数据库凭据和文件夹路径传递给exe。有哪位专家能给我建议如何做到这一点?提前谢谢