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