OrientDB cheatsheet.md

Markdown cheatsheet

Create

• Class
• Cluster
• Edge
• Vertex

Insert

• Insert

Update

• Update

Delete

• Delete

Select

• Select
  • Contains item
  • Contains document with item

Create class

Syntax:

CREATE CLASS <class> 
[EXTENDS <super-class>] 
[CLUSTER <clusterId>*]

Usage:

CREATE CLASS Car 
EXTENDS Vehicle

Create cluster

Syntax:

CREATE CLUSTER <name> <type> 
[DATASEGMENT <data-segment>|default] 
[LOCATION <path>|default] 
[POSITION <position>|append]

Usage:

CREATE CLUSTER account PHYSICAL

Create edge

Syntax:

CREATE EDGE [<class>] 
[CLUSTER <cluster>] 
FROM <rid>|(<query>)|[<rid>]* 
TO <rid>|(<query>)|[<rid>]* 
[SET <field> = <expression>[,]*]

Usage:

CREATE EDGE Drives 
FROM #10:3 
TO #11:4 
SET brand = 'fiat', 
    name = 'wow'

Create vertex

Syntax:

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

Usage:

CREATE VERTEX Car 
SET brand = 'fiat', 
    name = 'wow'

Insert

Syntax:

INSERT INTO <Class>|cluster:<cluster>|index:<index> [<cluster>](cluster) 
[VALUES (<expression>[,]((<field>[,]*))*)]|[<field> = <expression>[,](SET)*]

Usage:

INSERT INTO Profile 
SET name = 'Jay', 
    surname = 'Miner'

INSERT INTO Profile 
CLUSTER profile_recent 
SET name = 'Jay', 
    surname = 'Miner'

Update

Syntax:

UPDATE <class>|cluster:<cluster>|<recordID> 
SET|INCREMENT [= <field-value>](<field-name>)
[<field-name> = <field-value>](,)* 
[<conditions>](WHERE) 
[<max-records>](LIMIT)

Collections:

UPDATE <class>|cluster:<cluster>|<recordID> 
[[<field-name> = <field-value>](ADD|REMOVE])
[<field-name> = <field-value>](,)* 
[<conditions>](WHERE)

Maps:

UPDATE <class>|cluster:<cluster>|<recordID> 
[[<field-name> = <map-key> [,<map-value>]](PUT|REMOVE])
[<field-name> = <map-key> [,<map-value>]](,)* 
[<conditions>](WHERE)

Delete

Syntax:

DELETE FROM <Class>|cluster:<cluster>|index:<index> 
[<Condition>*](WHERE) 
[BY <Fields>* [ASC|DESC](ORDER)*] 
[<MaxRecords>](LIMIT)

Usage:

DELTE FROM Profile WHERE surname = 'unknown'

Select

Syntax:

SELECT 
[FROM <Target> 
[LET <Assignment>*](<Projections>]) 
[<Condition>*](WHERE) 
[BY <Field>](GROUP) 
[BY <Fields>* [ASC|DESC](ORDER)*] 
[<SkipRecords>](SKIP) 
[<MaxRecords>](LIMIT)

Usage:

SELECT foo, bar 
FROM Person 
WHERE foo LIKE 'bar%'

Contains item

SELECT foo, bar, languages
FROM Profile
WHERE languages CONTAINS 'English'

Contains document with item

SELECT foo, bar, Tags
FROM Articles
WHERE Tags CONTAINS (title = 'Java')