2 replies

Getting results in document form rather than record

Hi, new to drizzle but liking it so far. Is there away to get the results in more of a 'document' structure? For example, I'd like to get

{id: 1, user: "joe", posts: [{id : 1, title: "my first post"},{id : 2, title: "my second post"}]}

{id: 1, user: "joe", posts: [{id : 1, title: "my first post"},{id : 2, title: "my second post"}]}

rather than in record form

[{id: 1, user: "joe", post: {id : 1, title: "my first post"}}, ...}]

[{id: 1, user: "joe", post: {id : 1, title: "my first post"}}, ...}]

. I'm doing something like

select({id ... post: {id: posts.id, title, posts.title}})

select({id ... post: {id: posts.id, title, posts.title}})

. Thanks.

2 replies

Hi, new to drizzle but liking it so far. Is there away to get the results in more of a 'document' structure? For example, I'd like to get

{id: 1, user: "joe", posts: [{id : 1, title: "my first post"},{id : 2, title: "my second post"}]}

{id: 1, user: "joe", posts: [{id : 1, title: "my first post"},{id : 2, title: "my second post"}]}

rather than in record form

[{id: 1, user: "joe", post: {id : 1, title: "my first post"}}, ...}]

[{id: 1, user: "joe", post: {id : 1, title: "my first post"}}, ...}]

. I'm doing something like

select({id ... post: {id: posts.id, title, posts.title}})

select({id ... post: {id: posts.id, title, posts.title}})

. Thanks.