DBIx::SQLEngine::ToDo - Tasks, ideas, and bugs
Although it based on earlier code that was extensively tested over several years of production use, this code has recently been majorly refactored, and has not yet been sufficiently tested in its new form.
This version to be posted for review and discussion on DBI list, Perl Monks, and Perl Modules list.
The test script is fairly minimal and really ought to exercise the entire public interface.
The column-information retrieve in DBIx::SQLEngine::Default should be using DBI's type_info methods.
Extend the base interface with the following interfaces:
fetch_select_with_limit
do_insert_with_sequence
There's no transaction support at this point; at least a basic version should be added.
The Criteria subclasses are woefully incomplete. See the unfinished_code file for more.
Additional subclass logic will be required to support the following:
All: type of long field
Oracle: single, trailing long.
MySQL, Oracle: downcase column names.
DB2: Long insertion via multiple updates.
Informix: escape newlines on insert/update/where and select
DBIx::SQLEngine::ReadMe
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.