/ 
DBIx-Class-0.08190_01
River stage three • 347 direct dependents • 457 total dependents

Changes for version 0.08190_01 - 2011-05-02

  • New Features / Changes
    • Add quote_names connection option. When set to true automatically sets quote_char and name_sep appropriate for your RDBMS
    • Add retrieve_on_insert column info flag, allowing to retrieve any column value instead of just autoinc primary keys
    • Bring back strict ordering of selectors in complex search chains (an ill-fated attempt was made in 0.08127 to order intelligently)
    • All limit dialects (except for the older Top and FetchFirst) are now using bind parameters for the limits/offsets, making DBI's prepare_cached useful across paged resutsets
    • Support for savepoints for SQLite
    • Support for MS Access databases via DBD::ODBC and DBD::ADO (only Win32 support currently tested)
    • Support for the Firebird RDBMS over the new DBD::Firebird driver
    • IC::DateTime support for MSSQL over DBD::ADO
    • Both the ::ODBC and ::ADO dispatchers now warn if a rdbms-specific driver is not found for this connection before falling back to plain ::Storage::DBI
    • ::Storage::DBI::sth was mistakenly marked/documented as public, privatize and warn on deprecated use
    • Massive overhaul of bind values/attributes handling - slightly changes the output of as_query (should not cause compat issues)
    • Support ancient DB2 versions (5.4 and older), with proper limit dialect
    • Support sub-second precision for TIMESTAMPs for Firebird over ODBC
    • Support BLOBs and CLOBs in WHERE clauses for Oracle, including LIKE queries for CLOBs.
  • Fixes
    • Fix ::Storage::DBI::* MRO problems on 5.8.x perls
    • Disable mysql_auto_reconnect for MySQL - depending on the ENV it sometimes defaults to on and causes major borkage on older DBD::mysql versions
    • Fix dropped bind values in select/group_by on Oracle (omission from 0542ec57 and 4c2b30d6)
    • Fix remaining errors with Oracle and identifiers longer than the Oracle-imposed maximum of 30 characters (RT#66390)
    • Fix older oracle-specific "WhereJoins" to work properly with name quoting
    • Fix problems with M.A.D. under CGI::SpeedyCGI (RT#65131)
    • Reenable paging of cached resultsets - breakage erroneously added in 0.08127
    • Better error handling when prepare() fails silently
    • Fixes skipped lines when a comment is followed by a statement when deploying a schema via sql file
    • Fix reverse_relationship_info on prototypical result sources (sources not yet registered with a schema)
    • Warn and skip relationships missing from a partial schema during dbic cascade_delete
    • Automatically require the requested cursor class before use (RT#64795)
    • Work around a Firebird ODBC driver bug exposed by DBD::ODBC 1.29
    • Fix (to the extent allowed by the driver) transaction support in DBD::Sybase compiled against FreeTDS
    • Fix exiting via next warnings in ResultSource::sequence()
    • Fix stripping of table qualifiers in update/delete in arrayref condition elements
    • Change SQLMaker carp-monkeypatch to be compatible with versions of SQL::Abstract >= 1.73
    • Fix using \[] literals in the from resultset attribute
    • Fix populate() with \[], arrays (datatype) and other exotic values
    • Fix handling of rollbacks in nested transactions
    • Fix complex limits (RNO/RowNum/FetchFirst/Top/GenSubq) with sub-selects in the selectors list (correlated subqueries)
    • Fix inconsistency between $rs->next with and without HRI when all the "root" columns are in fact injected from the right rs side
    • Fix the join optimizer to correctly preserve the non-multi path to a multi relationship ( x -> might_have y -> has_many z )
    • Fix object-derived custom-relationship resultsets to resultsources with multilevel monikers (e.g. $schema->source('Foo::Bar') )
    • Fix incorrect signature of the default sqlt_deploy_hook - it now matches the documentation of passing in the result source object
    • Fix inadequate handling of internal storage methods within ::Storage::Replicated (RT#66295)
  • Misc
    • Rewire all warnings to a new Carp-like implementation internal to DBIx::Class, and remove the Carp::Clan dependency
    • Only load Class::C3 and friends if necessary ($] < 5.010)
    • Greatly reduced loading of non-essential modules to aid startup time (mainly benefiting CGI users)
    • Make sure all namespaces are clean of rogue imports
    • Dropped DBI req 2 years back - everything works with 1.57, no point requiring something newer

Changes for version 0.08190-TRIAL - 2011-01-24 (TRIAL RELEASE)

  • New Features / Changes
    • Support for completely arbitrary SQL::Abstract-based conditions in all types of relationships

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
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::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::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::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::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::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

Provides

DBIx::Class::_ENV_
in lib/DBIx/Class.pm

Examples

Other files