Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Ovid (2709)

Ovid
  (email not shown publicly)
http://publius-ovidius.livejournal.com/
AOL IM: ovidperl (Add Buddy, Send Message)

Stuff with the Perl Foundation. A couple of patches in the Perl core. A few CPAN modules. That about sums it up.

Journal of Ovid (2709)

Tuesday December 09, 2008
06:42 AM

App::Prove::History

[ #38051 ]

A new development version of App::Prove::History is available on github. You can check it out with:

git clone git://github.com/Ovid/app--prove--history.git

It depends on the development version of Test::Harness, available at:

svn co http://svn.hexten.net/tapx/trunk test_harness

The schema information is now documented in App::Prove::History::Builder. I've documented all tables (only 3) and what each field stores. If you know TAP::Parser, it should be straightforward. The main table everyone should care about:

  "test_result"
        CREATE TABLE IF NOT EXISTS test_result (
            id           INTEGER PRIMARY KEY,
            suite_id     INTEGER NOT NULL,
            test_name_id INTEGER NOT NULL,
            passed       INTEGER NOT NULL,
            failed       INTEGER NOT NULL,
            todo         INTEGER NOT NULL,
            todo_passed  INTEGER NOT NULL,
            skipped      INTEGER NOT NULL,
            planned      INTEGER NOT NULL,
            tests_run    INTEGER NOT NULL,
            exit         INTEGER NOT NULL,
            wait         INTEGER NOT NULL,
            run_time     REAL    NOT NULL
        );

    * "suite_id"
        A reference to "suite.id"

    * "test_name_id"
        A reference to "test_name.id"

    * "passed"
        The number of tests which passed.

    * "failed"
        The number of tests which failed.

    * "todo"
        The number of TODO tests.

    * "todo_passed"
        The number of TODO tests which unexpectedly succeeded.

    * "skipped"
        The number of tests skipped.

    * "planned"
        The number of tests planned.

    * "tests_run"
        The number of tests run.

    * "exit"
        The exit status of the test.

    * "wait"
        The wait status of the test.

    * "run_time"
        The time in seconds it tooks the test program to run. If Time::HiRes
        is installed, it will have a high resolution time.

I think that my current plan is to only shove this data into an SQLite database and not provide any wrappers or anything for it. If someone wants some DBIx::Class interface or to shove this into MySQL or PostGresql, they can do that separately. This should keep this package lightweight and allow me to focus on getting the data people want rather than supplying all of the bells and whistles.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • If you just use standard SQL (whatever this is), then using another DB should just be a matter of changing the DSN, shouldn't it?

    • Should be. And I make it easy to provide a different database handle, but that might be for later down the road after I've stabilized a few things :)