The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
DBIx-Class-0.08122
River stage three • 342 direct dependents • 452 total dependents
289 ++

Changes for version 0.08122 - 2010-05-03

  • New Features
    • Add DBIx::Class::FilterColumn for non-ref filtering
    • ::Storage::DBI now correctly preserves a parent $dbh from terminating children, even during interpreter-global out-of-order destruction
    • dbicadmin supports an -I option with the same semantics as perl itself
    • InflateColumn::DateTime support for MSSQL via DBD::Sybase
    • Millisecond precision support for MSSQL datetimes for InflateColumn::DateTime
    • Oracle-specific hierarchical query syntax support: CONNECT BY (NOCYCLE) / START WITH / ORDER SIBLINGS BY
    • Support connecting using $ENV{DBI_DSN} and $ENV{DBI_DRIVER}
    • current_source_alias method on ResultSet objects to determine the alias to use in programatically assembled search()es (originally added in 0.08100 but unmentioned)
    • Rewrite/unification of all subselecting limit emulations (RNO, Top, RowNum) to be much more robust wrt complex joined resultsets
    • MSSQL limits now don't require nearly as many applications of the unsafe_subselect_ok attribute, due to optimized queries
    • Support for Generic Subquery limit "emulation" - awfully slow and inefficient but works on almost any db, and is preferred to software limit emulation
    • Sybase ASE driver now uses SET ROWCOUNT where possible, and Generic Subquery otherwise for limit support instead of always using software limit emulation
    • create_ddl_dir (and derivatives) now attempt to create the given $ddl_dir if it does not already exist
    • deployment_statements now automatically supplies the current RDBMS version to SQLT producer_args for MySQL, Pg, SQLite and Oracle
  • Fixes
    • Fix nasty potentially data-eating bug when deleting/updating a limited resultset
    • Fix find() to use result_class set on object
    • Fix result_class setter behaviour to not mistakenly stuff attrs.
    • Don't try and ensure_class_loaded an object. This doesn't work.
    • Fix as_subselect_rs to not inject resultset class-wide where conditions outside of the resulting subquery
    • Fix count() failing with {for} resultset attribute (RT#56257)
    • Fixed incorrect detection of Limit dialect on unconnected $schema
    • update() on row not in_storage no longer throws an exception if there are no dirty columns to update (fixes cascaded update annoyances)
    • update()/delete() on prefetching resultsets no longer results in malformed SQL (some $rs attributes were erroneously left in)
    • Fix dbicadmin to allow deploy() on non-versioned schema
    • Fix dbicadmin to respect sql_dir on upgrade() (RT#57732)
    • Update Schema::Versioned to respect hashref style of connection_info
    • Do not recreate the same related object twice during MultiCreate (solves the problem of orphaned IC::FS files)
    • Fully qualify xp_msver selector when using DBD::Sybase with MSSQL (RT#57467)
    • Fix ::DBI::Storage to always be able to present a full set of connect() attributes to e.g. Schema::Versioned
    • Fix Oracle auto-inc trigger detection of "INSERT OR UPDATE"-type triggers
  • Misc
    • Reformatted Changelog \o/
    • DBIC goes git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git
    • Allow developers to skip optional dependency forcing when working from a checkout
    • Add a warning to load_namespaces if a class in ResultSet/ is not a subclass of DBIx::Class::ResultSet
    • All DBIC exception-handling switched to Try::Tiny
    • All DBIC modules are now free of imports via namespace::clean
    • Depend on optimized SQL::Abstract (faster SQL generation)
    • Depend on new Class::Accessor::Grouped reintroducing optional use of Class::XSAccessor (just install C::XSA and get lightning fast column accessors)

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.
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::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
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::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::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
Automatic primary key class for DB2
DBIx::Class::Storage::DBI::Informix
Base Storage Class for Informix Support
DBIx::Class::Storage::DBI::InterBase
Driver for the Firebird RDBMS
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::Role::QueryCounter
Role to add a query counter
DBIx::Class::Storage::DBI::SQLAnywhere
Driver for Sybase SQL Anywhere
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::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 the 'uniqueidentifier' type
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