./databases/p5-DBIx-Class, Extensible and flexible object <-> relational mapper

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 0.08270nb1, Package name: p5-DBIx-Class-0.08270nb1, Maintainer: pkgsrc-users

This is an SQL to OO mapper, inspired by the Class::DBI framework, and
meant to support compability with it, while restructuring the internals
and making it possible to support some new features like self-joins,
distinct, group bys and more.

This project is still at an early stage, so the maintainers don't make
any absolute promise that full backwards-compatibility will be
supported; however, if we can without compromising the improvements
we're trying to make, we will, and any non-compatible changes will merit
a full justification on the mailing list and a CPAN developer release
for people to test against.

Required to run:
[databases/p5-DBI] [databases/p5-SQL-Abstract] [lang/perl5] [devel/p5-Class-Inspector] [devel/p5-Path-Class] [databases/p5-SQL-Abstract-Limit] [devel/p5-Class-Accessor-Grouped] [devel/p5-MRO-Compat] [devel/p5-Module-Find] [devel/p5-Config-Any] [devel/p5-Data-Page] [devel/p5-Scope-Guard] [devel/p5-Class-C3-Componentised] [devel/p5-Class-Method-Modifiers] [devel/p5-namespace-clean] [devel/p5-Sub-Name] [devel/p5-Data-Compare] [devel/p5-Hash-Merge] [devel/p5-Devel-GlobalDestruction] [devel/p5-Context-Preserve] [devel/p5-Try-Tiny] [devel/p5-Data-Dumper-Concise] [devel/p5-Moo]

Required to build:
[databases/p5-DBD-SQLite] [databases/p5-Class-DBI] [devel/p5-Test-Exception] [devel/p5-File-Temp] [devel/p5-Test-Warn] [devel/p5-Test-Simple] [devel/p5-Package-Stash]

Master sites: (Expand)

SHA1: dfe29b59acbadaaa0ae811596303c54a176250b8
RMD160: 80a708a40e0a3e09f3d40f2fa87cbd6dda4c0687
Filesize: 789.431 KB

Version history: (Expand)

CVS history: (Expand)

   2014-05-30 01:38:20 by Thomas Klausner | Files touched by this commit (3049)
Log message:
Bump for perl-5.20.0.
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.
   2014-02-05 13:00:08 by Wen Heping | Files touched by this commit (2) | Package updated
Log message:
Update to 0.08270

