Re: Request For Pointer In Right Direction (newbie)

From: tmgstewar..ol.com
Date: Thu Oct 09 2008 - 12:46:07 EDT

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

    Thank you. This will help me tremendously.

    Theresa

    -----Original Message-----
    From: Mike Kienenberger <mkienen..mail.com>
    To: use..ayenne.apache.org
    Sent: Thu, 9 Oct 2008 11:38 am
    Subject: 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:47:14 EDT