Revision history for Dancer-Plugin-Database

2.10    2014-10-13
        [ ENHANCEMENTS ]
        - Support dsn_extra option (Thanks to Michael J South)

2.09    2013-12-22
        [ ENHANCEMENTS ]
        - Tests for cached handle after reconnection

2.08    Sun Sep  1 13:52:52 WEST 2013
        [ ENHANCEMENTS ]
        - Add quick_count method (Thanks to Colin Ewen)

2.07    Tue Jul 30 18:59:30 WEST 2013
        - Fix test with wrong base class (part 2)

2.06    Tue Jul 30 18:49:37 WEST 2013
        - Fix test with wrong base class.

2.05    2013-07-29
	- Remove code from module to share with Dancer2 plugin.
        - Added dependency on Dancer::Plugin::Database::Core

2.04    2013-03-04
        [ ENHANCEMENTS ]
        - Allow 'sid' to be passed into DSN, for Oracle support.

2.03    2012-12-14
        [ BUGFIX ]
        - Remove left-over debugging warning (thanks to ofosos for reporting)

2.02    2012-12-07
        [ ENHANCEMENTS ]
        - If asked for default connection (no connection name given) but there
          is no default connection configured, throw a more helpful error
          message.

2.01    2012-09-18
        [ BUGFIX ]
        - Fix crashing bug when charset: UTF-8 is present - thanks to Hugh
          Gallagher for reporting & providing fix in RT #79719.
          Presumably the test suite doesn't set UTF-8, so this failure never
          showed up in testing :(

2.00    2012-09-17
        [ ENHANCEMENTS ]
        - Support for Dancer 2
        - Automatic quoting handles e.g. schema.table properly - GH #33,
          thanks to mscolly for reporting
        - Accept limit offset,count syntax too - GH #31, thanks to nicolasfranck
          for reporting
        - a value of 0 for connectivity_check_threshold now disables checking
          entirely - thanks to knutov in GH #22

1.82    2012-06-28
        [ BUGFIXES ]
        - Fix for Debian RT #665221 :
        http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=665221 - avoid issues
        if we get a hashref of settings occupying the same region of memory as a
        previous hashref of settings which since went out of scope but which we
        still have a handle laying around for.

1.81    2012-03-07
        [ BUGFIXES ]
        - Don't generate invalid SQL with certain uses of where and order_by
          clauses together (PR-27, thanks to Michael Stapelberg (mstap))

1.80    2012-02-06
        [ ENHANCEMENTS]
        - New hooks 'database_error', 'database_connect_failed',
          'database_connection_lost'
        - New option 'handle_class' to allow the database handles to be
          reblessed into an alternative class, allowing you to subclass
          D::P::D::Handle if you want to extend it
        All requested by Nick S. Knutov - thanks Nick!

1.70    2012-01-31
        [ ENHANCEMENTS ]
        - New `order_by`, `limit` and `columns` options for quick_select()
          (Requested by bor in GH-20)

1.60    2011-12-29
        [ ENHANCEMENTS ]
        - Hook support, requested by mdom.  Currently supports a
          database_connected hook position; others may be added in future.

        Happy New Year!

1.51    2011-11-17
        [ BUGFIXES ]
        - Handle "is" operator properly (particularly if negated) - Issue 15.
        - Add =encoding utf8 to POD so contributor names render correctly on
          search.cpan.org / metacpan.org

1.50    2011-10-18
        All new features kindly contributed by Mark Allen (@mrallen1) - thanks!
        - Much more flexible WHERE clauses - e.g.  { foo => { like => 'bar'} }
        - Ability to select only specific columns in quick_select()
        - New quick_lookup() syntactic sugar method

1.42    2011-08-19
        - Don't produce spurious messages about enabling UTF-8 support when
          we have already done it (PR 9 from James Aitken (LoonyPandora))

1.41    2011-07-24
        - support where clauses with undef values. (Alberto Simões)

1.40    2011-05-29
        - Be fork/thread-safe - don't allow processes/threads to share handles.
          Thanks to Matt S Trout for pointing this out on IRC - cheers mst.
        - If we're given a pre-assembled DSN, extract the driver from it to
          avoid a warning, and to allow auto UTF-8 to work.
          Thanks to Matthew Vickers (mvickers) for bringing this up.

1.30    2011-05-23
        - Allow passing an empty hashref for where clause to signify that no
          where clause is desired (i.e. return all rows).
          Requested by Carlos Sosa (gnusosa) - thanks!

1.24    2011-05-09
        - Bugfixes in logging - avoid DBI swallowing up the param I'd wrongly
          named, and avoid warnings if any params are undef.
          Thanks to Martin J Evans (mje) for bringing this up on IRC - thanks
          for your help Martin.

1.23    2011-04-15
        - Only log queries generated by quick_*() helpers in D::P::D::Handle if
          the log_queries setting was enabled in the configuration.  This avoids
          the potential for the user to be unwittingly logging sensitive
          information, and would provide a (tiny) performance boost too.

1.22    2011-04-11
        - Bugfix: don't needlessly use to_json() in tests, as Dancer doesn't
          depend on JSON.pm, so tests will fail if it's not available.
          Reported in RT #66204 by Johnathan (JAWNSY) - thanks!

1.21    2011-03-06
        - Bugfix: return undef if connection fails, rather than attempting to
          re-bless and blowing up. Fixes GH-7, thanks to Nick Hibma

1.20    2011-02-23
        - New feature - automatically enable UTF-8 support if the app's charset
          setting is set to 'UTF-8' and we know how to enable UTF-8 support for
          the database driver in use.  This can be disabled with the new
          auto_utf8 setting in the plugin's config.
        - Bugfix - create test DB in memory, not a file named ":memory" by
          accident.  This should fix test failures on Windows, e.g.:
          http://www.cpantesters.org/cpan/report/d5987aa6-6d07-1014-91a2-7f5be4275be9


1.11    2011-02-18
        - Fix bug RT #65825 - quick_select didn't actually use the where clause
          correctly.
        - Extended test suite.
        
1.10    2011-02-11
        - New feature quick_select
        - Fix bug RT #65651, quick_insert generating SQL which MySQL/Postgres
          didn't accept due to use of quote() rather than quote_identifier(),
          thanks to Christian Sánchez and Michael Stiller
        - Fix GH #5 - named connections not working properly - thanks to
          "crayon"

1.00    2011-01-10
        - Bumping to 1.00 to signify being ready for production use, for users
          who have a mistrust of 0.x version numbers.
        - Applied Alan Haggai's changes to allow a hashref of settings to be
          passed to the database() keyword at runtime.  Thanks Alan!
          (This was released as 0.91_01 for testing first.)

0.91    2010-12-21
        - Whoah - didn't "use strict" in Dancer::Plugin::Database::Handle!
          Last tweak release, then I'll push 1.00 out soon.

0.90    2010-12-10
        - New features quick_insert, quick_update, quick_delete.  The database
          keyword now returns a Dancer::Plugin::Database::Handle object, which
          is a subclass of DBI::db so does everything you'd expect a DBI
          connection handle to do, but adds extra convenience methods.
        - Fixed test failures on Windows systems.

       (Large version bump due to new features; assuming there are no reports of
       issues with this version (there shouldn't be!), I'll release 1.0 soon,
       for those who look for a >= 1.0 version number as an indication of being
       production-ready.


0.12    2010-12-03
        - Documentation mentioned connectivity-check-threshold instead of the
          correct connection_check_threshold.  Thanks to bessarabov for catching
          this and submitting corrections via GitHub!

0.11    2010-11-09 (CoD Black Ops day!)
        - Bugfix: pass connection settings when reconnecting, too.

0.10    2010-10-30
        - Add some proper tests [Franck Cuny]

0.09    2010-09-28
        - Allow definition of multiple connections, and accept a param to the
          database() keyword to specify which connection you need a handle for.
          This was released as 0.08_01 for testing.

0.08    2010-09-14
        - Bugfix - make SQLite DWIMmery from previous version actually work.

0.07    2010-09-06
        - Extra params in DSN (database, host, port) should be separated with
          semi-colons, not colons.  Thanks to Steve Atkins for reporting this.
        - Documentation update to reflect use of $dbh->ping
        - If connecting to SQLite, which requires 'dbname' rather than
          'database', provide 'dbname' instead, so it will Just Work

0.06    2010-06-15
        - Stupid typo fix in documentation for features added in 0.05.  I wish
          I'd spotted this mistake before releasing 0.05, rather than just
          after!

0.05    2010-06-15
        - Allow parameters to be passed to DBI->connect call (e.g. RaiseError),
          and support providing a set of statements to execute upon connection.
          Thanks to Igor Bujna for providing this feature!

0.04    2010-05-20
        - If DBD driver does not implement ping(), perform our own connection
          check by performing a simple query.  This will check that the DB
          connection is still alive, and avoid needless re-connects, which are
          expensive.  Also seems to fix a problem Tadzik saw with a warning from
          DBD::SQLite when the old handle was thrown away.

0.03    2010-05-17
        - Fix warning where $last_connection_check was initially undefined but
          used in numeric comparison.  Thanks to Tadzik for reporting.

0.02    2010-04-18
        Documentation fixes, thanks to "mrpants" on Github:
        - Plugin names in config.yml are case-sensitive for current CPAN
          releases of Dancer; my commit fdc3f3 makes it case-insenitive, but
          that hasn't hit CPAN yet, so people using CPAN releases could be
          confused
        - stray trailing single-quote in example config

0.01    2010-04-14
        Initial version developed.