custom InsertStatement with returning

[wayerr]

For some cases I want to create 'insert on conflict update' (for Postgres) with RETURNING and custom conflict_target (in PG terms).
For this i was use InsertStatement as base class and override InsertStatement#prepareSQL it is works fine. Except insert is does not return column when it is presented in arguments.
Returning values is replaced with arguments:

Exposed/exposed-core/src/main/kotlin/org/jetbrains/exposed/sql/statements/InsertStatement.kt

Line 73 in 9c0d295

arguments!!.forEachIndexed { itemIndx, pairs ->

I can not override processResults - it is private.
I can override PreparedStatementApi.executeInternal(transaction: Transaction): Int, but resultedValues setter is private.

Therefore current design does not provide easy way to disable replacement of returned values.

[zak905]

Hi @wayerr,

would you mind sharing an example of how you managed to achieve an insert with returning please ?

[zak905]

Hi @wayerr, I see that you posted, and removed again, any particular reason ? by the way, I still have the code you posted from the email notification

[wayerr]

@zak905 I am not sure that this code is worked properly, and I does not have time to test it.

[zak905]

Ok thanks anyway, It seems so complex anyway, I think I will wait for #1456