Orientdb 简明教程

OrientDB console v.1.6.6 www.orientechnologies.com
Type 'help' to display all the commands supported.

orientdb>

orientdb> console.bat "connect remote:localhost/demo;select * from profile"

orientdb> set echo true

Orientdb> CREATE DATABASE PLOCAL:/opt/orientdb/databses/demo

Database created successfully.
Current database is: plocal: /opt/orientdb/databases/demo

orientdb {db = demo}>

orientdb> ALTER DATABASE custom strictSQL = false

Database updated successfully

$ backup.sh plocal: opt/orientdb/database/demo admin admin ./backup-demo.zip

orientdb> CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin

orientdb {db=demo}> BACKUP DATABASE ./backup-demo.zip

Backup executed in 0.30 seconds

$ orientdb

orientdb> CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin

Orientdb {db = demo}> RESTORE DATABASE backup-demo.zip

Database restored in 0.26 seconds

orientdb> CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin

Connecting to database [plocal:/opt/orientdb/databases/demo] with user 'admin'…OK
Orientdb {db = demo}>

orientdb {db = demo}> DISCONNECT

Disconnecting to database [plocal:/opt/orientdb/databases/demo] with user 'admin'…OK
orientdb>

orientdb {db = demo}> info

Current database: demo (url = plocal:/opt/orientdb/databases/demo)

DATABASE PROPERTIES
--------------------------------+---------------------------------------------+
 NAME                           | VALUE                                       |
--------------------------------+---------------------------------------------+
 Name                           | null                                        |
 Version                        | 14                                          |
 Conflict Strategy              | version                                     |
 Date format                    | yyyy-MM-dd                                  |
 Datetime format                | yyyy-MM-dd HH:mm:ss                         |
 Timezone                       | Asia/Kolkata                                |
 Locale Country                 | IN                                          |
 Locale Language                | en                                          |
 Charset                        | UTF-8                                       |
 Schema RID                     | #0:1                                        |
 Index Manager RID              | #0:2                                        |
 Dictionary RID                 | null                                        |
--------------------------------+---------------------------------------------+

DATABASE CUSTOM PROPERTIES:
 +-------------------------------+--------------------------------------------+
 | NAME                          | VALUE                                      |
 +-------------------------------+--------------------------------------------+
 | strictSql                     | true                                       |
 +-------------------------------+--------------------------------------------+
CLUSTERS (collections)
---------------------------------+-------+-------------------+----------------+
 NAME                            | ID    | CONFLICT STRATEGY | RECORDS        |
---------------------------------+-------+-------------------+----------------+

orientdb> connect remote:localhost guest

Connecting to remote Server instance [remote:localhost] with user 'guest'...OK
orientdb {server = remote:localhost/}>

orientdb {server = remote:localhost/}> list databases

Found 6 databases:
* demo (plocal)
* s2 (plocal)
* s1 (plocal)
* GratefulDeadConcerts (plocal)
* s3 (plocal)
* sample (plocal)
orientdb {server = remote:localhost/}>

Orientdb {db = demo}> FREEZE DATABASE

Database 'demo' was frozen successfully

Orientdb {db = demo}> RELEASE DATABASE

Database 'demo' was release successfully

Orientdb {db = demo}> CONFIG

LOCAL SERVER CONFIGURATION:
+---------------------------------------+-------------------------+
| NAME                                  | VALUE                   |
+---------------------------------------+-------------------------+
| environment.dumpCfgAtStartup          | false                   |
| environment.concurrent                | true                    |
| environment.allowJVMShutdown          | true                    |
| script.pool.maxSize                   | 20                      |
| memory.useUnsafe                      | true                    |
| memory.directMemory.safeMode          | true                    |
| memory.directMemory.trackMode         | false                   |
|………………………………..                         |                         |
| storage.lowestFreeListBound           | 16                      |
| network.binary.debug                  | false                   |
| network.http.maxLength                | 1000000                 |
| network.http.charset                  | utf-8                   |
| network.http.jsonResponseError        | true                    |
| network.http.json                     | false                   |
| tx.log.fileType                       | classic                 |
| tx.log.synch                          | false                   |
| tx.autoRetry                          | 1                       |
| client.channel.minPool                | 1                       |
| storage.keepOpen                      | true                    |
| cache.local.enabled                   | true                    |
+---------------------------------------+-------------------------+
orientdb {db = demo}>

