[prev in list] [next in list] [prev in thread] [next in thread] 

List:       clamav-users
Subject:    [clamav-users] SAWarning: relationship 'SBHash.reflist'
From:       Alex via clamav-users <clamav-users () lists ! clamav ! net>
Date:       2022-08-22 17:25:02
Message-ID: CAB1R3siivUN46jShztzw061suZNeFHL_C_D1FQ1y2JGdLby8mQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi, this issue was reported some time ago and is still occurring. Any ideas?

./clamsbwrite.py --config /etc/clamd.d/safebrowsing.conf
./clamsbwrite.py:36: SAWarning: relationship 'SBPrefix.hashes' will copy
column sbclient_v4_prefixes.reflist_id to column
sbclient_v4_hashes.reflist_id, which conflicts with relationship(s):
'SBList.hashes' (copies sbclient_v4_lists.id to
sbclient_v4_hashes.reflist_id). If this is not the intention, consider if
these relationships should be linked with back_populates, or if
viewonly=True should be applied to one or more if they are read-only. For
the less common case that foreign key constraints are partially
overlapping, the orm.foreign() annotation can be used to isolate the
columns that should be written towards.   To silence this warning, add the
parameter 'overlaps="hashes"' to the 'SBPrefix.hashes' relationship.
(Background on this error at: https://sqlalche.me/e/14/qzyx)
  lists = session.query(db.SBList).all()
...


https://github.com/Cisco-Talos/clamav-safebrowsing/issues/10

[Attachment #5 (text/html)]

<div dir="ltr">Hi, this issue was reported some time ago and is still occurring. Any \
ideas?<div><br></div><div>./clamsbwrite.py --config \
/etc/clamd.d/safebrowsing.conf<br>./clamsbwrite.py:36: SAWarning: relationship \
&#39;SBPrefix.hashes&#39; will copy column sbclient_v4_prefixes.reflist_id to column \
sbclient_v4_hashes.reflist_id, which conflicts with relationship(s): \
&#39;SBList.hashes&#39; (copies <a \
href="http://sbclient_v4_lists.id">sbclient_v4_lists.id</a> to \
sbclient_v4_hashes.reflist_id). If this is not the intention, consider if these \
relationships should be linked with back_populates, or if viewonly=True should be \
applied to one or more if they are read-only. For the less common case that foreign \
key constraints are partially overlapping, the orm.foreign() annotation can be used \
to isolate the columns that should be written towards.    To silence this warning, \
add the parameter &#39;overlaps=&quot;hashes&quot;&#39; to the \
&#39;SBPrefix.hashes&#39; relationship. (Background on this error at: <a \
href="https://sqlalche.me/e/14/qzyx">https://sqlalche.me/e/14/qzyx</a>)<br>   lists = \
session.query(db.SBList).all()<br><div>...</div><div><br></div><div><br></div><div><a \
href="https://github.com/Cisco-Talos/clamav-safebrowsing/issues/10">https://github.com/Cisco-Talos/clamav-safebrowsing/issues/10</a><br></div></div></div>




_______________________________________________

clamav-users mailing list
clamav-users@lists.clamav.net
https://lists.clamav.net/mailman/listinfo/clamav-users


Help us build a comprehensive ClamAV guide:
https://github.com/Cisco-Talos/clamav-documentation

https://docs.clamav.net/#mailing-lists-and-chat


[prev in list] [next in list] [prev in thread] [next in thread]