topic [resolved] pass tfileproperties schema to tmysqlinput in Talend Studio

[resolved] pass tfileproperties schema to tmysqlinput

_AnonymousUser — Wed, 06 Nov 2013 12:58:43 GMT

hi

how to pass tfileproperties schema value
dirname
size
md5
to tmysqlinput query
the flow is like as below
tfilelist----->iterate---->tfileproperties------>iterate------>tmysqlinput------>if--true---->tfilecopy
in query i want to give like this
select 1 from table_size where filename='"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"' and size= ;
for size i want tfileproperties size value to be passed. how to achieve it ???

And also how to pass this value "1" in query to a variable of tmysqlinput ,just giving a variable in the schema serve the purpose??

Re: [resolved] pass tfileproperties schema to tmysqlinput

Anonymous — Thu, 07 Nov 2013 10:15:06 GMT

Hi,
If I understand you well, the query should be:
"select 1 from table_size where filename='"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"' and size="+row.size
Where is your value 1 come from? It is fixed or dynamic?
Best regards
Sabrina

Re: [resolved] pass tfileproperties schema to tmysqlinput

_AnonymousUser — Fri, 08 Nov 2013 04:56:09 GMT

hi

the value one is fixed here ,the logic is this if select query has value for file name and size passed i shud get one else no value so . The row.size will it give tfileproperties size value ??

Re: [resolved] pass tfileproperties schema to tmysqlinput

Anonymous — Fri, 08 Nov 2013 06:57:20 GMT

Hi,

The row.size will it give tfileproperties size value ??

To make it clear, I have designed a demo job.
tfilelist-->iterate-->tfileproperties-->main-->tflowtoiterate-->tmysqlinput-->tlogrow
See my screenshots.
Is it what you are looking for?
Best regards
Sabrina

Re: [resolved] pass tfileproperties schema to tmysqlinput

_AnonymousUser — Fri, 08 Nov 2013 07:13:51 GMT

the row.size is not working and if i want to use if trigger condition for that value "one" returned from select query how to specify in java code in if condition code part . how to do it ??

Re: [resolved] pass tfileproperties schema to tmysqlinput

Anonymous — Fri, 08 Nov 2013 07:55:02 GMT

Hi,
What's your expected result from tmysqlinput? And your condition(Run if.....)?It seems you want to trigger a subjob(tfilecopy) if there is a result returned(value one)?
For example:
I want to trigger the subjob if there is a/no processed row in workflow
Set the condition of RunIf:
!((Integer)globalMap.get("tMysqlInput_1_NB_LINE"))==0 or ((Integer)globalMap.get("tMysqlInput_1_NB_LINE"))==0

Could you give us more info about your current job and paste your job design screenshots into forum. There may be better solution for your case.
Best regards
Sabrina

Re: [resolved] pass tfileproperties schema to tmysqlinput

_AnonymousUser — Fri, 08 Nov 2013 08:56:32 GMT

hi sabrina

thank you for the reply i used what u said in if condition its working fine
i changed the job as follows

twaitforfile--->iterate--->tfilelist---->iterate--->tfileproperties----->row(main)---->tflowtoiterate--->iterate--->tmysqlinput---->tflowtoiterate------>if---->tfilecopy

this is the query in tmysqlinput
select 1 from ETL_SIZE where filename='"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"' and size="+row2.size
in if condition
((Integer)globalMap.get("tMysqlInput_1_NB_LINE"))==1

its working fine but i want to run the job in infinite loop, if i connect tinfiniteloop to twaitforfile will it work or is it correct ??

Re: [resolved] pass tfileproperties schema to tmysqlinput

Anonymous — Fri, 08 Nov 2013 09:07:19 GMT

Hi,
For infinite loop
You can design a job like that:
tInfiniteLoop (set some time) --------> tIterateToFlow --------> tRunJob
In your subjob(trunjob), put your workflow into
tfilelist---->iterate--->tfileproperties----->row(main)---->tflowtoiterate--->iterate--->tmysqlinput---->tflowtoiterate------>if---->tfilecopy
Even if your subjob (tRunJob) fails, it will loop back, hold on for a few seconds and re -run your job again.
That means you should create 2 separate jobs. One job for the tmysqlinput workflow and trigger of tfilecopy and the other one aim at loop.
Does it satisfy your requirement?
Best regards
Sabrina

Re: [resolved] pass tfileproperties schema to tmysqlinput

_AnonymousUser — Fri, 08 Nov 2013 09:20:34 GMT

hi

yes , thank you sabrina for your suggestion

Re: [resolved] pass tfileproperties schema to tmysqlinput

Anonymous — Fri, 08 Nov 2013 09:28:56 GMT

Hi,
Don't hesitate to post your issue on forum.
Best regards
Sabrina