CONFIG SET <config-variable> <config-value>

CONFIG GET <config-variable>

orientdb {db = demo}> EXPORT DATABASE ./export-demo.export

Exporting current database to: DATABASE /home/linuxtp/Desktop/demo.export in
GZipped JSON format ...

Started export of database 'demo' to /home/linuxtp/Desktop/demo.export.gz...
Exporting database info...OK
Exporting clusters...OK (12 clusters)
Exporting schema...OK (11 classes)
Exporting records...
- Cluster 'internal' (id = 0)...OK (records = 3/3)
- Cluster 'index' (id = 1)...OK (records = 0/0)
- Cluster 'manindex' (id = 2)...OK (records = 0/0)
- Cluster 'default' (id = 3)...OK (records = 0/0)
- Cluster 'orole' (id = 4)...OK (records = 3/3)
- Cluster 'ouser' (id = 5)...OK (records = 3/3)
- Cluster 'ofunction' (id = 6)...OK (records = 0/0)
- Cluster 'oschedule' (id = 7)...OK (records = 0/0)
- Cluster 'orids' (id = 8)...OK (records = 0/0)
- Cluster 'v' (id = 9)...OK (records = 0/0)
- Cluster 'e' (id = 10)...OK (records = 0/0)
- Cluster '_studio' (id = 11)...OK (records = 1/1)

Done. Exported 10 of total 10 records

Exporting index info...
- Index dictionary...OK
- Index OUser.name...OK
- Index ORole.name...OK
OK (3 indexes)
Exporting manual indexes content...
- Exporting index dictionary ...OK (entries = 0)
OK (1 manual indexes)

Database export completed in 377ms

orientdb {db = demo}> IMPORT DATABASE ./export-demo.export.gz

Database import completed in 11612ms

orientdb {db = demo}> BEGIN

orientdb> INSERT INTO employee (id, name) VALUES (12, 'satish.P')

orientdb> commit

Transaction 2 has been committed in 4ms

orientdb {db = demo}> BEGIN

orientdb> INSERT INTO employee (id, name) VALUES (12, 'satish.P')

orientdb> SELECT FROM employee WHERE name LIKE '%.P'

---+-------+--------------------
 # | ID   | name
---+-------+--------------------
 0 | 12   | satish.P
---+-------+--------------------
1 item(s) found. Query executed in 0.076 sec(s).

orientdb> ROLLBACK

orientdb> SELECT FROM employee WHERE name LIKE '%.P'

0 item(s) found. Query executed in 0.037 sec(s).

OPTIMIZE DATABASE -lwedges

Database Optimization completed in 35ms

orientdb {db = demo}> DROP DATABASE

Database 'demo' deleted successfully

orientdb> DROP DATABASE PLOCAL:/opt/orientdb/databases/demo admin admin

Database 'demo' deleted successfully

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

INSERT INTO Customer (id, name, age) VALUES (01,'satish', 25)

Inserted record 'Customer#11:0{id:1,name:satish,age:25} v1' in 0.069000 sec(s).

INSERT INTO Customer SET id = 02, name = 'krishna', age = 26

Inserted record 'Customer#11:1{id:2,age:26,name:krishna} v1' in 0.005000 sec(s).

INSERT INTO Customer CONTENT {"id": "03", "name": "kiran", "age": "29"}

Inserted record 'Customer#11:2{id:3,name:kiran,age:29} v1' in 0.004000 sec(s).

