OrientDB - Export Record


Advertisements


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.NameAge
1Satish25
2Krishna26
3Kiran29
4Javeed21
5Raja29

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