Fork me on GitHub
#sql
<
2019-08-16
>
dcj18:08:42

@seancorfield: I'd like to insert a bunch (1000+) rows into my (postgres) db in one call, looking at next.jdbc.prepare/execute-batch! Let's say one of the columns is one that I have used the extend prepare/SettableParameter technique to transform my parameter/value appropriately. Will this work with prepare and execute-batch!?

seancorfield19:08:50

@dcj yes. It calls set-parameter. The docs walk through that whole scenario.

dcj19:08:18

@seancorfield Thank you! I will go back and re-read the docs.... Wrote some experimental code in the interim to test the above, indeed it works!

seancorfield20:08:30

@dcj if, having read that section, you have suggestions to make it clearer please open an issue with details / suggestions (I'm on vacation in England this week so I'm not on Slack much).