def __contains__(self, item: RF2_Quad) -> bool:
query = "SELECT count(t.id) FROM %s" % RelationshipDB.fname()
query += " WHERE " + \
"t_contains.sourceId = %s AND t_contains.destinationId = %s AND t_contains.typeId = %s and t_contains.gid = %s" % \
(item.s, item.t, item.a, item.g)
query += " FROM (%s) AS t_contains" % self.as_sql()
return int(list(self._execute_query(self._countSTMT % query))[0]) > 0
def __init__(self, query=None, rf: bool=None):
"""
Construct a set sctidGroups from a set of quads
:param query: quad query
:param rf: reverse flag if source_quads is not supplied
:return:
Note: This function assumes that the following table has been created:
relationship_ss_ext as:
create table relationship_ss_ext as
select *, IF(relationshipGroup > 0, relationshipGroup, id) as gid from relationship_ss
and it should have indices on source, type, dest, source+type, dest+type
"""
super().__init__()
assert rf is not None, "Reverse flag must be supplied"
self._len = None # number of elements
self._rf = rf
sord = 'destinationId' if rf else 'sourceId'
if query is not None:
self._query = "SELECT DISTINCT idg.id, idg.gid"
self._query += " FROM (%s) AS idg" % query
else:
self._query = "SELECT DISTINCT idg.%s AS id, idg.gid" % sord
self._query += " FROM %s AS idg WHERE active=1 AND locked=0" % (RelationshipDB.fname() + '_ext')
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
