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

Changes for version 0.93

  • New Functionality
    • Multi-column primary keys are now supported. [with huge thanks to Tim Bunce]
    • New syntax for inbuilt SQL
    • classes can control stringification via as_string() and stringify_column().
    • set_sql automatically translates __TABLE__, __ESSENTIAL__, and __IDENTIFIER__
  • Performance Improvements
    • use Storable's dclone() rather than Data::Dumper's deepcopy
  • Documentation
    • document the order_by option to search() [Drew Taylor]
    • fix the documentation of the DBI connect string [Phil Crow]
    • document working with pre_create triggers
    • add a note on dynamically generating a database connection
    • avoid using (shift => $val) due to quoting issues! [Simon Wilcox]
    • refer to Class::DBI::Oracle for sequences [Jay Strauss]
    • give better explanation for construct() [Jay Strauss]
    • document get/set with multiple arguments [Jay Strauss]
    • more detailed description of arguments to has_a()
  • Bug Fixes
    • Bug with setting driver defaults [Jay Strauss + Schwern]
    • Bug where selecting a column that was only in 'All' group also attempted to fetch any TEMP columns. [Dominic Mitchell]
  • Removal of Functionality
    • Undocumented ordered_search method has been removed in favour of order_by option to search.
    • Undocumented make_filter method removed in favour of add_constructor
    • add_constructor no longer does (undocumented) %s substitutions
    • (undocumented) single_value_select() method no longer takes raw SQL fragments.

Modules

Simple Database Abstraction
Columns and Column Groups
Iterate over Class::DBI search results
Manage SQL for Class::DBI

Provides

in lib/Class/DBI/Query.pm
in lib/Class/DBI.pm