Re: Request For Pointer In Right Direction (newbie)

From: Mike Kienenberger (mkienen..mail.com)
Date: Thu Oct 09 2008 - 12:38:23 EDT

  • Next message: tmgstewar..ol.com: "Re: Request For Pointer In Right Direction (newbie)"

    I don't know anything about IBM Rational Robot, so you'll have to
    figure out the details on your own.

    However, DbUnit lets you load either static or dynamic data sets into
    a database as well as compare data in the database to expected values.

    There are ant tasks available for working with DbUnit if that makes life easier.
    Or you can write your own java tasks in Robot if it supports some kind
    of java-based plugin.

    On 10/9/08, tmgstewar..ol.com <tmgstewart@aol.com> wrote:
    >
    > I see what you are thinking.
    >
    > Run a Robot script from the stable version, export the data (XML
    > file)...run the analogous script from the unknown version, export its
    > data...and compare. Then restore to the stable state and move on to the
    > next script.
    >
    > Thank you for the pointer!
    >
    > I still would like to somehow automate the Robot script for the stable
    > version to the analogous script from the unknown version. We have quite an
    > investment in the existing test scripts.
    >
    > Theresa
    >
    >
    >
    > -----Original Message-----
    > From: Mike Kienenberger <mkienen..mail.com>
    > To: use..ayenne.apache.org
    > Sent: Thu, 9 Oct 2008 10:51 am
    > Subject: Re: Request For Pointer In Right Direction (newbie)
    >
    >
    >
    > Have you looked at DbUnit?
    >
    > http://dbunit.sourceforge.net/
    >
    > I use an in-memory database (Hsqldb currently) and dbunit for testing
    > database expectations.
    >
    >
    > On 10/9/08, tmgstewar..ol.com <tmgstewart@aol.com> wrote:
    >
    > > Hi, All:
    > >
    > > Background --
    > >
    > > We have an existing (successful) product that has a VB interface.
    > >
    > > We are changing to a Java UI, with Cayenne as the ORM interface to
    > >
    > the MS
    >
    > > SQL database and Eclipse as the RCP.
    > >
    > > We have existing automated test scripts (IBM Rational Robot) and some
    > > manual (in text files...and probably some in the testers' minds).
    > >
    > You know
    >
    > > the story. I want to capitalize on what is already there, tweaking as
    > > necessary, and then supplement with my own once I understand any
    > >
    > helpful
    >
    > > mechanisms that have been put into place.
    > >
    > > I have been tasked to verify the first release of the new Java UI,
    > >
    > focusing
    >
    > > mainly on the database (that the database has not been corrupted by
    > >
    > the new
    >
    > > UI).
    > >
    > > My question is this....
    > >
    > > Where would I look to learn more about how I might use the existing
    > >
    > test
    >
    > > scripts (automated, files) and create my own to verify that the
    > >
    > database has
    >
    > > not been corrupted? What are the terms? Has anyone blazed this path
    > > before?
    > >
    > > I know that this is a somewhat broad question, and I will also post
    > >
    > onto
    >
    > > the Eclipse mailing list (since it may involve going one layer
    > >
    > "outside" of
    >
    > > Cayenne), but I'm really trying to become familiar with tools that
    > >
    > help me
    >
    > > test.
    > >
    > > Thank you,
    > > Theresa
    > >
    > >
    > >
    >
    >



    This archive was generated by hypermail 2.0.0 : Thu Oct 09 2008 - 12:38:57 EDT