sqlite3 到 csv 并下载到桌面

Question

我有一个数据库驻留在C：/Projects/Advisor Roster Swap(完整位置= C：/Projects/Advisor Roster Swap/employee.db(。我想将数据库转换为csv并将其下载到我的桌面上。

检查了正确的user_desktop_path(打印了位置，它给了我正确的桌面地址(;但是，无法确认连接是否成功或出了什么问题... 请帮忙

def downloadRoster(self):
user_desktop_path = os.path.join(os.path.join(os.environ['USERPROFILE']), 'Desktop')
response = messagebox.askyesno("Download | Roster After Swap", "Would you like to download the file?")
if response == 'yes':
connection = sqlite3.connect("C:/Projects/Advisor Roster Swap/employee.db")
connection.text_factory = sqlite3.OptimizedUnicode
sql = "SELECT * FROM employee_details"
database_dataframe = pd.read_sql_query(sql, connection)
database_dataframe.sort_values('Date', ascending = FALSE)
database_dataframe.to_csv(user_desktop_path + "Roster After Swap.csv", index = FALSE)
messagebox.showinfo("Download", "Successfully downloaded at desktop location")
elif response == 'no':
pass

Answer 1

您可以执行sql并获取结果以查看连接是否成功。下面是一个可能对您有所帮助的示例：

connection = sqlite3.connect("C:/Projects/Advisor Roster Swap/employee.db")
sql = "SELECT * FROM employee_details;"   
results = connection.execute(sql)
results = results.fetchall()
print(results)
if results:
# Your code here
connection.close()

Answer 2

def downloadRoster( self ):
connection = sqlite3.connect ( "C:/Projects/Advisor Roster Swap/employee.db" )
sql = "SELECT * FROM employee_details;"
database_dataframe = pd.read_sql_query ( sql , connection )
database_dataframe.sort_values ( 'Date' )
user_desktop_path = os.path.join ( os.path.join ( os.environ [ 'USERPROFILE' ] ) , 'Downloads' )
self.destination_path = filedialog.asksaveasfilename ( initialdir = "/" , title = "Select file" , filetypes = (
("CSV files" , "*.csv") , ("all files" , "*.*")) )
database_dataframe.to_csv ( self.destination_path + ".csv" , index = FALSE )
messagebox.showinfo ( "Download" , "Successfully Downloaded" )
connection.commit ()
connection.close ()