How to return a compound object in Neo4j / Cypher

Question

I would like to return a composite object from Neo4j, using cypher to clean up my requests.

To give an example, I have a user account object that has permissions saved as relationships. Permissions are complex objects, therefore they cannot be nested, they are now connected by the relation [: HAS_PERMISSION]. What I would like to do is return a complete complex object with already attached permissions, for example, in the example JSON object below

e.g.

permissions:
{
    action:'delete', 
    resource:'blog posts'
}
{
    action:'edit', 
    resource:'users'
}   

core user account:
{
  username:'Dave',
  email:'[e-mail]'
}

What i'd like:
 {
  username:'Dave',
  email:'[e-mail]'
  permissions: [{action:'delete', resource:'blog posts'},{action:'edit', resource:'users'}]
 }

I currently have a request:

MATCH(user:UserAccount)-[:HasPermission]->(permission:Permission)
WITH {user:user, permissions:collect(permission)} AS UserAccount
RETURN UserAccount

The problem is that this does not quite return what I need, it returns this:

{
     user: {
     username:'Dave',
     email:'[e-mail]'
     },
     permissions: [{action:'delete', resource:'blog posts'},{action:'edit', resource:'users'}]
 }

: , , . , , , ( ).

Answer 1

:

MATCH(user:UserAccount)-[:HasPermission]->(permission:Permission)
WITH { username:user.username, 
       email: user.email, 
       permissions:collect(permission)
     } AS UserAccount
RETURN UserAccount

apoc.map.setKey:

MATCH(user:UserAccount)-[:HasPermission]->(permission:Permission)
WITH user, collect(permission) as permissions
CALL apoc.map.setKey( user, 'permissions', permissions ) YIELD value as UserAccount
RETURN UserAccount

Answer 2

Neo4J 3.1 Map mapsions MATCH(user:UserAccount)-[:HasPermission]->(permission:Permission) WITH user, collect(permission) as permissions RETURN user{ .*, permissions: permissions}

Answer 3

set , . Neo4j , ​​

[{action: 'delete', resource: 'blog posts'}, {action: 'edit', : ''}]

node.

, , - -

{ : 'Dave', : [e-mail] ': [' delete ',' '}}

, UserAccount node.

MATCH(user:UserAccount)-[:HasPermission]->(permission:Permissions)
WITH user AS UserAccount, collect(permission.action +" "+ permission.resource) as permissions set UserAccount.permissions=permissions
return UserAccount

TL;DR: , , @stodb. .