fix/RAD-2271/system-accessor-not-upserting

MangoAutomation / ma-core-public

Mango Automation Core public code

Other

79 stars 50 forks source link

fix/RAD-2271/system-accessor-not-upserting #1800

Closed pierpuccini closed 1 year ago

pierpuccini commented 2 years ago

More info at #RAD-2271

jazdw commented 2 years ago

What dialects was the upsert tested on? Is there a way in jOOQ to write the upsert code once and it will translate it to the correct format for the dialect?

terrypacker commented 2 years ago

@jazdw this was tested on h2 and lifted from the event detector dao. I believe I originally wrote the Event Detector code and this was the recommended approach for UPSERT statements. But yes its worth looking into if JOOQ has a better way to implement this now.