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