On #2 it's pretty simple, I added schema like this:
ALTER TABLE devices ADD COLUMN zone_offset INTERVAL DAY TO SECOND;
I expected JOOQ to generate a DayToSecond.java field for setting and
getting but it did not, it created a field with setter and getters for type
Object.
R.
On Thursday, July 16, 2015 at 1:46:55 PM UTC-7, Robert DiFalco wrote:
>
> I'm about to do some schema changes to include time intervals (not
> date-time intervals), but before I go to far I was wondering if JOOQ had
> anything special to craft queries like this:
>
> select ...
> from devices d
> where (now() at time zone 'UTC' + make_interval(hours :=
> d.utc_offset_hours))::time
> BETWEEN time '10:00' AND time '22:00';
>
>
> I suppose at the very least I could make it a text string like this:
>
> "select ...
> from devices d
> where (now() at time zone 'UTC' + make_interval(hours :=
> d.utc_offset_hours))::time
> BETWEEN time ?' AND time ?"
>
>
> But it would be nice to be able to construct this query in a type-safe way
> that would detect schema changes. Maybe there is and I just don't know all
> the depths of JOOQ yet.
>
> TIA,
>
> R.
>
--
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 jooq-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
