Hi All,

I am planning to design a small module that would make use of object
oriented concepts of Perl.

Since its my first attempt in the field of Oops, I would request Perl
experts to review the code design as and when I would share the new piece of
development for this module.

Basic idea of the module: In many projects, qa needs to validate database
tables by executing many sql queries (test cases). The category of these sql
queries could be:

1. Count sql queries where in count returned by each sql query should be
exactly equal to the known count
2. Count sql queries where in count returned by each sql query should be
more than known count.
3. Count sql queries where in count returned by each sql query should
be less than known count.
4. Minus sql queries (sql1 minus sql2) where in expected output is 'no rows
returned' meaning data set of the the sql queries is exactly same.

The test cases i.e. sql queries would be mentioned in configuration file
(called cfg) - 1 sql query per line.

The configuration file would be given for processing to appropriate method.
This method would then execute all the test cases and generate the detailed
results in the result directory specified by the user.

Please feel free to share your valuable suggestions.

PS: Its just the first version and with only 1 method. I plan to implement
the remaining 5-6 methods gradually.

The reason I want to get it reviewed is because if it turns out to be
success I would love to release it to CPAN

The module can be found at:
http://perlmonks.org/?abspart=1;displaytype=displaycode;node_id=863241;part=1

And the testing script can be found at:
http://perlmonks.org/?abspart=1;displaytype=displaycode;node_id=863241;part=2

Cheers,
Parag

Reply via email to