Question

Hello

It would be nice to be able to order associations. The order associations appear in the mapping is important when you want to chose the columns order for a composite primary key using foreign keys

Comments

Thanks for feature request. Can you please post here (or send it to [email protected]) example of definition skipper file together with definition files where exactly is order important? Thanks!

---

I have the situation where table a contains a mandatory association to table b and an optional association to table c.
table c also has a mandatory association to table b

Because when skipper creates the yaml file, it is putting the association to table c first.
When c_id is null in table a, then the join to table b also fails because it is via table c

If I manually edit the yaml file to put the association to table b first, then the join is successful

---

I think I understand what you need. As a quick fix, it should be sufficient to change the order of these associations in Skipper xml file. Can you please try it?

Answer 1

Thanks Ludek, the quick fix worked