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