topic Re: User defined function(routine) in Talend Studio

User defined function(routine)

Anonymous — Wed, 24 Oct 2012 23:03:48 GMT

I am a newbie to Talend.
I know that I can create user defined routine(functions) using Java code.
What's the easiest way to do unit test for the function inside Talend Open Studio?
Thanks

Re: User defined function(routine)

Anonymous — Thu, 25 Oct 2012 03:44:10 GMT

Hi,
We don't understand your requirement very well, what's the purpose of "unit test". Do you mean how to call your routine in Talend Open Studio?
Best regards
Sabrina

Re: User defined function(routine)

Anonymous — Thu, 25 Oct 2012 15:59:56 GMT

Thanks for your reply.
My question is: for example, I need create my own function
myFunction()
How to test that myFunction() is doing what I expected? Can I do code testing inside TOS?
Or I have to test outside TOS? like Eclipse?
Thanks again.

Re: User defined function(routine)

Anonymous — Fri, 26 Oct 2012 10:26:28 GMT

hi,
you can use Eclipse to driven test and construct your routine.
Export in jar format , add jar to Talend lib or load jar file with Talend component and Test with différent user cases.
Or in Talend, create the routine and use somme assertion for each user case.
First test failed, because nothing has been developped.

    public static Integer addition(Integer nbre1,Integer nbre2) {
        Integer result = 0;
        
        return result;
    }

In my first user Case , I've fixed 2 values of integer to add at 10.
in tAssert i'm wating for ... 20
Run first failed (see result with tAssertCatcher).
Than begin to code your routine.

    public static Integer addition(Integer nbre1,Integer nbre2) {
        Integer result = 0;
        
        result = nbre1 + nbre2;
        
        return result;
    }

Run test again
Assert Catcher tell is Ok now.
Test with if a String is passed to your routines, or null values , or ..... etc
Hope it helps
regards
laurent

Re: User defined function(routine)

Anonymous — Fri, 26 Oct 2012 16:32:13 GMT

Thanks for the helpful information.
Originally, I would like to test the function only before calling it inside the ETL job.
According to the first way you mentioned, maybe I can try to do coding in Eclipse, then import them into TOS...

hi,
you can use Eclipse to driven test and construct your routine.
Export in jar format , add jar to Talend lib or load jar file with Talend component and Test with différent user cases.
Or in Talend, create the routine and use somme assertion for each user case.
First test failed, because nothing has been developped.
    public static Integer addition(Integer nbre1,Integer nbre2) {
        Integer result = 0;
        
        return result;
    }
In my first user Case , I've fixed 2 values of integer to add at 10.
in tAssert i'm wating for ... 20
Run first failed (see result with tAssertCatcher).
Than begin to code your routine.
    public static Integer addition(Integer nbre1,Integer nbre2) {
        Integer result = 0;
        
        result = nbre1 + nbre2;
        
        return result;
    }
Run test again
Assert Catcher tell is Ok now.
Test with if a String is passed to your routines, or null values , or ..... etc
Hope it helps
regards
laurent

Re: User defined function(routine)

Anonymous — Fri, 26 Oct 2012 16:55:03 GMT

in my example (in TOS), you're coding your routines directly in Talend, but separatly from the use of that routine
in your ETL process (in a tMap for ex).
By this way, you're testing each new user case and result is directly safe in the routine you're using in your process.
regards
laurent

Re: User defined function(routine)

Anonymous — Fri, 26 Oct 2012 17:42:45 GMT

Yes, I understand, basically you created a very simple job to run the test. It's a good idea.
BTW, as you said of another way, do you have any example about how to import jar file into TOS? It seems I couldn't find it.
Thanks

in my example (in TOS), you're coding your routines directly in Talend, but separatly from the use of that routine
in your ETL process (in a tMap for ex).
By this way, you're testing each new user case and result is directly safe in the routine you're using in your process.
regards
laurent

Re: User defined function(routine)

Anonymous — Fri, 26 Oct 2012 19:54:56 GMT

very simple
use tLibraryLoad
regards
laurent

Re: User defined function(routine)

Anonymous — Fri, 26 Oct 2012 20:54:32 GMT

Thank you.
Will try it later. 🙂

very simple
use tLibraryLoad
regards
laurent