OrientDB 学习笔记之常用命令

　

orientdb

OrientDB 学习笔记

简明教程

#创建类
create class Person extends V
create class Company extends V
create class WorkAt extends E
#创建属性
create property Person.firstName string
create property Person.lastName string
create property Company.name string
#插入数据
insert into Person (firstName, lastName) values ("Gary", "White"), ("Join", "Steven"), ("Lin", "Tom")
insert into Company set name = "ABC"
insert into Company set name = "XYZ"
#查询
select from V

这个也不错

https://idlesummerbreeze.wordpress.com/2015/05/18/oirentdb-学习笔记/

数据库命令

• 创建

CREATE DATABASE <database-url> [<user> <password> <storage-type> [<db-type>]]
CREATE DATABASE remote:localhost/GratefulDeadConcerts root ****
CREATE DATABASE PLOCAL:/opt/orientdb/databses/demo root ****

• 更改属性

ALTER DATABASE <attribute-name> <attribute-value> 

• 备份数据库

./backup.sh <dburl> <user> <password> <destination> [<type>]
backup.sh plocal: opt/orientdb/database/demo admin admin ./backup-demo.zip

#或者
CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin 
BACKUP DATABASE ./backup-demo.zip 

• 还原数据库

RESTORE DATABSE <url of the backup zip file>
CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin
RESTORE DATABASE backup-demo.zip

• 链接数据库

RESTORE DATABASE backup-demo.zip
CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin
CONNECT remote:localhost/GratefulDeadConcerts admin admin

• 断开数据库

DISCONNECT

• 查看info

CONNECT remote:localhost/GratefulDeadConcerts admin admin
info

• 列出所有数据库

CONNECT remote:localhost root ****
LIST DATABASES

• 冻结数据库,不响应任何读取和写入状态

CONNECT remote:localhost/GratefulDeadConcerts admin admin
FREEZE DATABASE

• 释放数据库

CONNECT remote:localhost/GratefulDeadConcerts admin admin
RElease DATABASE

• 配置数据库

CONNECT remote:localhost/GratefulDeadConcerts admin admin
CONFIG #(查看)
CONFIG SET <config-variable> <config-value> #(设置)
CONFIG SET tx.autoretry 5 
CONFIG GET <config-variable> #(获取)

• 导出

CONNECT remote:localhost/GratefulDeadConcerts admin admin
EXPORT DATABASE <output file>
EXPORT DATABASE ./export-demo.export

• 导入

CONNECT remote:localhost/GratefulDeadConcerts admin admin
IMPORT DATABASE <output file>
IMPORT DATABASE ./export-demo.export

• 删除

DROP DATABASE [<database-name> <server-username> <server-user-password>]
#1
CONNECT remote:localhost/GratefulDeadConcerts admin admin
orientdb {db = demo}> 
#2
DROP DATABASE PLOCAL:/opt/orientdb/databases/demo admin admin

Record命令

• 插入

#1 创建database-->创建类-->创建property
CREATE DATABASE plocal:/opt/orientdb/databases/sales
create class Customer
create property Customer.id integer
create property Customer.name String
create property Customer.age integer

#2 插入
INSERT INTO [class:]<class>|cluster:<cluster>|index:<index> 
   [(<field>[,]*) VALUES (<expression>[,]*)[,]*]| 
   [SET <field> = <expression>|<sub-command>[,]*]| 
   [content {<JSON>}] 
   [RETURN <expression>]  
   [FROM <query>] 
INSERT INTO Customer (id, name, age) VALUES (01,'satish', 25)
INSERT INTO Customer SET id = 02, name = 'krishna', age = 26 
INSERT INTO Customer CONTENT {"id": "03", "name": "kiran", "age": "29"}
INSERT INTO Customer (id, name, age) VALUES (04,'javeed', 21), (05,'raja', 29) 

#查看
SELECT FROM Customer

• 查看

SELECT [ <Projections> ] [ FROM <Target> [ LET <assignment>* ] ] 
   [ WHERE <Condition>* ] 
   [ GROUP BY <Field>* ] 
   [ order BY <Fields>* [ ASC|DESC ] * ] 
   [ UNWIND <Field>* ] 
   [ SKIP <SkipRecords> ] 
   [ limit <MaxRecords> ] 
   [ FETCHPLAN <FetchPlan> ] 
   [ TIMEOUT <Timeout> [ <STRATEGY> ] ]
   [ LOCK default|record ] 
   [ parallel ] 
   [ NOcache ]

SELECT FROM Customer 
SELECT FROM Customer where name like 'k%' #k开头的所有记录
SELECT FROM Customer WHERE name.left(1) = 'k'
SELECT id, name.toUpperCase() FROM Customer #名字大写
SELECT FROM Customer WHERE age in [25,29] #年纪
SELECT FROM Customer WHERE ANY() LIKE '%sh%' #任意字段包含sh
SELECT FROM Customer ORDER BY age DESC 

