I've been searching and googling and..
override fun update( agendaItem : AgendaItem, agendaId: AgendaId, zaakId:
ZaakId): Int =
val derivedTable = select(AGENDA_ITEM.ID,
AGENDA_ITEM.BEGINDATUM,
AGENDA_ITEM_TYPE.HELE_DAG
)
.from(AGENDA_ITEM
,AGENDA_ITEM_TYPE)
.where(AGENDA_ITEM_TYPE.ID).eq(AGENDA_ITEM.ITEM_TYPE_ID)
// this where gives an compiler error
.asTable("heleDagEvent")
val updateQuery = usingDSL { context ->
context.update(AGENDA_ITEM)
.set(AGENDA_ITEM.BEGINDATUM, agendaItem.begindatum)
// The agendaItem signature parameter is not recognized
.set(AGENDA_ITEM.EINDDATUM, agendaItem .einddatum)
.set(AGENDA_ITEM.BEGINTIJD, agendaItem .begintijd)
.set(AGENDA_ITEM.EINDTIJD, agendaItem .eindtijd)
.set(AGENDA_ITEM.RECORD_VERSION, agendaItem .recordVersion + 1)
.from(
AGENDA_ITEM_TYPE, derivedTable
)
.where(
(AGENDA_ITEM_TYPE.ID).eq(AGENDA_ITEM.ITEM_TYPE_ID)
.and(derivedTable.id).eq(agendItem.ID)
.and(AGENDA_ITEM.AGENDA_ID).eq( agendaItem .id.value)
.and(AGENDA_ITEM.BEGINDATUM).eq(derivedTable.begindatum)
.and(
((derivedTable.hele_dag).eq(true))
.or(
(AGENDA_ITEM.ID).eq( agendaItem .ID)
.and(derivedTable.hele_dag).eq(false)
)
)
)
context.execute(updateQuery)
// I don't know how todo this, exequeting the query?
}
--
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/9041c3ac-df2b-40cf-a7d4-0166966aa792n%40googlegroups.com.