INSERT INTO Customer (id, name, age) VALUES (04,'javeed', 21), (05,'raja', 29)

Inserted record '[Customer#11:3{id:4,name:javeed,age:21} v1,
Customer#11:4{id:5,name:raja,age:29} v1]' in 0.007000 sec(s).

SELECT FROM Customer

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:1|Customer|2   |krishna|26
2   |#11:2|Customer|3   |kiran  |29
3   |#11:3|Customer|4   |javeed |21
4   |#11:4|Customer|5   |raja   |29
----+-----+--------+----+-------+----

orientdb {db = demo}> SELECT FROM Customer

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:1|Customer|2   |krishna|26
2   |#11:2|Customer|3   |kiran  |29
3   |#11:3|Customer|4   |javeed |21
4   |#11:4|Customer|5   |raja   |29
----+-----+--------+----+-------+----

orientdb {db = demo}> SELECT FROM Customer WHERE name LIKE 'k%'

orientdb {db = demo}> SELECT FROM Customer WHERE name.left(1) = 'k'

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:1|Customer|2   |krishna|26
1   |#11:2|Customer|3   |kiran  |29
----+-----+--------+----+-------+----

orientdb {db = demo}> SELECT id, name.toUpperCase() FROM Customer

----+--------+----+-------
#   |@CLASS  |id  |name
----+--------+----+-------
0   |null    |1   |SATISH
1   |null    |2   |KRISHNA
2   |null    |3   |KIRAN
3   |null    |4   |JAVEED
4   |null    |5   |RAJA
----+--------+----+-------

orientdb {db = demo}> SELECT FROM Customer WHERE age in [25,29]

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:2|Customer|3   |kiran  |29
2   |#11:4|Customer|5   |raja   |29
----+-----+--------+----+-------+----

orientdb {db = demo}> SELECT FROM Customer WHERE ANY() LIKE '%sh%'

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:1|Customer|2   |krishna|26
----+-----+--------+----+-------+----

orientdb {db = demo}> SELECT FROM Customer ORDER BY age DESC

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:2|Customer|3   |kiran  |29
1   |#11:4|Customer|5   |raja   |29
2   |#11:1|Customer|2   |krishna|26
3   |#11:0|Customer|1   |satish |25
4   |#11:3|Customer|4   |javeed |21
----+-----+--------+----+-------+----

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

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

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

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

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

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

orientdb {db = demo}> EXPORT RECORD json

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

Orientdb {db = demo}> UPDATE Customer SET age = 28 WHERE name = 'Raja'

Updated 1 record(s) in 0.008000 sec(s).

orientdb {db = demo}> SELECT FROM Customer

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:1|Customer|2   |krishna|26
2   |#11:2|Customer|3   |kiran  |29
3   |#11:3|Customer|4   |javeed |21
4   |#11:4|Customer|5   |raja   |28
----+-----+--------+----+-------+----

Orientdb {db = demo}> TRUNCATE RECORD #11:4

Truncated 1 record(s) in 0.008000 sec(s).

Orientdb {db = demo}> SELECT FROM Customer

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:1|Customer|2   |krishna|26
2   |#11:2|Customer|3   |kiran  |29
3   |#11:3|Customer|4   |javeed |21
----+-----+--------+----+-------+----

orientdb {db = demo}> DELETE FROM Customer WHERE id = 4

Delete 1 record(s) in 0.008000 sec(s).

Orientdb {db = demo}> SELECT FROM Customer

----+-----+--------+----+-------+----
#   |@RID |@CLASS  |id  |name   |age
----+-----+--------+----+-------+----
0   |#11:0|Customer|1   |satish |25
1   |#11:1|Customer|2   |krishna|26
2   |#11:2|Customer|3   |kiran  |29
----+-----+--------+----+-------+----

orientdb> CREATE CLASS Account

Class created successfully

orientdb> CREATE CLASS Car EXTENDS Vehicle

