Admin message

Le support de mattermost va être supprimé de gitlab le 1 juin 2026. Nous vous invitons à utiliser https://chat.obspm.fr en remplacement.

[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

Assignee Loading
Time tracking Loading