Custom ordering in oneToMany relations

[oaubert]

Thanks @CodeDredd for this great library, it is really well thought out and implemented.

I have an issue on ordering oneToMany relations. I have a Container model with oneToMany relations with Items (Container { @HasMany(() => Item, 'parentId') }). I want the user to be able to modify the order of items.

The solution that comes to mind is to add an "index" field to Item, and use that when querying the repo : useRepo(Container).with('items', (query) => query.sortBy('index'))

My problem with this solution is that it simplifies retrieving, but not updating (if I change the order, I have to update indexes on all Items), and conceptually, it puts the index information in the Item, while this is a container-level information.

Using a hasManyThrough could solve the "conceptual" issue, but at the cost of a higher retrieval and update complexity.

Does anyone have any insight/example on how to solve this issue?