Python未插入到MariaDB数据库

2024-03-28 20:57:08 发布

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

我正在尝试使用Python将日志文件中的值插入MariaDB

我的密码是

db = mysql.connector.connect(
    host="localhost",
    user="x",
    passwd="y",
    database="z"
)
cursor=db.cursor()

file=open('../uploads/%s' % baseFileName + '.log','rt')

line=file.readline()
for line in file:
    status1=line.find('UFW')+5
    status2=line.find(' ',status1)-1
    status=line[status1:status2]    

sql_query="INSERT INTO table01 (status) VALUES (%s)"
values=(status)
cursor.execute(sql_query,values)

db.commit()
cursor.close()

file.close()

通过注释掉部分,问题似乎是从sql\u查询行开始的,所以我的语法有点错误

运行此命令时收到的错误消息是:

Traceback (most recent call last):
  File "./process.py", line 43, in <module>
    cursor.execute(sql_query,values)
  File "/usr/local/lib/python2.7/dist-packages/mysql/connector/cursor_cext.py", line 248, in execute
    prepared = self._cnx.prepare_for_mysql(params)
  File "/usr/local/lib/python2.7/dist-packages/mysql/connector/connection_cext.py", line 538, in prepare_for_mysql
    raise ValueError("Could not process parameters")
ValueError: Could not process parameters

我在debian9(Stretch)机器上运行这个。安装的python版本是python2.7.13和python3.5.3,尽管在脚本中我以#开头/usr/bin/python


Tags: inforexecutedbsqlconnectorstatusline