Revision history for Dancer-Plugin-Database
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.