Tks Lukas this is exactly what I'm doing at now. 2016-10-25 23:25 GMT+02:00 Lukas Eder <[email protected]>:
> Hi Denis, > > UpdatableRecord currently doesn't have an "UPSERT" feature (or INSERT ON > DUPLICATE KEY UPDATE, etc.) This is a pending feature request: > https://github.com/jOOQ/jOOQ/issues/2961 > > I guess we've postponed it long enough now, it shouldn't be too hard to > implement... > In the meantime, you can pass your record to an actual INSERT ON DUPLICATE > KEY UPDATE statement: > > ctx.insertInto(MYTABLE) > .set(rec) > .onDuplicateKeyUpdate() > .set(rec) // Maybe manually reset the PK columns again, here... > .execute(); > > > Hope this helps, > Lukas > > 2016-10-22 16:05 GMT+02:00 Denis Miorandi <[email protected]>: > >> I'm trying to use UpdatableRecord store() method, but it's not clear to >> me the right way. >> In my scenario I would like >> >> - create a record in memory, so >> - store record wheter exists or not so ) >> >> rec=ctx.newRecord(MYTABLE) >> rec.setField1(1) >> rec.setField2(1) >> .... >> rec.store() >> >> Issue is store() try to always insert it (wheter exists or not on db) >> cause not loaded from db with rec.refresh(), >> so that I've tried to do same thing using a refresh on rec (after set >> keys before set other values) but refresh() >> fail is record doesn't exists. So: >> >> >> - refresh() works only on existings records >> - store() works only if a record is loaded from refresh() otherwise >> always insert >> >> Am I right? Am I missunderstanding something? >> How can I store a new record wheter exists or not on db? >> >> Tks >> Denis >> >> >> -- >> 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. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/jooq-user/NRjbXIrPEfc/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Dott. Denis Miorandi via dei Vignai 27 38060 - Nogaredo (TN) -- 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.
