reference to another document about node-odata HOT 5 CLOSED

Hi @tomerpar133 ,

When you use mongoDB which is NoSQL database for persistent data, the best practices is that define a complex type to do this.

In your example, you should:

server.resource('books', {
title: String,
price: Number
authors: {
  name: String
},
categories: [{
  name: String
}],
...
});

So, you maybe not necessary to use reference.

from node-odata.

Hi

I need to do other manipulations on authers and I need it in another document

Is therea way to reference a collection to another?

from node-odata.

Hi,

Unfortunately, it's not support reference, at least for now. You have to query again, which you want to reference's resource (The worst case you should query N+1 times).

You can save resource's id in another resource. For example:

server.resource('books', {
  title: String,
  price: Number
});

server.resource('authors', {
  name: String,
  books: [{ String }]  // <--- book's id
});

Once again, good way is that define a complex type, even need redundant data.

GOOD: easy to query, and faster.
BAD: need update multiple resources when you want to modify it.

server.resource('books', {
  title: String,
  price: Number,
  author: {
    name: String
  }
});

server.resource('authors', {
  name: String,
  books: [{
    title: String,
    price: Number
  }]
});

from node-odata.

Ok
Thank you

from node-odata.

Hi, is there any work invested into enabling this? Especially with complex data with lots of data this would be helpful since data modeling does reduce the size of the db. I understand the workaround but using the reference might make it easier to automatically generate code to consume the api.

from node-odata.