Forum OpenACS Development: Database replay feature ??
Site-wide configuration options - db_record_p and db_record_log_file.
These procs (and any I didn't think of) - have them look at the db_record_p to see if they should log their efforts to $db_record_log_file.
db_record_p is off by default. I install OACS - set db_record_p, configure how I want it, run through and manually add a bunch of stuff. New OACS comes out, I want to regression test it - I just run a replay log into the new instance.
This might be useful for the demo sites at collaboraid ...
I suspect that capturing the web server log and replaying that through tclwebtest or portable.nsd might be a better idea.
I've had good luck with the latter... it's robust to user interface changes and it lets you test at a more granular command vs page level. YMMV.
Try a google search on "Unit Testing Database code" for more info on the issues involved.