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

Changes for version 0.08197 - 2012-07-10

  • New Features / Changes
    • Issue a warning when DateTime objects are passed to ->search
    • Fast populate() in void context is now even more efficient by going directly through execute_for_fetch bypassing execute_array
    • Fix update()/delete() on complex resultsets to no longer fall back to silly row-by-row deletion, construct a massive OR statement instead
    • Allow complex update/delete operations on sources without a primary key, as long as they have at least one non-nullable unique constraint
    • dbicadmin now better supports catalyst-style config files, by unrolling 'config_info' hashkeys
    • Multiple Improvements MSSQL over DBD::ADO
      • Transaction support
      • Support for VARCHAR(MAX)/VARBINARY(MAX)/NVARCHAR(MAX) datatypes
      • Nomalization of retrieved GUID values
  • Fixes
    • Fix complex has_many prefetch with resultsets not selecting identity columns from the root result source
    • Fix SkipFirst and FirstSkip limit dialects (Informix and Firebird)
    • Fix "Skimming limit" dialects (Top, FetchFirst) to properly check the order_by criteria for stability
    • Fix "Skimming limit" dialects (Top, FetchFirst) to propagate non-selected order criteria when part of a larger subquery
    • Fix RowNumberOver and all "skimming limits" to correctly assemble bind values when supplied for both select and order_by
    • Fix all subquery-based dialects to not lose a subquery fragment when we both select and order by the result of the same subquery
    • Fix the Sybase hubrid limit dialect (RowCountOrGenericSubQ) losing Group/Having/Order clauses when called without an offset (RT#73244)
    • No longer generate incorrect SQL on ->as_query called on resultsets with software_limit enabled
    • A number of corner case fixes of void context populate() with \[]
    • Fix corner case of forked children disconnecting the parents DBI handle
    • Improve identity/autoinc retrieval code in MSSQL and Sybase - should reduce weird side-effects especially with populate()
    • Explicitly disable DBD::ODBC batch operations (as of DBD::ODBC 1.35) for the following drivers too buggy to handle the optimized path:
      • FreeTDS ODBC driver (when used with MSSQL)
      • The Firebird ODBC driver
      • The MSAccess ODBC driver
    • Explicitly disable DBD::ODBC dynamic_cursors when using freetds 0.83 or later - they made enough ODBC incompatible changes making it impossible to support sanely
    • Explicitly disable SCOPE_IDENTITY queries and statement caching for MSSQL on DBD::Sybase compiled against freetds 0.83 or later - way too buggy
    • Disable statement caching when using Sybase ASE and DBD::Sybase compiled against freetds 0.83 or later
    • Fix leakage of $schema on in-memory new_related() calls
    • Fix more cases of $schema leakage in SQLT::Parser::DBIC
    • Fix leakage of $storage in ::Storage::DBI::Oracle
    • Fix pessimization of Oracle RowNum limit dialect query when no offset has been specified
    • Remove useless vestigial pessimization in Ordered.pm for cases when the position column is part of a unique constraint
    • Fix dbicadmin to no longer ignore the documented 'config' option
    • The schema-resultsource entanglement is now much more robust under threads
    • Fix ::Schema::ddl_filename() failing miserably on paths containing certain numeric sequences
    • t/53lean_startup.t adjusted for new 5.15.x base.pm behavior
  • Misc
    • Centralized leak-checks for all instances of DBICTest::Schema from within any test
    • Now passes all tests with Test::Builder 1.005
    • Codebase is now trailing-whitespace-free
    • Cleanup of complex resultset update/delete oprations - storage specific code moved back to ResultSet and replaced by checks of storage capabilities
    • Fixed carp_once only emitting one single warning per package regardless of warning content
    • Test suite now can be safely executed in parallel (prove -jN or HARNESS_OPTIONS=jN)

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::Features
A boatload of DBIx::Class features with links to respective documentation
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.
DBIx::Class::Storage::DBI::Replicated::Introduction
Minimum Need to Know
Method
dbicadmin
utility for administrating DBIx::Class schemata

Modules

DBIx::Class
Extensible and flexible object <-> relational mapper.
DBIx::Class::AccessorGroup
See Class::Accessor::Grouped
DBIx::Class::Admin
Administration object for schemas
DBIx::Class::CDBICompat
Class::DBI Compatibility layer.
DBIx::Class::Carp
Provides advanced Carp::Clan-like warning functions for DBIx::Class internals
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::FilterColumn
Automatically convert column data
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
DEPRECATED (superseded by DBIx::Class::InflateColumn::FS)
DBIx::Class::Optional::Dependencies
Optional module dependency specifications (for module authors)
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::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
Serializable pointers to ResultSource instances
DBIx::Class::ResultSourceProxy::Table
provides a classdata table object and method proxies
DBIx::Class::Row
Basic row methods
DBIx::Class::SQLMaker
An SQL::Abstract-based SQL maker class
DBIx::Class::SQLMaker::LimitDialects
SQL::Abstract::Limit-like functionality for DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::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 nfreeze/thaw
DBIx::Class::StartupCheck
Run environment checks on startup
DBIx::Class::Storage
Generic Storage Handler
DBIx::Class::Storage::BlockRunner
Try running a block of code until success with a configurable retry logic
DBIx::Class::Storage::DBI
DBI storage handler
DBIx::Class::Storage::DBI::ACCESS
Support specific to MS Access
DBIx::Class::Storage::DBI::ADO
Support for DBD::ADO
DBIx::Class::Storage::DBI::ADO::MS_Jet
Support for MS Access over ADO
DBIx::Class::Storage::DBI::ADO::MS_Jet::Cursor
GUID Support for MS Access over ADO
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server
Support for Microsoft SQL Server via DBD::ADO
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor
Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO
DBIx::Class::Storage::DBI::AutoCast
Storage component for RDBMS requiring explicit placeholder typing
DBIx::Class::Storage::DBI::Cursor
Object representing a query cursor on a resultset.
DBIx::Class::Storage::DBI::DB2
IBM DB2 support for DBIx::Class
DBIx::Class::Storage::DBI::Firebird
Driver for the Firebird RDBMS via DBD::Firebird
DBIx::Class::Storage::DBI::Firebird::Common
Driver Base Class for the Firebird RDBMS
DBIx::Class::Storage::DBI::IdentityInsert
Storage Component for Sybase ASE and MSSQL for Identity Inserts / Updates
DBIx::Class::Storage::DBI::Informix
Base Storage Class for Informix Support
DBIx::Class::Storage::DBI::InterBase
Driver for the Firebird RDBMS via DBD::InterBase
DBIx::Class::Storage::DBI::MSSQL
Base Class for Microsoft SQL Server support in DBIx::Class
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::Firebird
Driver for using the Firebird RDBMS through ODBC
DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server
Support specific to Microsoft SQL Server over ODBC
DBIx::Class::Storage::DBI::ODBC::SQL_Anywhere
Driver for using Sybase SQL Anywhere through ODBC
DBIx::Class::Storage::DBI::Oracle
Base class for Oracle driver
DBIx::Class::Storage::DBI::Oracle::Generic
Oracle Support for DBIx::Class
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::WithDSN
A DBI Storage Role with DSN information in trace output
DBIx::Class::Storage::DBI::SQLAnywhere
Driver for SQL Anywhere
DBIx::Class::Storage::DBI::SQLAnywhere::Cursor
GUID Support for SQL Anywhere over DBD::SQLAnywhere
DBIx::Class::Storage::DBI::SQLite
Automatic primary key class for SQLite
DBIx::Class::Storage::DBI::Sybase
Base class for drivers using DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::ASE
Sybase ASE SQL Server support for DBIx::Class
DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars
Storage::DBI subclass for Sybase ASE without placeholder support
DBIx::Class::Storage::DBI::Sybase::FreeTDS
Base class for drivers using DBD::Sybase over FreeTDS.
DBIx::Class::Storage::DBI::Sybase::MSSQL
(DEPRECATED) Legacy storage class for MSSQL via DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server
Support for Microsoft SQL Server via DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars
Support for Microsoft SQL Server via DBD::Sybase without placeholders
DBIx::Class::Storage::DBI::UniqueIdentifier
Storage component for RDBMSes supporting GUID types
DBIx::Class::Storage::DBI::mysql
Storage::DBI class implementing MySQL specifics
DBIx::Class::Storage::Statistics
SQL Statistics
DBIx::Class::Storage::TxnScopeGuard
Scope-based transaction handling
DBIx::Class::UTF8Columns
Force UTF8 (Unicode) flag on columns (DEPRECATED)
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

Examples

Other files