OrientDB – Export Record


OrientDB – Export Record


”;


Export Record is the command used to export the loaded record into the requested and supported format. If you are executing any wrong syntax, it will give the list of supported formats. OrientDB is a family of Document database, therefore JSON is the default supported format.

The following statement is the basic syntax of the Export Record command.

EXPORT RECORD <format> 

Where <Format> defines the format you want to get the record.

Note − Export command will export the loaded record based on Record ID.

Example

Let us consider the same Customer table that we have used in the previous chapter.

Sr.No. Name Age
1 Satish 25
2 Krishna 26
3 Kiran 29
4 Javeed 21
5 Raja 29

Try the following query to retrieve the record having Record ID @rid: #11:0.

orientdb {db = demo}> LOAD RECORD #11:0

If the above query is executed successfully, you will get the following output.

+---------------------------------------------------------------------------+ 
| Document - @class: Customer        @rid: #11:0           @version: 1      | 
+---------------------------------------------------------------------------+ 
|                     Name | Value                                          | 
+---------------------------------------------------------------------------+ 
|                       id | 1                                              | 
|                     name | satish                                         | 
|                      age | 25                                             | 
+---------------------------------------------------------------------------+ 

Use the following query to export he loaded record (#11:0) into JSON format.

orientdb {db = demo}> EXPORT RECORD json 

If the above query is executed successfully, you will get the following output.

{ 
   "@type": "d", 
      "@rid": "#11:0", 
   "@version": 1, 
   "@class": "Customer", 
      "id": 1, 
      "name": "satish", 
      "age": 25 
}

Advertisements

”;

Leave a Reply

Your email address will not be published. Required fields are marked *