Often, the first step developers do after creating their database is to create a REST API that can perform Create, Read, Update, and Delete (CRUD) operations for that database. This repo is designed to teach you and give you a starter project (in Ottoman JS using Express) to generate such a REST API. After you have installed travel-sample bucket in your database, you can run this application which is a REST API with Swagger documentation so that you can learn:
- How to create, read, update, and delete documents using Key Value operations (KV operations). KV operations are unique to couchbase and provide super fast (think microseconds) queries.
- How to write simple parametrized SQL++ queries using the built-in travel-sample bucket.
Full documentation for the tutorial can be found on the Couchbase Developer Portal.
To run this prebuilt project, you will need:
- Couchbase Capella cluster with travel-sample bucket loaded.
- To run this tutorial using a self managed Couchbase cluster, please refer to the appendix.
- LTS Node.js Version installed on local machine.
- Basic knowledge of JavaScript, Ottoman and Express
- Loading Travel Sample Bucket If travel-sample is not loaded in your Capella cluster, you can load it by following the instructions for your Capella Cluster:
This quickstart examples demonstrates creating REST API using NodeJS, however, quickstart is also available in following flavors and variants of javascript:
TypeScript REST API quickstart
We will walk through the different steps required to get the application running.
git clone https://github.com/couchbase-examples/ottomanjs-quickstart.git
Any dependencies will be installed by running the npm install command, which installs any dependencies required for the project.
# Execute this command in the project's root directory
npm install
To know more about connecting to your Capella cluster, please follow the instructions.
Specifically, you need to do the following:
- Create the database credentials to access the travel-sample bucket (Read and Write) used in the application.
- Allow access to the Cluster from the IP on which the application is running.
If travel-sample is not loaded in your Capella cluster, you can load it by following the instructions for your Capella Cluster:
All configuration for communication with the database is read from the environment variables. We have provided a convenience feature in this quickstart to read the environment variables from a local file, config/dev.env.example
.
Create a copy of dev.env.example
file and rename it to dev.env
and add the values for the Couchbase connection.
DB_CONN_STR=<connection_string>
DB_USERNAME=<user_with_read_write_permission_to_travel-sample_bucket>
DB_PASSWORD=<password_for_user>
Note: The connection string expects the
couchbases://
orcouchbase://
part.
At this point, we have installed the dependencies, loaded the travel-sample data and configured the application with the credentials. The application is now ready and you can run it.
The application will run on port 3000 of your local machine (http://localhost:3000). You will find the Swagger documentation of the API.
# Execute this command in the project's root directory
npm start
- Build the Docker image
# Execute this command in the project's root directory
docker build -t couchbase-ottoman-express-js-quickstart .
- Run the Docker image
# Execute this command in the project's root directory
docker run -it --env-file config/dev.env -p 3000:3000 couchbase-ottoman-express-js-quickstart
Note: The
config/dev.env
file has the connection information to connect to your Capella cluster. These will be part of the environment variables in the Docker container.
Once the application starts, you can see the details of the application on the terminal.
The application will run on port 3000 of your local machine (http://localhost:3000). You will find the interactive Swagger documentation of the API if you go to the URL in your browser. Swagger documentation is used in this demo to showcase the different API end points and how they can be invoked. More details on the Swagger documentation can be found in the appendix.
Create a copy of config/test.env.example
file and rename it to config/test.env
and add the values for the Couchbase connection.
To run the standard tests, use the following commands:
# Execute this command in the project's root directory
npm test
For this quickstart, we use three collections, airport
, airline
and routes
that contain sample airports, airlines and airline routes respectively. The routes collection connects the airports and airlines as seen in the figure below. We use these connections in the quickstart to generate airports that are directly connected and airlines connecting to a destination airport. Note that these are just examples to highlight how you can use SQL++ queries to join the collections.
If you would like to add another entity to the APIs, these are the steps to follow:
-
Create the New Entity in Couchbase Bucket:
- Utilize the Couchbase Server interface to establish the new collection within the Couchbase bucket.
-
Define the New Route:
- Navigate to the
src/routes
folder and create the new route.
- Navigate to the
-
Controller Configuration:
- Develop a new file in the
controllers
folder, mirroring the existing structures (e.g.,airportController.js
). Craft the corresponding method within this file to manage the new entity.
- Develop a new file in the
-
Add Tests:
- Add the tests for the new routes in a new file in the
__test__
folder similar to other collection tests.
- Add the tests for the new routes in a new file in the
Following these steps ensures a systematic and organized approach to expanding the API functionality with a new entity.
Ottoman simplifies key management by introducing an abstraction layer for handling keys used to store and access documents on the Couchbase database. Developers work with document IDs, while Ottoman automatically manages the keys for them.
The keyGenerator function is crucial in Ottoman's key generation process. The default function combines the model name with a unique identifier to form the key. Developers can override this function to customize key generation.
Example using the default keyGenerator:
const keyGenerator = ({ metadata }) => `${metadata.modelName}::0477024c`;
Example overriding keyGenerator:
const keyGenerator = ({ metadata }) => `${metadata.scopeName}::0477024c`;
const User = model('User', schema, { keyGenerator, scopeName: 'myScope' });
Developers can extend Ottoman's functionality by customizing the keyGenerator function. This allows for modifications to key generation logic, including prefix changes or removal. By understanding Ottoman's internal workings, developers gain the flexibility to tailor the library to specific project requirements.
For more in-depth information, refer to the Ottoman Documentation on How Ottoman Works.
If you are running this quickstart with a self managed Couchbase cluster, you need to load the travel-sample data bucket in your cluster and generate the credentials for the bucket by creating a user.
You need to update the connection string and the credentials in the config/dev.env
file.
Note: Couchbase Server must be installed and running prior to running this app.
Swagger documentation provides a clear view of the API including endpoints, HTTP methods, request parameters, and response objects.
Click on an individual endpoint to expand it and see detailed information. This includes the endpoint's description, possible response status codes, and the request parameters it accepts.
You can try out an API by clicking on the "Try it out" button next to the endpoints.
-
Parameters: If an endpoint requires parameters, Swagger UI provides input boxes for you to fill in. This could include path parameters, query strings, headers, or the body of a POST/PUT request.
-
Execution: Once you've inputted all the necessary parameters, you can click the "Execute" button to make a live API call. Swagger UI will send the request to the API and display the response directly in the documentation. This includes the response code, response headers, and response body.
Swagger documents the structure of request and response bodies using models. These models define the expected data structure using JSON schema and are extremely helpful in understanding what data to send and expect.