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 ) 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 ) - New: $result->attr. (Suggested by Sean McMurray ) - $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 . 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