[NIFI-3626] Support DELETE verb for ConvertJSONToSQL

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 20/Mar/17 17:23
• Updated: 21/Mar/17 21:21
• Resolved: 21/Mar/17 21:21

Description

ConvertJSONToSQL supports INSERT and UPDATE verbs (and if NIFI-991 is implemented, the UPSERT verb), but it would be helpful in use cases such as Change Data Capture and Database Migration to be able to generate DELETE statements.

I believe this would entail generating a conjunctive (aka AND) WHERE clause, using the sql.args attributes for the prepared statement.

Issue Links

• links to: GitHub Pull Request #1605