• 加载记录,根据id查找记录

SELECT FROM Customer
LOAD RECORD #25:0

• 重新加载记录,还是根据id查找记录，区别是忽略缓存

SELECT FROM Customer
reload  RECORD #25:0

• 导出记录，可以导出为json，感觉比较爽

SELECT FROM Customer
LOAD RECORD #25:0
EXPORT RECORD json

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

• 更新

connect plocal:/opt/orientdb/databases/sales admin admin
select from Customer
UPDATE Customer SET age = 28 WHERE name = 'Raja'

• 删除

connect plocal:/opt/orientdb/databases/sales admin admin
select from Customer
DELETE FROM <Class>|cluster:<cluster>|index:<index> 
   [LOCK <default|record>] 
   [RETURN <returning>] 
   [WHERE <Condition>*] 
   [LIMIT <MaxRecords>] 
   [TIMEOUT <timeout>]
DELETE FROM Customer WHERE id = 4

类命令

• 创建

CREATE DATABASE plocal:/opt/orientdb/databases/sales
#or
connect plocal:/opt/orientdb/databases/sales admin admin
create class Customer
create property Customer.id integer
create property Customer.name String
create property Customer.age integer

#or
CREATE CLASS Account
CREATE CLASS Car EXTENDS Account
CREATE CLASS Person ABSTRACT #抽象类

• 改变类

CREATE DATABASE plocal:/opt/orientdb/databases/sales
#or
connect plocal:/opt/orientdb/databases/sales admin admin

ALTER CLASS <class> <attribute-name> <attribute-value> 

#搞不懂有啥作用
#为现有类“Employee”定义超类“Person”。
ALTER CLASS Employee SUPERCLASS Person
#为现有类“Employee”添加超类“Person”
ALTER CLASS Employee SUPERCLASS +Person 

• 删除类

DROP CLASS <class> 
DROP CLASS Employee

集群命令

用于储存记录、文档或顶点

• 创建

CREATE CLUSTER <cluster> [ID <cluster-id>] 
CREATE CLUSTER sales 

• 改变

ALTER CLUSTER Employee NAME Employee2
ALTER CLUSTER 12 NAME Employee 
#命令将集群冲突策略更改为自动合并
ALTER CLUSTER V CONFICTSTRATEGY automerge 

• 删除

DROP CLUSTER <cluster-name>|<cluster-id>

属性相关命令

• 创建

CREATE DATABASE plocal:/opt/orientdb/databases/sales
#or
connect plocal:/opt/orientdb/databases/sales admin admin
create class Customer
create property Customer.id integer
create property Customer.name String
create property Customer.age integer

CREATE PROPERTY Employee.name STRING

• 改变

ALTER PROPERTY <class>.<property> <attribute-name> <attribute-value>
attribute-name就是NAME等属性
ALTER PROPERTY Customer.age NAME born
#改边为必须属性
ALTER PROPERTY Customer.name MANDATORY TRUE

• 删除

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

顶点相关命令

• 创建

CREATE VERTEX [<class>] [CLUSTER <cluster>] [SET <field> = <expression>[,]*]
CREATE VERTEX
CREATE CLASS V1 EXTENDS V 
CREATE VERTEX V1
CREATE VERTEX V1 SET brand = 'maruti', name = 'swift'

• 移动

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

select from V
+----+-----+------+
|#   |@RID |@CLASS|
+----+-----+------+
|0   |#9:0 |V     |
|1   |#50:0|V1    |
+----+-----+------+
create class Employee extends V
move vertex #50:0 to class:Employee
select from V
+----+-----+--------+
|#   |@RID |@CLASS  |
+----+-----+--------+
|0   |#9:0 |V       |
|1   |#58:0|Employee|
+----+-----+--------+

• 删除

DELETE VERTEX <vertex> [WHERE <conditions>] 
[LIMIT <MaxRecords>>] [BATCH <batch-size>]
DELETE VERTEX #14:1
select from Customer
+----+-----+--------+----+-------+----+
|#   |@RID |@CLASS  |id  |name   |age |
+----+-----+--------+----+-------+----+
|0   |#25:0|Customer|1   |satish |25  |
|1   |#26:0|Customer|2   |krishna|26  |
|2   |#27:0|Customer|3   |kiran  |29  |
|3   |#29:0|Customer|5   |raja   |29  |
+----+-----+--------+----+-------+----+
DELETE VERTEX Customer WHERE isSpam = TRUE 
delete vertex Customer where name = satish
select from Customer
+----+-----+--------+----+-------+----+
|#   |@RID |@CLASS  |id  |name   |age |
+----+-----+--------+----+-------+----+
|0   |#25:0|Customer|1   |satish |25  |
|1   |#26:0|Customer|2   |krishna|26  |
|2   |#27:0|Customer|3   |kiran  |29  |
|3   |#29:0|Customer|5   |raja   |29  |
+----+-----+--------+----+-------+----+

