链接orientdb的图形数据库_图数据库orientDB（1-2）例子

CREATE CLASS Company

EXTENDS V;

CREATE CLASS Project

EXTENDS V;

CREATE CLASS Preson

EXTENDS V;

CREATE CLASS Lover

EXTENDS E;

CREATE CLASS Sisiter

EXTENDS E;

CREATE CLASS Brother

EXTENDS E;

CREATE CLASS Employee

EXTENDS E;

CREATE CLASS Work EXTENDS E;

CREATE VERTEX Preson SET name="小朱",sex="男",age="25",company="Lianjia";

CREATE VERTEX Preson SET name="小刘",sex="女",age="23";

CREATE VERTEX Preson SET name="小田",sex="女",age="27";

CREATE VERTEX Company SET name="Lianjia";

CREATE VERTEX Preson SET name="小马",sex="男",age="29",company="Lianjia";

CREATE VERTEX Preson SET name="小龚",sex="男",age="28",company="Lianjia";

CREATE VERTEX Preson SET name="小微",sex="女",age="24",company="Lianjia";

CREATE VERTEX Project SET name="PROJECT-1",type='JAVA',starttime='2016/01/01';

CREATE VERTEX Project SET name="PROJECT-2",type='JAVA',starttime='2016/01/01';

CREATE VERTEX Project SET name="PROJECT-3",type='JAVA',starttime='2016/01/01';

#把以前的顶点移动到每个具体的类别

#MOVE VERTEX(SELECT FROM V WHERE name='ABC') TO CLASS:Company;

#创建情侣关系

CREATE EDGE Lover FROM (select from Preson where name='小朱') TO (select from Preson where name='小刘');

CREATE EDGE Lover FROM (select from Preson where name='小刘') TO (select from Preson where name='小朱');

#创建姐弟关系

CREATE EDGE Sisiter FROM (select from Preson where name='小朱') TO (select from Preson where name='小田');

CREATE EDGE Brother FROM (select from Preson where name='小田') TO (select from Preson where name='小朱');

#创建雇佣关系

CREATE EDGE Employee FROM (select from Preson where company='Lianjia') TO (select from Company where name ='Lianjia');

#创建项目关系

CREATE EDGE Work FROM (select from Preson where name in ['小朱','小马','小微']) TO (select from Project where name='PROJECT-1');

CREATE EDGE Work FROM (select from Preson where name in ['小朱','小马','小微','小龚']) TO (select from Project where name='PROJECT-2');

CREATE EDGE Work FROM (select from Preson where name in ['小朱','小马','小龚']) TO (select from Project where name='PROJECT-3');