Tree like relationships

[philhawthorn]

Hi, I'm wondering what the best way to approach a recursive relationship entity. E.g. like a folder/files tree like structure?

I have the following entity:

@Entity("folders", {
    allowApiCrud: true
})
export class Folder {
    @Fields.autoIncrement()
    id!: number;
    @Fields.string()
    name!: string;
    @Relations.toOne(()=> User, {
        defaultIncluded: true
    })
    owner?: User;
    @Relations.toOne(()=> Folder, {
        defaultIncluded: true
    })
    parent?: Folder;
    @Relations.toMany<Folder, Folder>(()=>Folder, "parent")
    folders?: Folder[] 
}

And the client code, which of course fetches the first level (and I am aware that I can include a pre-determined depth):

const folders = await remult.repo(Folder).find({
  include: {
    folders: true
  }
})

Without remult, I would have queried all records and then organised them hierarchically - I'm wondering if there's an elegant way of handling in remult, if if I would have to do the same?

Many thanks

[noam-honig]

You can set the defaultIncluded of the toMany relations to true and works nice - see:
https://codesandbox.io/p/devbox/demo-tree-shape-qvxkzv
(I had to set the defaultIncluded of the toOne relation to false for this

[philhawthorn]

Ah, thanks so much - I swear I already tried that, but perhaps not. The library is awesome, very slick 👏

[noam-honig]

Thanks - while I was working on it, I ran into a bug with default included - I'm working on it now and will release a version later today

[noam-honig]

Just released version 0.23.25 that will work even if you do keep the defaultIncluded for the toOne relation, and will also filter well on null - even if do not specify allowNull true

[philhawthorn]

Wow, amazing - thank you so much, thats really helpful.

[SpeedoPasanen]

If you eagerly load parent, does also parent.parent etc get loaded recursively ie. potentially a lot of queries?

[noam-honig]

Yes, if that becomes an issue you can selectively include - by setting default included false

…

On Sat, Dec 23, 2023 at 12:03 Toni ***@***.***> wrote: If you eagerly load parent, does also parent.parent etc get loaded recursively ie. potentially a lot of queries? — Reply to this email directly, view it on GitHub <#308 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD65PUZ7CYXMDLEY2RUA6PTYK2T6LAVCNFSM6AAAAABBABU4B6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM3TSMZTGE3TI> . You are receiving this because you commented.Message ID: ***@***.***>