bump $VERSION
[dbsrgits/DBIx-Class-Schema-Loader.git] / Changes
CommitLineData
af6c2665 1Revision history for Perl extension DBIx::Class::Schema::Loader
a78e3fed 2
7640ef4b 3 - better type info for DB2
d2df9c9b 4 - fix some newly-introduced test bugs
7640ef4b 5
b1d11550 60.07000 2010-05-22 23:40:15
7 - added qualify_objects option to prepend db_schema to table names
1b3e8f7a 8 - fix for negative numeric default values
5cd600fa 9 - sequence is detected for Oracle
10 - fix for SQLite is_auto_increment detection when table is empty (hobbs)
b511f36e 11 - rescan now reloads all tables
8c41c3ce 12 - minor type info improvements for all DBs
33aa3462 13 - fix erroneous default_value for MySQL NOT NULL columns (RT#57225)
6818ce9f 14 - remove is_deferrable => 1 from default for belongs_to rels
760fd65c 15 - better type info for Oracle
bc5afe55 16 - preliminary Informix support
0c1d5b47 17 - unregister dropped sources on rescan
b511f36e 18 - added 'preserve_case' option with support for all DBs where it makes
19 sense; removed the MSSQL 'case_sensitive_collation' and the
20 Firebird/InterBase 'unquoted_ddl' options in favor of it.
bc1cb85e 21 - support CamelCase table names and column names (in case-preserving
22 mode) at the v7 naming level
69219349 23 - rewrite datetime default functions as \'current_timestamp' where
8a64178e 24 possible (except for Sybase ASE) to ease cross-deployment
4337bddf 25 - use column_info instead of select to get Oracle column list (RT#42281)
be72dba7 26 - match quotes in MySQL parser in more places (RT#42101)
ae32aaf6 27 - fix unique detection in DB2 for multiple schemas (RT#39622)
9fdf3d5b 28 - fix column name collisions with methods (RT#49443)
3de915bc 29 - fix loading MySQL views on older MySQL versions (RT#47399)
30
5afd3e72 310.06001 2010-04-10 01:31:12
81ade4d9 32 - fix type info for MSSQL
103e90da 33 - fix MSSQL collation detection on freetds tds version 8.0
34
231688f8 350.06000 2010-04-06 01:12:25
26334ec1 36 - better type info for MySQL
37 - initial MySQL data type tests (jhannah)
2a8e93e9 38 - don't set result_namespace if it's 'Result'
9dc968df 39 - support for MSSQL databases with case sensitive collation, manually
40 overridable with 'case_sensitive_collation' option
71a6e88a 41 - do not try to detect driver and rebless when used with a custom
9dc968df 42 'loader_class'
bfb43060 43 - suppress 'bad table or view' warnings for filtered tables/views
27305cc1 44 - croak if several tables reduce to an identical moniker (ribasushi)
05f25b42 45 - better type info for Sybase ASE
df956aad 46 - better type info for Pg: sets sequence for serials, handles numerics
47 without precision
acfcc1fb 48 - better _tables_list for MSSQL
26da4cc3 49 - pick up views in SQLite too
50 - better rel inflection using Lingua::EN::Inflect::Phrase
53ef681d 51 - cascade_delete and cascade_copy are turned off for has_many/might_have
ee07e280 52 by default, and belongs_to has on_delete => 'CASCADE', on_update =>
53 'CASCADE' and is_deferrable => 1 by default, overridable via
54 relationship_attrs
55 - added config_file option for loading loader options from a file
0faae4b8 56 - set inflate_datetime => 1 for 'AS getdate()' computed columns in
57 Sybase
cf0ba25b 58 - Firebird support
829f17e3 59 - use introspection pragmas instead of regexes to introspect SQLite
60 (hobbs)
f170d55b 61 - generate POD for refs correctly from column_info
9dc968df 62 - fix tables list, fk introspection and type info for SQL Anywhere
05c54730 63
e42ec4ef 640.05003 2010-02-20 05:19:51
d8cbfbb8 65 - support for custom_column_info, datetime_timezone and datetime_locale
66 (rbo)
9fd0726a 67 - improve parsing of SQLite tables when a column definition
68 spans multiple lines (hobbs)
db36a574 69 - fix missing trailing _id stripping for some relationship
70 names (rbuels)
0547c283 71 - fixed accessor POD bug, was not dereferencing scalar refs
72 before printing (rbuels)
db36a574 73
83b38372 740.05002 2010-02-15 10:17:47
8793567f 75 - support for SQLAnywhere via DBD::SQLAnywhere and ODBC
83b38372 76 - fix picking up quoted tables for SQLite (RT#54538) patch from schwern
2a5dcfb3 77 - validate class/component loader_options to make sure classes
83b38372 78 are available before generating the schema, patch from bphillips
2a5dcfb3 79
dc767cd3 800.05001 2010-02-05 14:29:27
41968729 81 - correct default_value for all backends with common tests
82 - fix bug with quoted Pg tables from $dbh->tables (RT#54338)
83 - add inflate_datetime => 0 to 'timestamp' types for Sybase
84
ca7feebf 850.05000 2010-02-01 09:24:24
f730e1b6 86 - better data_type, default_value and size for Sybase
492dce8d 87 - added 'generate_pod' option, defaults to on
43b982ea 88 - added 'pod_comment_mode' and 'pod_comment_spillover_length' to
89 control table comment generation (waawaamilk)
492dce8d 90
04e60ed2 910.04999_14 2010-01-14 06:47:07
540a8149 92 - use_namespaces now default, with upgrade/downgrade support
805dbe0a 93 - filter out un-selectable tables/views
d4d1a665 94 - fix NUMERIC/DECIMAL size column_info for postgres
59f54738 95 - now mentions skip_load_external feature in comments (jhannah)
96 - moniker_map POD correction (jhannah)
d4d1a665 97
1fa18849 980.04999_13 2010-01-03 12:32:25
afb4c5bc 99 - exclude 'size' column_info for postgres when unnecessary, and
100 use the correct precision for varying types (except NUMERIC)
30a4c064 101 - 'naming' attribute and backward compatibility with 0.04006
7b505bbd 102 - added relationship_attrs option for setting attributes in
103 generated relationships
72cd9295 104 - added overwrite_modifications option that ignores md5sums on
105 generated code
33fb8fa0 106 - added skip_load_external (jhannah)
1fa18849 107 - remove Class::Data::Accessor and Class::Accessor::Fast and switch
33fb8fa0 108 everything to Class::Accessor::Grouped (jhannah)
46065bcb 109 - better handling of db_schema for Oracle, based on (RT#35732)
110
0a701ff3 1110.04999_12 2009-11-30 23:36:14
309e2aa1 112 - fix MySQL rel introspection with on_connect_call =>
113 'set_strict_mode' (RT#52087)
114 - now using base 'DBIx::Class::Core' for Results (RT#52141)
115
a06118a6 1160.04999_11 2009-11-29 18:08:46
fbcfebdd 117 - added patch to generate POD from postgres by Andrey Kostenko (GUGU)
4daef04f 118 - added test for norewrite feature
5c6fb0a1 119 - fix default_value for MSSQL
120
b1ad1a84 1210.04999_10 2009-10-31 12:28:53
8803e4ed 122 - patch from Robert Bohne to make _table_uniq_info more correct for
123 Oracle
b1ad1a84 124 - fix data_type for identity columns with MSSQL
8803e4ed 125
c25ff208 1260.04999_09 2009-10-08
79193756 127 - Only redump the files when something has actually changed
b4dcbcc5 128 - Place a warning at the top of the files saying 'do not modify' to
129 match the one at the bottom of the auto-gen'd section
79193756 130
c25ff208 1310.04999_08 2009-08-28
6ae3f335 132 - Replace UNIVERSAL::require with Class::C3::Componentised
3f4461a5 133 - Add Sybase/MSSQL support through DBD::Sybase
1bcb47d3 134 - use $dbh->get_info(29/41) for qote_car/name_sep if available (semifor)
bfe03a54 135 - add MSSQL support through DBD::ODBC
1bcb47d3 136 - support MSSQL table names with a '.' in the name
137 - support MySQL CURRENT_TIMESTAMP()
6ae3f335 138
c25ff208 1390.04999_07 2009-04-18
a28b70f1 140 - Add result_base_class and schema_base_class options (RT #43977)
d70c335f 141 - Ignore duplicate uniq indices (including duplicates of the PK).
632cb26f 142 - Fix for DBD::SQLite 1.20
706ef173 143 - Fix for DBIx::Class 0.08100
76c488a6 144
c25ff208 1450.04999_06 Tue Nov 11, 2008
22270947 146 - Singularise table monikers by default
e7886624 147 - Strip trailing _id from single-column belongs_to relationships
ff746964 148 - Add "dbicdump" script for easy commandline dumping
af31090c 149 - Throw out the in-memory class generation, just dump to a temporary
150 directory if the user didn't specify one
c7bf4194 151 - Fix Oracle constraint and auto-increment detection for non-owned schemas
152 (RT #35732)
c25ff208 153 - Handle ResultSetManager deprecation warning in common tests
22270947 154
c25ff208 1550.04999_05 Mon Apr 14, 2008
072d5aae 156 - Fix limiting table list to the specified schema for DB2
7a930e63 157 - Default db_schema to the username for DB2
29ddb54c 158 - Allow specifying a custom loader_class, overriding the
159 storage_type-based detection
565ca24d 160 - Cosmetic fixes to dumping of externally defined classes
2a620a1b 161 - Make ResultSetManager notice externally defined :ResultSet methods
2328d1fc 162 - Fix test failure for non-InnoDB MySQL due to wrong skip count
390bbe3f 163 - Fix base class ordering in dumped classes
164 - Run the common tests against both dynamic and dumped versions of
165 the schema
072d5aae 166
c25ff208 1670.04999_04 Wed Mar 12, 2008
772cfe65 168 - Add is_auto_increment detecton for DB2
169
c25ff208 1700.04999_03 Wed Mar 12, 2008
28357fd3 171 - Fix DB2 support
172
c25ff208 1730.04999_02 Tue Feb 12, 2008
fb328d1a 174 - Add is_auto_increment detection for Oracle
d87d939a 175 - Unnhide the Oracle module now that the CPAN perms are sorted
176 out. Thanks to Tsunoda Kazuya for the quick response.
fb328d1a 177
c25ff208 1780.04999_01 Tue Feb 5, 2008
e7213f4f 179 - Mark foreign key columns with is_foreign_key => 1
c5baf131 180 - Add support for vendor-specific extra column attributes.
8fdd52a2 181 - Add support for extra => { unsigned => 1 } for MySQL.
46bef65f 182 - Add support for enum value lists for MySQL
7dba7c70 183 - Set join_type => 'LEFT OUTER' for nullable foreign keys
184 (patch from Bernhard Weißhuhn)
78b7ccaa 185 - Set is_auto_increment for auto-increment columns (RT #31473)
186 (Only SQLite, MySQL and PostgreSQL are currently supported)
af99957c 187 - Generate one-to-one accessors for unique foreign keys (ilmari)
a1726271 188 - Add support for load_namespaces-style class layout
45f3698a 189 - Fix test skip count for main skip_rels block
a1726271 190 - Fix auto-inc column creation for the Oracle tests
75a0d986 191 - Fix column ordering in unique constraints for Oracle
2ffd6b4c 192 - Fix Win32 test skip counts for good (RT #30568, Kenichi Ishigaki)
d0e184e9 193 - Default Oracle db_schema to db username (patch
194 from Johannes Plunien)
af99957c 195
c25ff208 1960.04003 Wed Oct 4, 2007
f1f25439 197 - Prevent users from running Kwalitee test automatically
9616156f 198 - Fix extra whitespace being added to output on
199 regeneration (from ilmari)
200
c25ff208 2010.04002 Tue Jul 24, 2007
c39e3507 202 - rescan method now returns the actual list of new tables
203 loaded (previously, the return value wasn't taking
204 constraint/exclude into account, even though the meat
205 of the operation was).
206 - Hid the Oracle module so that search.cpan.org will stop
207 ignoring this package, temporary fix until perms are
208 sorted out
1c1efbce 209 - Fix Win32 test skip counts (RT #27715, Alexandr Ciornii)
210 - Fix a small output quoting bug (RT #28073, Tokuhiro Matsuno)
09c19d42 211
c25ff208 2120.04001 Tue Jun 26, 2007
28b4691d 213 - Deprecated dump_overwrite. The changed behavior from
214 0.03xxx was confusing.
215 - Added new option really_erase_my_files, which does what
216 dump_overwrite did in 0.04000, which is not what it did
217 in 0.03xxx.
218
c25ff208 2190.04000 Thu Jun 7, 2007
7507c8ce 220 - Added some env vars for controlling the Makefile.PL feature
221 questions, to make automation easier.
222
c25ff208 2230.03999_02 Tue May 22, 2007
3fe9c5d9 224 - Converted to Module::Install
225
c25ff208 2260.03012 Tue May 22, 2007
0c0a7757 227 - Relationship names for multiple multi-col rels between
228 the same table fixed by ilmari
229 - Fix from Marc Espie for CREATE TABLE 'foo' for SQLite
522ee84e 230 - skip ^sqlite_ tables in SQLite (thanks chromatic)
231
c25ff208 2320.03999_01 Sat Apr 14 19:57:40 GMT 2007
e7262300 233 - Added *experimental* Oracle support from work done
234 by Tsunoda Kazuya some months ago. Not well tested.
7fa9a8b1 235 - Added "rescan" schema (and loader) method, which picks
236 up newly created tables at runtime
7cab3ab7 237 - Made dump_to_dir / dump_overwrite much more intelligent
238 (they now preserve customizations by default)
fd589700 239 - Added support for DBI's new standard "statistics_info"
240 method to gather unique key info (only supported by
79fe0081 241 DBD::Pg trunk afaik)
12af3806 242 - columns_info_for imported from DBIx::Class
243 - relationships are now on by default, use skip_relationships
244 to disable them
245 - Removed previously deprecated methods/options
32f784fc 246 - Added $VERSION to all packages in this dist
247
c25ff208 2480.03011 Sat Apr 14 19:03:07 UTC 2007
050003c5 249 - fix case-sensitivity in UNIQUE parsing for SQLite
250
c25ff208 2510.03010 Thu Mar 29 12:36:19 UTC 2007
518472fa 252 - Workaround for new incompatible changes in DBD::mysql's "tables"
253 method, which was causing us to find no tables w/ DBD::mysql
254 4.002+
a0cc2498 255 - Fixed quoting problem in _table_columns (could cause crash when
256 dumping/doing a static create) (from ash)
257
c25ff208 2580.03009 Wed Nov 15 14:03:37 UTC 2006
a0cc2498 259 - fix for rt.cpan.org #22425 (use File::Spec where appropriate)
260 - use full instead of short classnames in relationships (from victori)
01de2418 261
c25ff208 2620.03008 Fri Oct 20 18:08:20 UTC 2006
88603c41 263 - fix for rt.cpan.org #21084 (dump_overwrite pathological output recursion)
264 - fix for rt.cpan.org #21758 (mysql reserved words as table names)
265 - fix for rt.cpan.org #21025 (SQLite FK parsing)
266 - workaround for rt.cpan.org #21746 ($Class::Accessor::Fast::VERSION issues)
267
c25ff208 2680.03007 Thu Jul 27 16:19:59 UTC 2006
e682950b 269 - Kill erroneous warning about connect/loader_options order (the real
270 case is warned about elsewhere)
271 - Fix t/22dump to work around ActiveState issues
272
c25ff208 2730.03006 Wed Jul 26 00:14:58 UTC 2006
520107ef 274 - Fixed column-case issue w/ columns_info_for
275
c25ff208 2760.03005 Wed Jul 19 15:09:30 UTC 2006
8ac8926d 277 [ Pretty much everything in this release originates from nilsonsfj patches ]
278 - bugfix: mysql unique constraint code had an
279 obvious but longstanding error
280 - bugfix: columns were being specified out-of-order,
281 bug was introduced in the 0.03004 column metadata
282 dumping feature
02356864 283 - dump code now skips+warns instead of dies when
8ac8926d 284 dump_overwrite not set
02356864 285
c25ff208 2860.03004 Tue Jul 11 04:38:09 UTC 2006
d65cda9e 287 - make_schema_at efficiency improvements
288 - improved debugging output
289 - column metadata now included in dumped schemas
d65cda9e 290 - Carp::Clan added, and some dies converted to croaks
291 - no longer overwrites files when dumping, unless asked
292 to do so via the dump_overwrite option
293 - loader_options can now be embedded in the connection info
294 - Documentation improvements
71b997e9 295 - Deprecation notices updated, most things that became
296 "deprecated" in 0.03 are now marked for death in 0.04000
297 - All deprecated usage patterns should now generate annoying
298 warnings (most did before).
299 - Somewhat improved test coverage
d65cda9e 300
c25ff208 3010.03003 Tue Jun 6 02:22:49 UTC 2006
e50425a9 302 - Fix inclusion of external add-on class definitions
303 in dump_to_dir output.
304
c25ff208 3050.03002 Tue Jun 6 01:27:25 UTC 2006
fc2b71fd 306 - rethrow exceptions that occur during make_schema_at
307
c25ff208 3080.03001 Mon Jun 5 23:17:57 UTC 2006
8f9d7ce5 309 - load_from_connection deprecation notice now mentions
310 upgrading Catalyst::Model::DBIC::Schema if that module
311 seems to be in use.
5223f24a 312 - DBIx::Class required version number fixed
313 - Loader statement caching for better load-time performance
314 - Improved Pg unique index loader, based on RDBO
315
c25ff208 3160.03000 Tue May 23 12:56:05 UTC 2006
074e81cd 317 - weakened the circular schema reference
318
c25ff208 3190.02999_10 Mon May 22 18:58:20 UTC 2006
996be9ee 320 - a few more small bugfixes
321 - more dump/debug improvements
322 - new exportable function "make_schema_at"
323
c25ff208 3240.02999_09 Sun May 21 23:26:58 UTC 2006
996be9ee 325 - More docs improvements
326 - default uniq_info just warns and returns nothing now,
327 instead of dying. In theory, this allows unsupported
328 DBD drivers to potentially work with this module, if
329 the generic methods happen to work for that vendor.
330 - New tests for the various current and legacy/deprecated
331 methods of connecting a Schema::Loader class/object.
332 - Bugfix to the new runtime object connect/load code.
333
c25ff208 3340.02999_08 Sat May 20 22:36:45 UTC 2006
996be9ee 335 - support for dumping to a directory for
336 conversion to manual DBIx::Class::Schema
337 - improved debugging output
338 - more documentation updates
339 - more backwards compatibility fixes
340 - runtime connection definitions (and cloning) work fine now.
341 - A couple of bugfixes related to db vendor "schemas", including
342 a fix for http://rt.cpan.org/Public/Bug/Display.html?id=19164
343
c25ff208 3440.02999_06 Thu May 18 16:32:41 UTC 2006
996be9ee 345 - backwards compat with all earlier versions
346 - no longer requires schema class to have a connection
347 - correctly determine source class names in the rel code generator
348 - fixed mysql testing w/o InnoDB
349 - Writing guide updated
350 - docs updated
351 - various trivial updates / fixes
352
c25ff208 3530.02999_05 Sun Mar 26 06:46:09 UTC 2006
996be9ee 354 - bugfixes to constraint/exclude code
355 - friendly warnings if we don't find any tables
356 - inflect_map becomes inflect_plural and inflect_singular
357 - Singularize relationship names where appropriate
358 - Test updates
359 - Supports multiple rels between the same pair of tables
360
c25ff208 3610.02007 Wed Mar 22 06:03:53 UTC 2006
ac890564 362 - Backported Class::C3::reinitialize changes from -refactor
a0cc2498 363 branch, resulting in significantly reduced load time
09d632a1 364
c25ff208 3650.02006 Fri Mar 17 04:55:55 UTC 2006
ac5ad557 366 - Fix long-standing table/col-name case bugs
367
c25ff208 3680.02999_04 Fri Mar 17 03:55:09 UTC 2006
996be9ee 369 - Fixed case-sensitivity issues for table/col names
370 - Punt columns_info_for to ->storage
371 - Large loading speedup (get rid of redundant C3 reinits)
372 - Removed TEST_POD checks
373 - Removed unneccesary storage->disconnect
374
c25ff208 3750.02999_03 Mon Mar 13 15:01:11 UTC 2006
996be9ee 376 - Added EXAMPLE section to pod [Kieren Diment]
377 - Invasive heavy changes to the DBI- and vendor-specific code
378 (expect some breakage in some cases until this settles down)
379 - Support for loading UNIQUE constraints
380 - Tests cleaned up a bit
381 - Relationship building seperated out into it's own file for
382 the changes that are coming, but still does basically what
383 it did before (this work is the next step).
384
c25ff208 3850.02999_02 Sat Mar 4 16:53:21 UTC 2006
996be9ee 386 - Merged in relevant changes from trunk since the split
387
c25ff208 3880.02005 Mon Feb 27 23:53:17 UTC 2006
d161cb49 389 - Move the external file loading to after everything else
a0cc2498 390 loader does, in case people want to define, override, or
391 build on top of the rels.
d161cb49 392
c25ff208 3930.02004 Mon Feb 27 23:53:17 UTC 2006
1b311bbb 394 - Minor fix to debugging message for loading external files
395
c25ff208 3960.02999_01 Sun Feb 28 00:24:00 UTC 2006
996be9ee 397 - Shuffle the modules around
398 - Make ourselves theoretically storage_type-agnostic
399 - Remove the _db_classes stuff, bump PK::Auto to Base
400 - Change default inflections to Lingua::EN::Inflect::Number::to_PL()
401
c25ff208 4020.02003 Sun Feb 19 20:42:01 UTC 2006
1031d4f6 403 - Deprecated arguments: dsn, user, password, options
404 - New argument: connect_info
405
c25ff208 4060.02002 Sat Feb 18 19:53:12 UTC 2006
4350370d 407 - Added moniker_map and inflect_map
408
c25ff208 4090.02001 Fri Feb 17 20:25:40 UTC 2006
c2849787 410 - tests fixed up a bit
17725ccb 411 - auto-loading of on-disk class definitions layered on top
412 of the generated definitions (create Foo::Schema::Bar, then
413 also try to ->require it if it exists on disk).
414 - new parameters components and resultset_components, which do
415 the obvious for the generated table classes.
416 - DBIx::Class pre-req bumped to 0.05006, since Schema::Loader
417 is virtually gauranteed to cause subtle mod_perl problems
418 without those fixes.
c2849787 419
c25ff208 4200.02000 Sun Feb 12 22:43:47 UTC 2006
89ecd854 421 - Just docs/version update, 0.01004 code released as 0.02000
422
c25ff208 4230.01004 Tue Feb 7 03:58:01 UTC 2006
738705c6 424 - No longer tries to parse out the table name from the dsn for mysql,
425 was unneccesary vestigial code from previous method.
426
c25ff208 4270.01003 Mon Feb 6 14:57:56 UTC 2006
c5de0b0c 428 - Fixed the has_many side of _make_cond_rel
429
c25ff208 4300.01002 Fri Feb 3 23:14:38 UTC 2006
f654c972 431 - Email address typo :(
432
c25ff208 4330.01001 Fri Feb 3 05:15:41 UTC 2006
457eb8a6 434 - Fixed up some documentation issues
435 - Load C3 at the right time
436
aec93e93 4370.01 Fri Feb 3 01:53:46 UTC 2006
438 - original release
439 - created from DBIx::Class::Loader 0.14