Class created successfully

orientdb> CREATE CLASS Person ABSTRACT

Class created successfully

orientdb> ALTER CLASS Employee SUPERCLASS Person

Class altered successfully

orientdb> ALTER CLASS Employee SUPERCLASS +Person

Class altered successfully

orientdb> TRUNCATE CLASS Profile

Class truncated successfully

Orientdb> DROP CLASS Employee

Class dropped successfully

orientdb> CREATE CLUSTER sales

Cluster created correctly with id #12

orientdb {db = demo}> ALTER CLUSTER Employee NAME Employee2

Cluster updated successfully

orientdb {db = demo}> ALTER CLUSTER 12 NAME Employee

Cluster updated successfully

orientdb {db = demo}> ALTER CLUSTER V CONFICTSTRATEGY automerge

Cluster updated successfully

Orientdb {db = demo}> TRUNCATE CLUSTER Profile

Cluster truncated successfully.

orientdb> DROP CLUSTER Sales

Cluster dropped successfully

orientdb> CREATE PROPERTY Employee.name STRING

Property created successfully with id = 1

orinetdb {db = demo}> ALTER PROPERTY Customer.age NAME born

Property altered successfully

orientdb {db = demo}> ALTER PROPERTY Customer.name MANDATORY TRUE

Property altered successfully

orientdb> DROP PROPERTY Customer.age

Property dropped successfully

orientdb> CREATE VERTEX

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

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

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

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

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

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

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

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

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)

orientdb> DELETE VERTEX #14:1

Delete record(s) '1' in 0.005000 sec(s)

orientdb> DELETE VERTEX Customer WHERE isSpam = TRUE

Delete record(s) '3' in 0.005000 sec(s)

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

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

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

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

orientdb> UPDATE EDGE address SET out = (SELECT FROM Address WHERE areaID = 001)
WHERE name = 'krishna'

Updated edge '[address[#10:3][#11:3->#14:2]]' in 0.012000 sec(s)

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

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

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

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

orientdb {db = demo}>SELECT out() from Vehicle

---+----------+---------
 # | @class   | out
---+----------+---------
 0 | Vehicle  | #11:2
 1 | Vehicle  | #13:1
 2 | Vehicle  | #13:4
---+----------+---------

orientdb {db = demo}>SELECT both() FROM #11:3

---+----------+--------+-------
 # | @class   | out    | in
---+----------+--------+-------
 0 | Vehicle  | #13:2  | #10:2
 ---+----------+-------+-------

orientdb {db = demo}>SELECT SUM(salary) FROM Employee

---+----------+---------
 # | @CLASS   | sum
---+----------+---------
 0 | null     | 150000
---+----------+---------

orientdb {db = demo}>SELECT avg(salary) FROM Employee

---+----------+---------
 # | @CLASS   | avg
---+----------+---------
 0 | null     | 25
---+----------+---------

orientdb {db = demo}>SELECT ID, set(teacher.id) AS teacherID from classess where class_id = 9

---+----------+--------+--------------------------
 # | @CLASS   | id     | TeacherID
---+----------+--------+--------------------------
 0 | null     | 9     |   1201, 1202, 1205, 1208
---+----------+-------+---------------------------

orientdb {db = demo}> SELECT if(eval("name = 'satish'"), "My name is satish",
"My name is not satish") FROM Employee

----+--------+-----------------------
#   |@CLASS  | IF
----+--------+-----------------------
0   |null    |My name is satish
1   |null    |My name is not satish
2   |null    |My name is not satish
3   |null    |My name is not satish
4   |null    |My name is not satish
----+--------+------------------------

orientdb {db = demo}> SELECT SYSDATE() FROM Employee

----+--------+-----------------------
#   |@CLASS  | SYSDATE
----+--------+-----------------------
0   |null    |2016-02-10 12:05:06
1   |null    |2016-02-10 12:05:06
2   |null    |2016-02-10 12:05:06
3   |null    |2016-02-10 12:05:06
4   |null    |2016-02-10 12:05:06
----+--------+------------------------

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

