pytest中_sa_instance_state的SQLAlchemy对象抛出属性错误
pytest中_sa_instance_state的SQLAlchemy对象抛出属性错误
提问于 2021-01-05 20:34:21
我找不到任何其他讨论为SQLAlchemy对象的'sa_instance_state‘获取属性错误的帖子。在pytest方法中调用Voterlist.query.all()时，我得到了这个错误。当我在API内或其他任何地方调用Voterlist.query.all()时，我没有得到这个错误。
这是一个具有前端和api蓝图的Flask应用程序。前端调用API。
conftest.py：
class TestConfig(Config):
TESTING = True
SQLALCHEMY_DATABASE_URI = 'sqlite:///test.db'
WTF_CSRF_ENABLED = False
BCRYPT_LOG_ROUNDS = 4
def fill_database():
s0 = Source(title='Catalist')
s1 = Source(title='L2')
sources = [s0, s1]
l0 = Voterlist(description='Test List 0')
l1 = Voterlist(description='Test List 1')
lists = [l0, l1]
return lists, sources
@pytest.fixture(scope='class')
def test_client():
flask_app = create_app(TestConfig)
with flask_app.test_client() as client:
app_context = flask_app.test_request_context()
app_context.push()
db.create_all()
lists, sources = fill_database()
for s in sources:
db.session.add(s)
db.session.commit()
for l in lists:
db.session.add(l)
db.session.commit()
sleep(1)
yield client
db.drop_all()
app_context.pop() test_api.py：
@pytest.mark.usefixtures('test_client')
class TestLists():
def test_get_lists(self, test_client):
'''Test download all lists.'''
response = test_client.get(url_for('api.lists'))
resplists = response.json['lists']
assert type(resplists) == list
dblists = Voterlist.query.all() <<<< Error here接口方法：
class ListAPI(Resource):
def __init__(self):
self.reqparse = reqparse.RequestParser()
self.fields = ['description', 'vendorquery', 'campaign', 's3key',
'ftimestamp', 'fname', 'source', 'user']
for f in self.fields:
self.reqparse.add_argument(f,
type=str,
location='json')
super(ListAPI, self).__init__()
def get(self):
"""Returns all lists."""
try:
alllists = Voterlist.query.all()
lists = []
for l in alllists:
l = l.__dict__
l.pop('_sa_instance_state', None)
lists.append(l)
return jsonify({'lists': lists})
except Exception as e:
print(e)
abort(400, str(e)) 您可以看到，当API方法调用Voterlist.query.all()时，它可以工作，甚至可以清楚地包含_sa_instance_state属性，否则，当我从列表中的每个对象中弹出该属性时，它将抛出相同的错误。
下面是Voterlist对象的定义：
class Voterlist(db.Model):
id = db.Column(db.Integer, primary_key=True, default=get_time)
description = db.Column(db.String(128))
vendorquery = db.Column(db.String(128))
campaign = db.Column(db.String(128))
s3key = db.Column(db.String(128))
fname = db.Column(db.String(128))
ftimestamp = db.Column(db.Integer)
source = db.Column(db.String(128))
user = db.Column(db.String(128))
status = db.Column(db.Integer, default=0)
def __repr__(self):
return '<List {}: {}>'.format(self.id, self.campaign)下面是pytest的完整输出，以防万一：
=================================================================== test session starts ====================================================================
platform linux -- Python 3.6.9, pytest-6.0.1, py-1.9.0, pluggy-0.13.1
rootdir: /home/alazar66/Downloads/data/rl/rlabs-voter-list-mgr
plugins: anyio-2.0.2
collected 1 item
tests/functional/test_api.py F [100%]
========================================================================= FAILURES =========================================================================
_________________________________________________________________ TestLists.test_get_lists _________________________________________________________________
self = <test_api.TestLists object at 0x74c48f8ff208>, test_client = <FlaskClient <Flask 'app'>>
def test_get_lists(self, test_client):
'''Test download all lists.'''
response = test_client.get(url_for('api.lists'))
resplists = response.json['lists']
assert type(resplists) == list
> dblists = Voterlist.query.all()
tests/functional/test_api.py:15:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/orm/query.py:3373: in all
return list(self)
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py:100: in instances
cursor.close()
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py:70: in __exit__
with_traceback=exc_tb,
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/util/compat.py:182: in raise_
raise exception
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py:80: in instances
rows = [proc(row) for row in fetch]
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py:80: in <listcomp>
rows = [proc(row) for row in fetch]
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
row = (1609879216, 'Test List 0', None, None, None, None, None, None, None, 0)
def _instance(row):
# determine the state that we'll be populating
if refresh_identity_key:
# fixed state that we're refreshing
state = refresh_state
instance = state.obj()
dict_ = instance_dict(instance)
isnew = state.runid != runid
currentload = True
loaded_instance = False
else:
# look at the row, see if that identity is in the
# session, or we have to create a new one
identitykey = (
identity_class,
tuple([row[column] for column in pk_cols]),
identity_token,
)
instance = session_identity_map.get(identitykey)
if instance is not None:
# existing instance
> state = instance_state(instance)
E AttributeError: 'Voterlist' object has no attribute '_sa_instance_state'
/home/alazar66/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py:532: AttributeError
================================================================= short test summary info ==================================================================
FAILED tests/functional/test_api.py::TestLists::test_get_lists - AttributeError: 'Voterlist' object has no attribute '_sa_instance_state'
==================================================================== 1 failed in 3.89s =====================================================================```回答 1
Stack Overflow用户
发布于 2021-01-05 23:00:23
我想通了。为了方便起见，我在API调用方法中不恰当地从对象__dict__属性中删除了'_sa_instance_state‘，并且在API调用之外仍然存在这种删除。
我就这样重写了API调用，并修复了它。
def get(self):
"""Returns all lists."""
try:
alllists = Voterlist.query.all()
lists = []
for l in alllists:
l = {k: v for (k, v) in l.__dict__.items()
if k != '_sa_instance_state'}
lists.append(l)
return jsonify({'lists': lists})
except Exception as e:
print(e)
abort(400, str(e))页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/65586172
复制相关文章
点击加载更多
相似问题
SQLAlchemy 'str‘对象没有属性'_sa_instance_state’
SQLAlchemy 'dict‘对象没有属性'_sa_instance_state’
SqlAlchemy AttributeError：'str‘对象没有属性'_sa_instance_state’
SQLAlchemy: AttributeError：'unicode‘对象没有属性'_sa_instance_state’
AttributeError：“str”对象没有属性“”_sa_instance_state“”- Flask SqlAlchemy
添加站长 进交流群
领取专属 10元无门槛券
AI混元助手 在线答疑
关注 腾讯云开发者公众号
洞察 腾讯核心技术
剖析业界实践案例
腾讯云开发者
