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

Changes for version 0.08108 - 2009-07-05

  • Fixed the has_many prefetch with limit/group deficiency - it is now possible to select "top 5 commenters" while prefetching all their comments
  • New resultsed method count_rs, returns a ::ResultSetColumn which in turn returns a single count value
  • Even better support of count with limit
  • New on_connect_call/on_disconnect_call functionality (check POD of Storage::DBI)
  • Automatic datetime handling environment/session setup for Oracle via connect_call_datetime_setup()
  • count/all on related left-joined empty resultsets now correctly returns 0/()
  • Fixed regression when both page and offset are specified on a resultset
  • Fixed HRI returning too many empty results on multilevel nonexisting prefetch
  • make_column_dirty() now overwrites the deflated value with an inflated one if such exists
  • Fixed set_$rel with where restriction deleting rows outside the restriction
  • populate() returns the created objects or an arrayref of the created objects depending on scalar vs. list context
  • Fixed find_related on 'single' relationships - the former implementation would overspecify the WHERE condition, reporting no related objects when there in fact is one
  • SQL::Translator::Parser::DBIx::Class now attaches tables to the central schema object in relationship dependency order
  • Fixed regression in set_column() preventing sourceless object manipulations
  • Fixed a bug in search_related doubling a join if the original $rs already joins/prefetches the same relation
  • Storage::DBI::connected() improvements for Oracle and Sybase
  • Fixed prefetch+incomplete select regression introduced in 0.08100
  • MSSQL limit (TOP emulation) fixes and improvements

Documentation

Index of the Manual
Developing DBIx::Class Components
Miscellaneous recipes
What documentation do we have?
Simple CD database example
Frequently Asked Questions (in theory)
Clarification of terms used.
Introduction to DBIx::Class
Manual on joining tables with DBIx::Class
How to read and write DBIx::Class POD.
Got a problem? Shoot it.
Execute operations upon DBIx::Class objects.

Modules

Extensible and flexible object <-> relational mapper.
See Class::Accessor::Grouped
Class::DBI Compatibility layer.
Emulates Class::DBI::AbstractSearch
Emulates the behavior of Class::DBI where the object can be accessed as a hash of columns.
Emulates Class::DBI->copy($new_id)
Emulates the extra behaviors of the Class::DBI search iterator.
Defines empty methods for object indexing. They do nothing
Emulate the Class::DBI::Relationship object returned from meta_info()
Emulate has_a(), has_many(), might_have() and meta_info()
Core set of DBIx::Class modules
Abstract object representing a query cursor on a resultset.
(DEPRECATED) classdata schema component
Exception objects for DBIx::Class
Automatically create references from column data
Auto-create DateTime objects from date and datetime columns.
map files from the Database to the filesystem.
Modify the position of objects in an ordered list.
Primary Key class
Automatic primary key class
(DEPRECATED) Automatic primary key class for DB2
(DEPRECATED) Automatic primary key class for MSSQL
(DEPRECATED) Automatic primary key class for MySQL
(DEPRECATED) Automatic primary key class for Oracle
(DEPRECATED) Automatic primary key class for Pg
(DEPRECATED) Automatic primary key class for SQLite
Inter-table relationships
Inter-table relationships
Get raw hashrefs from a resultset
Represents a query used for fetching a set of results.
helpful methods for messing with a single column of the resultset
scheduled for deletion in 09000
Result source object
ResultSource object representing a view
Decouple Rows/ResultSets objects from their Source objects
provides a classdata table object and method proxies
Basic row methods
Pre-ANSI Joins-via-Where-Clause Syntax
composable schemas
DBIx::Class::Schema plugin for Schema upgrades
hooks for Storable freeze/thaw
Run environment checks on startup
Generic Storage Handler
DBI storage handler
Storage component for RDBMS supporting multicolumn in clauses
Object representing a query cursor on a resultset.
Automatic primary key class for DB2
Storage::DBI subclass for MSSQL
Storage component for RDBMS supporting multicolumn in clauses
Sometime DBDs have poor to no support for bind variables
Base class for ODBC drivers
Support specific to MS Access over ODBC
Support specific to DB2/400 over ODBC
Support specific to Microsoft SQL Server over ODBC
Base class for Oracle driver
Automatic primary key class for Oracle
Oracle joins in WHERE syntax support (instead of ANSI).
Automatic primary key class for PostgreSQL
BETA Replicated database support
Manage a pool of replicants
A replicated DBI Storage Role
A DBI Storage Role with DSN information in trace output
Role to add a query counter
Automatic primary key class for SQLite
Storage::DBI subclass for Sybase
Common functionality for drivers using DBD::Sybase
(DEPRECATED) Legacy storage class for MSSQL via DBD::Sybase
Storage::DBI subclass for MSSQL via DBD::Sybase
Storage::DBI class implementing MySQL specifics
Scope-based transaction handling
Force UTF8 (Unicode) flag on columns
Create a SQL::Translator schema from a DBIx::Class::Schema instance

Provides

in lib/DBIx/Class/CDBICompat/Iterator.pm