-
Notifications
You must be signed in to change notification settings - Fork 14
/
Changes
252 lines (220 loc) · 11.9 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
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
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
{{$NEXT}}
0.23 2024-10-23T04:39:20Z
- Introduce as_escape method to D::OD::SQL to allow specifying escape clause #45
0.22 2023-02-01T05:14:13Z
- Clear %Handle cache if dbh is set to undef #42
- Skip fork test on win32 #41
0.21 2020-10-29T05:54:05Z
- Add GitHub Actions #38
- Support DBD::MariaDB #39
- Fork safety #40
0.20 2020-09-14T12:15:54Z
- Fix tests (Thanks to eseyman) #36
- Change license (Thanks to kentfredric) #34
0.19 2020-03-03T15:13:37Z
- Parallel testing #33
0.18 2019-07-09T08:10:31Z
- add_complex_where can not handle some case of nested group (usualoma) #30
0.17 2019-03-12T04:24:20Z
- Bump version
0.16 2019-03-07T07:07:14Z
- Avoid SQL syntax error: column IN () (charsbar) #26
- Add disconnect method explicitly to pass tests for windows (twata1) #25
0.15 2017-04-19T01:41:02Z
- Fix failed tests with Perl 5.25.11 (miniuchi) #24
0.14 2016-01-14T03:03:02Z
- Fix test for SQLite 3.10 compatibility (ziguzagu) #21
0.13 2015-05-20T02:26:46Z
- Fix 0.12 changes with braking inserting new records (masiuchi) #20
0.12 2015-05-18T05:33:33Z
- Fix broken $sth at inserting new records (masiuchi) #19
0.11 2015-03-28T10:04:24Z
- Fix test (ambs) #16
- Migrate to Minilla (ziguzagu) #17
- Pass the whole args to fallback driver. (Akira Sawada) #18
- Remove a joined table from the "FROM" phrase for fix error on MySQL. (usualoma) #7
0.10 2015.01.14
- Document spelling corrections (dsteinbrunner) #8 #9 #10 #11 #12 #13 #14
0.10_1 2015.01.14
- Fix test (ambs) #16
0.09 2011.03.17
- Fix reuse_dbh behaviour when ping fails on driver->dbh (RT 65448)
0.08 2010.12.06
- Fixed issue where a profiler cannot be returned if $@ is set
https://github.com/sixapart/data-objectdriver/pull/1 (Akira Sawada)
- Adds a new restricted IO operation mode controlled by the
$Data::ObjectDriver::RESTRICT_IO flag (Brad Whitaker)
0.07 2010.03.22
- When an object is changed, delete the cache instead of updating it.
It is a bit more expensive, but should safer.
- Fixed a uuv warning thanks to Kazuhiro Shibuya
- Fixed a issue in the test suite for newer version of SQLite
reported by Emmanuel Seyman
http://rt.cpan.org/Ticket/Display.html?id=45186
- Fixed boggus bulk_insert() in the MySQL driver
- Fixed a perl5.11 warning
- In case you haven't noticed DOD is now on github, bye svn.
0.06 2009.01.28
- Added peek_next() method to ResultSet, q.v.
- Localized creation of D::OD::Iterator object. Thanks to Hirotaka Ogawa
for the patch.
- Fixed compilation error with Perl 5.10. Thanks to smpeters for the patch.
- Added a new $object->uncache_object as a mirror of cache_object(), which
purge one object from the cache layer, for the cases where you want a
manual control over it.
- Added a "distinct" method to D::OD::SQL that forces the DISTINCT keyword
in the generated SQL statement. Thanks to John Berthels for the patch.
- Added a "window_size" argument for the search() method of the caching
layer to constrain the number of objects loaded from the database for
large or unbounded searches.
- Added a "comment" argument to search parameter allowing the SQL
queries to be watermarked with SQL comments.
- Added a "object_is_stored" method on DOD objects, which returns true until
the object has been saved in the persistent store.
- Added a "pk_str" method on base objects has a nice shortcut for printing
the primary key of an object.
- Added a "reuse_dbh" option to D::OD::D::DBI, if enabled it caches and reuses
$dbh using the dsn as the key.
- Exposed the transaction mechanism built in the drivers at the object levels:
D::OD::BO->begin_work now starts a global transaction across all drivers
ending with a rollback or a commit on the same class.
- Fix problem with prepare_cache in DBD::SQLite
- Fix PerlCritic tests
http://rt.cpan.org/Ticket/Display.html?id=37197
- Fix problems under 5.10
http://rt.cpan.org/Ticket/Display.html?id=30941
- Fix test failures under Win32
http://rt.cpan.org/Ticket/Display.html?id=24480
- Pg *can't* handle REPLACE
https://rt.cpan.org/Ticket/Display.html?id=38840
- Fixed an issue where Pg would look into the wrong sequence if DBI has a
'prefix' configured (used in a undocumented TheSchwartz feature)
https://rt.cpan.org/Ticket/Display.html?id=41880
- Added Oracle support, courtesy of Xiaoou Wu (Oracle)
https://rt.cpan.org/Ticket/Display.html?id=41929
- Added an "add_index_hint" method to D::OD::SQL to allow specifying
a "USE INDEX" hint.
- Added an experimental GearmanDBI driver that provides query coalescing
using Gearman workers (to sit in front of a direct DBI driver).
0.05 2008.02.24
- Added a new Data::ObjectDriver::ResultSet abstraction for building
result sets with lazy-loading of the actual results. This allows for
passing around a representation of a full result set (no limit, no
offset, etc), and allowing callers to modify the set as needed.
- search() now returns a subref blessed into the new D::OD::Iterator class.
It's backwards-compatible (you can still call $iter->()), but it now
supports $iter->next() as well.
- Added a D::OD::SQL::add_complex_where method, for creating more complex
WHERE clauses with boolean operations.
- Added instrumentation/profiling for the memcached, Apache, and RAM
caching drivers.
- Improved "remove" support in the experimental Multiplexer driver.
- Fixed an ordering bug with BaseCache->update: the cache is now updated
after the fallback (a persistent store, usually) is updated, to prevent
the cache being updated but the backend erroring out.
- Let DSNs start with "DBI:" instead of only "dbi:"
- Fix a bug where the iterator version of search() (search() called
in scalar context) wasn't calling finish() on $sth. It was generating
warnings on certain circumstances.
- Fixed a circular reference when using has_a.
0.04 2007.05.02
- Fixed a bug where single-PK classes were not returning the
objects correctly sorted during a lookup_multi.
- Added support for MySQL 'REPLACE INTO' syntax with a new
$obj->replace() method.
- Added a new trigger 'post_inflate'.
- Fixed a minor issue (warning) with no_changed_flags in column_func()
- Added has_a() construct to build linking methods between classes.
- remove() returns number of affected rows, with DBI semantics.
- Bulk inserting of data can now be done with the new bulk_insert()
Class method. It uses Postgres' COPY command or MySQL's
multi-value inserts to load data quickly.
- The new() constructor for objects now accepts column name/value
pairs which are passed to a new init() method.
- The new init() method can be called on any object to set
many parameters in one call.
- This init() method can also be overridden, allowing for custom
initialization code.
- Added parens around terms within complex SQL conditionals, to allow
even more complex conditions to be created.
- Made the second argument to D::OD::SQL::add_select optional. It defaults
to the value of the first argument (the column name).
- Pass along $orig_obj (original object) when calling post_save/post_update
triggers, even when the object hasn't changed.
- A non-numeric value in a LIMIT now causes an exception.
- Fixed a bug where calling SQL->add_join twice would create an invalid
SQL statement.
- More documentation!
- Added more DOD::DBD::* options: sql_for_unixtime, can_delete_with_limit,
is_case_insensitive, can_replace, sql_class.
- Added an experimental Multiplexer class to direct writes to multiple
backend drivers.
- Added a generic end_query method, analogous to start_query, which is
called after each query. Useful for profiling etc.
- Text::SimpleTable is now loaded dynamically so that it's no longer
a requirement for D::OD.
0.03 2006.08.05
- Added an inflate and deflate mechanism to memcached caching. When objects
are stored in memcached, they are now deflated to a hash reference
containing only the column values; retrieving the object from memcached
automatically inflates the object to the full representation. Classes
can override inflate and deflate to store additional information in the
memcached representation that's kept automatically up-to-date.
- Added a SimplePartition driver, which helps to make partitioning, well,
simpler. Still to come: documentation and a tutorial on partitioning.
- Many, many bug fixes and improvements to the caching drivers.
- Added detection of changed columns, such that only columns that have
been changed are updated in an UPDATE statement.
- Added a clear_cache method to the D::O::D::Cache::RAM class.
- Added cross-DBD error handling, which maps local error codes to error
constants in Data::ObjectDriver::Errors. The list of supported errors
is pretty miniscule thus far (just one), but will be expanded as needed.
- Added support for query profiling (Data::ObjectDriver::Profiler), which
counts queries, calculates frequent queries, and can produce reports.
- Added support for optional table prefixes, which simplifies setting up
identical schemas in the same database.
- Added an optional $terms argument to D::O::D::DBI->update, which can
add additional terms to the UPDATE statement besides just the PK.
- Added a D::O::D::DBI->begin_work method, and improved the commit and
rollback methods.
- Added a D::O::D::DBI->last_error method.
- Added support for multiple JOIN clauses with a new D::O::D::SQL->add_join
method.
- Multiple OR values are now contained in an IN (...) clause rather than
many joined OR clauses.
- Added a for_update option to search, which allows constructing a
SELECT ... FOR UPDATE query.
- D::O::D::BaseObject->column is now removed and replaced with a
column_func method, which returns a subroutine reference used to
initialize the dynamically-created methods for each column. This allows
some optimizations.
0.02 2006.02.21
- Added Data::ObjectDriver::BaseView, a base class for creating "views"
across multiple tables, or involving more complex aggregate queries.
- Added trigger/callback support for common operations. See the
Data::ObjectDriver documentation for more details.
- Added GROUP BY support in Data::ObjectDriver::SQL.
- Data::ObjectDriver::BaseCache->search now uses lookup_multi to do a
very fast PK lookup, which will hit the cache first before the
backend DB.
- Fixed bugs with BLOB columns in SQLite driver.
- Added connect_options option to Data::ObjectDriver::Driver::DBI, for
passing in custom options for a DBI->connect call.
- Data::ObjectDriver::BaseObject->remove now works as a class method.
- Added Data::ObjectDriver::BaseObject->primary_key_tuple for retrieving
the primary key value(s) for an object.
- Added Data::ObjectDriver::BaseObject->refresh to reload an object from
the database.
- Added support for HAVING clauses in Data::ObjectDriver::SQL. For views
that are not attached to a particular datasource, any terms passed in
to the query will automatically be turned into HAVING clauses.
- Improved the lookup_multi method for all BaseCache subclasses: we now
allow the subclass to look up multiple values in the cache and return
any already-cached items, then make a list of the remaining IDs and
send them to fallback->lookup_multi.
- Driver::DBI->lookup_multi will now use an OR clause to look up
multiple values in one query.
- Added lots of test cases.
- Pod fix (Thanks to Koichi Taniguchi)
0.01 2005.09.23
- Initial distribution.