Re: [orientdb] Re: How to perform a graph query where the result depends on another Class (data script included)

[SHak]

Luca,

I've adjusted my script to match the request above. it has the counts on 2 
of the edges.

#drop database if already exists
drop database remote:/locahost/touca root pass;

#create touca database
create database remote:localhost/touca root pass local;

#create classes/Vectors
create class User extends V;
create class Language extends V;
create class Label extends V;

#create Links/Edges
create class speaks extends E;
create class is extends E;
create class translatesTo extends E;

#create User Data
create vertex User set name = 'Luca';
create vertex User set name = 'Joe';

#create Language Data
create vertex Language set name = 'En-uk';
create vertex Language set name = 'En-us';
create vertex Language set name = 'Fr-fr';
create vertex Language set name = 'Ru-ru';
create vertex Language set name = 'Ar-sy';

#create Label Data
create vertex Label set name = 'Hello';
create vertex Label set name = 'Salut';
create vertex Label set name = 'Ciao';
create vertex Label set name = 'Good day';
create vertex Label set name = 'Bonjour';
create vertex Label set name = 'Hallo';
create vertex Label set name = 'Marhaba';

#index
create property speaks.out LINK;
create property speaks.in LINK;
CREATE INDEX unique_speaks ON speaks (in, out) UNIQUE;

#create property translatesTo.out LINK;
#create property translatesTo.in LINK;
#CREATE INDEX unique_translatesTo ON translatesTo (in, out) UNIQUE;


#create the links between the User->Language
create edge speaks from (select from User where name = 'Luca') to (select 
from Language where name = 'En-uk');
create edge speaks from (select from User where name = 'Luca') to (select 
from Language where name = 'En-us');
create edge speaks from (select from User where name = 'Luca') to (select 
from Language where name = 'Fr-fr');
create edge speaks from (select from User where name = 'Luca') to (select 
from Language where name = 'Ar-sy');

create edge speaks from (select from User where name = 'Joe') to (select 
from Language where name = 'En-uk');
create edge speaks from (select from User where name = 'Joe') to (select 
from Language where name = 'En-us');

#create the links between label and language
create edge is from (select from Label where name = 'Hello') to (select 
from Language where name = 'En-uk');
create edge is from (select from Label where name = 'Hello') to (select 
from Language where name = 'En-us');
create edge is from (select from Label where name = 'Salut') to (select 
from Language where name = 'Fr-fr');
create edge is from (select from Label where name = 'Ciao') to (select from 
Language where name = 'It-it');
create edge is from (select from Label where name = 'Good day') to (select 
from Language where name = 'En-uk');
create edge is from (select from Label where name = 'Bonjour') to (select 
from Language where name = 'Fr-fr');
create edge is from (select from Label where name = 'Hallo') to (select 
from Language where name = 'Ru-ru');
create edge is from (select from Label where name = 'Marhaba') to (select 
from Language where name = 'Ar-sy');

#create the links between labels
create edge translatesTo from (select from Label where name = 'Hello') to 
(select from Label where name = 'Good day');
create edge translatesTo from (select from Label where name = 'Hello') to 
(select from Label where name = 'Hallo');
create edge translatesTo from (select from Label where name = 'Hello') to 
(select from Label where name = 'Salut') SET ncount = 5;
create edge translatesTo from (select from Label where name = 'Hello') to 
(select from Label where name = 'Ciao') SET ncount = 10;
create edge translatesTo from (select from Label where name = 'Good day') 
to (select from Label where name = 'Bonjour');
create edge translatesTo from (select from Label where name = 'Bonjour') to 
(select from Label where name = 'Marhaba');
create edge translatesTo from (select from Label where name = 'Hallo') to 
(select from Label where name = 'Marhaba');



-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.