从已知顶点获取连接的顶点详细信息和边详细信息

Question

我已经在pyorient ogm 中创建了类

class Movie(Node):
    element_plural = "Movies"
    title = String(mandatory=True,indexed=True)
    rating = Short()
class Person(Node):
    element_plural = "Person"
    name = String(mandatory=True,indexed=True)
class ACTS_IN(Relationship):
    element_plural = "ACTS"
    name = String()
    out_ = Link(linked_to=Person,mandatory=True)
    in_ = Link(linked_to=Movie,mandatory=True)
class PRODUCED(Relationship):
    element_plural = "Producers"
    out_ = Link(linked_to=Person,mandatory=True)
    in_ = Link(linked_to=Movie,mandatory=True)

如何与演员和制片人一起返回特定电影的所有细节。我应该调用多个查询来获取电影、演员和制片人的详细信息吗？

从title="测试"的影片中选择*

从title="检测"的影片中选择展开(ine((.in((

它对外键不起作用吗？

Answer 1

试试这个：

select title, in("ACTS_IN").name as actors, in("PRODUCED").name as producers from Movie where title= "Test"

希望它能帮助

问候

Answer 2

如果您使用的是orient DB 3.0或更高版本，请使用以下查询来获取顶点和连接顶点的详细信息

select *, ACTS_IN:{*} as actorDetails, PRODUCED:{*} as producerDetailss from Movie where title= "Test"