Revision history for DBIx::Class
+ - order_by now can take \[$sql, @bind] as in
+ order_by => { -desc => \['colA LIKE ?', 'somestring'] }
+ - SQL::Abstract errors are now properly croak()ed with the
+ correct trace
+ - populate() now properly reports the dataset slice in case of
+ an exception
+ - Fixed corner case when populate() erroneously falls back to
+ create()
+ - Work around braindead mysql when doing subquery counts on
+ resultsets containing identically named columns from several
+ tables
+ - Fixed a m2m add_to_$rel to invoke find_or_create on the far
+ side of the relation, to avoid duplicates
+ - DBIC now properly handles empty inserts (invoking all default
+ values from the DB, normally via INSERT INTO tbl DEFAULT VALUES
+ - Fix find_or_new/create to stop returning random rows when
+ default value insert is requested (RT#28875)
+ - Make IC::DT extra warning state the column name too
+ - It is now possible to transparrently search() on columns
+ requiring DBI bind (i.e. PostgreSQL blob)
+ - as_query is now a Storage::DBI method, so custom cursors can
+ be seamlessly used
+ - Fix search_related regression introduced in 0.08103
+
+0.08103 2009-05-26 19:50:00 (UTC)
+ - 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
+
+0.08102 2009-04-30 08:29:00 (UTC)
+ - Fixed two subtle bugs when using columns or select/as
+ paired with a join (limited prefetch)
+ - Fixed breakage of cdbi tests (RT#45551)
+ - Some POD improvements
+
+0.08101 2009-04-27 09:45:00 (UTC)
+ - Fix +select, +as, +columns and include_columns being stripped
+ by $rs->get_column
+ - move load_optional_class from DBIx::Class::Componentised to
+ Class::C3::Componentised, bump dependency
+ - register_extra_source() now *really* fixed wrt subclassing
+ - Added missing POD descriptions (RT#45195)
+ - Fix insert() to not store_column() every present object column
+ - Multiple Makefile.PL fixes
+
+0.08100 2009-04-19 11:39:35 (UTC)
+ - Todo out the register_extra_source test until after shipping
+
+0.08099_08 2009-03-30 00:00:00 (UTC)
+ - Fixed taint mode with load_namespaces
+ - Putting IC::DateTime locale, timezone or floating_tz_ok attributes into
+ extra => {} has been deprecated. The new way is to put these things
+ directly into the columns definition
+ - Switched MI code to MRO::Compat
+ - Document db-side default_value caveats
+ - Search_like() now warns to indicate deprecation in 0.09.
+ - TxnScopeGuard left experimental state
+
+0.08099_07 2009-02-27 02:00:00 (UTC)
+ - multi-create using find_or_create rather than _related for post-insert
+ - fix get_inflated_columns to check has_column_loaded
+ - Add DBIC_MULTICREATE_DEBUG env var (undocumented, quasi-internal)
+ - Fix up multi-create to:
+ - correctly propagate columns loaded during multi-insert of rels
+ - not try and insert things tagged on via new_related unless required
+ - Possible to set locale in IC::DateTime extra => {} config
+ - Calling the accessor of a belongs_to when the foreign_key
+ was NULL and the row was not stored would unexpectedly fail
+ - Split sql statements for deploy only if SQLT::Producer returned a scalar
+ containing all statements to be executed
+ - Add as_query() for ResultSet and ResultSetColumn. This makes subqueries
+ possible. See the Cookbook for details.
+ - Massive rewrite of Ordered to properly handle position constraints and
+ to make it more matpath-friendly
+ - deploy_statements called ddl_filename with the $version and $dir arguments
+ in the wrong order.
+ - columns/+columns attributes now support { as => select } hahsrefs
+ - support for views both in DBIC and via deploy() in SQLT
+
+0.08099_06 2009-01-23 07:30:00 (UTC)
+ - Allow a scalarref to be supplied to the 'from' resultset attribute
+ - Classes submitted as result_class for a resultsource are now
+ automatically loaded via ensure_loaded()
+ - 'result_class' resultset attribute, identical to result_class()
+ - add 'undef_on_null_fk' option for relationship accessors of type 'single'.
+ This will prevent DBIC from querying the database if one or more of
+ the key columns IS NULL
+ - for 'belongs_to' rels, 'undef_on_null_fk' defaults to true.
+ - fixed scope unaware last_insert_id fetching for MSSQL
+ (http://msdn.microsoft.com/en-us/library/ms190315.aspx)
+ - an sqlt_deploy_hook can now be shared between result sources using
+ a configurable callback trigger
+ - new order_by => { -desc => 'colname' } syntax supported
+ - PG array datatype supported
+ - insert should use store_column, not set_column to avoid marking
+ clean just-stored values as dirty. New test for this
+ - regression test for source_name
+
+0.08099_05 2008-10-30 21:30:00 (UTC)
+ - Rewrite of Storage::DBI::connect_info(), extended with an
+ additional argument format type
+ - InflateColumn::DateTime: add warning about floating timezone
+ - InflateColumn::DateTime: possible to enforce/skip inflation
+ - delete throws exception if passed arguments to prevent drunken mishaps.
+ - Fix storage to copy scalar conds before regexping to avoid
+ trying to modify a constant in odd edge cases
+ - Related resultsets on uninserted objects are now empty
+ - Fixed up related resultsets and multi-create
+ - Fixed superfluous connection in ODBC::_rebless
+ - Fixed undef PK for first insert in ODBC::Microsoft_SQL_Server
+ - Added virtual method to Versioned so a user can create upgrade
+ path across multiple versions (jgoulah)
+ - Better (and marginally faster) implementation of the HashRefInflator
+ hash construction algorithm
+ - Allow explicit specification of ON DELETE/ON UPDATE constraints
+ when using the SQLT parser
+
+0.08099_04 2008-07-24 01:00:00
+ - Functionality to storage to enable a sub to be run without FK checks
+ - Fixed $schema->clone bug which caused clone and source to share
+ internal hash refs
+ - Added register_extra_source methods for additional sources
+ - Added datetime_undef_if_invalid for InflateColumn::DateTime to
+ return undef on invalid date/time values
+ - Added search_related_rs method to ResultSet
+ - add a make_column_dirty method to Row to force updates
+ - throw a clear exception when user tries multi-has_many prefetch
+ - SQLT parser prefixes index names with ${table}_idx_ to avoid clashes
+ - mark ResultSetManager as deprecated and undocument it
+ - pod fix (RT #32988)
+ - add Test::Exception to test requirements (RT #34256)
+ - make ash's build_requires/META.yml fixes work better
+ - is_deferable support on relations used by the SQL::Translator
+ parser
+ - Refactored DBIx::Class::Schema::Versioned
+ - Syntax errors from resultset components are now reported correctly
+ - sqltargs respected correctly in deploy et al.
+ - Added support for savepoints, and using them automatically in
+ nested transactions if auto_savepoint is set in connect_info.
+ - Changed naming scheme for constraints and keys in the sqlt parser;
+ names should now be consistent and collision-free.
+ - Improve handling of explicit key attr in ResultSet::find
+ - Add warnings for non-unique ResultSet::find queries
+ - Changed Storage::DBI::Replication to Storage::DBI::Replicated and
+ refactored support.
+ - By default now deploy/diff et al. will ignore constraint and index
+ names
+ - Add ResultSet::_is_deterministic_value, make new_result filter the
+ values passed to new to drop values that would generate invalid SQL.
+ - Use Sub::Name to name closures before installing them. Fixes
+ incompatibility with Moose method modifiers on generated methods.
+
+0.08010 2008-03-01 10:30
+ - Fix t/94versioning.t so it passes with latest SQL::Translator
+
+0.08009 2008-01-20 13:30
+ - Made search_rs smarter about when to preserve the cache to fix
+ mm prefetch usage
+ - Added Storage::DBI subclass for MSSQL over ODBC.
+ - Added freeze, thaw and dclone methods to Schema so that thawed
+ objects will get re-attached to the schema.
+ - Moved dbicadmin to JSON::Any wrapped JSON.pm for a sane API
+ (also fixes RT #32393)
+ - introduced DBIx::Class::set_inflated_columns
+ - DBIx::Class::Row::copy uses set_inflated_columns
+
+0.08008 2007-11-16 14:30:00
+ - Fixed join merging bug (test from Zby)
+ - When adding relationships, it will throw an exception if you get the
+ foreign and self parts the wrong way round in the condition
+ - ResultSetColumn::func() now returns all results if called in list
+ context; this makes things like func('DISTINCT') work as expected
+ - Many-to-many relationships now warn if the utility methods would
+ clash
+ - InflateColumn::DateTime now accepts an extra parameter of timezone
+ to set timezone on the DT object (thanks Sergio Salvi)
+ - Added sqlt_deploy_hook to result classes so that indexes can be
+ added.
+ - Added startup checks to warn loudly if we appear to be running on
+ RedHat systems from perl-5.8.8-10 and up that have the bless/overload
+ patch applied (badly) which causes 2x -> 100x performance penalty.
+ (Jon Schutz)
+ - ResultSource::reverse_relationship_info can distinguish between
+ sources using the same table
+ - Row::insert will now not fall over if passed duplicate related objects
+ - Row::copy will not fall over if you have two relationships to the
+ same source with a unique constraint on it
+
+0.08007 2007-09-04 19:36:00
+ - patch for Oracle datetime inflation (abram@arin.net)
+ - added on_disconnect_do
+ - on_connect_do and on_disconnect_do take coderefs and arrayrefs
+
+0.08006 2007-08-12 15:12:00
+ - Move to using Class::C3::Componentised
+ - Remove warn statement from DBIx::Class::Row
+
+0.08005 2007-08-06
+ - add timestamp fix re rt.cpan 26978 - no test yet but change
+ clearly should cause no regressions
+ - provide alias for related_resultset via local() so it's set
+ correctly at resultset construction time (fixes RestrictWithObject)
+ - fixes bind params in debug statements
+ (original test from abraxxa)
+ - fixed storage->connected fork bug
+ (test and fix from Radu Greab)
+ - add 1; to AccessorGroup.pm for stuff that still uses it
+ - refactor Statistics to create debugging filehandle to fix bug with
+ closed STDERR, update docs and modify Versioned to use Statistics
+ (original fix from diz)
+
+0.08004 2007-08-06 19:00:00
+ - fix storage connect code to not trigger bug via auto-viv
+ (test from aherzog)
+ - fixup cursor_class to be an 'inherited' attr for per-package defaults
+ - add default_resultset_attributes entry to Schema
+ - optimisation in DBI::Cursor to check software_limit before falling
+ back to base Cursor->all
+ - fix bug with create_multi not inserting non-storage objects
+ (test and fix from davinchi)
+ - DBIx::Class::AccessorGroup made empty subclass of
+ Class::Accessor::Grouped
+ - fixed an ugly bug regarding $dbh->{AutoCommit} and transactions
+ - ensure_class_loaded handles non-classnames better.
+ - non-destructive hashref handling for connect_info options
+ - count no longer returns negative values after slice
+ (report and test from JOHANL)
+ - rebless before building datetime_parser
+ (patch from mattlaw / Matt Lawrence)
+
+0.08003 2007-07-14 18:01:00
+ - improved populate bulk_insert mode
+ - fixed up multi_create to be more intelligent about PK<->PK rels
+ - fix many-many rels to not use set_columns
+ - Unmarked deploy as experimental since it isn't anymore
+ - Removed Cwd dep since it's not required and causes problems
+ with debian packaging
+ - Patch to fix ? in data for NoBindVars (from Tom Hukins)
+ - Restored mk_classaccessor method for compatibility
+ - Fixed group_by problem with oracle limit syntax
+ - Fixed attr merging problem
+ - Fixed $rs->get_column w/prefetch problem
+
+0.08002 2007-06-20 06:10:00
+ - add scope guard to Row::insert to ensure rollback gets called
+ - more heuristics in Row::insert to try and get insert order right
+ - eliminate vestigial code in PK::Auto
+ - more expressive DBI errors
+ - soften errors during deploy
+ - ensure_connected before txn_begin to catch stomping on transaction
+ depth
+ - new method "rethrow" for our exception objects
+
+0.08001 2007-06-17 21:21:02
+ - Cleaned up on_connect handling for versioned
+ - removed DateTime use line from multi_create test
+ - hid DBIx::ContextualFetch::st override in CDBICompat
+
+0.08000 2007-06-17 18:06:12
+ - Fixed DBIC_TRACE debug filehandles to set ->autoflush(1)
+ - Fixed circular dbh<->storage in HandleError with weakref
+
+0.07999_06 2007-06-13 04:45:00
+ - tweaked Row.pm to make last_insert_id take multiple column names
+ - Fixed DBIC::Storage::DBI::Cursor::DESTROY bug that was
+ messing up exception handling
+ - added exception objects to eliminate stacktrace/Carp::Clan
+ output redundancy
+ - setting $ENV{DBIC_TRACE} defaults stacktrace on.
+ - added stacktrace option to Schema, makes throw_exception
+ use "confess"
+ - make database handles use throw_exception by default
+ - make database handles supplied by a coderef use our
+ standard HandleError/RaiseError/PrintError
+ - add "unsafe" connect_info option to suppress our setting
+ of HandleError/RaiseError/PrintError
+ - removed several redundant evals whose sole purpose was to
+ provide extra debugging info
+ - fixed page-within-page bug (reported by nilsonsfj)
+ - fixed rare bug when database is disconnected inbetween
+ "$dbh->prepare_cached" and "$sth->execute"
+
+0.07999_05 2007-06-07 23:00:00
+ - Made source_name rw in ResultSource
+ - Fixed up SQL::Translator test/runtime dependencies
+ - Fixed t/60core.t in the absence of DateTime::Format::MySQL
+ - Test cleanup and doc note (ribasushi)
+
+0.07999_04 2007-06-01 14:04:00
+ - pulled in Replication storage from branch and marked EXPERIMENTAL
+ - fixup to ensure join always LEFT after first LEFT join depthwise
+ - converted the vendor tests to use schema objects intead of schema
+ classes, made cleaned more reliable with END blocks
+ - versioning support via DBIx::Class::Schema::Versioned
+ - find/next now return undef rather than () on fail from Bernhard Graf
+ - rewritten collapse_result to fix prefetch
+ - moved populate to resultset
+ - added support for creation of related rows via insert and populate
+ - transaction support more robust now in the face of varying AutoCommit
+ and manual txn_begin usage
+ - unbreak back-compat for Row/ResultSet->new_result
+ - Added Oracle/WhereJoins.pm for Oracle >= 8 to support
+ Oracle <= 9i, and provide Oracle with a better join method for
+ later versions. (I use the term better loosely.)
+ - The SQL::T parser class now respects a relationship attribute of
+ is_foreign_key_constrain to allow explicit control over wether or
+ not a foreign constraint is needed
+ - resultset_class/result_class now (again) auto loads the specified
+ class; requires Class::Accessor::Grouped 0.05002+
+ - added get_inflated_columns to Row
+ - %colinfo accessor and inflate_column now work together
+ - More documentation updates
+ - Error messages from ->deploy made more informative
+ - connect_info will now always return the arguments it was
+ originally given
+ - A few small efficiency improvements for load_classes
+ and compose_namespace
+
+0.07006 2007-04-17 23:18:00
+ - Lots of documentation updates
+ - deploy now takes an optional 'source_names' parameter (dec)
+ - Quoting for for columns_info_for
+ - RT#25683 fixed (multiple open sths on DBD::Sybase)
+ - CDBI compat infers has_many from has_a (Schwern)
+ - Fix ddl_filename transformation (Carl Vincent)
+
+0.07999_02 2007-01-25 20:11:00
+ - add support for binding BYTEA and similar parameters (w/Pg impl)
+ - add support to Ordered for multiple ordering columns
+ - mark DB.pm and compose_connection as deprecated
+ - switch tests to compose_namespace
+ - ResultClass::HashRefInflator added
+ - Changed row and rs objects to not have direct handle to a source,
+ instead a (schema,source_name) tuple of type ResultSourceHandle
+
+0.07005 2007-01-10 18:36:00
+ - fixup changes file
+ - remove erroneous .orig files - oops
+
+0.07004 2007-01-09 21:52:00
+ - fix find_related-based queries to correctly grep the unique key
+ - fix InflateColumn to inflate/deflate all refs but scalar refs
+
+0.07003 2006-11-16 11:52:00
+ - fix for rt.cpan.org #22740 (use $^X instead of hardcoded "perl")
+ - Tweaks to resultset to allow inflate_result to return an array
+ - Fix UTF8Columns to work under Perl <= 5.8.0
+ - Fix up new_result in ResultSet to avoid alias-related bugs
+ - Made new/update/find handle 'single' rel accessor correctly
+ - Fix NoBindVars to be safer and handle non-true bind values
+ - Don't blow up if columns_info_for returns useless results
+ - Documentation updates
+
+0.07999_01 2006-10-05 21:00:00
+ - add connect_info option "disable_statement_caching"
+ - create insert_bulk using execute_array, populate uses it
- added DBIx::Class::Schema::load_namespaces, alternative to
load_classes
- added source_info method for source-level metadata (kinda like
- columns_info_for is deprecated, and no longer runs automatically.
You can make it work like before via
__PACKAGE__->column_info_from_storage(1) for now
-
-0.07003 2006-XX-XX XX:XX:XX
- - Fix UTF8Columns to work under Perl <= 5.8.0
+ - Replaced DBIx::Class::AccessorGroup and Class::Data::Accessor with
+ Class::Accessor::Grouped. Only user noticible change is to
+ table_class on ResultSourceProxy::Table (i.e. table objects in
+ schemas) and, resultset_class and result_class in ResultSource.
+ These accessors no longer automatically require the classes when
+ set.
0.07002 2006-09-14 21:17:32
- fix quote tests for recent versions of SQLite
- fixes to pass test suite on Windows
- rewrote and cleaned up SQL::Translator tests
- changed relationship helpers to only call ensure_class_loaded when the
- join condition is inferred
+ join condition is inferred
- rewrote many_to_many implementation, now provides helpers for adding
and deleting objects without dealing with the link table
- reworked InflateColumn implementation to lazily deflate where
- changed join merging to not create a rel_2 alias when adding a join
that already exists in a parent resultset
- Storage::DBI::deployment_statements now calls ensure_connected
- if it isn't passed a type
+ if it isn't passed a type
- fixed Componentized::ensure_class_loaded
- InflateColumn::DateTime supports date as well as datetime
- split Storage::DBI::MSSQL into MSSQL and Sybase::MSSQL
- - fixed wrong debugging hook call in Storage::DBI
- - set connect_info properly before setting any ->sql_maker things
+ - fixed wrong debugging hook call in Storage::DBI
+ - set connect_info properly before setting any ->sql_maker things
0.06999_02 2006-06-09 23:58:33
- Fixed up POD::Coverage tests, filled in some POD holes
0.05002 2006-02-06 12:12:03
- Added recommends for Class::Inspector
- - Added skip_all to t/40resultsetmanager.t if no Class::Inspector available
+ - Added skip_all to t/40resultsetmanager.t if no Class::Inspector
+ available
0.05001 2006-02-05 15:28:10
- debug output now prints NULL for undef params
0.04999_04 2006-01-24 21:48:21
- more documentation improvements
- - add columns_info_for for vendor-specific column info (Zbigniew Lukasiak)
- - add SQL::Translator::Producer for DBIx::Class table classes (Jess Robinson)
+ - add columns_info_for for vendor-specific column info (Zbigniew
+ Lukasiak)
+ - add SQL::Translator::Producer for DBIx::Class table classes (Jess
+ Robinson)
- add unique constraint declaration (Daniel Westermann-Clark)
- add new update_or_create method (Daniel Westermann-Clark)
- rename ResultSetInstance class to ResultSetProxy, ResultSourceInstance
0.04999_03 2006-01-20 06:05:27
- imported Jess Robinson's SQL::Translator::Parser::DBIx::Class
- - lots of internals cleanup to eliminate result_source_instance requirement
+ - lots of internals cleanup to eliminate result_source_instance
+ requirement
- added register_column and register_relationship class APIs
- made Storage::DBI use prepare_cached safely (thanks to Tim Bunce)
- many documentation improvements (thanks guys!)
- - added ->connection, ->connect, ->register_source and ->clone schema methods
+ - added ->connection, ->connect, ->register_source and ->clone schema
+ methods
- Use croak instead of die for user errors.
0.04999_02 2006-01-14 07:17:35
0.01 2005-08-08 17:10:00
- initial release
+