The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

DBIx::SQLEngine::ToDo - Tasks, ideas, and bugs

TO DO

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.

Internals

Review, perhaps switch to use of new DBI subclassing functionality in place of DBIx::AnyDBD.

Distribution

The test script is fairly minimal and really ought to exercise the entire public interface.

For comapbility with the CPAN installer and automated testing tools, it may be more appropriate to query for a test DSN in the Makefile.PL, rather than in the test.pl.

Columns

The column-information retrieve in DBIx::SQLEngine::Default should be using DBI's type_info methods.

Interface

Extend the base interface with the following interfaces:

  • fetch_select_with_limit

  • do_insert_with_sequence

Transactions

There's no transaction support at this point; at least a basic version should be added.

Criteria

The Criteria subclasses are woefully incomplete.

Subclasses

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

SEE ALSO

DBIx::SQLEngine::ReadMe