[DATABASE] SQLAlchemy Warning messages (SAWarning) with Classes AnnotatedNonNullColumn and NonNullColumn
The following warning messages are returned by SQLAlchemy:
root@e1039070fb57:/poppy# pop -ll INFO idb list releases
/poppy/poppy-core/poppy/core/db/handlers.py:193: SAWarning: Class AnnotatedNonNullColumn will not make use of SQL compilation caching as it does not set the 'inherit_cache' attribute to ``True``. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this object can make use of the cache key generated by the superclass. Alternatively, this attribute may be set to False which will disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
return session.query(model).filter_by(**kwargs).one(), False
/poppy/poppy-core/poppy/core/db/connector.py:78: SAWarning: Class NonNullColumn will not make use of SQL compilation caching as it does not set the 'inherit_cache' attribute to ``True``. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this object can make use of the cache key generated by the superclass. Alternatively, this attribute may be set to False which will disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
self.session.commit()
Run with SQLAlchemy 1.4.44, poppy-core 0.11.2dev and poppy-pop 0.8.2dev