3) CRUD Services

HTTP Methods

CRUD services have been implemented following the REST paradigm:

Service	HTTP Method
Create	POST
Retrieve	GET
Update	PUT
Delete	DELETE

Parameters

Each service takes four parameters:

Name	Description	Values
datasource	Name of the datasource.	As specified in the configuration file.
query	Payload that will be passed to the DB.	n.a.
collection	Name of the collection (NoSQL) or of the table (SQL).	n.a.
outputType	Defines the format of the output: array of arrays or array of objects.	object (default) array

Payload

The payload is an object containing different fields according to the method and to the DBMS type.

	CREATE	RETRIEVE	UPDATE	DELETE
query	YES	YES	YES	YES
filters	NO	SQL: NO MongoDB: YES OrientDB: NO	NO	NO
sort	NO	SQL: NO MongoDB: YES OrientDB: NO	NO	NO
limit	NO	SQL: NO MongoDB: YES OrientDB: NO	NO	NO
update	NO	NO	SQL: YES MongoDB: YES OrientDB: YES	NO