Re: [Tora-develop] New feature - Unit Testing

[Mike J. <mrj...@mi...>]

Cool with me, but I think we should move it to it's own tool. The schema
browser is way too complicated already....

You can grab the dbms output, see output tool. I've been meaning to fix
it though because it runs it's queries in the main thread and can block
if you run a long query somewhere else.


On Mon, 2008-04-28 at 14:48 +0200, Petr Vanek wrote:
> hi all,
> 
> I've just commit new feature for Schema Browser/Code called "Unit Test". I
> know it is not safe to add new tools in this "stabilize it" phase, but I
> needed to test huge amount of procedures last week... So I did it for TOra.
> 
> What is the Unit Test Script? The anonymous PL/SQL block with the following
> structure:
> 
> DECLARE
>     -- declarations of IN/OUT parameters
>     foo number;
>     bar varchar2(22);
> BEGIN
>     -- definitions of parameters
>     foo := 1;
>     bar := 2;
>     -- calling requested unit
>     MYOWN.COOLPACKAGE.FOOBAR(
>         foo => foo,
>         bar => bar
>         );
>     -- printing of the results
>     sys.dbms_output.put_line('foo: ' || foo);
>     sys.dbms_output.put_line('bar: ' || bar);
> END;
> 
> All results should printed to the SERVEROUTPUT.
> 
> It can handle only basic data types currently.
> No PLSQLdata (record of etc.) supported yet.
> 
> Things to solve:
> 
> - Serveroutput is not connected. Dunno why. How to set toWorksheetWidget to
> use it?
> 
> - It's Oracle only now. I don't know Posgresql enough to implement this for
> pgsql.
> 
> - The first call of toUnitTest::handleDone() is skipped propably.
> toResultModel issue?
> 
> - support for "advanced" datatypes.
> 
> - polish it and make it bugfree (muwahaha)
> 
> 
> Feedback and corrections are always welcome
> 
> petr
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Tora-develop mailing list
> Tor...@li...
> https://lists.sourceforge.net/lists/listinfo/tora-develop