| / |
GET |
Home page; display the list of public databases. |
| /about/contact |
GET |
Display the contact information page. |
| /about/gdpr |
GET |
Display the personal data policy page. |
| /about/settings |
GET |
Display the configuration settings. |
| /about/software |
GET |
Display software in system with links and version info. |
| /api |
GET |
API root resource; links to other API resources. |
| /api/db/<name:dbname> |
DELETE, GET, POST, PUT |
GET: List the database tables, views and metadata.
PUT: Create the database, load any input data (Sqlite3 file, XLSX file).
POST: Edit the database metadata.
DELETE: Delete the database.
|
| /api/db/<name:dbname>/query |
POST |
Perform a query of the database; return rows. |
| /api/db/<name:dbname>/readonly |
POST |
POST: Set the database to read-only. |
| /api/db/<name:dbname>/readwrite |
POST |
POST: Set the database to read-write. |
| /api/dbs/all |
GET |
Return the list of all databases. |
| /api/dbs/owner/<name:username> |
GET |
Return the list of databases owned by the given user. |
| /api/dbs/public |
GET |
Return the list of public databases. |
| /api/table/<name:dbname>/<name:tablename> |
DELETE, GET, PUT |
GET: Return the SQL schema for the table in JSON format.
PUT: Create the table from an SQL schema in JSON format.
DELETE: Delete the table.
|
| /api/table/<name:dbname>/<name:tablename>.csv |
GET |
Return the rows in CSV format. |
| /api/table/<name:dbname>/<name:tablename>.json |
GET |
Return the rows in JSON format. |
| /api/table/<name:dbname>/<name:tablename>/empty |
POST |
Empty the table; delete all rows. |
| /api/table/<name:dbname>/<name:tablename>/insert |
POST |
POST: Insert rows from JSON or CSV data into the table. |
| /api/table/<name:dbname>/<name:tablename>/statistics |
GET |
Return the SQL schema for the table with statistics for the columns. |
| /api/table/<name:dbname>/<name:tablename>/update |
POST |
POST: Update table rows from CSV data (JSON not implemented). |
| /api/user/<name:username> |
GET |
Return the API JSON user display. |
| /api/users/all |
GET |
Return the list of all user accounts. |
| /api/view/<name:dbname>/<name:viewname> |
DELETE, GET, PUT |
GET: Return the SQL schema for the view in JSON format.
PUT: Create the view from an SQL schema in JSON format.
DELETE: Delete the view.
|
| /api/view/<name:dbname>/<name:viewname>.csv |
GET |
Return the rows in CSV format. |
| /api/view/<name:dbname>/<name:viewname>.json |
GET |
Return the rows in JSON format. |
| /data/<name:dbname>/<name:dataname> |
GET |
Redirect to display rows in the table or view. |
| /db/ |
GET, POST |
Create a database. |
| /db/<name:dbname>/analyze |
POST |
Run ANALYZE on the database. |
| /db/<name:dbname>/clone |
GET, POST |
Create a clone of the database. |
| /db/<name:dbname>/download |
GET |
Download the Sqlite3 database file. |
| /db/<name:dbname>/edit |
DELETE, GET, POST |
Edit the database metadata. Or delete the database. |
| /db/<name:dbname>/logs |
GET |
Display the logs for a database. |
| /db/<name:dbname>/owner |
GET, POST |
Change owner of the database. |
| /db/<name:dbname>/private |
POST |
Set the database to private access. |
| /db/<name:dbname>/public |
POST |
Set the database to public access. |
| /db/<name:dbname>/readonly |
POST |
Set the database to read-only mode. Compute content hashes. |
| /db/<name:dbname>/readwrite |
POST |
Set the database to read-write mode. |
| /db/<name:dbname>/upload |
GET, POST |
Create a table from the data in a CSV file. |
| /db/<name:dbname>/vacuum |
POST |
Run VACUUM on the database. Also reset the table caches. |
| /db/<nameext:dbname> |
GET |
List the database tables, views and metadata. |
| /dbs/all |
GET |
Display the list of all databases. |
| /dbs/lookup/<hashcode> |
GET |
Lookup and redirect to the database with the given hash. |
| /dbs/owner |
GET |
Display the list of databases owned by the given user. |
| /dbs/public |
GET |
Display the list of public databases. |
| /dbs/upload |
GET, POST |
Upload a database file: Sqlite3 or XLSX file. |
| /documentation/ |
GET |
Home documentation page in Markdown format. |
| /documentation/<page> |
GET |
Documentation page in Markdown format. |
| /documentation/endpoints |
GET |
Display all URL endpoints. |
| /query/<name:dbname> |
GET |
Define a query of the database. |
| /query/<name:dbname>/rows |
GET, POST |
Display results of a query to the database. |
| /query/<name:dbname>/table |
GET, POST |
Create a table containing the results of the query. |
| /site/static/<filename> |
GET |
Static file for the site. |
| /static/<path:filename> |
GET |
Static web page support files. |
| /status |
GET |
Return JSON for the current status and some counts for the database. |
| /table/<name:dbname> |
GET, POST |
Create a table with columns in the database. |
| /table/<name:dbname>/<name:tablename> |
GET |
Display the rows in the table. |
| /table/<name:dbname>/<name:tablename>/clone |
GET, POST |
Create a clone of the table. |
| /table/<name:dbname>/<name:tablename>/column |
GET, POST |
Add a column to the table. |
| /table/<name:dbname>/<name:tablename>/download |
GET |
Download the rows in the table to a file. |
| /table/<name:dbname>/<name:tablename>/download.csv |
GET |
Output a CSV file of the rows in the table. |
| /table/<name:dbname>/<name:tablename>/edit |
DELETE, GET, POST |
Edit the table metadata. Or delete the table. |
| /table/<name:dbname>/<name:tablename>/empty |
POST |
Empty the table; delete all rows. |
| /table/<name:dbname>/<name:tablename>/index |
GET, POST |
Create an index on the table in the database. |
| /table/<name:dbname>/<name:tablename>/index/<indexname> |
DELETE, POST |
Delete the index. 'tablename' is not needed, but included for consistency. |
| /table/<name:dbname>/<name:tablename>/insert |
GET |
Insert data from a file into the table. |
| /table/<name:dbname>/<name:tablename>/insert/csv |
POST |
Insert data from a CSV file into the table. |
| /table/<name:dbname>/<name:tablename>/row |
GET, POST |
Insert a row into the table. |
| /table/<name:dbname>/<name:tablename>/row/<int:rowid> |
DELETE, GET, POST |
Edit or delete a row into the table. |
| /table/<name:dbname>/<name:tablename>/schema |
GET |
Display the schema for a table. |
| /table/<name:dbname>/<name:tablename>/statistics |
GET |
Display statistics for the content of the table's columns. |
| /table/<name:dbname>/<name:tablename>/update |
GET |
Update the table with data from a file. |
| /table/<name:dbname>/<name:tablename>/update/csv |
POST |
Update the table with data from a CSV file. |
| /user/create |
GET, POST |
Create a new user account. |
| /user/disable/<name:username> |
POST |
Disable the given user account. |
| /user/display |
GET |
Display the given user. |
| /user/display/<name:username>/edit |
DELETE, GET, POST |
Edit the user. Or delete the user. |
| /user/display/<name:username>/logs |
GET |
Display the log records of the given user. |
| /user/enable/<name:username> |
POST |
Enable the given user account. |
| /user/login |
GET, POST |
Login to a user account. Set the session cookie. |
| /user/logout |
POST |
Logout from the user account. |
| /user/users |
GET |
Display list of all users. |
| /view/<name:dbname> |
GET, POST |
Create a view of the data in the database. |
| /view/<name:dbname>/<name:viewname> |
GET |
Display rows in the view. |
| /view/<name:dbname>/<name:viewname>/clone |
GET, POST |
Create a clone of the view. |
| /view/<name:dbname>/<name:viewname>/csv |
GET |
Output a CSV file of the rows in the view. |
| /view/<name:dbname>/<name:viewname>/download |
GET |
Download the rows in the view to a file. |
| /view/<name:dbname>/<name:viewname>/edit |
DELETE, GET, POST |
Edit the metadata of the view. Or delete the view. |
| /view/<name:dbname>/<name:viewname>/schema |
GET |
Display the schema for a view. |
SciLifeLab Data Centre
DbShare
2.7.10