I have the following DB:
create class Customer extends V
create class Car extends V
create class Dealer extends V
create class Owns extends E
insert into Customer(first,last) values ('John','Doe')
insert into Customer(first,last) values ('James','Bond')
insert into Customer(first,last) values ('Tony','Stark')
insert into Dealer(name,city,state) values ('Open Cars','New York','NY')
insert into Dealer(name,city,state) values ('Side Cars','Jersey City','NJ')
insert into Car(year,brand,model) values ('2014','Audi','R8')
insert into Car(year,brand,model) values ('2012','Audi','TTRS')
insert into Car(year,brand,model) values ('2014','BMW','M3')
insert into Car(year,brand,model) values ('2012','Jaguar','XKJ')
orientdb {testdb}> select from Car
----+-----+----+------+-----
# |@RID |year|brand |model
----+-----+----+------+-----
0 |#13:0|2014|Audi |R8
1 |#13:1|2014|BMW |M3
2 |#13:2|2012|Jaguar|XKJ
3 |#13:3|2012|Audi |TTRS
----+-----+----+------+-----
3 item(s) found. Query executed in 0.0010 sec(s).
orientdb {testdb}> select from Customer
----+-----+-----+-----
# |@RID |first|last
----+-----+-----+-----
0 |#12:0|John |Doe
1 |#12:1|James|Bond
2 |#12:2|Tony |Stark
----+-----+-----+-----
3 item(s) found. Query executed in 0.0010 sec(s).
//
// Now create car ownership
//
// Tony owns all Audis
orientdb {testdb}> create edge Owns from #12:2 to #13:0
Created edge '[Owns{in:#13:0,out:#12:2}]' in 0.042000 sec(s).
orientdb {testdb}> create edge Owns from #12:2 to #13:3
Created edge '[Owns{in:#13:3,out:#12:2}]' in 0.004000 sec(s).
// James owns BMW and and Audi R8
orientdb {testdb}> create edge Owns from #12:1 to #13:0
orientdb {testdb}> create edge Owns from #12:1 to #13:1
So I can query for all the customer that owns an Audi
orientdb {testdb}> select from (traverse in_Owns from (select from Car
where brand='Audi')) where @class='Customer'
----+-----+--------+-----+-----
# |@RID |out_Owns|first|last
----+-----+--------+-----+-----
0 |#12:2|[size=2]|Tony |Stark
1 |#12:1|[size=2]|James|Bond
----+-----+--------+-----+-----
But how do I do the query if I want to display in a single table owner
first , last and the year,brand,model of the car they own ..?
--
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
