DBIx::Easy - Easy to Use DBI Interface ************************************** * The homepage of `DBIx::Easy' is http://www.linuxia.de/DBIx/Easy/. * The latest version (currently 0.15) is always available as http://www.linuxia.de/DBIx/Easy/DBIx-Easy.tar.gz. * See the manual page for more informations. Requirements ************ * DBI (URL: http://www.symbolstone.org/technology/perl/DBI/index.html) * `DBD::Pg', `DBD::mysql', `DBD::mSQL', `DBD::ODBC' or `DBD::sybase' (ask for other database drivers) Installation ************ tar -xzf DBIx-Easy.tar.gz cd DBIx-Easy-0.15 perl Makefile.PL make make install Scripts ******* The `DBIx::Easy' package contains the following scripts: Name Description Remarks `dbs_dumptabdata' creates file set with SQL table data Manual page `dbs_dumptabstruct' creates file set with SQL table schemas Manual page `dbs_empty' erases all data from a SQL database Manual page `dbs_printtab' prints data from SQL table New in 0.07 Manual page `dbs_update' update SQL database from text file Manual page Debian Package ************** This software is also available as Debian package, maintained by Dennis Schön . The download address is http://www.linuxia.de/DBIx/Easy/libdbix-easy-perl_0.15-1_all.deb. Changes ******* 0.15 **** `Easy.pm' ========= * support for ODBC and Sybase added 0.14 **** `Easy.pm' ========= * implemented the optional `map' parameter in the `random_row' method which was already documented 0.13 **** `Easy.pm' ========= * don't use password from `~/.my.cnf' for databases on other hosts * database port is configurable now * new method `is_auth_error' `dbs_dumptabdata' ================= * `--cleanse' failed in some case if one of the keys was '`0'' `dbs_printtab' ============== * new option `--sort' `dbs_update' ============ * `dbs_printtab' is emulated instead called as program * `--headline' and `--format=CSV' weren't fully compatible 0.12 **** `Easy.pm' ========= * new method `random_row' 0.11 **** * several warnings fixed (most introduced in conjunction with Perl 5.6) `Easy.pm' ========= * new method `delete' `dbs_update' ============ * new option `--match-sql' 0.10 **** `dbs_dumptabdata' ================= * pass the `user' parameter to `dbs_printtab' 0.09 **** `Easy.pm' ========= * escape tabulator in `view' method * caches table structures * new methods `columns', `types', `sizes', `typemap', `sizemap' `dbs_dumptabdata', `dbs_dumptabstruct' ====================================== * pass options first to `mysqldump', needed for compatibility with older MySQL versions `dbs_update' ============ * return values of user-defined filters indicate if record is valid * inclusion mode of `--columns' fixed * expand tabulators * apply user-defined filter specified by `--routine' only once * choosed comma as default field separator for CSV format * insert an empty string instead of NULL for string columns * new option `--rows' * option `--keys' accepts key names too * issue warning on missing type information 0.08 **** `dbs_update' ============ * brown paper bug fixed that kept --cleanse from working by growing the SQL statement which each record to be cleansed * bug fixed that may be triggered by the combination of `--headline' and ` --map' * strip whitespace from column names found in the headline of the input * field separator for CSV format can selected from the commandline now * `--columns' can be used to exclude columns explicitly * strip blanks from parameter list for `--columns' * first field may contain table name and start column instead of table name only * example for `--routine' added to documentation 0.07 **** * new script `dbs_printtab' * made more verbose if connection cannot be established * method `view' fixed in respect to `limit' option, option `separator' added, separator defaults to the tabulator now, escape newlines * new option `--exclude-matching-tables' for `dbs_dumptabdata', ` dbs_dumptabstruct' and `dbs_empty' * new option `--tables' for `dbs_empty', `dbs_dumptabstruct' and ` dbs_dumptabdata' * new options `--cleanse', `--columns', `--format', `--keys', `--map', ` --skipbadlines' and `--update-only' for `dbs_update' * new option `--use-printtab' for `dbs_dumptabdata' * new option `--pipe' for `dbs_dumptabstruct' * `dbs_dumptabstruct' dumps sequences too * optional parameter CONDITION added to method `makemap' * optional parameter COLUMNS added to method `view' * made `dbs_update' more verbose on errors, ensure commit, newlines will be regenerated, remembers table name if specified with `--table', carriage returns are removed from input * don't call `rollback' within error handler if `AutoCommit' is enabled * new methods `is_table', `sequences' Authors ******* Stefan Hornburg Dennis Schön Support for Sybase and ODBC provided by David B. Bitton .