Orientdb извлекает отношения как массив в json

Question

Я хочу получить вершины, соединенные ребром, которые будут возвращены в виде массива как свойство в json.

Например: если POST имеет 10 комментариев, запрос должен возвращать что-то вроде этого.

{
    @class: Post,
    postTitle: "Some title",
    comments: [
        { 
           @class: Comment,
           content: "First Comment,
           someKey: "Some Value"  
        },
        { 
           @class: Comment,
           content: "Second Comment
           someKey: "Some Value"
        }
    ]
}

По этому запросу можно получить одно свойство вершин в массиве.

select *, out('HAS_COMMENT').content as comments from POST

Это приведет к массиву, который имеет только значение свойства 'content' в классе Comment

Мне нужно получить полную запись как вложенный JSON.

ОБНОВИТЬ

Если я просто использую out('HAS_COMMENT') в запросе вместо out('HAS_COMMENT').content, он возвращает @rid поле вместо полной записи.

Answer 1

Я попробовал ваш случай с этой структурой:

create class Post extends V
create class Comment extends V
create class HAS_COMMENT extends E

create property Post.postTitle String
create property Comment.content String
create property Comment.someKey Integer

create vertex Post set postTitle="First"
create vertex Post set postTitle="Second"
create vertex Comment set content="First Comment", someKey="1"
create vertex Comment set content="Second Comment", someKey="2"
create vertex Comment set content="Third Comment", someKey="3"
create vertex Comment set content="Fourth Comment", someKey="4"
create vertex Comment set content="Fifth Comment", someKey="5"
create vertex Comment set content="Sixth Comment", someKey="6"
create vertex Comment set content="Seventh Comment", someKey="7"
create vertex Comment set content="Eighth Comment", someKey="8"
create vertex Comment set content="Ninth Comment", someKey="9"
create vertex Comment set content="Tenth Comment", someKey="10"
create vertex Comment set content="Eleventh Comment", someKey="11"
create vertex Comment set content="Twelfth Comment", someKey="12"
create vertex Comment set content="Thirteenth Comment", someKey="13"
create vertex Comment set content="Fourteenth Comment", someKey="14"

create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="First Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Second Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Third Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Fourth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Fifth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Sixth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Seventh Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Eighth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Ninth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="First") to (select from Comment where content="Tenth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="Second") to (select from Comment where content="Eleventh Comment")
create edge HAS_COMMENT from (select from Post where postTitle="Second") to (select from Comment where content="Twelfth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="Second") to (select from Comment where content="Thirteenth Comment")
create edge HAS_COMMENT from (select from Post where postTitle="Second") to (select from Comment where content="Fourteenth Comment")

Чтобы получить желаемый результат, вы можете использовать следующий запрос:

select expand($ris)
    let $a = (select from Post where postTitle = 'First'),
        $b = (select from Comment where in('HAS_COMMENT').postTitle in $a.postTitle),
        $ris = unionAll($a,$b)

Студия:

Консольный вывод:

----+-----+-------+---------+---------------+---------------+-------+--------------
#   |@RID |@CLASS |postTitle|out_HAS_COMMENT|content        |someKey|in_HAS_COMMENT
----+-----+-------+---------+---------------+---------------+-------+--------------
0   |#12:0|Post   |First    |[size=10]      |null           |null   |null
1   |#13:0|Comment|null     |null           |First Comment  |1      |[size=1]
2   |#13:1|Comment|null     |null           |Second Comment |2      |[size=1]
3   |#13:2|Comment|null     |null           |Third Comment  |3      |[size=1]
4   |#13:3|Comment|null     |null           |Fourth Comment |4      |[size=1]
5   |#13:4|Comment|null     |null           |Fifth Comment  |5      |[size=1]
6   |#13:5|Comment|null     |null           |Sixth Comment  |6      |[size=1]
7   |#13:6|Comment|null     |null           |Seventh Comment|7      |[size=1]
8   |#13:7|Comment|null     |null           |Eighth Comment |8      |[size=1]
9   |#13:8|Comment|null     |null           |Ninth Comment  |9      |[size=1]
10  |#13:9|Comment|null     |null           |Tenth Comment  |10     |[size=1]
----+-----+-------+---------+---------------+---------------+-------+--------------

О вашем вопросе, подчеркнутом в вашем ОБНОВЛЕНИИ, чтобы получить полную запись / записи от @rid Вы можете использовать expand() функция.

Пример:

Получение всех комментариев, связанных с вершиной. postTitle = 'Second'

Запрос: select expand(out('HAS_COMMENT')) from Post where postTitle = 'Second'

Студия:

Консольный вывод:

----+------+-------+------------------+-------+--------------
#   |@RID  |@CLASS |content           |someKey|in_HAS_COMMENT
----+------+-------+------------------+-------+--------------
0   |#13:10|Comment|Eleventh Comment  |11     |[size=1]
1   |#13:11|Comment|Twelfth Comment   |12     |[size=1]
2   |#13:12|Comment|Thirteenth Comment|13     |[size=1]
3   |#13:13|Comment|Fourteenth Comment|14     |[size=1]
----+------+-------+------------------+-------+--------------

Надеюсь, поможет

РЕДАКТИРОВАНИЕ

Запрос:

select *, $a as comments from Post
let $a = (select @class, content, someKey from Comment where in('HAS_COMMENT').postTitle in $parent.current.postTitle)

Студия: