Matt Burgess created NIFI-3676:
----------------------------------
Summary: Support Expression Language (and BEGIN and COMMIT verbs)
for ConvertJSONToSQL
Key: NIFI-3676
URL: https://issues.apache.org/jira/browse/NIFI-3676
Project: Apache NiFi
Issue Type: Improvement
Components: Extensions
Reporter: Matt Burgess
Currently, ConvertJSONToSQL allows the user to select from a drop-down list of
verbs (INSERT, UPDATE, DELETE). However in automated flows, it would be nice to
specify the verb via an Expression Language statement; otherwise the workaround
will be a RouteOnAttribute with one ConvertJSONToSQL per verb. As we add verbs
(UPSERT, BEGIN, COMMIT, etc.) this could get overly complex.
Speaking of added verbs, it would be nice to add support for BEGIN and COMMIT
to help handle transactions. Although each RDBMS has their own syntax for
various features of transactions, many of the popular ones (MySQL, Oracle,
PostgreSQL, SQL Server) support BEGIN as a lone keyword for starting a
transaction, and COMMIT to end it. This would also help simplify CDC flows
(using the CaptureChangeMySQL processor in NIFI-3413, for example).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
