row = result.fetchone() AttributeError：'NoneType‘对象没有'fetchone’属性
row = result.fetchone() AttributeError：'NoneType‘对象没有'fetchone’属性
提问于 2018-06-05 05:15:41
我有一个python脚本，它应该从postgres数据库中‘获取’信息
create_table.py
from flask import request
from flask_restful import Resource
import psycopg2
class single_user_Request(Resource):
def get(self, username):
connection = psycopg2.connect("dbname = 'tracker' "
"user = 'postgres' "
"password='rasengan1408' "
"host = 'localhost' "
"port='5432'")
cursor = connection.cursor()
query = "SELECT * FROM users WHERE username=%s"
result = cursor.execute(query, (username,))
row = result.fetchone()
connection.close()
if row:
return {'req_id':row[0], 'username':row[1], 'equipment_name': row[2], 'requesttype':row[3], 'description': row[4], 'status':row[5]}
return {'message':'request not found'}, 404初始化.py
from flask import Flask
from flask_restful import Api
from app.api.v1.requests import single_user_Request
def create_app():
app = Flask(__name__)
app.secret_key = 'GciOiJIUzI1NiJ9.eyJleHAiOj'
api = Api(app)
api.add_resource(single_user_Request, '/api/v1/userrequests/<string:username>')
return apprun.py
from app.api import create_app
app = create_app()
app.run(debug=True)在运行脚本之后
AttributeError: 'NoneType' object has no attribute 'fetchone'我很难理解，如果数据库有数据，为什么fetchone会是一个非类型对象
回答 1
Stack Overflow用户
发布于 2018-06-05 05:18:15
cursor.execute不会返回任何内容，您需要像这样更改代码
query = "SELECT * FROM users WHERE username=%s"
cursor.execute(query, (username,))
row = cursor.fetchone()页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50688882
复制相关文章
相似问题