Change log for DBIWrapper Perl Module. Version 0.01 - 11/02/2000 - Initial version. Created all base files and the initial version of the connection and cleanup code. The read and write functions should be done. - The test.pl script should do a complete test minus writing. Version 0.02 - 11/03/2000 - Fully fleshed out test script. Added database creation sample file. - Added methods commit and rollback. Version 0.03 - 11/06/2000 - Fixed some POD documentation. - Modified the instantiation code so it would work with references to objects. - Improved the Makefile.PL script to not proceed if DBI not installed. Version 0.07 - 11/17/2000 - Added the sql statement to the error output from read and write. Version 0.09 - 12/09/2000 - First released version. - Created RPM's. - More debugging output when error's occur in read and write. Version 0.10 - 02/27/2001 - Added setError method. Changed all error_string -> errorString. - Made dbh be undefined by default. Version 0.11 - 06/27/2001 - Tried to add better error checking around the close method. - Wrapped commit and rollback in eval statements so that I can trap when the dbh is not defined and an error occurs. - Made the setDateStyle actually call the write method so error checking is done instead of doing the prepare and execute manually. - Set the dbh value to undef after we close the connection to indicate we are no longer valid. - Added detection code for MySQL transaction support. Internal variables now keep track of if the current database type supports transactions and if it is MySQL and does, then the type of transaction support detected. - Cleaned up all error setting code to use setError. - Added better checking for DBI::err being set after a DBI call so I can trap when things go wrong and you don't have raiseError => 1. Version 0.12 - 07/16/2001 - Updated License to be Perl Artistic License. Version 0.13 - 07/23/2001 - Improving error display so that I have an idea of what database gave me a problem if using multiple DBIWrapper objects in a project. - Added logLevel option with values 0, 1, 2, 3: 0) no extra info output 1) dbType, dbHost, dbName, printError, raiseError, autoCommit, setDateStyle supportsTransactions, transactionType 2) all of 1 plus dbUser, dbPort, predefinedDSN 3) all of 2 plus dbPasswd - Added setLogLevel and getLogLevel helper methods. - Added debugMessage method which returns the info string to include in the error message. Version 0.14 - 09/08/2001 - Made the plug='@plug' output in errors be plug='xxx', 'yyy', etc. so that it is easier to determine what the entries were in the array. Version 0.15 - 10/22/2001 - Updated error trapping in DESTROY and close methods. Version 0.16 - 12/23/2001 - Updated the error display code to use a variable to name the method we are having an issue in. - Implemented the readXML method to return an XML document with the results of the specified sql statement. Version 0.17 - 03/15/2002 - Updated the generated XML to incorporate the error code in the tag and not in a CDATA section and added the columns value to the tag. - Added an XMLParser module which will allow the user to parse apart the generated XML from the readXML method. The data will be stored in the ResultSet module. See it's man page for details. - Updated the test cases in test.pl to cover the XMLParser module, etc. - The readXML method no longer propagates the error condition if read had an error. The XML document will contain the error. Version 0.18 - 10/11/2002 - Fixed the error display code for the XML code to return the errors instead of the ARRAY(0x) reference of the array. Version 0.19 - 2004-03-15 - Fixed debian dependancy issues on libdbd-pg-perl or libdb-pg-mysql. - Improving the read/write methods to interpret a single argument as the sql statement, else we treat it as pass by name. Version 0.20 - 2004-04-14 - Adding dbiToBool() and boolToDBI() methods to convert to and from the bool values that DBI takes and exports and a more human readable version. 1 <-> true, 0 <-> false. - Creating readHTML() which JT requested. Version 0.21 - 2004-10-19 - Added the error(), prefixError(), resetError() methods as based upon the Portal::Base implementation. - Cleaned up all
to be
. - Removed the $errStr prefixes from the setError() calls and converted all setError() calls to error() calls. - Updated the test.pl script to take into account the new error output. Version 0.22 - 2005-06-17 - Added getID() method to return the ID of the last insert and work correctly for MySQL versus PostgreSQL implementations. - Added test code for getID(). - Added support for Sybase as a supported database backend. - Added getDataArray()/getDataArrayHeader()/getDataHash()/getDataHashHeader() methods to help simplify data retrieval. Version 0.23 - 2005-10-21 - Fixing the Sybase support where an empty row was being added onto the returned data when there was more data available to get. - Added displayNULLAs to the readHTML/readXML methods, so you can specify what undefined (NULL) values get displayed as. Defaults to NULL. - Added the ability to specify what tags to not encode via readXML/readHTML. - Added columns=2 to readXML(), which returns the data in tags named after the column being returned. - Fixed the error handling in the getData... methods. - Added server & interfaces to the debugMessage() output. - Added syb_error_handler support so that we can ignore informational errors that were causing the connect to fail.