REST database access module (CRUD) for Akera.io web service - used by rest explorer module and other mobile/web clients this broker middleware service provides access to connected databases on the application server. Both meta-data information (database structure) and create/read/update/delete (CRUD) operations are supported.
Installation
$ npm install akera-rest-crudDocs
Quick Start
This module is designed to only be loaded as broker level service which
is usually done by adding a reference to it in services section of
each broker's configuration in akera-web.json configuration file.
"brokers": [
{ "name": "demo",
"host": "localhost",
"port": 3737,
"services": [
{
"middleware": "akera-rest-crud",
"config": {
"route": "/rest-crud/"
}
}
]
}
]Service options available:
- route: the route where the service is going to be mounted (default: '/rest/crud/')
The interface can then be used to retrieve meta-data information about connected databases, create/read/update/delete records from those databases by making HTTP requests:
| Method | Url | Function | Result |
|---|---|---|---|
| GET | http://[host]/[broker]/rest-crud/[db]/[table] |
reads records from database table, optional query parameters (filter, sort, limit, offset) can be sent using the filter parameter through the HTTP query string |
HTTP 404 if no record found, JSON object if only one record found or array if multiple |
| GET | http://[host]/[broker]/rest-crud/[db]/[table]/[id](/[id])* |
reads a single record from database table, primary key field(s) values should be sent as URL segments in the same order as in the primary index definition | HTTP 404 if record not found, JSON object if found |
| GET | http://[host]/[broker]/rest-crud/[db]/[table]/count |
returns number of records from database table, optional query filter can be sent using the filter parameter through the HTTP query string |
JSON object with num property holding the number of records |
| POST | http://[host]/[broker]/rest-crud/[db]/[table] |
create a new record in database table, the request body should be a JSON object holding values to be set for each table's fields | HTTP 500 if error on create, JSON object with full table record (fields might be set in database triggers) |
| PUT | http://[host]/[broker]/rest-crud/[db]/[table]/rowid/[id] |
update a record in database table using the ROWID value sent as last URL segment and the request body should be a JSON object holding values to be set for each table's fields |
HTTP 404 if record not found, HTTP 500 if error on update, JSON object with full table record (fields might be updated in database triggers) |
| PUT | http://[host]/[broker]/rest-crud/[db]/[table]/[id](/[id])* |
update a record in database table, primary key field(s) values should be sent as URL segments and the request body should be a JSON object holding values to be set for each table's fields | HTTP 404 if record not found, HTTP 500 if error on update, JSON object with full table record (fields might be updated in database triggers) |
| DELETE | http://[host]/[broker]/rest-crud/[db]/[table]/rowid/[id] |
delete a record from database table, primary key field(s) values should be sent as URL segments | HTTP 404 if record not found, HTTP 500 if error on delete, JSON object with num property holding the number of records deleted |
| DELETE | http://[host]/[broker]/rest-crud/[db]/[table]/[id](/[id])* |
delete a record from database table using the ROWID value sent as last URL segment |
HTTP 404 if record not found, HTTP 500 if error on delete, JSON object with num property holding the number of records deleted |
| GET | http://[host]/[broker]/rest-crud/meta |
returns the list of connected databases | JSON array with one string entry for each connected database containing the database logical name |
| GET | http://[host]/[broker]/rest-crud/meta/[db] |
returns the list of database's tables, db parameter can be either the database name or zero-base index |
HTTP 404 if database not found, JSON array with one string entry for each database table containing the table name |
| GET | http://[host]/[broker]/rest-crud/meta/[db]/[table] |
returns database table's field information, table parameter can be either the database name or zero-base index |
HTTP 404 if table not found, JSON array with one entry for each table field |
| GET | http://[host]/[broker]/rest-crud/meta/[db]/[table]/index |
returns database table's indexes information, table parameter can be either the database name or zero-base index |
HTTP 404 if table not found, JSON array with one entry for each table index |