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
