activejdbc include parent recursively

Question

I'm work with activejdbc and:

I have 3 Models: City belongs to State belongs to Country, ok? I do this:

Paginator p = new Paginator(City.class, count, filters).orderBy(orderParams); LazyList page = p.getPage(pag).include(State.class);

This, loads cities with their states (i do page.toMaps()),

Now I want to load the country also

It's possible?

score 0 · Accepted Answer · answered Apr 14 '16 at 22:18

0

The include() method goes on dependencies only one level up or down. This means that if you are starting at the level of CIty, you can only get a state. If you want to get both, you can start at the level of State like this:

Paginator p = new Paginator(State.class, count, filters) 
                                       .orderBy(orderParams); 
LazyList page = p.getPage(pag).include(City.class, Country.class);

Not sure of this will work for you though. Here is an example without the Paginator: http://javalite.io/lazy_and_eager#eager-simultaneous-loading-of-parents-and-children

answered Apr 14 '16 at 22:18

ipolevoy

5,432
2
31
46

1

can anyone suggest any simple orm for java with recursive relation loading? – Muhammad Inaam Munir Apr 10 '19 at 10:40
What if there's a table `continents` and I want to eager load its record, too? – Aetherus Feb 08 '21 at 03:09
it is hard to answer your question without understanding your data model. File a new issue here as a question and supply more detail: https://github.com/javalite/javalite/issues – ipolevoy Feb 08 '21 at 20:49

activejdbc include parent recursively

1 Answers1