Cheers :). I'll have a go and see how it goes!
It's late and I'm well overdue for sleep, so probably not thinking clearly! I think the SPI basically seems to do a lot of work that we implemented in another application, so I can probably take a similar approach, just that you've done the hard bit :) I'll post anything back here, hopefully in a bit less rushed and more sensical manner (Is that even a word?) :) Thanks! Ryan On Wednesday, 28 May 2014 21:34:50 UTC+8, Lukas Eder wrote: > > (It must be Ryan... 3 messages in the thread before I'm here to answer ;-) > ) > > VisitListener examples are overdue, indeed, just as much as some default > implementations for common use-cases like soft-deleting, for instance: > https://github.com/jOOQ/jOOQ/issues/2683 > > Unfortunately, this hasn't been a priority so far. We're hoping to improve > this by jOOQ 3.5. The only example we have so far is this one: > > http://www.jooq.org/doc/latest/manual/sql-building/queryparts/custom-sql-transformation/transformation-bind-value-abbreviation/ > > Maybe you delve into it and if you run into issues, you'll ask concrete > questions? That might also help us assess what should be improved / > documented. > > Cheers > Lukas > > 2014-05-28 14:57 GMT+02:00 Ryan How <[email protected] <javascript:>>: > >> Hi, >> >> Just dropping in. I have a small new project I'm working on and naturally >> using JOOQ :). I'm keen on the multi-tenancy approach with the visit >> listener. Have you got any examples to get started? If I can add >> multi-tenancy without having to go and alter all the SQL that would be >> awesome :). As simple as adding a field to every table and JOOQ can >> automatically insert and query that field?. I'm not sure what the suggested >> approach would be? >> >> I'm mostly thinking I can be quite lazy and rely on JOOQ to make sure I >> don't have any issues with accessing other users data, and also I don't >> have to alter SQL and remember all the time to add a "user_id = ?" on every >> query and join appropriate tables, etc. >> >> Yes, using shared schema... >> >> >> Thanks! Ryan >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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/d/optout.
