All the Perl that's Practical to Extract and Report
use Perl Log In
Mark Leighton Fisher (4252)
(email not shown publicly)
http://mark-fisher.home.mindspring.com/
I am a Systems Engineer at Regenstrief Institute [regenstrief.org]. I also own Fisher's Creek Consulting [comcast.net].
Journal of Mark Leighton Fisher (4252)
Test::MockDBI v0.50
Test::MockDBI v0.50 is wending its way through CPAN, even as I write this. Test::MockDBI uses Test::MockObject::Extends to mock up the whole DBI interface for testing. Rules for DBI behavior are set up, then the standard output of the containing program can be examined for matching patterns.
Mocking up the whole DBI interface is useful for us consultants, as the Test::MockDBI code can be added to an existing program without that program's knowledge, allowing you to test the program's use of DBI without modifying the base code of the program -- or for that matter, hitting an actual database at all (unless you want to).
The rules can be sensitive to what SQL is currently being processed, as well as depending on a numeric DBI testing type. Wildcarding is allowed, so if you have some DBI processing that is done by all programs, you can set up that processing without it interfering with testing your specific program's DBI usage.
Test::MockDBI is an improvement over DBD::Mock or DBI::trace(), as you can modify the mocked-up DBI's behavior to force conditions to occur that might be difficult or impossible to otherwise force to occur.
Test::MockDBI v0.50 is marked as alpha code, because although what I have written and tested is beta or production-quality code, not all of the DBI is mocked-up yet. If anyone has a good idea on how DBI::quote() should work in Test::MockDBI, I would love to hear from you.
help them think they understand.
--Larry Wall
Whats so wrong with DBD::Mock (Score:1)
What exactly would you like to see DBD::Mock do that it doesn't? I am happy to take suggestions and/or patches.
- stvn-stvn
DBD::Mock and Test::MockDBI (Score:1)
First off, I view DBD::Mock, Test::MockDBI, and DBI::trace() as complementary, as they each take a somewhat different tack to the same problem.
Although I finally realize that you can use DBD::Mock for similar purposes as Test::MockDBI, the current documentation (at least) is geared more towards using DBD::Mock as a tracing tool. My docs for Test::MockDBI explicitly stress changing the DBI behavior.
Plus, DBD::Mock is good for situations where you use configurable data sources, while Test::MockDBI is good
Re:DBD::Mock and Test::MockDBI (Score:1)
I too see them as complementary (at least as much as I can glean of what Test::MockDBI does). I would actually be very interested in seeing more information on Test::MockDBI if you care to provide it :)
I am actually planning a re-write parts of the DBD::Mock docs when I have some time to better show some of it's newer features. I will take your suggestions, and also try to stress it's role in testing more as well.
You are correct that DBD::Mock cannot really insert debugging code, and it only allows s
-stvn