[hibernate-issues] [Hibernate-JIRA] Commented: (OGM-144) Support associations in MongoDB

[Emmanuel Bernard (JIRA)]

    [ https://hibernate.onjira.com/browse/OGM-144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=46123#comment-46123 ] 

Emmanuel Bernard commented on OGM-144:
--------------------------------------

For an actual list or map, we could consider that the row property name be the actual index

{code:javascript}
//considering that MongoDB collections == tables
// in collection "User_Address"
{ 
    "_id" : ObjectId("4f7486c6318ca0fafa7761d0"), 
    "association" : {
        "addresses_id": "169e2d61-ce39-4bca-8300-185487df7119", 
    }
    "rows" : { 
        "1" : { 
            "User_id": "f11e01e8-7c2f-4795-81dc-94de7c4ba246",
            "nick": "home"
         } 
    }
}
{code}

> Support associations in MongoDB
> -------------------------------
>
>                 Key: OGM-144
>                 URL: https://hibernate.onjira.com/browse/OGM-144
>             Project: Hibernate OGM
>          Issue Type: New Feature
>          Components: datastore
>            Reporter: Emmanuel Bernard
>
> h3. Proposal 1
> {code:javascript}
> { 
>     "_id" : ObjectId("4f7486c6318ca0fafa7761d0"), 
>     "columnNames" : [ "addresses_id" ], 
>     "columnValues" : [ "169e2d61-ce39-4bca-8300-185487df7119" ], 
>     "rows" : { 
>         "-387062339" : { 
>             "table" : "User_Address", 
>             "columnNames" : [ "User_id", "nick" ], 
>             "columnValues" : [ "f11e01e8-7c2f-4795-81dc-94de7c4ba246", "home" ] 
>          } 
>     }, 
>     "table" : "User_Address" 
> }
> {code}	
> h3. Proposal 2
> {code:javascript}
> //example 2: closer to how entities are stored
> { 
>     "_id" : ObjectId("4f7486c6318ca0fafa7761d0"), 
>     "table" : "User_Address", 
>     "columnNames" : [ "addresses_id" ], 
>     "columnValues" : [ "169e2d61-ce39-4bca-8300-185487df7119" ], 
>     "rows" : { 
>         "9d2386c6318ca0fafa32867ae" : { 
>             "User_id": "f11e01e8-7c2f-4795-81dc-94de7c4ba246",
>             "nick": "home"
>          } 
>     }
> }	
> {code}
> h3. Proposal 3 assuming MongoDB collection == table
> {code:javascript}
> //example 3: considering that MongoDB collections == tables
> // in collection "User_Address"
> { 
>     "_id" : ObjectId("4f7486c6318ca0fafa7761d0"), 
>     "addresses_id": "169e2d61-ce39-4bca-8300-185487df7119", 
>     "rows" : { 
>         "9d2386c6318ca0fafa32867ae" : { 
>             "User_id": "f11e01e8-7c2f-4795-81dc-94de7c4ba246",
>             "nick": "home"
>          } 
>     }
> }	
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira