DBIx::SQLEngine::Driver::CSV - Support DBD::CSV driver
DBI Wrapper: Adds methods to a DBI database handle.
my $sqldb = DBIx::SQLEngine->new( 'dbi:CSV:f_dir=my_data_path' );
Portability Subclasses: Uses driver's idioms or emulation.
$hash_ary = $sqldb->fetch_select( table => 'students' limit => 5, offset => 10 );
This package provides a subclass of DBIx::SQLEngine which compensates for some of DBD::CSV's idiosyncrasies.
Note that DBD::CSV does not support the normal full range of SQL DBMS functionality. Upgrade to the latest versions of DBI and SQL::Statement and consult their documentation to understand their current limits.
You do not need to use this package directly; when you connect to a database, the SQLEngine object is automatically re-blessed in to the appropriate subclass.
Overrides behavior of DBIx::SQLEngine::Driver::Trait::NoSequences.
$sqldb->sql_detect_table ( $tablename ) : %sql_select_clauses
Implemented using DBD::CSV's "select * from $tablename where 1 = 0".
$sqldb->dbms_null_becomes_emptystring () : 1
Capability Limitation: This driver does not store real null or undefined values, converting them instead to empty strings.
See DBIx::SQLEngine for the overall interface and developer documentation.
See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.
To install DBIx::SQLEngine, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::SQLEngine
CPAN shell
perl -MCPAN -e shell install DBIx::SQLEngine
For more information on module installation, please visit the detailed CPAN module installation guide.