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