Delete edge command is used to remove the database. This is equivalent of the delete command, with the addition of checking and maintaining consistency with vertices by removing all cross-references to the edge from both ‘in’ and ‘out’ vertex properties.

The following statement is the basic syntax of Delete Edge command.

DELETE EDGE
   ( <rid>
      |
      [<rid> (, <rid>)*]
      |
      ( [ FROM (<rid> | <select_statement> ) ] [ TO ( <rid> | <select_statement> ) ] )
      |
      [<class>]
   (
      [WHERE <conditions>]
      [LIMIT <MaxRecords>]
      [BATCH <batch-size>]
   ))

Following are the details about the options in the above syntax.

FROM − Defines the starting point vertex of the edge to delete.

To − Defines the ending point vertex of the edge to delete.

WHERE − Defines the filtering conditions.

LIMIT − Defines the maximum number of edges to delete.

BATCH − Defines the block size for the operation.

Example

Try the following examples to learn how to delete edges.

Execute the following query to delete the edge between two vertices (#11:2, #11:10). But there might be a chance that might exist one or more edges between two vertices. So that we are using the date property for proper functionality. This query will delete the edges which are created on ”2015-01-15” and later.

orientdb {db = demo}> DELETE EDGE FROM #11:2 TO #11:10 WHERE date >= "2012-01-15"

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

Delete record(s) ''2'' in 0.00200 sec(s)

Execute the following query to delete edges starting from the vertex ‘#11:5’ to the vertex ‘#11:10’ and which are related to ‘class = Customer’.

orientdb {db = demo}> DELETE EDGE FROM #11:5 TO #11:10 WHERE @class = ''Customer''

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

Delete record(s) ''2'' in 0.00200 sec(s)

In OrientDB, the concept Edge works like a relation between vertices with the help of some properties. Edges and vertices are the main components of a graph database. It applies polymorphism on Edges. The base class for an Edge is E. While implementing edges, if source or destination vertices are missing or don’t exist, then the transaction will be rollback.

The following statement is the basic syntax of Create Edge Command.

CREATE EDGE <class> [CLUSTER <cluster>] FROM <rid>|(<query>)|[<rid>]* TO <rid>|(<query>)|[<rid>]*
     [SET <field> = <expression>[,]*]|CONTENT {<JSON>}
     [RETRY <retry> [WAIT <pauseBetweenRetriesInMs]] [BATCH <batch-size>]

Following are the details about the options in the above syntax.

<class> − Defines the class name for the edge.

<cluster> − Defines the cluster in which you want to store the edge.

JSON − Provides JSON content to set as the record.

RETRY − Defines the number of retries to attempt in the event of conflict.

WAIT − Defines the time to delay between retries in milliseconds.

BATCH − Defines whether it breaks the command down into smaller blocks and the size of the batches.

Example

Execute the following query to create an edge E between two vertices #9:0 and #14:0.

orientdb> CREATE EDGE FROM #11:4 TO #13:2

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

Created edge ''[e[#10:0][#9:0->#14:0]]'' in 0.012000 sec(s)

Execute the following query to create a new edge type and an edge of new type.

orientdb> CREATE CLASS E1 EXTENDS E
orientdb> CREATE EDGE E1 FROM #10:3 TO #11:4

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

Created edge ''[e[#10:1][#10:3->#11:4]]'' in 0.011000 sec(s)

Sequences is a concept used in auto increment mechanism and it is introduced in OrientDB v2.2. In database terminology, sequence is a structure that manages the counter field. Simply said sequences are mostly used when you need a number that always increments. It supports two types−

ORDERED − Each time the pointer calls the .next method that returns a new value.

CACHED − The sequence will cache ‘N’ items on each node. To call each item we use .next(), which is preferred when the cache contains more than one item.

Create Sequence

Sequence is usually used to auto increment the id value of a person. Like other SQL concepts of OrientDB it also preforms similar operations as Sequence in RDBMS.

The following statement is the basic syntax to create sequences.

CREATE SEQUENCE <sequence> TYPE <CACHED|ORDERED> [START <start>]
[INCREMENT <increment>] [CACHE <cache>]

Following are the details about the options in the above syntax.

<Sequence> − Local name for sequence.

TYPE − Defines the sequence type ORDERED or CACHED.

START − Defines the initial value.

INCREMENT − Defines the increment for each .next method call.

CACHE − Defines the number of value to pre-cache, in the event that you used to cache sequence type.

Let us create a sequence named ‘seqid’ which starts with number 1201. Try the following queries to implement this example with sequence.

CREATE SEQUENCE seqid START 1201

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

Sequence created successfully

Try the following query to use sequence ‘seqid’ to insert the id value of Account table.

INSERT INTO Account SET id = sequence(''seqid'').next()

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

Insert 1 record(s) in 0.001000 sec(s)

Alter Sequence

Alter sequence is a command used to change the properties of a sequence. It will modify all the sequence options except sequence type.

The following statement is the basic syntax to alter sequence.

ALTER SEQUENCE <sequence> [START <start-point>]
[INCREMENT <increment>] [CACHE <cache>]

Following are the details about the options in the above syntax.

<Sequence> − Defines the sequence you want to change.

START − Defines the initial value.

INCREMENT − Defines the increment for each .next method call.

CACHE − Defines the number of value to pre-cache in the event that you used to cache sequence type.

Try the following query to alter the start value from ‘1201 to 1000’ of a sequence named seqid.

ALTER SEQUENCE seqid START 1000

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

Altered sequence successfully

Drop Sequence

Drop sequence is a command used to drop a sequence.

The following statement is the basic syntax to drop a sequence.

DROP SEQUENCE <sequence>

Where <Sequence> defines the sequence you want to drop.

Try the following query to drop a sequence named ‘seqid’.

DROP SEQUENCE seqid

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

Sequence dropped successfully

The Drop property command removes the property from the schema. It does not remove the property values from the record, it just change the schema.

The following statement is the basic syntax of Drop Property Command.

DROP PROPERTY <class>.<property> [FORCE]

Following are the details about the options in the above syntax.

<class> − Defines the class where the property exists.

<property> − Defines the property you want to remove.

[Force] − In case one or more indexes are defined on the property.

Example

Try the following command to remove ‘age’ property from the class ‘Customer’.

orientdb> DROP PROPERTY Customer.age

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

Property dropped successfully

OrientDB database is not only a Document database but also a Graph database. New concepts such as Vertex and Edge are used to store the data in the form of graph. It applies polymorphism on vertices. The base class for Vertex is V.

In this chapter you can learn how to create vertex to store graph data.

The following statement is the basic syntax of Create Vertex Command.

CREATE VERTEX [<class>] [CLUSTER <cluster>] [SET <field> = <expression>[,]*]

Following are the details about the options in the above syntax.

<class> − Defines the class to which the vertex belongs.

<cluster> − Defines the cluster in which it stores the vertex.

<field> − Defines the field you want to set.

<expression> − Defines the express to set for the field.

Example

Try the following example to understand how to create vertex.

Execute the following query to create a vertex without ‘name’ and on the base class V.

orientdb> CREATE VERTEX

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

Created vertex ''V#9:0 v1'' in 0.118000 sec(s)

Execute the following query to create a new vertex class named v1, then create vertex in that class.

orientdb> CREATE CLASS V1 EXTENDS V
orientdb> CREATE VERTEX V1

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

Created vertex ''V1#14:0 v1'' in 0.004000 sec(s)

Execute the following query to create a new vertex of the class named v1, defining its properties such as brand = ”Maruti” and name = ”Swift”.

orientdb> CREATE VERTEX V1 SET brand = ''maruti'', name = ''swift''

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

Created vertex ''V1#14:1{brand:maruti,name:swift} v1'' in 0.004000 sec(s)

Move Vertex command in OrientDB is to move one or more vertices from current location to different class or cluster. If you are applying move command on a particular vertex, then it will update all the edges that are connected to this vertex. If you are specifying a cluster to move vertex, then it moves the vertices to the server owner of the target cluster.

The following statement is the basic syntax of Move Vertex Command.

MOVE VERTEX <source> TO <destination>
[SET [<field>=<value>]* [,]]
[MERGE <JSON>]
[BATCH <batch-size>]

Following are the details about the options in the above syntax.

<source> − Defines the vertex you want to move. It accepts Record ID of a particular vertex or array of Record IDs for vertices.

<destination> − Defines where you want to move the vertex. It supports either class or a cluster as destination.

SET − Sets the values to fields.

MERGE − Sets the values to fields through JSON.

BATCH − Defines the batch size.

Note − This command updates all connected edges, but not links. When using Graph API, it is recommended to use edge connected to vertices.

Example

Try the following examples to learn how to move vertices.

Execute the following query to move a single vertex having Record ID #11:2 from its current position to Class Employee.

orientdb> MOVE VERTEX #11:2 TO CLASS:Employee

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

Move vertex command executed with result ''[{old:#11:2, new:#13:0}]'' in 0.022000 sec(s)

Execute the following query to move set of vertices from the class ‘Customer’ to class ‘Employee’.

orientdb> MOVE VERTEX (SELECT FROM Customer) TO CLASS:Employee

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

Move vertex command executed with result ''[{old:#11:0,
new:#13:1},{old:#11:1, new:#13:2},{old:#11:2, new:#13:3}]'' in 0.011000 sec(s)