Front page | perl.beginners |
Postings from December 2003
Hello, I have to look at doing a lot of testing for a database audit trail (it's a federal regulations thing). It's a big database, so my plan is to write some sort of program that will query out a list of tables and then randomly select N tables to do inserts and updates. Later I'll verify that the auditing mechanism captured all those changes/inserts. It'll be fussy; I'll have to account for unknown-at-runtime constraints... Needless to say, I'll do this in Perl using a DBD:ODBC, or possibly DBD::ADO (it' s a SQL Server db). My question is, does anyone know of an existing module or project oriented to this sort of thing? It'd be nice not to have to write the whole thing. I've been looking through CPAN, but haven't run across anything germane. Thanks, John ============================================== System Administrator Clinical Data Systems Fred Hutchinson Cancer Research Center 1100 Fairview Ave N Mail Stop D5-360 PO Box 19024 Seattle, WA 98109 jgoodlea@fhcrc.org 206/667-2521