000

Revision history for Perl extension DBIx::Simple.

Incompatible changes are marked with "!!". Incompatibility with and changes in
"undocumented features" are not always specifically mentioned here.

1.35  Tue Jan 4 23:48 2010
     !! - RaiseError is now enabled by default, as announced three years ago.
          Set PERL_DBIX_SIMPLE_NO_RAISEERROR=1 to get the old behavior.

1.34  Mon Dec 12 16:28 2010
        - Added missing documentation. (Reported by Krassimir Berov.)
        - Fixed off-by-20 mistake in unit tests.

1.33  Sat Dec 4 0:30 2010
        - New license: any(OSI).
        - Documentation overhaul.
        - New: $result->kv_list, $result->kv_array, $result->kv_flat,
          $result->kv_arrays. Handy if the unordered nature of hashes gets in
          the way.
        - New: $result->object, $result->objects.
        - Fixed bug #26924. Cache lookup missed statements at index 0.
          (Reported by Stanis Trendelenburg via RT.)
        - Please note that very probably RaiseError will be enabled by
          default in the next version.

1.32  Mon Sep 17 14:58 2007
        - Test updated to conform to fixed bug in Test::More. See
          http://www.nntp.perl.org/group/perl.qa/2007/09/msg9269.html

1.31  Sun Jul 15 0:29 2007
        - New: $db->iquery. This method loads SQL::Interp on demand. The
          feature was requested by several people. Thanks go out to David
          Manura for writing SQL::Interpolate, and to Mark Stosberg for
          improving it and releasing that as SQL::Interp.

1.30  Sun Apr 8 2:29 2007
        - Fixed bug #18629. Apparently Want does not consider a method call in
          rvalue context. The premature optimization that used Want has simply
          been removed. (Reported by Tomi via RT.)
        - Fixed bug #22829. With connect($dbh) or new($dbh), DBIx::Simple no
          longer disconnects implicitly. (Reported by BORISZ via RT.)

1.29  Web Apr 4 2:22 2007
        - Fixed documentation typo.

1.28  Wed Apr 4 2:16 2007
        - New: $db->result_class. This allows using a custom subclass.
        - $result->flat now returns an array reference in scalar context.
        - Optimized: map (up to 15% faster).
        - The "map" method now really requires exactly two columns.
        - Minor documentation improvements.

1.27  Sun Mar 18 21:14 2007
     !! - Bugfix: (??) was replaced when quoted
     !! - Bugfix: \' escaping was assumed, but actually only MySQL uses that
        - New: support \' escaping only for DBD::mysql
        - New: test suite!
        - Removed dependency on Data::Swap
     !! - Removed compatibility package DBIx::Simple::SQE

1.26  Tue Nov 30 14:25 2004
        - Removed documentation of emulate_subqueries.
        - Minor documentation fixes.

1.25  Mon Jun 21 9:39 2004
        - New: $result->text.
        - This new method can use Anno Siegel's Text::Table (loaded on demand).

1.24  Sun Jun 20 21:32 2004
        - New: $result->xto.
        - New: $result->html.
        - These new methods use Jeffrey Hayes Anderson's DBIx::XHTML_Table
          (loaded on demand).
        - New: $result->text.
        - Documentation =~ s/ESQ/SQE/g. (Reported by Larry Kos)

1.23  Thu Jun 10 0:00 2004
        - New: DBIx::Simple::SQE.
        - New: $db->abstract.
        - New: $db->select.
        - New: $db->insert.
        - New: $db->update.
        - New: $db->delete.
        - These new methods use Nathan Wiger's SQL::Abstract (loaded on demand)
          and are based on a suggestion by simonm (perlmonks.org).
        - Yes, I lied. I said that this module would never get SQL abstraction,
          but this was too easy to add and doesn't hurt anyone who doesn't use
          it.
        - New: $db->begin, an alias for $db->begin_work.
     !! - Removed: $db->emulate_subqueries, $db->esq. (But see
          DBIx::Simple::SQE.)
     !! - Removed: $db->omniholder. (Now a constant: always "(??)".)

1.22  Thu May 6 17:30 2004
        - Changed the declaration of a variable so that it doesn't blow up
          under 5.8.4's better strict. This should also fix a still
          undiscovered bug in the deprecated subquery emulation.
          (Reported and patched by Jos Boumans <irc>)

1.21  Thu Apr 29 14:40 2004
        - Removed two nonsense entries from the changelog. $db->array and
          $db->hash do NOT reuse.

