Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.6

Request #5478 Verify schema/referential integrity
Submitted: 2005-09-21 23:44 UTC
From: bhill at sims dot berkeley dot edu Assigned: wiesemann
Status: Closed Package: DB_Table
PHP Version: 5.0.5 OS: WinXP/Ampp
Roadmaps: (Not assigned)    
Comments Add Comment Add patch

Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem : 8 + 21 = ?

 [2005-09-21 23:44 UTC] bhill at sims dot berkeley dot edu
Description: ------------ a feature request for a "test DB" helper method that is similar to many PHP package's test for both schema completeness and correctness (does every table have at least the columns necessary to insert rows) and referential integrity. PHPSurveyor has a great one in checkfields.php


 [2005-09-24 21:22 UTC] wiesemann
Interesting request, maybe this could be done by allowing the value "check" or "verify" for the third constructor parameter ($create). If it has this value but the verification fails, $error would be a PEAR_Error object telling you what the error in the table is. If you are able to provide a patch that adds this functionality to DB_Table, I'd be happy to apply it. Otherwise you will have to wait some weeks - it's a nice new feature but nothing I have time for at the moment.
 [2005-11-23 20:56 UTC] wiesemann
A first implementation is now available in CVS, feedback is very much welcome. Please note the CVS commit message for more information.
 [2006-02-17 21:29 UTC] wiesemann
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on by the end of next Sunday (CET). If this was a problem with the website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.