def __init__(self, rf: bool=False, atts: Sctids=None, eq: bool=True, ecv: Sctids=None, query=None, _mt_instance=None):
"""
Construct a set of quads from
:param rf: reverse flag. If true ecv applies to source. If false, destination
:param atts: attributes (types)
:param eq: If true, test for equal, if false, for not equal
:param ecv: sources / destinations for testing
:param query: query to use instead of constructing. Still need rf
:return:
"""
Set.__init__(self, Quads)
_Instance.__init__(self, RF2_Quad)
RF2_Substrate_Common.__init__(self)
self._val = self
self._type = Quads
if _mt_instance:
self._query = "SELECT id AS rid, sourceId AS id, typeId, destinationId, gid FROM %s WHERE 0" % \
(RelationshipDB.fname() + "_ext")
self.rf = False
self._len = 0
else:
self._len = None # number of elements
if query:
self._query = query
else:
self._query = "SELECT id AS rid, sourceId" + (" AS id," if not rf else ",")
self._query += " typeId, destinationId" + (" AS id," if rf else ",")
self._query += " gid FROM %s" % RelationshipDB.fname() + '_ext'
self._query += " WHERE "
if atts is not None:
self._query += (("typeId IN (%s)" % atts.as_sql()) if eq else
("typeId NOT IN (%s)" % atts.as_sql())) + " AND "
if ecv is not None:
self._query += (("sourceId IN (%s)" % ecv.as_sql()) if rf else
("destinationId IN (%s)" % ecv.as_sql())) + " AND "
self._query += "active=1 AND locked=0"
self.rf = rf
def ancestorsOrSelf_of(query: Sctids) -> Sctids:
return Sctids(query=_self_query % (_transitive_query % ("parent", query.as_sql(), "child"), query.as_sql()))
def ancestors_of(query: Sctids) -> Sctids:
return Sctids(query=_transitive_query % ("parent", query.as_sql(), "child"))
def descendantsOrSelf_of(query: Sctids) -> Sctids:
return Sctids(query=_self_query % (_transitive_query % ("child", query.as_sql(), "parent"), query.as_sql()))
def descendants_of(query: Sctids) -> Sctids:
return Sctids(query=_transitive_query % ("child", query.as_sql(), "parent"))