Update sql.args.n.value to Date format For PutSql

[rakesh <ra...@gmail.com>]

Hi All,


I'm trying a usecase in nifi unfortunately I could't be able to make it. So
finally I came here to ask for help.


*My Usecase*: I have two Mysql instences running two different machines I
want to make sync between those two which means what ever the
events(Insert,Update,Delete) happen in source db it should execute in dest
db also(Both are  having same schema). I'm recording the events using "mysql
bin log"
(Capture Change Mysql) I'm getting flow data in json format with datatime
column values as "*Mon Oct 09 23:38:55 IST 2017*". After this I'm converting
JSON to SQL and update attribute to convert date values to  "*yyyy-MM-dd
HH:mm:ss*" and Executing it using putsql.


To achieve this I tried below approaches.
I.
  i)Using Extract Text Processor by applying regex on flow file taking out
the date columns into one  
    variable date.
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t310/NifiHelp.png>
.
  ii)I got the date values.
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t310/nifihelp1.png>
.
  iii) Using Replace Text replacing the datetime value to required format.
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t310/NifiHelp.png>
.
  iv)After this my flow file is updated with same value for all columns with
datetime. I know it is based on 
     expression given by me only but I want to update date.1 with
"DiscoveredTime" and date.2 with 
     "LatestDiscoveredTime" so on....






--
Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/