索引错误：元组索引超出范围 -- 字符串格式化

Question

索引错误：元组索引超出范围 -- 字符串格式化

3

我正在制作一种类似图像留言板的东西，尝试进行 MySQL 插入，但是这段代码会抛出错误：

curs.execute("INSERT INTO posts(date,replies,title,link,text,userip,username) VALUES('{}',{},'{}','{}','{}','{}','{}');".format((self.date.isoformat(),self.replies,self.title,self.embed,self.text,self.userip,self.username)))

以下是错误信息（在Falcon/WSGI上运行时出现）：

2015-05-05 17:37:14,135 :Traceback (most recent call last):
2015-05-05 17:37:14,136 :  File "/bin/user_wsgi_wrapper.py", line 130, in __call__
2015-05-05 17:37:14,136 :    self.error_log_file.logger.exception("Error running WSGI application")
2015-05-05 17:37:14,136 :  File "/usr/lib/python2.7/logging/__init__.py", line 1185, in exception
2015-05-05 17:37:14,136 :    self.error(msg, *args, **kwargs)
2015-05-05 17:37:14,136 :  File "/usr/lib/python2.7/logging/__init__.py", line 1178, in error
2015-05-05 17:37:14,136 :    self._log(ERROR, msg, args, **kwargs)
2015-05-05 17:37:14,136 :  File "/usr/lib/python2.7/logging/__init__.py", line 1270, in _log
2015-05-05 17:37:14,137 :    record = self.makeRecord(self.name, level, fn, lno, msg, args, exc_info, func, extra)
2015-05-05 17:37:14,137 :  File "/usr/lib/python2.7/logging/__init__.py", line 1244, in makeRecord
2015-05-05 17:37:14,137 :    rv = LogRecord(name, level, fn, lno, msg, args, exc_info, func)
2015-05-05 17:37:14,137 :  File "/usr/lib/python2.7/logging/__init__.py", line 284, in __init__
2015-05-05 17:37:14,137 :    self.threadName = threading.current_thread().name
2015-05-05 17:37:14,137 :  File "/usr/lib/python2.7/threading.py", line 1160, in currentThread
2015-05-05 17:37:14,137 :    return _active[_get_ident()]
2015-05-05 17:37:14,137 :  File "/bin/user_wsgi_wrapper.py", line 122, in __call__
2015-05-05 17:37:14,138 :    app_iterator = self.app(environ, start_response)
2015-05-05 17:37:14,138 :  File "/home/isitcoldinfallschurch/.virtualenvs/myvirtualenv/local/lib/python2.7/site-packages/falcon/api.py", line 175, in __call__
2015-05-05 17:37:14,138 :    responder(req, resp, **params)
2015-05-05 17:37:14,138 :  File "./new.py", line 89, in on_post
2015-05-05 17:37:14,139 :    thispost.insertdb()
2015-05-05 17:37:14,139 :  File "./new.py", line 57, in insertdb
2015-05-05 17:37:14,140 :    curs.execute("INSERT INTO posts(date,replies,title,link,text,userip,username) VALUES('{}',{},'{}','{}','{}','{}','{}');".format((self.date.isoformat(),self.replies,self.title,self.embed,self.text,self.userip,self.username)))
2015-05-05 17:37:14,140 :IndexError: tuple index out of range

我该如何纠正这个问题？

- midc111

1

你的第二组{}缺少单引号 VALUES('{}',{},'{}','{}','{}','{}','{}')。 - Cory Kramer

2

你为什么要创建另一个元组？只需执行format(self.date.isoformat(),self.replies,self.title,self.embed,self.text,self.userip,self.username)即可。 - thefourtheye

1

@Cyber 如果该值实际上是一个数字，那么我猜你不需要它们。 - thefourtheye

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- Anshul Goyal · Accepted Answer

您的.format输入中有额外的括号，这会导致它将输入视为一个元组。

证明：

>>> "{}{}".format((1,2))
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
IndexError: tuple index out of range
>>> "{}{}".format(1,2)
'12'

所以，不要这样做

curs.execute("INSERT INTO posts(date,replies,title,link,text,userip,username) VALUES('{}',{},'{}','{}','{}','{}','{}');".format((self.date.isoformat(),self.replies,self.title,self.embed,self.text,self.userip,self.username)))

做这个。

curs.execute("INSERT INTO posts(date,replies,title,link,text,userip,username) VALUES('{}',{},'{}','{}','{}','{}','{}');".format(self.date.isoformat(),self.replies,self.title,self.embed,self.text,self.userip,self.username))

如下评论中@chepner所指出的，更好的方法是使用以下方式，其中%s将由光标填充，使用作为execute的第二个参数传递的元组：

curs.execute("INSERT INTO posts(date,replies,title,link,text,userip,username) VALUES(%s, %s, %s, %s, %s, %s, %s);", (self.date.isoformat(), self.replies, self.title, self.embed, self.text, self.userip, self.username))