The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
DBIx-Class-0.08103
River stage three • 342 direct dependents • 452 total dependents
289 ++

Changes for version 0.08103 - 2009-05-26

  • Multiple $resultset -> count/update/delete fixes. Now any of these operations will succeed, regardless of the complexity of $resultset. distinct, group_by, join, prefetch are all supported with expected results
  • Return value of $rs->delete is now the storage return value and not 1 as it used to be
  • don't pass SQL functions into GROUP BY
  • Remove MultiDistinctEmulation.pm, effectively deprecating { select => { distinct => [ qw/col1 col2/ ] } }
  • Change ->count code to work correctly with DISTINCT (distinct => 1) via GROUP BY
  • Removed interpolation of bind vars for as_query - placeholders are preserved and nested query bind variables are properly merged in the correct order
  • Refactor DBIx::Class::Storage::DBI::Sybase to automatically load a subclass, namely Microsoft_SQL_Server.pm (similar to DBIx::Class::Storage::DBI::ODBC)
  • Refactor InflateColumn::DateTime to allow components to circumvent DateTime parsing
  • Support inflation of timestamp datatype
  • Support BLOB and CLOB datatypes on Oracle
  • Storage::DBI::Replicated::Balancer::Random: added master_read_weight
  • Storage::DBI::Replicated: storage opts from connect_info, connect_info merging to replicants, hashref connect_info support, improved trace output, other bug fixes/cleanups
  • distinct => 1 with prefetch now groups by all columns
  • on_connect_do accepts a single string equivalent to a one element arrayref (RT#45159)
  • DB2 limit + offset now works correctly
  • Sybase now supports autoinc PKs (RT#40265)
  • Prefetch on joins over duplicate relations now works correctly (RT#28451)
  • "timestamp with time zone" columns (for Pg) now get inflated with a time zone information preserved
  • MSSQL Top limit-emulation improvements (GROUP BY and subquery support)
  • ResultSetColumn will not lose the joins infered from a parent resultset prefetch

Documentation

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

Modules

DBIx::Class
Extensible and flexible object <-> relational mapper.
DBIx::Class::AccessorGroup
See Class::Accessor::Grouped
DBIx::Class::CDBICompat
Class::DBI Compatibility layer.
DBIx::Class::CDBICompat::AbstractSearch
Emulates Class::DBI::AbstractSearch
DBIx::Class::CDBICompat::Tied::ColumnValue
Emulates the behavior of Class::DBI where the object can be accessed as a hash of columns.
DBIx::Class::CDBICompat::Copy
Emulates Class::DBI->copy($new_id)
DBIx::Class::CDBICompat::Iterator
Emulates the extra behaviors of the Class::DBI search iterator.
DBIx::Class::CDBICompat::NoObjectIndex
Defines empty methods for object indexing. They do nothing
DBIx::Class::CDBICompat::Relationship
Emulate the Class::DBI::Relationship object returned from meta_info()
DBIx::Class::CDBICompat::Relationships
Emulate has_a(), has_many(), might_have() and meta_info()
DBIx::Class::CDBICompat::SQLTransformer
Transform SQL
DBIx::Class::Core
Core set of DBIx::Class modules
DBIx::Class::Cursor
Abstract object representing a query cursor on a resultset.
DBIx::Class::DB
(DEPRECATED) classdata schema component
DBIx::Class::Exception
Exception objects for DBIx::Class
DBIx::Class::InflateColumn
Automatically create references from column data
DBIx::Class::InflateColumn::DateTime
Auto-create DateTime objects from date and datetime columns.
DBIx::Class::InflateColumn::File
map files from the Database to the filesystem.
DBIx::Class::Ordered
Modify the position of objects in an ordered list.
DBIx::Class::PK
Primary Key class
DBIx::Class::PK::Auto
Automatic primary key class
DBIx::Class::PK::Auto::DB2
(DEPRECATED) Automatic primary key class for DB2
DBIx::Class::PK::Auto::MSSQL
(DEPRECATED) Automatic primary key class for MSSQL
DBIx::Class::PK::Auto::MySQL
(DEPRECATED) Automatic primary key class for MySQL
DBIx::Class::PK::Auto::Oracle
(DEPRECATED) Automatic primary key class for Oracle
DBIx::Class::PK::Auto::Pg
(DEPRECATED) Automatic primary key class for Pg
DBIx::Class::PK::Auto::SQLite
(DEPRECATED) Automatic primary key class for SQLite
DBIx::Class::Relationship
Inter-table relationships
DBIx::Class::Relationship::Base
Inter-table relationships
DBIx::Class::ResultClass::HashRefInflator
Get raw hashrefs from a resultset
DBIx::Class::ResultSet
Represents a query used for fetching a set of results.
DBIx::Class::ResultSetColumn
helpful methods for messing with a single column of the resultset
DBIx::Class::ResultSetManager
scheduled for deletion in 09000
DBIx::Class::ResultSource
Result source object
DBIx::Class::ResultSource::Table
Table object
DBIx::Class::ResultSource::View
ResultSource object representing a view
DBIx::Class::ResultSourceHandle
Decouple Rows/ResultSets objects from their Source objects
DBIx::Class::ResultSourceProxy::Table
provides a classdata table object and method proxies
DBIx::Class::Row
Basic row methods
DBIx::Class::SQLAHacks
This module is a subclass of SQL::Abstract::Limit and includes a number of DBIC-specific workarounds, not yet suitable for inclusion into SQLA proper.
DBIx::Class::SQLAHacks::OracleJoins
Pre-ANSI Joins-via-Where-Clause Syntax
DBIx::Class::Schema
composable schemas
DBIx::Class::Schema::Versioned
DBIx::Class::Schema plugin for Schema upgrades
DBIx::Class::Serialize::Storable
hooks for Storable freeze/thaw
DBIx::Class::StartupCheck
Run environment checks on startup
DBIx::Class::Storage
Generic Storage Handler
DBIx::Class::Storage::DBI
DBI storage handler
DBIx::Class::Storage::DBI::Cursor
Object representing a query cursor on a resultset.
DBIx::Class::Storage::DBI::DB2
Automatic primary key class for DB2
DBIx::Class::Storage::DBI::MSSQL
Storage::DBI subclass for MSSQL
DBIx::Class::Storage::DBI::MultiColumnIn
Storage component for RDBMS supporting multicolumn in clauses
DBIx::Class::Storage::DBI::NoBindVars
Sometime DBDs have poor to no support for bind variables
DBIx::Class::Storage::DBI::ODBC
Base class for ODBC drivers
DBIx::Class::Storage::DBI::ODBC::ACCESS
Support specific to MS Access over ODBC
DBIx::Class::Storage::DBI::ODBC::DB2_400_SQL
Support specific to DB2/400 over ODBC
DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server
Support specific to Microsoft SQL Server over ODBC
DBIx::Class::Storage::DBI::Oracle
Base class for Oracle driver
DBIx::Class::Storage::DBI::Oracle::Generic
Automatic primary key class for Oracle
DBIx::Class::Storage::DBI::Oracle::WhereJoins
Oracle joins in WHERE syntax support (instead of ANSI).
DBIx::Class::Storage::DBI::Pg
Automatic primary key class for PostgreSQL
DBIx::Class::Storage::DBI::Replicated
BETA Replicated database support
DBIx::Class::Storage::DBI::Replicated::Balancer
A Software Load Balancer
DBIx::Class::Storage::DBI::Replicated::Balancer::First
Just get the First Balancer
DBIx::Class::Storage::DBI::Replicated::Balancer::Random
A 'random' Balancer
DBIx::Class::Storage::DBI::Replicated::Pool
Manage a pool of replicants
DBIx::Class::Storage::DBI::Replicated::Replicant
A replicated DBI Storage Role
DBIx::Class::Storage::DBI::Replicated::Types
Types used internally by DBIx::Class::Storage::DBI::Replicated
DBIx::Class::Storage::DBI::Replicated::WithDSN
A DBI Storage Role with DSN information in trace output
DBIx::Class::Storage::DBI::Role::QueryCounter
Role to add a query counter
DBIx::Class::Storage::DBI::SQLite
Automatic primary key class for SQLite
DBIx::Class::Storage::DBI::Sybase
Storage::DBI subclass for Sybase
DBIx::Class::Storage::DBI::Sybase::MSSQL
(DEPRECATED) Legacy storage class for MSSQL via DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server
Storage::DBI subclass for MSSQL via DBD::Sybase
DBIx::Class::Storage::DBI::mysql
Automatic primary key class for MySQL
DBIx::Class::Storage::Statistics
SQL Statistics
DBIx::Class::Storage::TxnScopeGuard
Scope-based transaction handling
DBIx::Class::UTF8Columns
Force UTF8 (Unicode) flag on columns
SQL::Translator::Parser::DBIx::Class
Create a SQL::Translator schema from a DBIx::Class::Schema instance
SQL::Translator::Producer::DBIx::Class::File
DBIx::Class file producer

Provides

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

Examples

Other files