边缘命令

• 创建

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>]
CREATE EDGE FROM #11:4 TO #13:2
CREATE CLASS E1 EXTENDS E 

select from V
+----+-----+--------+
|#   |@RID |@CLASS  |
+----+-----+--------+
|0   |#9:0 |V       |
|1   |#58:0|Employee|
+----+-----+--------+
create class e1 extends E
select from E

create edge E1 from #9:0 to #58:0
select from E
+----+-----+------+----+-----+
|#   |@RID |@CLASS|out |in   |
+----+-----+------+----+-----+
|0   |#66:0|e1    |#9:0|#58:0|
+----+-----+------+----+-----+

• 更新

UPDATE EDGE <edge>  
   [SET|INCREMENT|ADD|REMOVE|PUT <field-name> = <field-value> [,]*]|[CONTENT|MERGE <JSON>] 
   [RETURN <returning> [<returning-expression>]] 
   [WHERE <conditions>] 
   [LOCK default|record] 
   [LIMIT <max-records>] [TIMEOUT <timeout>]
UPDATE EDGE address SET out = (SELECT FROM Address WHERE areaID = 001) 

select from V
+----+-----+--------+-------+------+-----+-------+
|#   |@RID |@CLASS  |out_e1 |brand |name |in_e1  |
+----+-----+--------+-------+------+-----+-------+
|0   |#9:0 |V       |[#66:0]|      |     |       |
|1   |#50:1|V1      |       |maruti|swift|       |
|2   |#58:0|Employee|       |      |     |[#66:0]|
+----+-----+--------+-------+------+-----+-------+
select from E
+----+-----+------+----+-----+
|#   |@RID |@CLASS|out |in   |
+----+-----+------+----+-----+
|0   |#66:0|e1    |#9:0|#58:0|
+----+-----+------+----+-----+
update edge #60:0 set in = #50:1
select from E
+----+-----+------+----+-----+
|#   |@RID |@CLASS|out |in   |
+----+-----+------+----+-----+
|0   |#66:0|e1    |#9:0|#58:0|
+----+-----+------+----+-----+

• 删除

DELETE EDGE  
   ( <rid> 
      | 
      [<rid> (, <rid>)*] 
      | 
      ( [ FROM (<rid> | <select_statement> ) ] [ TO ( <rid> | <select_statement> ) ] ) 
      | 
      [<class>]  
   ( 
      [WHERE <conditions>] 
      [LIMIT <MaxRecords>]  
      [BATCH <batch-size>]
   ))
   
DELETE EDGE FROM #11:2 TO #11:10 WHERE date >= "2012-01-15" 
DELETE EDGE FROM #11:5 TO #11:10 WHERE @class = 'Customer' 
delete edge #66:0

orientdb高级概念

• 图形函数

SELECT out() from Vehicle
select from E

+----+-----+------+----+-----+
|#   |@RID |@CLASS|out |in   |
+----+-----+------+----+-----+
|0   |#17:0|E     |#9:0|#50:1|
+----+-----+------+----+-----+

select from V

+----+-----+--------+-------+-------+------+-----+-------+-------+
|#   |@RID |@CLASS  |out_e1 |out_   |brand |name |in_    |in_e1  |
+----+-----+--------+-------+-------+------+-----+-------+-------+
|0   |#9:0 |V       |[#66:0]|[#17:0]|      |     |       |       |
|1   |#50:1|V1      |       |       |maruti|swift|[#17:0]|       |
|2   |#58:0|Employee|       |       |      |     |       |[#66:0]|
+----+-----+--------+-------+-------+------+-----+-------+-------+

SELECT out() from E

+----+-----+
|#   |out()|
+----+-----+
|0   |     |
+----+-----+

SELECT out() from V

+----+-------+
|#   |out()  |
+----+-------+
|0   |[#50:1]|
|1   |[]     |
|2   |[]     |
+----+-------+


SELECT both() FROM #11:3

• 数学公式

SELECT SUM(salary) FROM Employee 
SELECT avg(salary) FROM Employee
SELECT ID, set(teacher.id) AS teacherID from classess where class_id = 9 

• 其他

SELECT if(eval("name = 'satish'"), "My name is satish","My name is not satish") FROM Employee

相关阅读

主流图数据库Neo4J、ArangoDB、OrientDB综合对比：架构

1： 本地存储方式2： 内置查询语言分析3： 性能分析4： 图算法支持 本地存储方式 Neo4J neo4j数据库支持最大多少个节点？最大支持多少条