forked from bigpresh/Dancer-Plugin-Database
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Changes
159 lines (127 loc) · 7 KB
/
Changes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
Revision history for Dancer-Plugin-Database
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.