Skip to main content

Check the Existence of a Database

Checking the Database Existance

To check whether a database exists / has been created, the user can issue a GET request on the /db/{dbname} endpoint where {dbname} should be replaced with the dbname for which the user wants to perform this check.

For this query, the submitting user needs to sign {"user_id":"<userid","db_name":"<dbname>"}, where userid denotes the submitting user and the <dbname> denotes the name of the database for which the user is performing the existence check.

When the BDB server boot up, it creates a default database called bdb in the cluster. Hence, we can check its existence. For this case, the submitting user admin needs to sign {"user_id":"admin","db_name":"bdb"} as shown below:

./bin/signer -privatekey=deployment/sample/crypto/admin/admin.key -data='{"user_id":"admin","db_name":"bdb"}'

The above command produces a digital signature and prints it as a base64-encoded string as shown below:

MEUCIBzH0qIz88jKdHsJvmQsNNuK3Cf0G+7LDWSiwv6yjba0AiEAgb/hBFZrr3w64M0Q6LmZjQ0i/sjYr27K1DJSlXHWfRU=

Once the signature is computed, we can issue a GET request using the following cURL command by setting the above signature string in the Signature header.

curl \
   -H "Content-Type: application/json" \
   -H "UserID: admin" \
   -H "Signature: MEUCIBzH0qIz88jKdHsJvmQsNNuK3Cf0G+7LDWSiwv6yjba0AiEAgb/hBFZrr3w64M0Q6LmZjQ0i/sjYr27K1DJSlXHWfRU=" \
   -X GET http://127.0.0.1:6001/db/bdb | jq .

The above command results in the following output:

{
  "response": {
    "header": {
      "node_id": "bdb-node-1"
    },
    "exist": true
  },
  "signature": "MEUCIQCPr3NPVJJ17lYbn7dDSvT7WMVj4mak/VKUcp36YTMeTwIgVJgO3VjA1ZvD6H7k991d5he/ce47+tbBGw28oYFLiRw="
}