Easy to Use DBI interface
Perl
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Easy
debian
scripts
t
.gitignore
Changes
Easy.pm
LIESMICH
MANIFEST
Makefile.PL
README

README

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 
<dennis@cobolt.net>. 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 <racke@linuxia.de>

Dennis Schön <dennis@cobolt.net>

Support for Sybase and ODBC provided by David B. Bitton 
<david@codenoevil.com>.