1.20  Tue Apr 27 11:15 2004
        - Almost a complete rewrite :)
        - $db->emulate_subqueries is now deprecated. Use a better database
          engine instead.
        - $db->omniholder is now deprecated. The omniholder will be constant.
        - $db->{success} is now deprecated. Use the return value of $db->query
          instead.
        - $db->{reason} is now deprecated. Use $db->error instead.
     !! - $db->{dbi} has been renamed. Use $db->dbh instead (not $db->{dbh}).
        - DBIx::Simple->error can now be used as a class method.
        - New: $db->last_insert_id.
        - New: $db->keep_statements and statement caching.
        - New: $db->dbh.
     !! - New: $db->lc_columns, enabled by default. Affects $result->columns,
          $result->hash, $result->hashes, and $result->map_hashes.
        - New: $result->columns.
        - New: $result->bind, $result->fetch, $result->into.
        - New: $result->func. (Suggested by Sean McMurray <smcmurray@cpan.org>)
        - New: $result->attr. (Suggested by Sean McMurray <smcmurray@cpan.org>)
        - $result->array now returns a copy instead of the same arrayref over
          and over. If you need maximum efficiency, use $result->fetch instead.
        - Removed dependency on Attribute::Property to fix bugs with
          $db->emulate_subqueries and $db->omniholder in Perl 5.8.x.
     !! - As a result, archaic property assignment style no longer works.
          Instead of "$foo->bar($new_value)", use "$foo->bar = $new_value".
        - Improved error reporting.
        - As a result, DBIx::Simple now depends on Data::Swap.
        - Moved examples to a separate document: DBIx::Simple::Examples.
        - More conditions in DESTROY methods, to handle random destruction
          order during global destruction better.
        - Rebuilt distribution with h2xs to get lib/ and t/.

1.11  Tue Mar 26 19:05 2003
        - Documentation updates.
     !! - list() now returns the *last* element in scalar context (was: first).
        - hashes() and arrays() now return array references in scalar context.
        - Migrated two properties to Attribute::Properties. (new dependency)
        - $VERSION++.

0.10  Thu Jan 9 10:03 2003
        - Documentation rewrite!
        - New: $db->error(). In an upcoming release, $db->{reason} will be
          removed.
        - New: $db->func().
        - Removed some unused variables.
        - prepare() and execute() are now wrapped in eval { } to rewrite
          filename and line number if you use RaiseError
        - $result->map_hashes(), $result->map_arrays() and $result->map() now
          return a list in list context. In scalar context, they still return
          a hash reference
        - Dummy objects in boolean context now evaluate to false, so you can
          write "$db->query(...) or die $db->error;" but still be able to write
          "$db->query(...)->something()".
        - Dummy object's methods now return an empty list in list context
          instead of undef.
        - PrintError now defaults to 0

0.09  Sun Dec 8 5:59 2002
        - $dbh->disconnect() only if the object's still there. This works
          around perl bug #18951. Something is killing objects during (or just
          before) global destruction. This bug was first found by Gerard Oskamp
          <gerard-perl@tuxje.nl>.

0.08  Mon Dec 2 21:16 2002
        - Added $result->finish() method
        - The documentation was wrong: "undef $result" did nothing useful, as
          DBIx::Simple kept a copy internally, for garbage cleaning purposes.
          An in-between class DBIx::Simple::Statement was added to work around
          this.
        - $db->disconnect() now destroys active statements
        - When finish() or disconnect() is used, attempts to use the database
          connection or statement handle now result in a verbose error message.

0.07  Mon Sep 30 7:48 2002
        - Removed TraceLevel thing that caused DBI to output debugging info
        - Very minor documentation update (removed 2 characters)

0.06  Fri Sep 20 10:55 2002
        - Oops: forgot to update the README file; nothing serious

0.05  Thu Sep 19 14:32 2002
        - Added $db->begin_work
        - No longer expanding the (??) omniholder inside quoted SQL
        - Subquery emulation! Have subqueries in MySQL! YAY!
          (Not enabled by default. Use $db->esq(1) to enable)
        - This module now requires Perl >= 5.6

0.04  Tue Sep 17 15:46 2002
        - Documentation updates only

0.03  Thu Jun 13 09:50 2002
        - New: "(??)" and $db->omniholder() (like EZDBI's ??L placeholder)
        - Documentation updates
        - Code updates (now uses $_[0] directly for speed in many methods)
        - $result->list() in scalar context returns first value only

0.02  Sat Mar 30 14:00 2002
        - New: $db->commit() and rollback().
          Suggested by tradez (perlmonks.org)
        - New: $result->map_hashes(), map_arrays(), map().
          Suggested by mattr (perlmonks.org)
        - New: $result->flat(), a plural form of list()

0.01  Thu Mar 28 18:04 2002
        - Initial CPAN release