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
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
|
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.37 2017-12-08 23:49
- POD syntax fix
1.36 2017-12-08 21:23
- $result->object and $result->objects now load any module on demand.
(Suggested by Krasimir Berov.)
- New: $result->group, $result->group_hashes, $result->group_arrays.
(Suggested by Mark Overmeer.)
- Fixed typo in 1.35 release date below. (Reported by Sjors Gielen.)
- Changed changelog date format from insane to ISO 8601-ish.
1.35 2011-01-04 23:48
!! - 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 2010-12-12 16:28
- Added missing documentation. (Reported by Krasimir Berov.)
- Fixed off-by-20 mistake in unit tests.
1.33 2010-12-04 00:30
- 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 2007-07-17 14:58
- 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 2007-07-15 00:29
- 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 2007-04-08 02:29
- 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 2007-04-04 02:22
- Fixed documentation typo.
1.28 2007-04-04 02:16
- 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 2007-0318 21:14
!! - 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 2004-11-30 14:25
- Removed documentation of emulate_subqueries.
- Minor documentation fixes.
1.25 2004-06-21 09:39
- New: $result->text.
- This new method can use Anno Siegel's Text::Table (loaded on demand).
1.24 2004-06-20 21:32
- 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 2004-06-10 00:00
- 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 2004-05-06 17:30
- 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 2004-04-29 14:40
- Removed two nonsense entries from the changelog. $db->array and
$db->hash do NOT reuse.
1.20 2004-04-27 11:15
- 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 2003-03-26 19:05
- 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 2003-01-09 10:03
- 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 2002-12-08 05:59
- $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 2002-12-02 21:16
- 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 2002-09-30 07:48
- Removed TraceLevel thing that caused DBI to output debugging info
- Very minor documentation update (removed 2 characters)
0.06 2002-09-20 10:55
- Oops: forgot to update the README file; nothing serious
0.05 2002-09-19 14:32
- 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 2002-09-17 15:46
- Documentation updates only
0.03 2002-06-13 09:50
- 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 2002-03-30 14:00
- 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 2002-03-28 18:04
- Initial CPAN release
|