CREATE SEQUENCE seqid START 1201

Sequence created successfully

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

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

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

ALTER SEQUENCE seqid START 1000

Altered sequence successfully

DROP SEQUENCE <sequence>

DROP SEQUENCE seqid

Sequence dropped successfully

CREATE INDEX <name> [ON <class-name> (prop-names)] <type> [<key-type>]
[METADATA {<metadata>}]

SELECT FROM INDEX:indexforId

----+------+----+-----
#   |@CLASS|key |rid
----+------+----+-----
0   |null  |1   |#11:7
1   |null  |2   |#11:6
2   |null  |3   |#11:5
3   |null  |4   |#11:8
----+------+----+-----

DROP INDEX <name>

DROP INDEX sales_users.Id

Index dropped successfully

COMMIT

ROLLBACK

-server -XX:+PerfDisableSharedMem

$ bin/console.sh (or bin/console.bat under Windows)
orientdb> CONNECT DATABASE local:/temp/demo admin admin
orientdb> EXPORT DATABASE /temp/demo.json.gzip
orientdb> DISCONNECT

orientdb> CREATE DATABASE plocal:/temp/newdb admin admin plocal graph

orientdb> IMPORT DATABASE /temp/demo.json.gzip -preserveClusterIDs=true
orientdb> QUIT

$ server.sh

http://localhost:2480

<users>
   <user name = "root" password = "pwd" resources = "*" />
</users>

<users>
   <user name = "root" password = "pwd" resources = "*" />
</users>

Select From Customer

CREATE DATABASE PLOCAL:/opt/orientdb/databases/testdb
CREATE CLASS Employee
CREATE PROPERTY Customer.id integer
CREATE PROPERTY Customer.name String
CREATE PROPERTY Customer.salary integer
CREATE PROPERTY Customer.join_date date

import com.orientechnologies.common.log.OLogManager;
import com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx;
import org.junit.After;
import org.junit.Before;
import org.junit.BeforeClass;

import java.io.File;
import java.sql.DriverManager;
import java.util.Properties;

import static com.orientechnologies.orient.jdbc.OrientDbCreationHelper.createSchemaDB;
import static com.orientechnologies.orient.jdbc.OrientDbCreationHelper.loadDB;
import static java.lang.Class.forName;

public abstract class OrientJdbcDemo {

   protected OrientJdbcConnection conn;

   public static void main(String ar[]){

      //load Driver
      forName(OrientJdbcDriver.class.getName());
      String dbUrl = "memory:testdb";
      ODatabaseDocumentTx db = new ODatabaseDocumentTx(dbUrl);
      String username = "admin";
      String password = "admin";
      createSchemaDB(db);
      loadDB(db, 20);
      dbtx.create();

      //Create Connection
      Properties info = new Properties();
      info.put("user", username);
      info.put("password", password);
      conn = (OrientJdbcConnection) DriverManager.getConnection("jdbc:orient:" + dbUrl, info);

      //create and execute statement
      Statement stmt = conn.createStatement();
      int updated = stmt.executeUpdate("INSERT into emplyoee
         (intKey, text, salary, date) values ('001','satish','25000','"
         + date.toString() + "')");
      int updated = stmt.executeUpdate("INSERT into emplyoee
         (intKey, text, salary, date) values ('002','krishna','25000','"
         + date.toString() + "')");
      System.out.println("Records successfully inserted");

      //Close Connection
      if (conn != null && !conn.isClosed())
         conn.close();
   }
}

$ javac –classpath:.:orientdb-jdbc-1.0-SNAPSHOT.jar OrientJdbcDemo.java
$ java –classpath:.:orientdb-jdbc-1.0-SNAPSHOT.jar OrientJdbcDemo

Records Successfully Inserted