Reconstructing Document in OrientDB

Question

I am attempting to make a database to keep a simple menu of items for my favorite restaurants. I have a class for establishments, a class for different menus (like happy hour/dinner/lunch/etc.) and a class for individual items on the menus. Each establishment class has a set of menus and each menu has a set of items.

Is there a single command to reconstruct an entire restaurants menu into a single document?

I'm guessing it has something to do with functions. I have tried messing around with unwind, expand, out, and traverse but I can't seem to figure it out.

Answer 1

Have you tried "fetch plans" in Orientdb. https://orientdb.com/docs/last/Fetching-Strategies.html

Giving -1 as the depth level will go through the links unlimited and load all the documents to a single doc.

In your case the fetch plan would be something like this.

"select from Establishment fetchPlan *:-1"