Pg _table_fk_info to use catalog not info_schema
[dbsrgits/DBIx-Class-Schema-Loader.git] / Changes
CommitLineData
af6c2665 1Revision history for Perl extension DBIx::Class::Schema::Loader
a78e3fed 2
f839d33b 3 - rewrite pg fk introspection to use catalog views instead of
4 information_schema as information_schema does not work for readonly
5 users
3492170f 6 - add rel_type param for relationship_attrs coderef
7
ae151d4f 80.07033 2012-09-09 16:11:47
10b0a36e 9 - more thoroughly document the new behavior for relationship attributes
10 under "relationship_attrs" in ::Base POD
11 - add a loud WARNING to Makefile.PL about the new behavior for
12 relationship attributes
13
c34033b1 140.07032 2012-09-09 13:17:20
add8bcf0 15 - SQLite: detect is_deferrable for inline FKs
7b6a8d73 16 - support coderefs for relationship_attrs
17
e505923e 180.07031 2012-09-06 15:07:08
41bc1375 19 - fix 02pod.t failure due to lack of =encoding utf8 statement (patch by
20 Marcel Gruenauer) (RT#79481)
21
0af7cacc 220.07030 2012-09-06 03:27:09
9890b10c 23 - allow user to set qualify_objects=0 in multischema configurations
0af7cacc 24 (andrewalker)
9890b10c 25
533d98c0 260.07029 2012-09-05 16:41:56
a40434df 27 - Oracle: introspect ON DELETE and DEFERRABLE FK clauses
28 - Oracle WARNING: on_delete is now 'NO ACTION' by default, not
29 'CASCADE'. on_update is now 'NO ACTION' by default (Oracle does not
30 have update rules, this was done to preserve the behavior of the
31 schema when cross-deploying to SQLite.) is_deferrable is now
32 0 by default, not 1.
075473b9 33 - DB2: introspect ON DELETE/UPDATE FK clauses
34 - DB2 WARNING: the default for on_delete/on_update is now 'NO ACTION'
35 not 'CASCADE', the default for is_deferrable is still 1 because DB2
a40434df 36 does not have deferrable constraints.
075473b9 37 - SQLite: introspect ON DELETE/UPDATE and DEFERRABLE FK clauses
3b61a7ca 38 - SQLite WARNING: the default for on_delete/on_update is now 'NO ACTION'
39 not 'CASCADE', and the default for is_deferrable is now 0 not 1.
40
8990a2b2 410.07028 2012-08-30 05:32:42
f8640ecc 42 - MSSQL: introspect ON DELETE/UPDATE clauses for foreign keys
43 - MSSQL WARNING: the default for on_delete/on_update is now 'NO ACTION'
44 not 'CASCADE'.
45
ef73d2ad 460.07027 2012-08-26 22:39:45
958d5fcf 47 - PostgreSQL: introspect ON DELETE/UPDATE clauses for foreign keys and
48 the DEFERRABLE clause.
49 - PostgreSQL WARNING: the default for on_delete/on_update attributes for
50 belongs_to relationships is now 'NO ACTION' not 'CASCADE! The default
51 for is_deferrable is now 0 not 1.
52
b95e25c9 530.07026 2012-08-26 01:01:26
9dedee1f 54 - MySQL: introspect ON DELETE/UPDATE clauses for foreign keys.
55 - MySQL WARNING: the default on_delete/on_update attributes for
56 belongs_to relationships is now RESTRICT, *NOT* CASCADE! This is
57 overridable via the relationship_attrs option.
58
70119893 590.07025 2012-06-08 22:48:05
b8aba8da 60 - support SQL Server 2000 again (broken in 0.07011)
70119893 61 - some slight optimization for SQL Server driver
b8aba8da 62
c819561a 630.07024 2012-05-08 15:35:16
79137580 64 - work around broken keyseq in DBD::Pg foreign_key_info (RT#77062)
65
835a650f 660.07023 2012-05-05 11:44:15
a273b50c 67 - properly order FK columns when using base ::DBI loader (SineSwiper)
adf7b1a9 68 - bump Class::Inspector dep to 1.27 due to test failures with earlier
69 versions on perl >= 5.15.7 (RT#74236)
70
7c2059da 710.07022 2012-04-08 12:11:00
006c8ed3 72 - do separate queries for default_value on Sybase ASE as some servers
73 can't join to that table (pcmantz) (RT#74170)
e17ad40a 74 - set correct size for nchar/nvarchar columns for Sybase ASE,
75 depending on @@ncharsize
76
bb46cd4b 770.07021 2012-04-04 23:47:34
23fd9773 78 - use ::Schema::connect instead of ::Schema::connection in
79 make_schema_at (RT#74175)
80 - register sources on the schema class, never the instance, regardless
81 of how the connection is made for dynamic schemas
82
dec80986 830.07020 2012-03-31 21:34:06
383bd2a8 84 - fix some mro issues under perl 5.8
85
22f91663 860.07019 2012-03-28 17:23:09
116431d6 87 - fix some errors due to case issues (RT#75805)
88
18eb280f 890.07018 2012-03-27 05:55:10
f21f7e97 90 - skip dbicdump tests on Win32 due to test fails (RT#75732)
5f4a9d44 91 - fix undefined warnings for DBDs without schemas
1af21646 92 - work around ORA-24345 from $dbh->column_info
a82f1dd4 93 - fix spelling mistake in Base POD (RT#74796)
94
b45a0999 950.07017 2012-02-07 07:23:48
07307014 96 - *EXPERIMENTAL* support for dumping PostgreSQL schemas inside of a
97 transaction
b45a0999 98 - use DBI table_info/column_info REMARKS field if/where available for
99 table/column comments (SineSwiper)
100 - better compatibility with more DBDs (SineSwiper)
07307014 101
5fc335ab 1020.07015 2011-12-09 10:36:17
eaf23084 103 - generate many_to_many bridges for targets of link tables
104
0f844832 1050.07014 2011-11-18 17:06:34
c5694be0 106 - fix a bug in the automatic multischema clashing moniker disambiguation
107 code that overwrote $loader->moniker_parts
108
6bb8fa3c 1090.07013 2011-11-17 23:12:47
4c2e2ce9 110 - automatically prefix database/schema to clashing monikers for
111 the same table name in multischema configurations
112
eeeab540 1130.07012 2011-11-09 15:16:29
5b1d1376 114 - as of 0.07011 all callbacks receive a ::Loader::Table or
115 interface-compatible object instead of the table name, this object
116 stringifies to the table name (RT#72260)
50b95db6 117 - fix a bug in dynamic schema_base_class/schema_components
118 implementation that ran the connection method twice on subsequent
119 connects
310f3603 120 - use a temp file for filter_generated_code with a string program name
121 instead of IPC::Open2, which hangs on Win32 (RT#72226)
538bbf85 122 - previous version referred to the wrong RT# for the uniq_to_primary
123 change, it is actually (RT#51696)
124
8e6c80c9 1250.07011 2011-11-01 09:00:00
112415f1 126 - add -I option to dbicdump
b564fc4b 127 - do not delete default custom content comment and ending 1; from custom
128 content in files that are being renamed (RT#70507)
33c40155 129 - use MooseX::MarkAsMethods instead of namespace::autoclean for the
130 use_moose option, this protects operator overloads, only_autoclean
131 option added for the old behavior
57a3ea24 132 - add experimental naming=v8 mode with better CamelCase identifier
133 support, relationship naming and conversion of non-identifier chars
134 (RT#71945)
3bb5544f 135 - add naming => { force_ascii => 1 } option for Unicode database names
d3b8acfc 136 - implement schema_base_class and schema_components for dynamic and
137 working schemas
a79e1189 138 - remove dependency on File::Slurp
2db2c898 139 - allow the constraint and exclude options to be used simultaneously
140 (bphillips)
5975bbe6 141 - fix Oracle multi-db_schema unique detection (RT#70851)
f213ae4e 142 - fix Oracle common tests fail with multi_schema due to not resetting
143 the preserve_case option after the preserve_case tests (RT#70829)
1132d047 144 - handle <type> DEFAULT NULL for Pg
145 - handle boolean DEFAULT 0::boolean for Pg
3bb5544f 146 - config file support for dbicdump script (alnewkirk)
7dc01f79 147 - added filter_generated_code option (RT#53841)
ea998e8e 148 - generic table and column comments support
149 - MySQL table and column comments support
fcf328c7 150 - support DOS line endings on *nix and *nix line ending on Win32
900195eb 151 - add quiet option
39d5612f 152 - $schema->loader is now a public method
1fe6af07 153 - add schema_components option
b33d5949 154 - sort relationships so they always come out in the same order
6d358d58 155 - also sort unique constraints so they always come out in the same order
c4a69b87 156 - multi db_schema support with cross-schema rels (RT#39478)
157 - added moniker_parts option for name clashes in multi db_schema setups
59388920 158 - add rel_name_map option
3568bda9 159 - fix the decimal data type for MS Access over ODBC
698c11d8 160 - fix enum/set detection for MySQL (RT#68717)
2ae19e70 161 - fix is_nullable detection on MS Access
d5c9c286 162 - remove '$table has no primary key' warning
f92914ef 163 - added uniq_to_primary option to promote unique keys to primary keys
164 (RT#25944)
dc96667a 165 - support arrayrefs for result_namespace and resultset_namespace
166 (RT#40214)
c0a0986f 167 - add naming => { monikers => 'preserve' } or 'singular'/'plural' to
168 control moniker inflection (RT#44935)
169 - add naming => { column_accessors => 'preserve' } to not normalize
170 CamelCase column names to lower case for accessors (RT#64668)
12b86f07 171 - support quoted PostgreSQL schema names with special chars (RT#64766)
6ebd0f33 172 - automatically turn on quoting for MySQL (RT#60469)
af15ea33 173 - become utf8-aware (RT#67920)
dc379dc6 174 - handle duplicate relationship names (RT#64041)
175 - fix a bug in Sybase ASE foreign key detection
a8acb698 176 - generate POD for result_base_class, additional_classes,
177 additional_base_classes, left_base_classes, components,
8007f3a7 178 result_components_map, result_roles, result_roles_map, unique
179 constraints, set_primary_key and table
d36c8734 180 - rename result_component_map to result_components_map (old name still
181 works)
182 - fix accessor collision detection for methods from
183 result_components_map components
184 - add result_roles and result_roles_map options
c0767caf 185 - fix for mysql rel detection in mixed-case tables on mixed-case
186 filesystems (OSX and Windows)
308d65f0 187 - support for DBD::Firebird
5111e5d0 188 - support for unicode Firebird data types
0f21885a 189 - handle "use warnings FATAL => 'all';" in custom/external content
190 (RT#59849)
9c703ffb 191 - for dynamic schemas, if the naming option is set, will automatically
192 turn on use_namespaces=1 as well. Set use_namespaces=0 to disable
193 this behavior (RT#59849)
308d65f0 194
4295c4b4 1950.07010 2011-03-04 08:26:31
196 - add result_component_map option
197
c8845f2e 1980.07009 2011-02-25 11:06:51
ca2ca9c8 199 - fix a syntax error in MS Access ADO driver
200
3bdcf490 2010.07008 2011-02-25 01:54:43
3fea497f 202 - rename column_accessor_map to col_accessor_map, the old alias still
203 works
3b17d988 204 - support MSSQL over DBD::ADO
205 - support for MS Access over DBD::ODBC and DBD::ADO
3fea497f 206
3b71e53b 2070.07007 2011-02-15 10:00:07
208 - bump DBIx::Class dep to 0.08127
ae38ed69 209 - fix MSSQL data types for native client and EasySoft driver
210
e94ccbea 2110.07006 2011-02-01 02:18:32
da793144 212 - turn unloading of RelBuilder temp classes back on, now with proper
213 check for class existance using Class::Inspector->loaded
214 - bump up dep on namespace::clean to avoid breakage with earlier
215 versions (RT#65149)
216
c697835e 2170.07005 2011-01-25 23:07:55
667f1a0b 218 - support extra connect_info options like quote_char for dbicdump
07ba0049 219 - fix breakage on perl 5.8.x related to unloading temporary classes
220
4e793de7 2210.07004 2011-01-24 03:43:05
26c54680 222 - fix bug with result class methods being cached on in a closure instead
223 of the object, which breaks for multiple dynamic schemas in a single
224 perl instance
225
659817cf 2260.07003 2011-01-21 06:43:05
a7116285 227 - fix relname/method collisions (RT#62648)
71687093 228 - fix fully qualified component classes (RT#62624)
23ed3da1 229 - improve sybase/mssql db_schema detection
49643e1d 230 - remove MooseX::NonMoose from Schema files under use_moose=1
8f65b7e5 231 - better _tables_list for Sybase ASE
80b1e888 232 - add datetime_undef_if_invalid => 1 for MySQL datetime data types
57a9fc92 233 (RT#64820) This behavior can be turned off by passing
234 datetime_undef_if_invalid=0 as a loader option
cfc5dce3 235 - added column_accessor_map option
1ad8e8c3 236 - Preserve relationship names when redumping and another FK is added
237 (RT#62424)
238 - Remove resultset_components as ResultSetManager is deprecated
0dd4099e 239 - Fix a fail when very old Moose/CMOP is installed
15c4393b 240 - Added warning for column-accessor collisions, doc section in ::Base
241 ("COLUMN ACCESSOR COLLISIONS") and the col_collision_map option.
620f4ca4 242 - Handle column accessor collisions with UNIVERSAL methods
b8ae4518 243 - Generate custom_type_name hint for PostgreSQL enums, as used
244 by very recent SQL::Translator
12333562 245 - Added support for PostgreSQL enum types
4cd5155b 246 - Added table/column comment support for Oracle
61cd4bfc 247 - Fix missing require (RT#62072)
248
f671b630 2490.07002 2010-09-11 01:48:00
8de81918 250 - Properly detect a schema loaded with use_moose on subsequent
251 reloads
22edddda 252 - Die with a sensible message when a schema loaded with
253 use_moose => 1 is reloaded with use_moose => 0
942bd5e0 254 - Switch to MRO::Compat
1db66065 255 - Fix oracle common tests failure / lc(undef) warnings
a8ae008d 256 - Bump Moose/Moosex::NonMoose optional dependencies to fixed-up
257 versions
8dcf4292 258 - Fix mssql common tests failures with MSSQL 2005 (skip test of
259 datatypes found only on MSSQL 2008)
ebed3e6e 260 - Fix DB2 v8 test failures (skip tests of graphics types found
261 only on DB2 v9)
01f93238 262 - Fix dangerous invocation of ->meta on classes during upgrade
263 (may be *non* moosified and contain a user-defined meta() )
f671b630 264 - Multiple test cleanups and refactorings
942bd5e0 265
28949670 2660.07001 2010-07-24 21:28:08
aa0867ee 267 - put is_deferrable => 1 back into default attributes for belongs_to
9f333983 268 - fix Postgres sequence detection for qualified sequences
fb69f4f6 269 - detect DOS line ends in table/column comments and convert to \n
c9cf9b4d 270 - added use_moose option
10c0c4f3 271 - always mark pk columns is_nullable=0
4a1323d2 272 - fix unique constraint names for SQLite (actual names break ->deploy)
414c61a0 273 - fix bug in qualify_objects that would add schema to relnames
274 - better type info for Informix, except for DATETIME precision and
275 INTERVAL support
7640ef4b 276 - better type info for DB2
d2df9c9b 277 - fix some newly-introduced test bugs
6550c2ee 278 - fix composite PKs getting marked is_auto_increment on SQLite
7640ef4b 279
b1d11550 2800.07000 2010-05-22 23:40:15
281 - added qualify_objects option to prepend db_schema to table names
1b3e8f7a 282 - fix for negative numeric default values
5cd600fa 283 - sequence is detected for Oracle
284 - fix for SQLite is_auto_increment detection when table is empty (hobbs)
b511f36e 285 - rescan now reloads all tables
8c41c3ce 286 - minor type info improvements for all DBs
33aa3462 287 - fix erroneous default_value for MySQL NOT NULL columns (RT#57225)
6818ce9f 288 - remove is_deferrable => 1 from default for belongs_to rels
760fd65c 289 - better type info for Oracle
bc5afe55 290 - preliminary Informix support
0c1d5b47 291 - unregister dropped sources on rescan
b511f36e 292 - added 'preserve_case' option with support for all DBs where it makes
293 sense; removed the MSSQL 'case_sensitive_collation' and the
294 Firebird/InterBase 'unquoted_ddl' options in favor of it.
bc1cb85e 295 - support CamelCase table names and column names (in case-preserving
296 mode) at the v7 naming level
69219349 297 - rewrite datetime default functions as \'current_timestamp' where
8a64178e 298 possible (except for Sybase ASE) to ease cross-deployment
4337bddf 299 - use column_info instead of select to get Oracle column list (RT#42281)
be72dba7 300 - match quotes in MySQL parser in more places (RT#42101)
ae32aaf6 301 - fix unique detection in DB2 for multiple schemas (RT#39622)
9fdf3d5b 302 - fix column name collisions with methods (RT#49443)
3de915bc 303 - fix loading MySQL views on older MySQL versions (RT#47399)
304
5afd3e72 3050.06001 2010-04-10 01:31:12
81ade4d9 306 - fix type info for MSSQL
103e90da 307 - fix MSSQL collation detection on freetds tds version 8.0
308
231688f8 3090.06000 2010-04-06 01:12:25
26334ec1 310 - better type info for MySQL
311 - initial MySQL data type tests (jhannah)
2a8e93e9 312 - don't set result_namespace if it's 'Result'
9dc968df 313 - support for MSSQL databases with case sensitive collation, manually
314 overridable with 'case_sensitive_collation' option
71a6e88a 315 - do not try to detect driver and rebless when used with a custom
9dc968df 316 'loader_class'
bfb43060 317 - suppress 'bad table or view' warnings for filtered tables/views
27305cc1 318 - croak if several tables reduce to an identical moniker (ribasushi)
05f25b42 319 - better type info for Sybase ASE
df956aad 320 - better type info for Pg: sets sequence for serials, handles numerics
321 without precision
acfcc1fb 322 - better _tables_list for MSSQL
26da4cc3 323 - pick up views in SQLite too
324 - better rel inflection using Lingua::EN::Inflect::Phrase
53ef681d 325 - cascade_delete and cascade_copy are turned off for has_many/might_have
ee07e280 326 by default, and belongs_to has on_delete => 'CASCADE', on_update =>
327 'CASCADE' and is_deferrable => 1 by default, overridable via
328 relationship_attrs
329 - added config_file option for loading loader options from a file
0faae4b8 330 - set inflate_datetime => 1 for 'AS getdate()' computed columns in
331 Sybase
cf0ba25b 332 - Firebird support
829f17e3 333 - use introspection pragmas instead of regexes to introspect SQLite
334 (hobbs)
f170d55b 335 - generate POD for refs correctly from column_info
9dc968df 336 - fix tables list, fk introspection and type info for SQL Anywhere
05c54730 337
e42ec4ef 3380.05003 2010-02-20 05:19:51
d8cbfbb8 339 - support for custom_column_info, datetime_timezone and datetime_locale
340 (rbo)
9fd0726a 341 - improve parsing of SQLite tables when a column definition
342 spans multiple lines (hobbs)
db36a574 343 - fix missing trailing _id stripping for some relationship
344 names (rbuels)
0547c283 345 - fixed accessor POD bug, was not dereferencing scalar refs
346 before printing (rbuels)
db36a574 347
83b38372 3480.05002 2010-02-15 10:17:47
8793567f 349 - support for SQLAnywhere via DBD::SQLAnywhere and ODBC
83b38372 350 - fix picking up quoted tables for SQLite (RT#54538) patch from schwern
2a5dcfb3 351 - validate class/component loader_options to make sure classes
83b38372 352 are available before generating the schema, patch from bphillips
2a5dcfb3 353
dc767cd3 3540.05001 2010-02-05 14:29:27
41968729 355 - correct default_value for all backends with common tests
356 - fix bug with quoted Pg tables from $dbh->tables (RT#54338)
357 - add inflate_datetime => 0 to 'timestamp' types for Sybase
358
ca7feebf 3590.05000 2010-02-01 09:24:24
f730e1b6 360 - better data_type, default_value and size for Sybase
492dce8d 361 - added 'generate_pod' option, defaults to on
43b982ea 362 - added 'pod_comment_mode' and 'pod_comment_spillover_length' to
363 control table comment generation (waawaamilk)
492dce8d 364
04e60ed2 3650.04999_14 2010-01-14 06:47:07
540a8149 366 - use_namespaces now default, with upgrade/downgrade support
805dbe0a 367 - filter out un-selectable tables/views
d4d1a665 368 - fix NUMERIC/DECIMAL size column_info for postgres
59f54738 369 - now mentions skip_load_external feature in comments (jhannah)
370 - moniker_map POD correction (jhannah)
d4d1a665 371
1fa18849 3720.04999_13 2010-01-03 12:32:25
afb4c5bc 373 - exclude 'size' column_info for postgres when unnecessary, and
374 use the correct precision for varying types (except NUMERIC)
30a4c064 375 - 'naming' attribute and backward compatibility with 0.04006
7b505bbd 376 - added relationship_attrs option for setting attributes in
377 generated relationships
72cd9295 378 - added overwrite_modifications option that ignores md5sums on
379 generated code
33fb8fa0 380 - added skip_load_external (jhannah)
1fa18849 381 - remove Class::Data::Accessor and Class::Accessor::Fast and switch
33fb8fa0 382 everything to Class::Accessor::Grouped (jhannah)
46065bcb 383 - better handling of db_schema for Oracle, based on (RT#35732)
384
0a701ff3 3850.04999_12 2009-11-30 23:36:14
309e2aa1 386 - fix MySQL rel introspection with on_connect_call =>
387 'set_strict_mode' (RT#52087)
388 - now using base 'DBIx::Class::Core' for Results (RT#52141)
389
a06118a6 3900.04999_11 2009-11-29 18:08:46
fbcfebdd 391 - added patch to generate POD from postgres by Andrey Kostenko (GUGU)
4daef04f 392 - added test for norewrite feature
5c6fb0a1 393 - fix default_value for MSSQL
394
b1ad1a84 3950.04999_10 2009-10-31 12:28:53
8803e4ed 396 - patch from Robert Bohne to make _table_uniq_info more correct for
397 Oracle
b1ad1a84 398 - fix data_type for identity columns with MSSQL
8803e4ed 399
c25ff208 4000.04999_09 2009-10-08
79193756 401 - Only redump the files when something has actually changed
b4dcbcc5 402 - Place a warning at the top of the files saying 'do not modify' to
403 match the one at the bottom of the auto-gen'd section
79193756 404
c25ff208 4050.04999_08 2009-08-28
6ae3f335 406 - Replace UNIVERSAL::require with Class::C3::Componentised
3f4461a5 407 - Add Sybase/MSSQL support through DBD::Sybase
1bcb47d3 408 - use $dbh->get_info(29/41) for qote_car/name_sep if available (semifor)
bfe03a54 409 - add MSSQL support through DBD::ODBC
1bcb47d3 410 - support MSSQL table names with a '.' in the name
411 - support MySQL CURRENT_TIMESTAMP()
6ae3f335 412
c25ff208 4130.04999_07 2009-04-18
a28b70f1 414 - Add result_base_class and schema_base_class options (RT #43977)
d70c335f 415 - Ignore duplicate uniq indices (including duplicates of the PK).
632cb26f 416 - Fix for DBD::SQLite 1.20
706ef173 417 - Fix for DBIx::Class 0.08100
76c488a6 418
c25ff208 4190.04999_06 Tue Nov 11, 2008
22270947 420 - Singularise table monikers by default
e7886624 421 - Strip trailing _id from single-column belongs_to relationships
ff746964 422 - Add "dbicdump" script for easy commandline dumping
af31090c 423 - Throw out the in-memory class generation, just dump to a temporary
424 directory if the user didn't specify one
c7bf4194 425 - Fix Oracle constraint and auto-increment detection for non-owned schemas
426 (RT #35732)
c25ff208 427 - Handle ResultSetManager deprecation warning in common tests
22270947 428
c25ff208 4290.04999_05 Mon Apr 14, 2008
072d5aae 430 - Fix limiting table list to the specified schema for DB2
7a930e63 431 - Default db_schema to the username for DB2
29ddb54c 432 - Allow specifying a custom loader_class, overriding the
433 storage_type-based detection
565ca24d 434 - Cosmetic fixes to dumping of externally defined classes
2a620a1b 435 - Make ResultSetManager notice externally defined :ResultSet methods
2328d1fc 436 - Fix test failure for non-InnoDB MySQL due to wrong skip count
390bbe3f 437 - Fix base class ordering in dumped classes
438 - Run the common tests against both dynamic and dumped versions of
439 the schema
072d5aae 440
c25ff208 4410.04999_04 Wed Mar 12, 2008
772cfe65 442 - Add is_auto_increment detecton for DB2
443
c25ff208 4440.04999_03 Wed Mar 12, 2008
28357fd3 445 - Fix DB2 support
446
c25ff208 4470.04999_02 Tue Feb 12, 2008
fb328d1a 448 - Add is_auto_increment detection for Oracle
d87d939a 449 - Unnhide the Oracle module now that the CPAN perms are sorted
450 out. Thanks to Tsunoda Kazuya for the quick response.
fb328d1a 451
c25ff208 4520.04999_01 Tue Feb 5, 2008
e7213f4f 453 - Mark foreign key columns with is_foreign_key => 1
c5baf131 454 - Add support for vendor-specific extra column attributes.
8fdd52a2 455 - Add support for extra => { unsigned => 1 } for MySQL.
46bef65f 456 - Add support for enum value lists for MySQL
7dba7c70 457 - Set join_type => 'LEFT OUTER' for nullable foreign keys
458 (patch from Bernhard WeiĂŸhuhn)
78b7ccaa 459 - Set is_auto_increment for auto-increment columns (RT #31473)
460 (Only SQLite, MySQL and PostgreSQL are currently supported)
af99957c 461 - Generate one-to-one accessors for unique foreign keys (ilmari)
a1726271 462 - Add support for load_namespaces-style class layout
45f3698a 463 - Fix test skip count for main skip_rels block
a1726271 464 - Fix auto-inc column creation for the Oracle tests
75a0d986 465 - Fix column ordering in unique constraints for Oracle
2ffd6b4c 466 - Fix Win32 test skip counts for good (RT #30568, Kenichi Ishigaki)
d0e184e9 467 - Default Oracle db_schema to db username (patch
468 from Johannes Plunien)
af99957c 469
c25ff208 4700.04003 Wed Oct 4, 2007
f1f25439 471 - Prevent users from running Kwalitee test automatically
9616156f 472 - Fix extra whitespace being added to output on
473 regeneration (from ilmari)
474
c25ff208 4750.04002 Tue Jul 24, 2007
c39e3507 476 - rescan method now returns the actual list of new tables
477 loaded (previously, the return value wasn't taking
478 constraint/exclude into account, even though the meat
479 of the operation was).
480 - Hid the Oracle module so that search.cpan.org will stop
481 ignoring this package, temporary fix until perms are
482 sorted out
1c1efbce 483 - Fix Win32 test skip counts (RT #27715, Alexandr Ciornii)
484 - Fix a small output quoting bug (RT #28073, Tokuhiro Matsuno)
09c19d42 485
c25ff208 4860.04001 Tue Jun 26, 2007
28b4691d 487 - Deprecated dump_overwrite. The changed behavior from
488 0.03xxx was confusing.
489 - Added new option really_erase_my_files, which does what
490 dump_overwrite did in 0.04000, which is not what it did
491 in 0.03xxx.
492
c25ff208 4930.04000 Thu Jun 7, 2007
7507c8ce 494 - Added some env vars for controlling the Makefile.PL feature
495 questions, to make automation easier.
496
c25ff208 4970.03999_02 Tue May 22, 2007
3fe9c5d9 498 - Converted to Module::Install
499
c25ff208 5000.03012 Tue May 22, 2007
0c0a7757 501 - Relationship names for multiple multi-col rels between
502 the same table fixed by ilmari
503 - Fix from Marc Espie for CREATE TABLE 'foo' for SQLite
522ee84e 504 - skip ^sqlite_ tables in SQLite (thanks chromatic)
505
c25ff208 5060.03999_01 Sat Apr 14 19:57:40 GMT 2007
e7262300 507 - Added *experimental* Oracle support from work done
508 by Tsunoda Kazuya some months ago. Not well tested.
7fa9a8b1 509 - Added "rescan" schema (and loader) method, which picks
510 up newly created tables at runtime
7cab3ab7 511 - Made dump_to_dir / dump_overwrite much more intelligent
512 (they now preserve customizations by default)
fd589700 513 - Added support for DBI's new standard "statistics_info"
514 method to gather unique key info (only supported by
79fe0081 515 DBD::Pg trunk afaik)
12af3806 516 - columns_info_for imported from DBIx::Class
517 - relationships are now on by default, use skip_relationships
518 to disable them
519 - Removed previously deprecated methods/options
32f784fc 520 - Added $VERSION to all packages in this dist
521
c25ff208 5220.03011 Sat Apr 14 19:03:07 UTC 2007
050003c5 523 - fix case-sensitivity in UNIQUE parsing for SQLite
524
c25ff208 5250.03010 Thu Mar 29 12:36:19 UTC 2007
518472fa 526 - Workaround for new incompatible changes in DBD::mysql's "tables"
527 method, which was causing us to find no tables w/ DBD::mysql
528 4.002+
9dedee1f 529 - Fixed quoting problem in _table_columns (could cause crash when
a0cc2498 530 dumping/doing a static create) (from ash)
531
c25ff208 5320.03009 Wed Nov 15 14:03:37 UTC 2006
a0cc2498 533 - fix for rt.cpan.org #22425 (use File::Spec where appropriate)
534 - use full instead of short classnames in relationships (from victori)
01de2418 535
c25ff208 5360.03008 Fri Oct 20 18:08:20 UTC 2006
88603c41 537 - fix for rt.cpan.org #21084 (dump_overwrite pathological output recursion)
538 - fix for rt.cpan.org #21758 (mysql reserved words as table names)
539 - fix for rt.cpan.org #21025 (SQLite FK parsing)
540 - workaround for rt.cpan.org #21746 ($Class::Accessor::Fast::VERSION issues)
541
c25ff208 5420.03007 Thu Jul 27 16:19:59 UTC 2006
e682950b 543 - Kill erroneous warning about connect/loader_options order (the real
544 case is warned about elsewhere)
545 - Fix t/22dump to work around ActiveState issues
546
c25ff208 5470.03006 Wed Jul 26 00:14:58 UTC 2006
520107ef 548 - Fixed column-case issue w/ columns_info_for
549
c25ff208 5500.03005 Wed Jul 19 15:09:30 UTC 2006
8ac8926d 551 [ Pretty much everything in this release originates from nilsonsfj patches ]
552 - bugfix: mysql unique constraint code had an
553 obvious but longstanding error
554 - bugfix: columns were being specified out-of-order,
555 bug was introduced in the 0.03004 column metadata
556 dumping feature
02356864 557 - dump code now skips+warns instead of dies when
8ac8926d 558 dump_overwrite not set
02356864 559
c25ff208 5600.03004 Tue Jul 11 04:38:09 UTC 2006
d65cda9e 561 - make_schema_at efficiency improvements
562 - improved debugging output
563 - column metadata now included in dumped schemas
d65cda9e 564 - Carp::Clan added, and some dies converted to croaks
565 - no longer overwrites files when dumping, unless asked
566 to do so via the dump_overwrite option
567 - loader_options can now be embedded in the connection info
568 - Documentation improvements
71b997e9 569 - Deprecation notices updated, most things that became
570 "deprecated" in 0.03 are now marked for death in 0.04000
571 - All deprecated usage patterns should now generate annoying
572 warnings (most did before).
573 - Somewhat improved test coverage
d65cda9e 574
c25ff208 5750.03003 Tue Jun 6 02:22:49 UTC 2006
e50425a9 576 - Fix inclusion of external add-on class definitions
577 in dump_to_dir output.
578
c25ff208 5790.03002 Tue Jun 6 01:27:25 UTC 2006
fc2b71fd 580 - rethrow exceptions that occur during make_schema_at
581
c25ff208 5820.03001 Mon Jun 5 23:17:57 UTC 2006
8f9d7ce5 583 - load_from_connection deprecation notice now mentions
584 upgrading Catalyst::Model::DBIC::Schema if that module
585 seems to be in use.
5223f24a 586 - DBIx::Class required version number fixed
587 - Loader statement caching for better load-time performance
588 - Improved Pg unique index loader, based on RDBO
589
c25ff208 5900.03000 Tue May 23 12:56:05 UTC 2006
074e81cd 591 - weakened the circular schema reference
592
c25ff208 5930.02999_10 Mon May 22 18:58:20 UTC 2006
996be9ee 594 - a few more small bugfixes
595 - more dump/debug improvements
596 - new exportable function "make_schema_at"
597
c25ff208 5980.02999_09 Sun May 21 23:26:58 UTC 2006
996be9ee 599 - More docs improvements
600 - default uniq_info just warns and returns nothing now,
601 instead of dying. In theory, this allows unsupported
602 DBD drivers to potentially work with this module, if
603 the generic methods happen to work for that vendor.
604 - New tests for the various current and legacy/deprecated
605 methods of connecting a Schema::Loader class/object.
606 - Bugfix to the new runtime object connect/load code.
607
c25ff208 6080.02999_08 Sat May 20 22:36:45 UTC 2006
996be9ee 609 - support for dumping to a directory for
610 conversion to manual DBIx::Class::Schema
611 - improved debugging output
612 - more documentation updates
613 - more backwards compatibility fixes
614 - runtime connection definitions (and cloning) work fine now.
615 - A couple of bugfixes related to db vendor "schemas", including
616 a fix for http://rt.cpan.org/Public/Bug/Display.html?id=19164
617
c25ff208 6180.02999_06 Thu May 18 16:32:41 UTC 2006
996be9ee 619 - backwards compat with all earlier versions
620 - no longer requires schema class to have a connection
621 - correctly determine source class names in the rel code generator
622 - fixed mysql testing w/o InnoDB
623 - Writing guide updated
624 - docs updated
625 - various trivial updates / fixes
626
c25ff208 6270.02999_05 Sun Mar 26 06:46:09 UTC 2006
996be9ee 628 - bugfixes to constraint/exclude code
629 - friendly warnings if we don't find any tables
630 - inflect_map becomes inflect_plural and inflect_singular
631 - Singularize relationship names where appropriate
632 - Test updates
633 - Supports multiple rels between the same pair of tables
634
c25ff208 6350.02007 Wed Mar 22 06:03:53 UTC 2006
ac890564 636 - Backported Class::C3::reinitialize changes from -refactor
a0cc2498 637 branch, resulting in significantly reduced load time
09d632a1 638
c25ff208 6390.02006 Fri Mar 17 04:55:55 UTC 2006
ac5ad557 640 - Fix long-standing table/col-name case bugs
641
c25ff208 6420.02999_04 Fri Mar 17 03:55:09 UTC 2006
996be9ee 643 - Fixed case-sensitivity issues for table/col names
644 - Punt columns_info_for to ->storage
645 - Large loading speedup (get rid of redundant C3 reinits)
646 - Removed TEST_POD checks
647 - Removed unneccesary storage->disconnect
648
c25ff208 6490.02999_03 Mon Mar 13 15:01:11 UTC 2006
996be9ee 650 - Added EXAMPLE section to pod [Kieren Diment]
651 - Invasive heavy changes to the DBI- and vendor-specific code
652 (expect some breakage in some cases until this settles down)
653 - Support for loading UNIQUE constraints
654 - Tests cleaned up a bit
655 - Relationship building seperated out into it's own file for
656 the changes that are coming, but still does basically what
657 it did before (this work is the next step).
658
c25ff208 6590.02999_02 Sat Mar 4 16:53:21 UTC 2006
996be9ee 660 - Merged in relevant changes from trunk since the split
661
c25ff208 6620.02005 Mon Feb 27 23:53:17 UTC 2006
d161cb49 663 - Move the external file loading to after everything else
a0cc2498 664 loader does, in case people want to define, override, or
665 build on top of the rels.
d161cb49 666
c25ff208 6670.02004 Mon Feb 27 23:53:17 UTC 2006
1b311bbb 668 - Minor fix to debugging message for loading external files
669
c25ff208 6700.02999_01 Sun Feb 28 00:24:00 UTC 2006
996be9ee 671 - Shuffle the modules around
672 - Make ourselves theoretically storage_type-agnostic
673 - Remove the _db_classes stuff, bump PK::Auto to Base
674 - Change default inflections to Lingua::EN::Inflect::Number::to_PL()
675
c25ff208 6760.02003 Sun Feb 19 20:42:01 UTC 2006
1031d4f6 677 - Deprecated arguments: dsn, user, password, options
678 - New argument: connect_info
679
c25ff208 6800.02002 Sat Feb 18 19:53:12 UTC 2006
4350370d 681 - Added moniker_map and inflect_map
682
c25ff208 6830.02001 Fri Feb 17 20:25:40 UTC 2006
c2849787 684 - tests fixed up a bit
17725ccb 685 - auto-loading of on-disk class definitions layered on top
686 of the generated definitions (create Foo::Schema::Bar, then
687 also try to ->require it if it exists on disk).
688 - new parameters components and resultset_components, which do
689 the obvious for the generated table classes.
690 - DBIx::Class pre-req bumped to 0.05006, since Schema::Loader
691 is virtually gauranteed to cause subtle mod_perl problems
692 without those fixes.
c2849787 693
c25ff208 6940.02000 Sun Feb 12 22:43:47 UTC 2006
89ecd854 695 - Just docs/version update, 0.01004 code released as 0.02000
696
c25ff208 6970.01004 Tue Feb 7 03:58:01 UTC 2006
738705c6 698 - No longer tries to parse out the table name from the dsn for mysql,
699 was unneccesary vestigial code from previous method.
700
c25ff208 7010.01003 Mon Feb 6 14:57:56 UTC 2006
c5de0b0c 702 - Fixed the has_many side of _make_cond_rel
703
c25ff208 7040.01002 Fri Feb 3 23:14:38 UTC 2006
f654c972 705 - Email address typo :(
706
c25ff208 7070.01001 Fri Feb 3 05:15:41 UTC 2006
457eb8a6 708 - Fixed up some documentation issues
709 - Load C3 at the right time
710
aec93e93 7110.01 Fri Feb 3 01:53:46 UTC 2006
712 - original release
713 - created from DBIx::Class::Loader 0.14