Python/MySQL -将csv文件导入mysql
Python/MySQL -将csv文件导入mysql
提问于 2020-01-15 02:47:40
我正在开发一个应用程序，该应用程序包括在目录中选择一个文件(.csv)，然后将其中的数据导入数据库(mysql)，但出现以下错误：
Traceback (most recent call last):
File "C:\Users\TESTES\AppData\Local\Programs\Python\Python38-32\lib\tkinter\__init__.py", line 1883, in __call__
return self.func(*args)
File "C:/Users/TESTES/PycharmProjects/Heiken/tess.py", line 16, in import_file
with open(browse_file):
TypeError: expected str, bytes or os.PathLike object, not function下面是测试界面中的函数的完整代码：
from tkinter import *
import pymysql
from tkinter import filedialog
tess = Tk()
def browse_file():
fname = filedialog.askopenfilename(filetypes=(("Template files", "*.csv"), ("All files", "*")))
print(fname)
def import_file():
conn = pymysql.connect(host='localhost', port=3306, user='root', password='', db='omnia')
print('connect successfull!')
with open(browse_file):
statm = "INSERT INTO omniacademp(n_id, n_cod, c_cnpjcpf, c_razao, c_enderecom, c_nr, c_compl, c_cep, c_bairro, c_cidade, c_estado, c_telefone, c_email, c_celular, c_email2) VALUES (0, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
cursor = conn.cursor()
cursor.execute(statm)
conn.commit()
bt = Button(tess, text='browse file', command=browse_file)
bt.place(x=10, y=10)
bt = Button(tess, text='import file', command=import_file)
bt.place(x=10, y=45)
tess.mainloop()Stack Overflow用户
发布于 2020-01-15 02:59:47
首先，您应该从browse_file函数返回路径。试试这个：
from tkinter import *
import pymysql
from tkinter import filedialog
tess = Tk()
def browse_file():
return filedialog.askopenfilename(filetypes=(("Template files", "*.csv"), ("All files", "*")))
def import_file():
conn = pymysql.connect(host='localhost', port=3306, user='root', password='', db='omnia')
print('connect successfull!')
with open(browse_file()):
statm = "INSERT INTO omniacademp(n_id, n_cod, c_cnpjcpf, c_razao, c_enderecom, c_nr, c_compl, c_cep, c_bairro, c_cidade, c_estado, c_telefone, c_email, c_celular, c_email2) VALUES (0, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
cursor = conn.cursor()
cursor.execute(statm)
conn.commit()
bt = Button(tess, text='browse file', command=browse_file)
bt.place(x=10, y=10)
bt = Button(tess, text='import file', command=import_file)
bt.place(x=10, y=45)
tess.mainloop()页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59739971
复制相关文章
相似问题
腾讯云开发者
