def relevant(exp, object_class, target_class, query):
"Filter by relevant object"
if exp['object_name'] == "__previous__":
exp = query[exp['ids'][0]]
object_name = exp['object_name']
ids = exp['ids']
snapshoted = (object_class.__name__ in rules.Types.scoped
and object_name in rules.Types.all)
if not snapshoted:
return object_class.id.in_(
RelationshipHelper.get_ids_related_to(
object_class.__name__,
object_name,
ids,
))
snapshot_qs = models.Snapshot.query.filter(
models.Snapshot.parent_type == models.Audit.__name__,
models.Snapshot.child_type == object_name,
models.Snapshot.child_id.in_(ids),
).options(load_only(models.Snapshot.id), ).distinct().subquery("snapshot")
dest_qs = models.Relationship.query.filter(
models.Relationship.destination_id == snapshot_qs.c.id,
models.Relationship.destination_type == models.Snapshot.__name__,
models.Relationship.source_type == object_class.__name__,
).options(load_only("source_id")).distinct()
source_qs = models.Relationship.query.filter(
models.Relationship.source_id == snapshot_qs.c.id,
models.Relationship.source_type == models.Snapshot.__name__,
models.Relationship.destination_type == object_class.__name__,
).options(load_only("destination_id")).distinct()
ids_qs = dest_qs.union(source_qs).distinct().subquery("ids")
return object_class.id == ids_qs.c.relationships_source_id
def relevant():
"""Filter by relevant object."""
query = (self.query[exp["ids"][0]]
if exp["object_name"] == "__previous__" else exp)
return object_class.id.in_(
RelationshipHelper.get_ids_related_to(
object_class.__name__,
query["object_name"],
query["ids"],
))
def relevant(object_name, ids):
"""Filter by relevant object.
Args:
object_name (basestring): the name of the related model.
ids ([int]): the ids of related objects of type `object_name`.
Returns:
sqlalchemy.sql.elements.BinaryExpression if an object of `object_class`
is related (via a Relationship or another m2m) to one the given objects.
"""
return object_class.id.in_(
RelationshipHelper.get_ids_related_to(
object_class.__name__,
object_name,
ids,
))
def _relevant(object_name, ids):
"""Filter by relevant object.
Args:
object_name (basestring): the name of the related model.
ids ([int]): the ids of related objects of type `object_name`.
Returns:
sqlalchemy.sql.elements.BinaryExpression if an object of `object_class`
is related (via a Relationship or another m2m) to one the given objects.
"""
return object_class.id.in_(
RelationshipHelper.get_ids_related_to(
object_class.__name__,
object_name,
ids,
)
)