(sorry if this gets duplicated) I guess I'm just not clear how I would do a one to many mapping in this situation. If I have customer 13 come in, and I need to query his table, I'm unclear how I can take the "standard" schema, and then say "for this particular query, use this schema against table customer_data_13."
On Friday, April 12, 2024 at 1:51:29 AM UTC-7 [email protected] wrote: > Hi Jason, > > Unless you have complex, per-query naming logic for those tables (in case > of which Replacers would be a good approach), I think that your use-case is > still sufficiently covered by the runtime schema/table mapping feature? > > https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-render-mapping/ > > Why do you think it doesn't address your problem? > > Lukas > > On Thu, Apr 11, 2024 at 10:37 PM Jason Bennett <[email protected]> wrote: > >> I have a use case where I have a certain table that is manually sharded, >> such that each customer account has their own copy of the table, but the >> schema are identical (e.g. customer_data_1, customer_data_2). In the past, >> it appears that static table mapping was the answer, although I don't think >> that actually addresses my problem. >> >> I see there is new functionality called Replacers that seems to do >> exactly what I want, but is commercial-only apparently. Is there similar >> functionality in the open-source version, or just this new feature in >> commercial? >> >> -- >> 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]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/29ffddf7-bd3c-490b-a82d-2f9abbd6c484n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/29ffddf7-bd3c-490b-a82d-2f9abbd6c484n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/c5bb09c7-124a-4f55-9f76-a22936bee524n%40googlegroups.com.
