continueOnFail support for postgresql/mysql and mssql

Feature Requests Nodes
#1

Currently continueOnFail not directly supported in postgresql and mysql.

  • 1 sql line (item 1)
  • 2 sql line (item 2)
  • 3 sql line (item 3) [error]

get result of 1 and 2.

For postgresql:

  • executeQuery: Currently all queries are combined to one. I don’t know if we can get the results of each line.
  • insert: all values combined to one query
  • update: all values combined to one query

For mysql:

  • executeQuery: should be possible
  • insert: all values combined to one query
  • update: should be possible

For mssql:

  • executeQuery: not execute for each item, i think this sould also be fixed
  • insert: executeQueryQueue, currently i don’t know
  • update: executeQueryQueue, currently i don’t know

Myself i’m interested on postgresql.
If we want to implement it and it requires each query to be executed individually, should it be an option? ( i think it costs performance)

#2

Here some extra informations:
I try to work on the postgres.
MYSQL/MSSQL is unimportant for me and will probably not be touched by me.

Without flag:

For postgresql:

executeQuery: use multi/mutliResult
insert: keep!
update: keep?

For mysql:

executeQuery: execute multiple statement queries (combined query)
insert: keep?
update: execute multiple statement queries (combined query)

For mssql:

executeQuery: not execute for each item => combined query with request.query
insert: keep?
update: keep?

With “independently” flag (to work with continueOnFail):

For postgresql:

executeQuery: use batch/task
insert: use batch/task
update: use batch/task

For mysql:

executeQuery: execute multiple statement queries (combined query)
insert: keep?
update: execute multiple statement queries (combined query)

For mssql:

executeQuery: i don't know (no time to analyse it)
insert: i don't know (no time to analyse it)
update: i don't know (no time to analyse it)

With transactions flag (with auto rollback):

For postgresql:

executeQuery: use batch/tx
insert: use batch/tx
update: use batch/tx

For mysql:

executeQuery: beginTransaction
insert: beginTransaction
update: beginTransaction

For mssql:

executeQuery: transaction.begin
insert: transaction.begin
update: transaction.begin