comparison libervia/backend/memory/sqla_mapping.py @ 4161:2074b2bbe616

core (memory/sqla_mapping): `delete-orphan` in History: add `cascade=delete-orphan` to History's `messages`, `subjects` and `thread`, to make modification of those attributes easier.
author Goffi <goffi@goffi.org>
date Tue, 28 Nov 2023 17:35:20 +0100
parents 23d21daed216
children 5f2d496c633f
comparison
equal deleted inserted replaced
4160:6a0066ea5c97 4161:2074b2bbe616
297 nullable=False, 297 nullable=False,
298 ) 298 )
299 extra = Column(LegacyPickle) 299 extra = Column(LegacyPickle)
300 300
301 profile = relationship("Profile") 301 profile = relationship("Profile")
302 messages = relationship("Message", backref="history", passive_deletes=True) 302 messages = relationship(
303 subjects = relationship("Subject", backref="history", passive_deletes=True) 303 "Message",
304 backref="history",
305 cascade="all, delete-orphan",
306 passive_deletes=True
307 )
308 subjects = relationship(
309 "Subject",
310 backref="history",
311 cascade="all, delete-orphan",
312 passive_deletes=True
313 )
304 thread = relationship( 314 thread = relationship(
305 "Thread", uselist=False, back_populates="history", passive_deletes=True 315 "Thread",
316 uselist=False,
317 back_populates="history",
318 cascade="all, delete-orphan",
319 passive_deletes=True
306 ) 320 )
307 __mapper_args__ = {"version_id_col": version_id} 321 __mapper_args__ = {"version_id_col": version_id}
308 322
309 def __init__(self, *args, **kwargs): 323 def __init__(self, *args, **kwargs):
310 source_jid = kwargs.pop("source_jid", None) 324 source_jid = kwargs.pop("source_jid", None)