Revision history for Perl extension DBIx::Class::Schema::Loader
-0.02007 Wed Mar 22 06:03:53 UTC 2006
+ - preliminary Informix support
+ - unregister dropped sources on rescan
+ - added 'preserve_case' option with support for SQLite, mysql, MSSQL and
+ Firebird/InterBase; removed the MSSQL 'case_sensitive_collation' and
+ the Firebird/InterBase 'unquoted_ddl' options in favor of it.
+ - support CamelCase table names and column names (in case-preserving
+ mode) at the v7 naming level
+ - rewrite datetime default functions as \'CURRENT_TIMESTAMP' where
+ possible (except for Sybase ASE) to ease cross-deployment
+ - use column_info instead of select to get Oracle column list (RT#42281)
+ - match quotes in MySQL parser in more places (RT#42101)
+ - fix unique detection in DB2 for multiple schemas (RT#39622)
+ - fix column name collisions with methods (RT#49443)
+ - fix loading MySQL views on older MySQL versions (RT#47399)
+
+0.06001 2010-04-10 01:31:12
+ - fix type info for MSSQL
+ - fix MSSQL collation detection on freetds tds version 8.0
+
+0.06000 2010-04-06 01:12:25
+ - better type info for MySQL
+ - initial MySQL data type tests (jhannah)
+ - don't set result_namespace if it's 'Result'
+ - support for MSSQL databases with case sensitive collation, manually
+ overridable with 'case_sensitive_collation' option
+ - do not try to detect driver and rebless when used with a custom
+ 'loader_class'
+ - suppress 'bad table or view' warnings for filtered tables/views
+ - croak if several tables reduce to an identical moniker (ribasushi)
+ - better type info for Sybase ASE
+ - better type info for Pg: sets sequence for serials, handles numerics
+ without precision
+ - better _tables_list for MSSQL
+ - pick up views in SQLite too
+ - better rel inflection using Lingua::EN::Inflect::Phrase
+ - cascade_delete and cascade_copy are turned off for has_many/might_have
+ by default, and belongs_to has on_delete => 'CASCADE', on_update =>
+ 'CASCADE' and is_deferrable => 1 by default, overridable via
+ relationship_attrs
+ - added config_file option for loading loader options from a file
+ - set inflate_datetime => 1 for 'AS getdate()' computed columns in
+ Sybase
+ - Firebird support
+ - use introspection pragmas instead of regexes to introspect SQLite
+ (hobbs)
+ - generate POD for refs correctly from column_info
+ - fix tables list, fk introspection and type info for SQL Anywhere
+
+0.05003 2010-02-20 05:19:51
+ - support for custom_column_info, datetime_timezone and datetime_locale
+ (rbo)
+ - improve parsing of SQLite tables when a column definition
+ spans multiple lines (hobbs)
+ - fix missing trailing _id stripping for some relationship
+ names (rbuels)
+ - fixed accessor POD bug, was not dereferencing scalar refs
+ before printing (rbuels)
+
+0.05002 2010-02-15 10:17:47
+ - support for SQLAnywhere via DBD::SQLAnywhere and ODBC
+ - fix picking up quoted tables for SQLite (RT#54538) patch from schwern
+ - validate class/component loader_options to make sure classes
+ are available before generating the schema, patch from bphillips
+
+0.05001 2010-02-05 14:29:27
+ - correct default_value for all backends with common tests
+ - fix bug with quoted Pg tables from $dbh->tables (RT#54338)
+ - add inflate_datetime => 0 to 'timestamp' types for Sybase
+
+0.05000 2010-02-01 09:24:24
+ - better data_type, default_value and size for Sybase
+ - added 'generate_pod' option, defaults to on
+ - added 'pod_comment_mode' and 'pod_comment_spillover_length' to
+ control table comment generation (waawaamilk)
+
+0.04999_14 2010-01-14 06:47:07
+ - use_namespaces now default, with upgrade/downgrade support
+ - filter out un-selectable tables/views
+ - fix NUMERIC/DECIMAL size column_info for postgres
+ - now mentions skip_load_external feature in comments (jhannah)
+ - moniker_map POD correction (jhannah)
+
+0.04999_13 2010-01-03 12:32:25
+ - exclude 'size' column_info for postgres when unnecessary, and
+ use the correct precision for varying types (except NUMERIC)
+ - 'naming' attribute and backward compatibility with 0.04006
+ - added relationship_attrs option for setting attributes in
+ generated relationships
+ - added overwrite_modifications option that ignores md5sums on
+ generated code
+ - added skip_load_external (jhannah)
+ - remove Class::Data::Accessor and Class::Accessor::Fast and switch
+ everything to Class::Accessor::Grouped (jhannah)
+ - better handling of db_schema for Oracle, based on (RT#35732)
+
+0.04999_12 2009-11-30 23:36:14
+ - fix MySQL rel introspection with on_connect_call =>
+ 'set_strict_mode' (RT#52087)
+ - now using base 'DBIx::Class::Core' for Results (RT#52141)
+
+0.04999_11 2009-11-29 18:08:46
+ - added patch to generate POD from postgres by Andrey Kostenko (GUGU)
+ - added test for norewrite feature
+ - fix default_value for MSSQL
+
+0.04999_10 2009-10-31 12:28:53
+ - patch from Robert Bohne to make _table_uniq_info more correct for
+ Oracle
+ - fix data_type for identity columns with MSSQL
+
+0.04999_09 2009-10-08
+ - Only redump the files when something has actually changed
+ - Place a warning at the top of the files saying 'do not modify' to
+ match the one at the bottom of the auto-gen'd section
+
+0.04999_08 2009-08-28
+ - Replace UNIVERSAL::require with Class::C3::Componentised
+ - Add Sybase/MSSQL support through DBD::Sybase
+ - use $dbh->get_info(29/41) for qote_car/name_sep if available (semifor)
+ - add MSSQL support through DBD::ODBC
+ - support MSSQL table names with a '.' in the name
+ - support MySQL CURRENT_TIMESTAMP()
+
+0.04999_07 2009-04-18
+ - Add result_base_class and schema_base_class options (RT #43977)
+ - Ignore duplicate uniq indices (including duplicates of the PK).
+ - Fix for DBD::SQLite 1.20
+ - Fix for DBIx::Class 0.08100
+
+0.04999_06 Tue Nov 11, 2008
+ - Singularise table monikers by default
+ - Strip trailing _id from single-column belongs_to relationships
+ - Add "dbicdump" script for easy commandline dumping
+ - Throw out the in-memory class generation, just dump to a temporary
+ directory if the user didn't specify one
+ - Fix Oracle constraint and auto-increment detection for non-owned schemas
+ (RT #35732)
+ - Handle ResultSetManager deprecation warning in common tests
+
+0.04999_05 Mon Apr 14, 2008
+ - Fix limiting table list to the specified schema for DB2
+ - Default db_schema to the username for DB2
+ - Allow specifying a custom loader_class, overriding the
+ storage_type-based detection
+ - Cosmetic fixes to dumping of externally defined classes
+ - Make ResultSetManager notice externally defined :ResultSet methods
+ - Fix test failure for non-InnoDB MySQL due to wrong skip count
+ - Fix base class ordering in dumped classes
+ - Run the common tests against both dynamic and dumped versions of
+ the schema
+
+0.04999_04 Wed Mar 12, 2008
+ - Add is_auto_increment detecton for DB2
+
+0.04999_03 Wed Mar 12, 2008
+ - Fix DB2 support
+
+0.04999_02 Tue Feb 12, 2008
+ - Add is_auto_increment detection for Oracle
+ - Unnhide the Oracle module now that the CPAN perms are sorted
+ out. Thanks to Tsunoda Kazuya for the quick response.
+
+0.04999_01 Tue Feb 5, 2008
+ - Mark foreign key columns with is_foreign_key => 1
+ - Add support for vendor-specific extra column attributes.
+ - Add support for extra => { unsigned => 1 } for MySQL.
+ - Add support for enum value lists for MySQL
+ - Set join_type => 'LEFT OUTER' for nullable foreign keys
+ (patch from Bernhard Weißhuhn)
+ - Set is_auto_increment for auto-increment columns (RT #31473)
+ (Only SQLite, MySQL and PostgreSQL are currently supported)
+ - Generate one-to-one accessors for unique foreign keys (ilmari)
+ - Add support for load_namespaces-style class layout
+ - Fix test skip count for main skip_rels block
+ - Fix auto-inc column creation for the Oracle tests
+ - Fix column ordering in unique constraints for Oracle
+ - Fix Win32 test skip counts for good (RT #30568, Kenichi Ishigaki)
+ - Default Oracle db_schema to db username (patch
+ from Johannes Plunien)
+
+0.04003 Wed Oct 4, 2007
+ - Prevent users from running Kwalitee test automatically
+ - Fix extra whitespace being added to output on
+ regeneration (from ilmari)
+
+0.04002 Tue Jul 24, 2007
+ - rescan method now returns the actual list of new tables
+ loaded (previously, the return value wasn't taking
+ constraint/exclude into account, even though the meat
+ of the operation was).
+ - Hid the Oracle module so that search.cpan.org will stop
+ ignoring this package, temporary fix until perms are
+ sorted out
+ - Fix Win32 test skip counts (RT #27715, Alexandr Ciornii)
+ - Fix a small output quoting bug (RT #28073, Tokuhiro Matsuno)
+
+0.04001 Tue Jun 26, 2007
+ - Deprecated dump_overwrite. The changed behavior from
+ 0.03xxx was confusing.
+ - Added new option really_erase_my_files, which does what
+ dump_overwrite did in 0.04000, which is not what it did
+ in 0.03xxx.
+
+0.04000 Thu Jun 7, 2007
+ - Added some env vars for controlling the Makefile.PL feature
+ questions, to make automation easier.
+
+0.03999_02 Tue May 22, 2007
+ - Converted to Module::Install
+
+0.03012 Tue May 22, 2007
+ - Relationship names for multiple multi-col rels between
+ the same table fixed by ilmari
+ - Fix from Marc Espie for CREATE TABLE 'foo' for SQLite
+ - skip ^sqlite_ tables in SQLite (thanks chromatic)
+
+0.03999_01 Sat Apr 14 19:57:40 GMT 2007
+ - Added *experimental* Oracle support from work done
+ by Tsunoda Kazuya some months ago. Not well tested.
+ - Added "rescan" schema (and loader) method, which picks
+ up newly created tables at runtime
+ - Made dump_to_dir / dump_overwrite much more intelligent
+ (they now preserve customizations by default)
+ - Added support for DBI's new standard "statistics_info"
+ method to gather unique key info (only supported by
+ DBD::Pg trunk afaik)
+ - columns_info_for imported from DBIx::Class
+ - relationships are now on by default, use skip_relationships
+ to disable them
+ - Removed previously deprecated methods/options
+ - Added $VERSION to all packages in this dist
+
+0.03011 Sat Apr 14 19:03:07 UTC 2007
+ - fix case-sensitivity in UNIQUE parsing for SQLite
+
+0.03010 Thu Mar 29 12:36:19 UTC 2007
+ - Workaround for new incompatible changes in DBD::mysql's "tables"
+ method, which was causing us to find no tables w/ DBD::mysql
+ 4.002+
+ - Fixed quoting problem in _table_columns (could cause crash when
+ dumping/doing a static create) (from ash)
+
+0.03009 Wed Nov 15 14:03:37 UTC 2006
+ - fix for rt.cpan.org #22425 (use File::Spec where appropriate)
+ - use full instead of short classnames in relationships (from victori)
+
+0.03008 Fri Oct 20 18:08:20 UTC 2006
+ - fix for rt.cpan.org #21084 (dump_overwrite pathological output recursion)
+ - fix for rt.cpan.org #21758 (mysql reserved words as table names)
+ - fix for rt.cpan.org #21025 (SQLite FK parsing)
+ - workaround for rt.cpan.org #21746 ($Class::Accessor::Fast::VERSION issues)
+
+0.03007 Thu Jul 27 16:19:59 UTC 2006
+ - Kill erroneous warning about connect/loader_options order (the real
+ case is warned about elsewhere)
+ - Fix t/22dump to work around ActiveState issues
+
+0.03006 Wed Jul 26 00:14:58 UTC 2006
+ - Fixed column-case issue w/ columns_info_for
+
+0.03005 Wed Jul 19 15:09:30 UTC 2006
+ [ Pretty much everything in this release originates from nilsonsfj patches ]
+ - bugfix: mysql unique constraint code had an
+ obvious but longstanding error
+ - bugfix: columns were being specified out-of-order,
+ bug was introduced in the 0.03004 column metadata
+ dumping feature
+ - dump code now skips+warns instead of dies when
+ dump_overwrite not set
+
+0.03004 Tue Jul 11 04:38:09 UTC 2006
+ - make_schema_at efficiency improvements
+ - improved debugging output
+ - column metadata now included in dumped schemas
+ - Carp::Clan added, and some dies converted to croaks
+ - no longer overwrites files when dumping, unless asked
+ to do so via the dump_overwrite option
+ - loader_options can now be embedded in the connection info
+ - Documentation improvements
+ - Deprecation notices updated, most things that became
+ "deprecated" in 0.03 are now marked for death in 0.04000
+ - All deprecated usage patterns should now generate annoying
+ warnings (most did before).
+ - Somewhat improved test coverage
+
+0.03003 Tue Jun 6 02:22:49 UTC 2006
+ - Fix inclusion of external add-on class definitions
+ in dump_to_dir output.
+
+0.03002 Tue Jun 6 01:27:25 UTC 2006
+ - rethrow exceptions that occur during make_schema_at
+
+0.03001 Mon Jun 5 23:17:57 UTC 2006
+ - load_from_connection deprecation notice now mentions
+ upgrading Catalyst::Model::DBIC::Schema if that module
+ seems to be in use.
+ - DBIx::Class required version number fixed
+ - Loader statement caching for better load-time performance
+ - Improved Pg unique index loader, based on RDBO
+
+0.03000 Tue May 23 12:56:05 UTC 2006
+ - weakened the circular schema reference
+
+0.02999_10 Mon May 22 18:58:20 UTC 2006
+ - a few more small bugfixes
+ - more dump/debug improvements
+ - new exportable function "make_schema_at"
+
+0.02999_09 Sun May 21 23:26:58 UTC 2006
+ - More docs improvements
+ - default uniq_info just warns and returns nothing now,
+ instead of dying. In theory, this allows unsupported
+ DBD drivers to potentially work with this module, if
+ the generic methods happen to work for that vendor.
+ - New tests for the various current and legacy/deprecated
+ methods of connecting a Schema::Loader class/object.
+ - Bugfix to the new runtime object connect/load code.
+
+0.02999_08 Sat May 20 22:36:45 UTC 2006
+ - support for dumping to a directory for
+ conversion to manual DBIx::Class::Schema
+ - improved debugging output
+ - more documentation updates
+ - more backwards compatibility fixes
+ - runtime connection definitions (and cloning) work fine now.
+ - A couple of bugfixes related to db vendor "schemas", including
+ a fix for http://rt.cpan.org/Public/Bug/Display.html?id=19164
+
+0.02999_06 Thu May 18 16:32:41 UTC 2006
+ - backwards compat with all earlier versions
+ - no longer requires schema class to have a connection
+ - correctly determine source class names in the rel code generator
+ - fixed mysql testing w/o InnoDB
+ - Writing guide updated
+ - docs updated
+ - various trivial updates / fixes
+
+0.02999_05 Sun Mar 26 06:46:09 UTC 2006
+ - bugfixes to constraint/exclude code
+ - friendly warnings if we don't find any tables
+ - inflect_map becomes inflect_plural and inflect_singular
+ - Singularize relationship names where appropriate
+ - Test updates
+ - Supports multiple rels between the same pair of tables
+
+0.02007 Wed Mar 22 06:03:53 UTC 2006
- Backported Class::C3::reinitialize changes from -refactor
- branch, resulting in significantly reduced load time
+ branch, resulting in significantly reduced load time
-0.02006 Fri Mar 17 04:55:55 UTC 2006
+0.02006 Fri Mar 17 04:55:55 UTC 2006
- Fix long-standing table/col-name case bugs
-0.02005 Mon Feb 27 23:53:17 UTC 2006
+0.02999_04 Fri Mar 17 03:55:09 UTC 2006
+ - Fixed case-sensitivity issues for table/col names
+ - Punt columns_info_for to ->storage
+ - Large loading speedup (get rid of redundant C3 reinits)
+ - Removed TEST_POD checks
+ - Removed unneccesary storage->disconnect
+
+0.02999_03 Mon Mar 13 15:01:11 UTC 2006
+ - Added EXAMPLE section to pod [Kieren Diment]
+ - Invasive heavy changes to the DBI- and vendor-specific code
+ (expect some breakage in some cases until this settles down)
+ - Support for loading UNIQUE constraints
+ - Tests cleaned up a bit
+ - Relationship building seperated out into it's own file for
+ the changes that are coming, but still does basically what
+ it did before (this work is the next step).
+
+0.02999_02 Sat Mar 4 16:53:21 UTC 2006
+ - Merged in relevant changes from trunk since the split
+
+0.02005 Mon Feb 27 23:53:17 UTC 2006
- Move the external file loading to after everything else
- loader does, in case people want to define, override, or
- build on top of the rels.
+ loader does, in case people want to define, override, or
+ build on top of the rels.
-0.02004 Mon Feb 27 23:53:17 UTC 2006
+0.02004 Mon Feb 27 23:53:17 UTC 2006
- Minor fix to debugging message for loading external files
-0.02003 Sun Feb 19 20:42:01 UTC 2006
+0.02999_01 Sun Feb 28 00:24:00 UTC 2006
+ - Shuffle the modules around
+ - Make ourselves theoretically storage_type-agnostic
+ - Remove the _db_classes stuff, bump PK::Auto to Base
+ - Change default inflections to Lingua::EN::Inflect::Number::to_PL()
+
+0.02003 Sun Feb 19 20:42:01 UTC 2006
- Deprecated arguments: dsn, user, password, options
- New argument: connect_info
-0.02002 Sat Feb 18 19:53:12 UTC 2006
+0.02002 Sat Feb 18 19:53:12 UTC 2006
- Added moniker_map and inflect_map
-0.02001 Fri Feb 17 20:25:40 UTC 2006
+0.02001 Fri Feb 17 20:25:40 UTC 2006
- tests fixed up a bit
- auto-loading of on-disk class definitions layered on top
of the generated definitions (create Foo::Schema::Bar, then
is virtually gauranteed to cause subtle mod_perl problems
without those fixes.
-0.02000 Sun Feb 12 22:43:47 UTC 2006
+0.02000 Sun Feb 12 22:43:47 UTC 2006
- Just docs/version update, 0.01004 code released as 0.02000
-0.01004 Tue Feb 7 03:58:01 UTC 2006
+0.01004 Tue Feb 7 03:58:01 UTC 2006
- No longer tries to parse out the table name from the dsn for mysql,
was unneccesary vestigial code from previous method.
-0.01003 Mon Feb 6 14:57:56 UTC 2006
+0.01003 Mon Feb 6 14:57:56 UTC 2006
- Fixed the has_many side of _make_cond_rel
-0.01002 Fri Feb 3 23:14:38 UTC 2006
+0.01002 Fri Feb 3 23:14:38 UTC 2006
- Email address typo :(
-0.01001 Fri Feb 3 05:15:41 UTC 2006
+0.01001 Fri Feb 3 05:15:41 UTC 2006
- Fixed up some documentation issues
- Load C3 at the right time