pyodbc中的用户密码与pyinstaller无关?

2024-04-27 19:13:01 发布

您现在位置:Python中文网/ 问答频道 /正文

以下是代码:

import pyodbc
import pandas as pd
from pandas import ExcelWriter
import sys
import time
import getpass

username = input('Please enter username starting with COMPANY\\: ')
password = getpass.getpass('Please enter your password: ')


cnxn = pyodbc.connect(
    'Driver={ODBC DRiver 17 for SQL Server};'
    'Server=COMPANY;'
    'Database=COMPANY;'
    'uid=' + username + ';pwd=' + password + ';Trusted_connection=yes')

df = pd.read_sql_query(
    'doesnt matter, hiding for business',
    cnxn)

df['Counts'] = df.groupby(['DocumentNo'])['ItemNo'].transform('count')

df2 = df[df['Counts'] == 1]

df3 = df2[['ItemNo','DocumentNo','QO']].copy()

df3['Counts'] = df3.groupby(['ItemNo'])['DocumentNo'].transform('count')

df3 = df3[df3['Counts'] > 1]

df4 = df3.groupby(['ItemNo']).QO.sum().reset_index()

df5 = df3.merge(df4, on='ItemNo', how='left')

df6 = df5.groupby(['ItemNo','QO_y'])['DocumentNo'].apply(lambda x: ' | '.join(x.astype(str))).reset_index()


location = input('Please put the exact folder location where you want to put the excel file, and name of file: ')

writer = ExcelWriter(location)
df6.to_excel(writer,'Data')
writer.save()

time.sleep(10)
sys.exit()

在使用pyinstaller创建一个文件后,我打开了程序。我输入用户名,没问题。我可以输入我想要的任何密码,然后它会提示输入excel文件的位置。文件输入时是正确的。为什么会这样?这些密码是特定于用户的,所以我不应该输入任何我想要的密码。第二,当另一个用户试图在共享服务器上打开程序时,他们会输入密码,程序就会关闭

请注意,我隐藏了公司相关信息,包括SQL查询。它不需要向我指出


Tags: import密码dfusernamelocationpasswordcompanyplease