I'm trying to run the following query in jooq.
select * from tpas.edt_task where status = 'ERROR' and
(source_date_time at TIME ZONE source_time_zone)::DATE = current_date
- integer '1'
To translate that into jooq the best I could find was something along these
lines.
dslContext.selectFrom(TPAS.EDT_TASK)
.where(TPAS.EDT_TASK.STATUS.eq("ERROR"))
.and(field("(source_date_time at TIME ZONE
source_time_zone)::DATE", LocalDate.class)
.eq(DSL.currentLocalDate().sub(1)))
.fetch()
.forEach(record -> DBHelper.constructMap(record, columns, results));
The generated SQL looks something along these lines.
select
tpas.edt_task.id,
tpas.edt_task.tpasns_id,
tpas.edt_task.advertiser_id,
tpas.edt_task.data_source,
tpas.edt_task.log_type,
tpas.edt_task.source_uri,
tpas.edt_task.source_date,
tpas.edt_task.source_size,
tpas.edt_task.status,
tpas.edt_task.state,
tpas.edt_task.start_time,
tpas.edt_task.end_time,
tpas.edt_task.executed_by,
tpas.edt_task.parent_id,
tpas.edt_task.part_num,
tpas.edt_task.records_invalid,
tpas.edt_task.records_read,
tpas.edt_task.submission_time,
tpas.edt_task.submitted_by,
tpas.edt_task.source_time,
tpas.edt_task.config_pk,
tpas.edt_task.source_time_zone,
tpas.edt_task.source_date_timefrom tpas.edt_taskwhere
(tpas.edt_task.status = 'ERROR' and
(source_date_time at TIME ZONE source_time_zone) :: DATE =
(current_date + (-(1) || ' day') :: interval))
Is there an API i can invoke that wouldn't require me to use a
field("....") notation? also the syntax looks a bit goofy though I think
it's functionally equivalent.
--
Thank you
Samir Faci
https://keybase.io/csgeek
--
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.
