def delete_object(query_info: Dict[str, str], session: scoped_session, collection: bool = False) -> None: """ Delete the object from the database :param query_info: Dict containing the id and @type of object that has to retrieved :param session: sqlalchemy session :param collection: True if the type_ is of a collection, False for any other class """ type_ = query_info["@type"] id_ = query_info["id_"] database_class = get_database_class(type_) if collection: try: objects = session.query(database_class).filter_by( collection_id=id_).delete() except NoResultFound: raise InstanceNotFound(type_=type_, id_=id_) try: session.commit() except InvalidRequestError: session.rollback() return id_ else: try: object_ = (session.query(database_class).filter( database_class.id == id_).one()) except NoResultFound: raise InstanceNotFound(type_=type_, id_=id_) session.delete(object_) try: session.commit() except InvalidRequestError: session.rollback()
def get_object(query_info: Dict[str, str], session: scoped_session, collection: bool = False) -> Dict[str, str]: """ Get the object from the database :param query_info: Dict containing the id and @type of object that has to retrieved :param session: sqlalchemy session :param collection: True if the type_ is of a collection, False for any other class :return: dict of object with its properties """ type_ = query_info["@type"] id_ = query_info["id_"] database_class = get_database_class(type_) if collection: objects = (session.query( database_class.members, database_class.member_type).filter( database_class.collection_id == id_).all()) if len(objects) == 0: raise InstanceNotFound(type_=type_, id_=id_) object_template = {} object_template["@type"] = query_info["@type"] object_template["members"] = objects return object_template else: try: object_ = (session.query(database_class).filter( database_class.id == id_).one()).__dict__ except NoResultFound: raise InstanceNotFound(type_=type_, id_=id_) # Remove the unnecessary keys from the object retrieved from database object_template = copy.deepcopy(object_) object_template.pop("_sa_instance_state") object_template.pop("id") object_template["@type"] = query_info["@type"] return object_template
def update_single(object_: Dict[str, Any], session: scoped_session, api_name: str, path: str = None) -> int: """Update instance of classes with single objects. :param object_: new object :param session: sqlalchemy scoped session :param api_name: api name specified while starting server :param path: endpoint :return: id of the updated object """ try: rdf_class = session.query(RDFClass).filter( RDFClass.name == object_["@type"]).one() except NoResultFound: raise ClassNotFound(type_=object_["@type"]) try: instance = session.query(Instance).filter( Instance.type_ == rdf_class.id).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_=rdf_class.name) return update( id_=instance.id, type_=object_["@type"], object_=object_, session=session, api_name=api_name, path=path)
def get_single(type_: str, api_name: str, session: scoped_session, path: str = None) -> Dict[str, Any]: """Get instance of classes with single objects. :param type_: type of object to be updated :param api_name: api name specified while starting server :param session: sqlalchemy scoped session :param path: endpoint :return: response containing information about a single object """ try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.type_ == rdf_class.id).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_=rdf_class.name) object_ = get(instance.id, rdf_class.name, session=session, api_name=api_name, path=path) if path is not None: object_["@id"] = "/{}/{}".format(api_name, path) else: object_["@id"] = "/{}/{}".format(api_name, type_) return object_
def delete_multiple(id_: List[int], type_: str, session: scoped_session) -> None: """ To delete multiple rows in a single request :param id_: list of ids for objects to be deleted\ :param type_: type of object to be deleted :param session: sqlalchemy scoped session Raises: ClassNotFound: If `type_` does not represent a valid/defined RDFClass. InstanceNotFound: If any instance with type 'type_' and any id in 'id_' list does not exist. """ id_ = id_.split(',') try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) instances = list() data_III = list() data_IAC = list() data_IIT = list() for index in id_: try: instance = session.query(Instance).filter( Instance.id == index and type_ == rdf_class.id).one() instances.append(instance) except NoResultFound: raise InstanceNotFound(type_=rdf_class.name, id_=index) data_IIT += session.query(triples).filter( triples.GraphIIT.subject == index).all() data_IAC += session.query(triples).filter( triples.GraphIAC.subject == index).all() data_III += session.query(triples).filter( triples.GraphIII.subject == index).all() data = data_III + data_IIT + data_IAC for item in data: session.delete(item) for data in data_IIT: terminal = session.query(Terminal).filter( Terminal.id == data.object_).one() session.delete(terminal) for data in data_III: III_instance = session.query(Instance).filter( Instance.id == data.object_).one() III_instance_type = session.query(RDFClass).filter( RDFClass.id == III_instance.type_).one() # Get the III object type_ delete(III_instance.id, III_instance_type.name, session=session) for instance in instances: session.delete(instance) session.commit()
def get_single_response(session: scoped_session, type_: str): """ Get instance of classes with single objects. :param session: sqlalchemy scoped session :param type_: @type of object to be deleted :return: instance """ database_class = get_database_class(type_) try: instance = session.query(database_class).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_) return instance
def delete_single(type_: str, session: scoped_session) -> None: """Delete instance of classes with single objects.""" try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.type_ == rdf_class.id).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_=rdf_class.name) return delete(instance.id, type_, session=session)
def delete(id_: str, type_: str, session: scoped_session) -> None: """Delete an Instance and all its relations from DB given id [DELETE]. :param id_: id of object to be deleted :param type_: type of object to be deleted :param session: sqlalchemy scoped session Raises: ClassNotFound: If `type_` does not represent a valid/defined RDFClass. InstanceNotFound: If no instace of type `type_` with id `id_` exists. """ try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.id == id_ and type_ == rdf_class.id).one() except NoResultFound: raise InstanceNotFound(type_=rdf_class.name, id_=id_) data_IIT = session.query(triples).filter( triples.GraphIIT.subject == id_).all() data_IAC = session.query(triples).filter( triples.GraphIAC.subject == id_).all() data_III = session.query(triples).filter( triples.GraphIII.subject == id_).all() data = data_III + data_IIT + data_IAC for item in data: session.delete(item) for data in data_IIT: terminal = session.query(Terminal).filter( Terminal.id == data.object_).one() session.delete(terminal) for data in data_III: III_instance = session.query(Instance).filter( Instance.id == data.object_).one() III_instance_type = session.query(RDFClass).filter( RDFClass.id == III_instance.type_).one() # Get the III object type_ delete(III_instance.id, III_instance_type.name, session=session) session.delete(instance) session.commit()
def update_single(object_, session, api_name): """Update instance of classes with single objects.""" try: rdf_class = session.query(RDFClass).filter( RDFClass.name == object_["@type"]).one() except NoResultFound: print("Class not found in update_single") raise ClassNotFound(type_=object_["@type"]) try: instance = session.query(Instance).filter( Instance.type_ == rdf_class.id).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_=rdf_class.name) return update(id_=instance.id, type_=object_["@type"], object_=object_, session=session, api_name=api_name)
def get_single(type_: str, api_name: str, session: Session) -> Dict[str, Any]: """Get instance of classes with single objects.""" try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.type_ == rdf_class.id).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_=rdf_class.name) object_ = get(instance.id, rdf_class.name, session=session, api_name=api_name) object_["@id"] = "/" + api_name + "/" + type_ return object_
def delete(id_: int, type_: str, session: scoped_session) -> None: """Delete an Instance and all its relations from DB given id [DELETE].""" try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: print(type_) raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.id == id_ and type_ == rdf_class.id).one() except NoResultFound: raise InstanceNotFound(type_=rdf_class.name, id_=id_) data_IIT = session.query(triples).filter( triples.GraphIIT.subject == id_).all() data_IAC = session.query(triples).filter( triples.GraphIAC.subject == id_).all() data_III = session.query(triples).filter( triples.GraphIII.subject == id_).all() data = data_III + data_IIT + data_IAC for item in data: session.delete(item) for data in data_IIT: terminal = session.query(Terminal).filter( Terminal.id == data.object_).one() session.delete(terminal) for data in data_III: III_instance = session.query(Instance).filter( Instance.id == data.object_).one() III_instance_type = session.query(RDFClass).filter( RDFClass.id == III_instance.type_).one() # Get the III object type_ delete(III_instance.id, III_instance_type.name, session=session) session.delete(instance) session.commit()
def delete_single(type_: str, session: scoped_session) -> None: """Delete instance of classes with single objects. :param type_: type of object to be deleted :param session: sqlalchemy scoped session :return: None Raises: ClassNotFound: If `type_` does not represt a valid/defined RDFClass. InstanceNotFound: If no Instance of the class exists. """ try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.type_ == rdf_class.id).all()[-1] except (NoResultFound, IndexError, ValueError): raise InstanceNotFound(type_=rdf_class.name) return delete(instance.id, type_, session=session)
def get(id_: int, type_: str, api_name: str, session: scoped_session, recursive: bool = False) -> Dict[str, str]: """Retrieve an Instance with given ID from the database [GET].""" object_template = { "@type": "", } # type: Dict[str, Any] try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.id == id_, Instance.type_ == rdf_class.id).one() except NoResultFound: raise InstanceNotFound(type_=rdf_class.name, id_=id_) data_IAC = session.query(triples).filter( triples.GraphIAC.subject == id_).all() data_III = session.query(triples).filter( triples.GraphIII.subject == id_).all() data_IIT = session.query(triples).filter( triples.GraphIIT.subject == id_).all() for data in data_IAC: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name class_name = session.query(RDFClass).filter( RDFClass.id == data.object_).one().name object_template[prop_name] = class_name for data in data_III: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name instance = session.query(Instance).filter( Instance.id == data.object_).one() # Get class name for instance object inst_class_name = session.query(RDFClass).filter( RDFClass.id == instance.type_).one().name # Recursive call should get the instance needed object_ = get(id_=instance.id, type_=inst_class_name, session=session, recursive=True, api_name=api_name) object_template[prop_name] = object_ for data in data_IIT: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name terminal = session.query(Terminal).filter( Terminal.id == data.object_).one() try: object_template[prop_name] = terminal.value except: # If terminal is none object_template[prop_name] = "" object_template["@type"] = rdf_class.name if not recursive: object_template[ "@id"] = "/" + api_name + "/" + type_ + "Collection/" + str(id_) return object_template
def get(id_: str, type_: str, api_name: str, session: scoped_session, path: str = None) -> Dict[str, str]: """Retrieve an Instance with given ID from the database [GET]. :param id_: id of object to be fetched :param type_: type of object :param api_name: name of api specified while starting server :param session: sqlalchemy scoped session :param path: endpoint :return: response to the request """ object_template = { "@type": "", } # type: Dict[str, Any] try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.id == id_, Instance.type_ == rdf_class.id).one() except NoResultFound: raise InstanceNotFound(type_=rdf_class.name, id_=id_) data_IAC = session.query(triples).filter( triples.GraphIAC.subject == id_).all() data_III = session.query(triples).filter( triples.GraphIII.subject == id_).all() data_IIT = session.query(triples).filter( triples.GraphIIT.subject == id_).all() for data in data_IAC: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name class_name = session.query(RDFClass).filter( RDFClass.id == data.object_).one().name object_template[prop_name] = class_name for data in data_III: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name instance = session.query(Instance).filter( Instance.id == data.object_).one() # Get class name for instance object inst_class_name = session.query(RDFClass).filter( RDFClass.id == instance.type_).one().name doc = get_doc() nested_class_path = "" for collection in doc.collections: if doc.collections[collection]["collection"].class_.path == inst_class_name: nested_class_path = doc.collections[collection]["collection"].path object_template[prop_name] = "/{}/{}/{}".format( api_name, nested_class_path, instance.id) break if nested_class_path == "": object_template[prop_name] = "/{}/{}/".format( api_name, inst_class_name) for data in data_IIT: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name terminal = session.query(Terminal).filter( Terminal.id == data.object_).one() try: object_template[prop_name] = terminal.value except BaseException: # If terminal is none object_template[prop_name] = "" object_template["@type"] = rdf_class.name if path is not None: object_template["@id"] = "/{}/{}Collection/{}".format( api_name, path, id_) else: object_template["@id"] = "/{}/{}Collection/{}".format( api_name, type_, id_) return object_template
def get(id_: int, type_: str, api_name: str, session: scoped_session, recursive: bool = False, path: str=None) -> Dict[str, str]: """Retrieve an Instance with given ID from the database [GET]. :param id_: id of object to be fetched :param type_: type of object :param api_name: name of api specified while starting server :param session: sqlalchemy scoped session :param recursive: flag used to form value for key "@id" :param path: endpoint :return: response to the request """ object_template = { "@type": "", } # type: Dict[str, Any] try: rdf_class = session.query(RDFClass).filter( RDFClass.name == type_).one() except NoResultFound: raise ClassNotFound(type_=type_) try: instance = session.query(Instance).filter( Instance.id == id_, Instance.type_ == rdf_class.id).one() except NoResultFound: raise InstanceNotFound(type_=rdf_class.name, id_=id_) data_IAC = session.query(triples).filter( triples.GraphIAC.subject == id_).all() data_III = session.query(triples).filter( triples.GraphIII.subject == id_).all() data_IIT = session.query(triples).filter( triples.GraphIIT.subject == id_).all() for data in data_IAC: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name class_name = session.query(RDFClass).filter( RDFClass.id == data.object_).one().name object_template[prop_name] = class_name for data in data_III: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name instance = session.query(Instance).filter( Instance.id == data.object_).one() # Get class name for instance object inst_class_name = session.query(RDFClass).filter( RDFClass.id == instance.type_).one().name # Recursive call should get the instance needed object_ = get(id_=instance.id, type_=inst_class_name, session=session, recursive=True, api_name=api_name) object_template[prop_name] = object_ for data in data_IIT: prop_name = session.query(properties).filter( properties.id == data.predicate).one().name terminal = session.query(Terminal).filter( Terminal.id == data.object_).one() try: object_template[prop_name] = terminal.value except BaseException: # If terminal is none object_template[prop_name] = "" object_template["@type"] = rdf_class.name if not recursive: if path is not None: object_template["@id"] = "/" + api_name + \ "/" + path + "Collection/" + str(id_) else: object_template["@id"] = "/" + api_name + \ "/" + type_ + "Collection/" + str(id_) return object_template