Hi Pete, >> > - How to convert [A] into [A]_* ? I've no idea, I hadn't seen anything >> > obvious in the interfaces. >> >> Maybe, runtime table mapping could help, here? >> >> http://www.jooq.org/doc/2.6/manual/sql-building/factory/runtime-schema-mapping/#N1061E >> >> This feature was originally designed to allow for adding table >> prefixes in environments where the database / schema is shared among >> several applications - e.g. on a shared hosting provider. It could >> work just the same for you. >> >> If you want, we could also discuss Solution #1, but I feel that it >> will be much harder to do correctly. Specifically because the _1 and >> _2 suffixes used for partitioning should probably be dynamic...? >> > > I think I understand what you're suggesting here - I'm going to try some of > this out over the next couple of days. > > Best I can come up with is to use the date as a generated prefix - > > 2013_01_TABLE_A > 2013_02_TABLE_A > 2013_03_TABLE_A > ... > > Of course, jOOQ itself won't even need to know about the child tables then, > only the parent table TABLE_A. > > Thank you again for the suggestions and help.
You're welcome. Looking forward to feedback about whether this works out for you Cheers Lukas -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