Upstream changes:
0.08270 2014-01-30 21:54 (PST)
    * Fixes
        - Fix 0.08260 regression in DBD::SQLite bound int handling. Inserted
          data was not affected, but any function <=> integer comparison would
          have failed (originally fixed way back in 0e773352)
        - Fix failure to load DateTime formatter when connecting to Firebird
          over ODBC

    * Misc
        - All drivers based on ::Storage::DBI::Firebird::Common now return the
          same sqlt_type value (affects ::DBI::Interbase, ::DBI::Firebird and

0.08260 2014-01-28 18:52 (UTC)
    * New Features
        - A new zero-to-DBIC style manual: DBIx::Class::Manual::QuickStart

    * Notable Changes and Deprecations
        - Explicitly deprecate combination of distinct and selecting a
          non-column via $rs->get_column()

    * Fixes
        - More robust handling of circular relationship declarations by loading
          foreign classes less frequently (should resolve issues like
          http://lists.scsys.co.uk/pipermail/dbix … 11374.html)
          Note that none of this is a manifestations of a DBIC bug, but rather
          unexpected (but correct) behavior of load-order-dependent (hence
          logically broken) Resultclass hierarchies. In order to deal with this
          DBIC is scaling back a large number of sanity checks, which are to be
          reintroduce pending a better framework for source registration
        - Fix multiple edge cases of complex prefetch combining incorrectly
          with correlated subquery selections
        - Fix multiple edge cases stemming from interaction of a non-selecting
          order_by specification and distinct and/or complex prefetch
        - Fix unbound growth of a resultset during repeated execute/exhaust
          cycles (GH#29)
        - Work around (and be very vocal about the fact) when DBIC encounters
          an exception object with broken string overloading
        - Clarify ambiguous behavior of distinct when used with ResultSetColumn
          i.e. $rs->search({}, { distinct => 1 })->get_column (...)
        - Setting quote_names propagates to SQL::Translator when producing
          SQLite DDL (it is one of the few producers *NOT* quoting by default)
        - Fix incorrect binding of large integers on old versions of
          DBD::SQLite (now DBIC simply always binds SQLite ints as BIGINT)
        - Silence (harmless) warnings on recent DBD::SQLite versions, when
          inserting/updating large integers on 32bit ivsize systems (RT#76395)
        - Back out self-cleaning from DBIx::Class::Carp for the time being
          (as a side effect fixes RT#86267)
        - Fix incorrect internal use of implicit list context in copy()
        - Fix 0.08250 regression in driver determination when DBI_DSN is used
        - Tests no longer fail if $ENV{DBI_DSN} is set
        - Throw clearer exception on ->new_related() with a non-existent
        - Fix incorrect parethesis unroll with multicolumn in, (never noticed
          before fixing false positive in SQLA::Test 1.77)
        - Fix t/storage/replicated.t class loading problem
        - Stop using the deprecated Class::MOP::load_class()
        - Fix warning in t/54taint.t with explicitly unset PERL5LIB (RT#91972)
        - Fix t/54taint.t failing under a local::lib with installed earlier
          DBIC version (RT#92486)

    * Misc
        - Massive incompatible change of ::BlockRunner internals (was never
          documented as usable externally, this last set of changes settles
          the design for proper documentation and opening up)
        - Adjust exceptions in tests to accommodate changes in the upcoming
          DBD::SQLite based on libsqlite 3.8.2
        - More robust lock file naming scheme - allow tests to work on exotic
          MSWin32 filesystems (habitual offender being http://is.gd/iy5XVP)
        - Better diagnostics when File::Spec->tmpdir gives us crap in testing
        - Replace $row with $result in all docs to be consistent and to
          clarify various return values
   2013-05-31 14:42:58 by Thomas Klausner | Files touched by this commit (2880)
Log message:
Bump all packages for perl-5.18, that
a) refer 'perl' in their Makefile, or
b) have a directory name of p5-*, or
c) have any dependency on any p5-* package

Like last time, where this caused no complaints.
   2013-05-02 09:22:12 by Wen Heping | Files touched by this commit (2) | Package updated
Log message:
Update to 0.08250

Upstream changes:
0.08250 2013-04-29 22:00 (UTC)
    * New Features / Changes
        - Rewrite from scratch the result constructor codepath - many bugfixes
          and performance improvements (the current codebase is now capable of
          outperforming both DBIx::DataModel and Rose::DB::Object on some
          workloads). Some notable benefits:
          - Multiple has_many prefetch
          - Partial prefetch - you now can select only columns you are
            interested in, while preserving the collapse functionality
            (collapse is now exposed as a first-class API attribute)
          - Prefetch of resultsets with arbitrary order
            (RT#54949, RT#74024, RT#74584)
          - Prefetch no longer inserts right-side table order_by clauses
            (massively helps the deficient MySQL optimizer)
          - Prefetch with limit on right-side ordered resultsets now works
            correctly (via aggregated grouping)
          - No longer order the insides of a complex prefetch subquery,
            unless required to satisfy a limit
          - Stop erroneously considering order_by criteria from a join under
            distinct => 1 (the distinct should apply to the main source only)
        - Massively optimize codepath around ->cursor(), over 10x speedup
          on some iterating workloads.
        - Support standalone \[ $sql, $value ] in literal SQL with bind
          specifications: \[ '? + ?', 42, 69 ] is now equivalent to
          \[ '? + ?', [ {} => 42 ], [ {} => 69 ] ]
        - Changing the result_class of a ResultSet in progress is now
          explicitly forbidden. The behavior was undefined before, and
          would result in wildly differing outcomes depending on $rs
        - Deprecate returning of prefetched 'filter' rels as part of
          get_columns() and get_inflated_columns() data
        - Invoking get_inflated_columns() no longer fires get_columns() but
          instead retrieves data from individual non-inflatable columns via
        - Emit a warning on incorrect use of nullable columns within a
          primary key
        - Limited checks are performed on whether columns without declared
          is_nullable => 1 metadata do in fact sometimes fetch NULLs from
          the database (the check is currently very limited and is performed
          only on resultset collapse when the alternative is rather worse)

    * Fixes
        - Fix _dbi_attrs_for_bind() being called befor DBI has been loaded
          (regression in 0.08210)
        - Fix update/delete operations on resultsets *joining* the updated
          table failing on MySQL. Resolves oversights in the fixes for
          RT#81378 and RT#81897
        - Fix open cursors silently resetting when inherited across a fork
          or a thread
        - Properly support "MySQL-style" left-side group_by with prefetch
        - Fix $grouped_rs->get_column($col)->func($func) producing incorrect
          SQL (RT#81127)
        - Stop Sybase ASE storage from generating invalid SQL in subselects
          when a limit without offset is encountered
        - Even more robust behavior of GenericSubQuery limit dialect
        - Make sure deployment_statements() and cursor_class() are called on
          a resolved storage subclass

    * Misc
        - Fix tests failing due to unspecified resultset retrieval order
          (test suite now will pass with newest SQLite libs)

0.08210 2013-04-04 15:30 (UTC)
    * New Features / Changes
        - Officially deprecate the 'cols' and 'include_columns' resultset
        - Remove ::Storage::DBI::sth() deprecated in 0.08191

    * Fixes
        - Work around a *critical* bug with potential for data loss in
          DBD::SQLite - RT#79576
        - Audit and correct potential bugs associated with braindead reuse
          of $1 on unsuccessful matches
        - Fix incorrect warning/exception originator reported by carp*() and

0.08209 2013-03-01 12:56 (UTC)
    * New Features / Changes
        - Debugging aid - warn on invalid result objects created by what
          seems like an invalid inheritance hierarchy

    * Fixes
        - Fix another embarrassing regression preventing correct refining of
          the search criteria on a prefetched relation (broken in 0.08205)
        - Fix incorrect callsite reporting by DBIC::Carp

0.08208 2013-02-20 09:56 (UTC)
    * New Features / Changes
        - A bunch of nonsensically named arguments to the SQL::Translator
          parser have been marked as deprecated (while still fully

    * Fixes
        - Fix duplicated selected columns when calling 'count' when a same
          aggregate function is used more than once in a 'having' clause
        - Prevent SQL::Translator::Producer::YAML from seeing the $dbh
          in a potentially connected $schema instance (RT#75394)

    * Misc
        - Fixup our distbuilding process to stop creating world-writable
          tarball contents (implicitly fixes RT#83084)
        - Added strict and warnings tests for all lib and test files

0.08206 2013-02-08
    * Fixes
        - Fix dbh_do() failing to properly reconnect (regression in 0.08205)
        - Extra sanity check of a fresh DBI handle ($dbh). Fixes
          connection coderefs returning garbage (seen in the wild)

    * Misc
        - Only allow known globals in SQL::Translator leak allowance
        - General cleanup of error message texts - quote names/identifiers
          for easier reading
        - Stop t/52leaks.t from failing when AUTOMATED_TESTING=1
   2013-01-26 14:20:11 by Ulrich Habel | Files touched by this commit (2) | Package updated
Log message:
- updated to 0.08205

0.08205 2013-01-22
    * New Features / Changes
        - The emulate_limit() arbitrary limit dialect emulation mechanism is
          now deprecated, and will be removed when DBIx::Class migrates to
        - Support for the source_bind_attributes() storage method has been
          removed after a lengthy deprecation cycle
    * Fixes
        - When performing resultset update/delete only strip condition
          qualifiers - leave the source name alone (RT#80015, RT#78844)
        - Fix incorrect behavior on resultset update/delete invoked on
          composite resultsets (e.g. as_subselect_rs)
        - Fix update/delete operations referencing the updated table failing
          on MySQL, due to its refusal to modify a table being directly
          queried. As a workaround induce in-memory temp-table creation
          (RT#81378, RT#81897)
        - More robust behavior under heavily threaded environments - make
          sure we do not have refaddr reuse in the global storage registry
        - Fix failing test on 5.8 under Win32 (RT#81114)
        - Fix hash-randomization test issues (RT#81638)
        - Disallow erroneous calling of connect_info on a replicated storage
    * Misc
        - Improve the populate docs in ::Schema and ::ResultSet
        - ::Storage::DBI::source_bind_attributes() removed as announced
          on Jan 2011 in 0e773352a

0.08204 2012-11-08
    * New Features / Changes
        - SQLMaker now accepts \'literal' with the 'for' rs attribute as an
          override to the builtin FOR options
    * Fixes
        - Fix unique constraint violations in Ordered.pm blanket movement
          (RT#79773, rolls back short-sighted 5e6fde33e)
        - Fix API mismatch between new_result() and new_related() (originally
          broken by fea3d045)
        - Fix test failure on perl 5.8
    * Misc
        - Much more extensive diagnostics when a new RDBMS/DSN combination is
          encountered (RT#80431)

0.08203 2012-10-18
    * Fixes
        - Really fix inadequate $dbh->ping SQLite implementation (what shipped
          in 0.08201 tickled other deficiencies in DBD::SQLite itself)

0.08202 2012-10-06
    * Fixes
        - Replace inadequate $dbh->ping SQLite implementation with our own,
          fixes RT#78420
   2012-10-03 23:59:10 by Thomas Klausner | Files touched by this commit (2798)
Log message:
Bump all packages that use perl, or depend on a p5-* package, or
are called p5-*.

I hope that's all of them.
   2012-10-02 23:25:56 by Aleksej Saushev | Files touched by this commit (323)
Log message:
Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.
   2012-09-10 15:38:27 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
Updating package for CPAN module DBIx::Class in databases/p5-DBIx-Class
from 0.08196 to 0.08200.

pkgsrc changes:
- update and adjust dependencies

upstream changes:
0.08200 2012-08-24 (UTC)
    * Fixes
        - Change one of the new tests for the previous release to not require

0.08199 2012-08-22 (UTC)
    same as devrel

0.08198_01 2012-07-25 (UTC)
    * Fixes
        - Roll back incomplete (and broken) internal changes - restore prefetch \ 

0.08198 2012-07-11 03:43 (UTC)
    * Fixes
        - Fix a number of Win32 Test issues
        - Fix silent Oracle connection failures

0.08197 2012-07-10 10:32 (UTC)
    * 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
        - 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
        - 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
        - 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)