python - mysql-python fetchrow 带来: TypeError: 'long' object is not callable

Question

我有一张 table :

+-----------+-------------+------+-----+---------+-------+| Field     | Type        | Null | Key | Default | Extra |+-----------+-------------+------+-----+---------+-------+| Benutzer  | varchar(50) | YES  |     | NULL    |       || Confirmed | tinyint(1)  | YES  |     | NULL    |       |+-----------+-------------+------+-----+---------+-------+

with one entry!

If I execute on the mysql console in a shell:

select Benutzer from UserConfirm where Benutzer = '\{\'gid\'\:\ \'tamer\'\,\ \'uid\'\:\ \'tamer\'\}'

有效!

在 mysql-python 中出现错误消息:

TypeError: 'long' object is not callable

我做错了什么？!这是我的 Python 代码:

cursor = self.__db.cursor().execute('select * from UserConfirm where Benutzer = \'' + ds + '\'') 
return cursor().fetchrow()

如有任何建议，我将非常感谢。

Answer 1

问题是你存储的不是游标对象，只是execute的返回值，不是游标，应该是:

cursor = self.__db.cursor()
cursor.execute('select * from UserConfirm where Benutzer = \'' + ds + '\'') 
return cursor.fetchone()