10 years agoUse skip_all or diag for missing RDBMS test dependencies
Dagfinn Ilmari Mannsåker [Mon, 28 Jul 2014 17:40:36 +0000]
Use skip_all or diag for missing RDBMS test dependencies

This way we get a list of all the missing modules if DBICTEST_FOO_DSN
is set, but something is missing.

10 years agoBump MooseX::NonMoose - the Zefram strikes back
Peter Rabbitson [Thu, 12 Jun 2014 03:06:27 +0000]
Bump MooseX::NonMoose - the Zefram strikes back

10 years agoRelease 0.07040 0.07040
Dagfinn Ilmari Mannsåker [Tue, 27 May 2014 18:14:30 +0000]
Release 0.07040

10 years agoFix stray tab in Changes file
Dagfinn Ilmari Mannsåker [Tue, 27 May 2014 16:46:02 +0000]
Fix stray tab in Changes file

10 years agoAvoid clobbering caller's $_ (RT#96010)
Dagfinn Ilmari Mannsåker [Tue, 27 May 2014 16:37:21 +0000]
Avoid clobbering caller's $_ (RT#96010)

10 years agoFix inconsistent naming of duplicate unique constraints
Dagfinn Ilmari Mannsåker [Wed, 21 May 2014 16:50:59 +0000]
Fix inconsistent naming of duplicate unique constraints

Sort the constraints by name in _table_uniq_info, so we consistently
pick the same constraint if there are several on the same set of
columns.

10 years agoAdd moritz to CONTRIBUTORS in dbicdump too
Dagfinn Ilmari Mannsåker [Sun, 20 Apr 2014 16:43:16 +0000]
Add moritz to CONTRIBUTORS in dbicdump too

10 years agoAdd moritz to CONTRIBUTORS
Dagfinn Ilmari Mannsåker [Sun, 20 Apr 2014 16:42:12 +0000]
Add moritz to CONTRIBUTORS

10 years agoFix name and encoding
Moritz Lenz [Sun, 20 Apr 2014 16:12:29 +0000]
Fix name and encoding

10 years agoImprove config example in dbicdump
Moritz Lenz [Sun, 20 Apr 2014 15:21:25 +0000]
Improve config example in dbicdump

it was not apparent to me that dump_directory belongs into the
loader_options section, so make it obvious in the example

10 years agoFix dumping unique indexes with DBD::Pg < 1.50
Dagfinn Ilmari Mannsåker [Sat, 5 Apr 2014 20:56:18 +0000]
Fix dumping unique indexes with DBD::Pg < 1.50

10 years agoSkip dumping unique indexes with expressions (RT#93613)
Dagfinn Ilmari Mannsåker [Fri, 4 Apr 2014 15:27:22 +0000]
Skip dumping unique indexes with expressions (RT#93613)

DBD::Pg 3.0.0 returns expression indexes from ->statistics_info, with
COLUMN_NAME => undef and pg_expression => $expression.  Because
->_table_uniq_info just skipped individual rows without COLUMN_NAME,
an index contains a mix of plain columns and expressions would
generate erroneous ->add_unique_constraint() calls.

10 years agoAdd Dag-Erling Smørgrav to CONTRIBUTORS
Dagfinn Ilmari Mannsåker [Fri, 4 Apr 2014 13:36:49 +0000]
Add Dag-Erling Smørgrav to CONTRIBUTORS

10 years agoAdd options to omit the version and timestamp from the generated code (RT#92300)
Dag-Erling Smørgrav [Fri, 4 Apr 2014 13:26:27 +0000]
Add options to omit the version and timestamp from the generated code (RT#92300)

10 years agoRelease 0.07039 0.07039
Dagfinn Ilmari Mannsåker [Mon, 6 Jan 2014 17:55:26 +0000]
Release 0.07039

10 years agoFix generated_classes with dry_run => 1
Dagfinn Ilmari Mannsåker [Mon, 6 Jan 2014 15:33:20 +0000]
Fix generated_classes with dry_run => 1

10 years agoAdd dry-run mode for static schema creation
Dagfinn Ilmari Mannsåker [Tue, 26 Nov 2013 17:36:07 +0000]
Add dry-run mode for static schema creation

10 years agoAdd accessor for the list of (re)generated classes
Dagfinn Ilmari Mannsåker [Tue, 26 Nov 2013 17:28:05 +0000]
Add accessor for the list of (re)generated classes

10 years agoConvert t/22dump.t to done_testing()
Dagfinn Ilmari Mannsåker [Mon, 6 Jan 2014 13:46:49 +0000]
Convert t/22dump.t to done_testing()

10 years agoAdd mailmap file
Dagfinn Ilmari Mannsåker [Thu, 2 Jan 2014 21:59:49 +0000]
Add mailmap file

10 years agoadd myself to contributors pod
Matt Phillips [Thu, 2 Jan 2014 21:28:42 +0000]
add myself to contributors pod

10 years agoSupport for DBD::DB2 1.85 as well as < 1.85
Matt Phillips [Tue, 3 Sep 2013 16:21:45 +0000]
Support for DBD::DB2 1.85 as well as < 1.85

IBM attempted to become compatible with the DBI spec with their latest release,
but seem to have failed. This tweak fixes support for all versions of the DBD.

10 years agoSwap order of _relnames_and_method return values
Dagfinn Ilmari Mannsåker [Fri, 20 Dec 2013 22:06:29 +0000]
Swap order of _relnames_and_method return values

It makes more sense to have the local relname first, then the remote
relname and method. Note that this plus the previous commit are not a
no-op, since the meanings of the names have changed.

10 years agoSwap local_relname and remote_relname around in RelBuilder
Dagfinn Ilmari Mannsåker [Fri, 20 Dec 2013 21:47:47 +0000]
Swap local_relname and remote_relname around in RelBuilder

All the other remote/local names refer to things _on_ the respective
tables, except these, which referred to the name of the rel _to_ the
named table. Fixing this longstanding inconsistency makes the code
easier to understand (IMHO, at least).

10 years agoUse hash slice assignment instead of loop
Dagfinn Ilmari Mannsåker [Fri, 20 Dec 2013 19:28:33 +0000]
Use hash slice assignment instead of loop

10 years agoRe-wrap and re-indent for readability and consistency
Dagfinn Ilmari Mannsåker [Fri, 20 Dec 2013 19:11:40 +0000]
Re-wrap and re-indent for readability and consistency

10 years agoRelease 0.07038 0.07038
Dagfinn Ilmari Mannsåker [Wed, 20 Nov 2013 11:38:16 +0000]
Release 0.07038

10 years agoFix detection of qualified sequence names for Oracle (RT#90341)
Dagfinn Ilmari Mannsåker [Fri, 15 Nov 2013 15:03:44 +0000]
Fix detection of qualified sequence names for Oracle (RT#90341)

10 years agoFix national character type sizes on DBD::Oracle >= 1.52
Dagfinn Ilmari Mannsåker [Tue, 19 Nov 2013 18:36:01 +0000]
Fix national character type sizes on DBD::Oracle >= 1.52

Older versions erroneously reported the size in bytes (using UTF-16),
not characters.

10 years agoActually test data types that require separate tables
Dagfinn Ilmari Mannsåker [Tue, 19 Nov 2013 18:32:42 +0000]
Actually test data types that require separate tables

10 years agoFix moniker_map callback test for upcasing databases (e.g. Oracle)
Dagfinn Ilmari Mannsåker [Tue, 19 Nov 2013 18:31:25 +0000]
Fix moniker_map callback test for upcasing databases (e.g. Oracle)

10 years agoFix skip count for Oracle multi-schema tests
Dagfinn Ilmari Mannsåker [Tue, 19 Nov 2013 18:27:26 +0000]
Fix skip count for Oracle multi-schema tests

10 years agoupdate repository url
David Steinbrunner [Fri, 15 Nov 2013 17:46:25 +0000]
update repository url

10 years agoFix MySQL column info detection with multiple schemas (RT#82358)
Dagfinn Ilmari Mannsåker [Fri, 15 Nov 2013 17:38:17 +0000]
Fix MySQL column info detection with multiple schemas (RT#82358)

Specifically, if similarly-named tables exist in multiple schemas, we
might get the column info for the wrong one.

10 years agoAllow coderef maps to call back into the hashref mapping code
Dagfinn Ilmari Mannsåker [Thu, 7 Nov 2013 13:53:42 +0000]
Allow coderef maps to call back into the hashref mapping code

11 years agoRelease 0.07037 0.07037
Dagfinn Ilmari Mannsåker [Wed, 30 Oct 2013 12:44:41 +0000]
Release 0.07037

11 years agoAllow overriding individual moniker parts
Dagfinn Ilmari Mannsåker [Fri, 25 Oct 2013 15:48:43 +0000]
Allow overriding individual moniker parts

If there's no moniker_map entry, moniker_part_map is consulted for each
part individually.

11 years agoRelease 0.07036_04 0.07036_04
Dagfinn Ilmari Mannsåker [Thu, 24 Oct 2013 11:57:53 +0000]
Release 0.07036_04

11 years agoSet $result_source_class->table_class appropriately on views
Aaron Crane [Sun, 29 Sep 2013 13:19:19 +0000]
Set $result_source_class->table_class appropriately on views

This constitutes partial support for the per-backend TODO items labelled
"introspect view SQL".  I've therefore left those items unchanged for the
backends that are now known to support this, and added a note for this part
of the work to the other backends.

Backends whose DBD implements enough of the DBI table_info method to indicate
whether a relation is in fact a view should also acquire support for setting
table_class, but there are no tests for other backends, so they haven't been
declared working.

11 years agoPush table-equality checks into _dbh_table_info
Aaron Crane [Sun, 29 Sep 2013 13:11:06 +0000]
Push table-equality checks into _dbh_table_info

Some DBDs don't support table_info.  Even in those that do, we may need
to iterate over the table_info data to find the entry that exactly
matches the table we want.

11 years agoRelease 0.07036_03 0.07036_03
Dagfinn Ilmari Mannsåker [Tue, 22 Oct 2013 10:50:59 +0000]
Release 0.07036_03

11 years agoUse sigwarn_silencer() everywhere appropriate
Dagfinn Ilmari Mannsåker [Tue, 22 Oct 2013 00:05:21 +0000]
Use sigwarn_silencer() everywhere appropriate

11 years agoSilence warnings from pure-perl Cwd::abs_path()
Dagfinn Ilmari Mannsåker [Mon, 21 Oct 2013 23:35:21 +0000]
Silence warnings from pure-perl Cwd::abs_path()

11 years agoFix t/23dumpmore on perl 5.8.8 and earlier
Dagfinn Ilmari Mannsåker [Mon, 21 Oct 2013 17:36:20 +0000]
Fix t/23dumpmore on perl 5.8.8 and earlier

/m isn't honoured for $ when matching a pre-compiled regex (qr//), so
just drop the anchoring

11 years agoMerge branch 'topic/better-multi-schema' into master
Dagfinn Ilmari Mannsåker [Sun, 20 Oct 2013 14:25:06 +0000]
Merge branch 'topic/better-multi-schema' into master

11 years agoRelease 0.07036_02 0.07036_02
Dagfinn Ilmari Mannsåker [Wed, 25 Sep 2013 12:36:57 +0000]
Release 0.07036_02

11 years agoFully-qualify all pg_catalog.* names
Dagfinn Ilmari Mannsåker [Wed, 25 Sep 2013 12:29:23 +0000]
Fully-qualify all pg_catalog.* names

11 years agoRestore support for PostgreSQL 8.3 (RT#87291)
Dagfinn Ilmari Mannsåker [Wed, 25 Sep 2013 12:17:13 +0000]
Restore support for PostgreSQL 8.3 (RT#87291)

Instead of using a subselect with unnest(array), join agaist a
generate_series() matching the array indices.

11 years agoRemove implemented FK introspection items from TODO
Dagfinn Ilmari Mannsåker [Tue, 24 Sep 2013 17:07:14 +0000]
Remove implemented FK introspection items from TODO

11 years agoRemove implemented items from TODO
Dagfinn Ilmari Mannsåker [Tue, 24 Sep 2013 16:55:08 +0000]
Remove implemented items from TODO

11 years agoThis branch deals with multiple schemas
Dagfinn Ilmari Mannsåker [Tue, 24 Sep 2013 16:46:46 +0000]
This branch deals with multiple schemas

11 years agoDocument fully-qualified constraint/exclude
Dagfinn Ilmari Mannsåker [Wed, 4 Sep 2013 11:02:59 +0000]
Document fully-qualified constraint/exclude

11 years agoSkip many_to_many bridges involving might_have relationships
D. Ilmari Mannsåker [Mon, 16 Sep 2013 11:19:09 +0000]
Skip many_to_many bridges involving might_have relationships

If one or both of the relationsips is a one-to-one relatiohip,
the bridge should be one-to-many or one-to-one, respectively.

However, DBIx::Class doesn't support such bridges, so skip them
for now, keeping the option open to add support if/when DBIC does,
without having to worry about back-compat shenanigans.

This reverts commit b0cdc8a5bc6db9206a53e52bd9c868ba8442ca2b
and fixes the crash differently.

11 years agoRelease 0.07036_01 0.07036_01
Dagfinn Ilmari Mannsåker [Sun, 11 Aug 2013 12:09:05 +0000]
Release 0.07036_01

11 years agoAllow matching all the moniker parts in constraint/exclude
Dagfinn Ilmari Mannsåker [Mon, 29 Jul 2013 19:35:52 +0000]
Allow matching all the moniker parts in constraint/exclude

11 years agoAllow using all the moniker parts in hashref moniker_map
Dagfinn Ilmari Mannsåker [Wed, 24 Jul 2013 21:36:30 +0000]
Allow using all the moniker parts in hashref moniker_map

11 years agoAllow specifying the moniker part separator
Dagfinn Ilmari Mannsåker [Sun, 21 Jul 2013 12:23:11 +0000]
Allow specifying the moniker part separator

Used between the parts specified by "moniker_parts", defaults to the
empty string.

11 years agoAllow specifying custom attributes for many_to_many bridges
Dagfinn Ilmari Mannsåker [Sun, 11 Aug 2013 11:00:51 +0000]
Allow specifying custom attributes for many_to_many bridges

11 years agoFix many_to_many bridges involving might_have relationships
Dagfinn Ilmari Mannsåker [Tue, 6 Aug 2013 21:57:04 +0000]
Fix many_to_many bridges involving might_have relationships

11 years agoDon't ship MYMETA.* files (RT#87713)
Dagfinn Ilmari Mannsåker [Sun, 11 Aug 2013 10:43:04 +0000]
Don't ship MYMETA.* files (RT#87713)

11 years agoDemote diag about skip reason to note
Dagfinn Ilmari Mannsåker [Tue, 6 Aug 2013 22:06:24 +0000]
Demote diag about skip reason to note

11 years agoFix typos in POD and comments (RT#87644)
Dagfinn Ilmari Mannsåker [Tue, 6 Aug 2013 19:52:21 +0000]
Fix typos in POD and comments (RT#87644)

11 years agoAvoid conditional assignment in variable declarations
Dagfinn Ilmari Mannsåker [Sun, 21 Jul 2013 12:20:11 +0000]
Avoid conditional assignment in variable declarations

any() already returns a boolean, just assign it directly

11 years agoRelease 0.07036 0.07036
D. Ilmari Mannsåker [Mon, 8 Jul 2013 12:25:18 +0000]
Release 0.07036

11 years agoIgnore dist directory
D. Ilmari Mannsåker [Mon, 8 Jul 2013 13:11:53 +0000]
Ignore dist directory

11 years agoIgnore Emacs droppings
D. Ilmari Mannsåker [Mon, 8 Jul 2013 12:23:57 +0000]
Ignore Emacs droppings

11 years agoFix ordering issues in Pg loader
D. Ilmari Mannsåker [Mon, 8 Jul 2013 13:19:27 +0000]
Fix ordering issues in Pg loader

- Order foreign keys by name
- Order enum values by explicit order column or OID if unavailable

11 years agoFix tabs in Changes file
D. Ilmari Mannsåker [Mon, 8 Jul 2013 12:10:30 +0000]
Fix tabs in Changes file

11 years agoFix "table" parameter in col_accessor_map callback (RT#84050)
D. Ilmari Mannsåker [Mon, 8 Jul 2013 12:09:30 +0000]
Fix "table" parameter in col_accessor_map callback (RT#84050)

Keep the old, erroneous "table_name" for backward compatibility.

11 years agoFix MySQL enums with empty strings and leading/trailing quotes (RT#86091)
D. Ilmari Mannsåker [Mon, 8 Jul 2013 11:38:22 +0000]
Fix MySQL enums with empty strings and leading/trailing quotes (RT#86091)

11 years agoFix stray comma in Pg on_delete/on_update => CASCADE (RT#84706)
Dagfinn Ilmari Mannsåker [Thu, 18 Apr 2013 07:52:15 +0000]
Fix stray comma in Pg on_delete/on_update => CASCADE (RT#84706)

11 years agoRelease 0.07035 0.07035
John SJ Anderson [Tue, 26 Feb 2013 14:51:04 +0000]
Release 0.07035

11 years agoRelease 0.07034_02 0.07034_02
John SJ Anderson [Tue, 22 Jan 2013 04:57:06 +0000]
Release 0.07034_02

11 years agoFix fixtures to work with older DBD::SQLite
John SJ Anderson [Tue, 22 Jan 2013 04:49:11 +0000]
Fix fixtures to work with older DBD::SQLite

11 years agoRelease 0.07034_01 0.07034_01
John SJ Anderson [Thu, 17 Jan 2013 01:17:27 +0000]
Release 0.07034_01

11 years agoFix typo in t/46relationships_multi_m2m.t
John SJ Anderson [Wed, 16 Jan 2013 16:41:42 +0000]
Fix typo in t/46relationships_multi_m2m.t

s/twoes/twos/

11 years agoRemove implemented item from TODO
Dagfinn Ilmari Mannsåker [Thu, 22 Nov 2012 19:01:49 +0000]
Remove implemented item from TODO

11 years agopass link table details to rel_name_map for many_to_many bridges (RT#81091)
Dagfinn Ilmari Mannsåker [Sat, 10 Nov 2012 23:01:59 +0000]
pass link table details to rel_name_map for many_to_many bridges (RT#81091)

If two tables have multiple many-to-many link tables between them, the
rel_name_map coderef needs to know which link table it's naming the rel
for.

11 years agoReorganize and freshen up deps
Peter Rabbitson [Thu, 15 Nov 2012 10:19:56 +0000]
Reorganize and freshen up deps

12 years agobetter schemas support for SQL Server > 2000
Rafael Kitover [Wed, 17 Oct 2012 18:49:35 +0000]
better schemas support for SQL Server > 2000

Use schema_name() instead of user_name() on > 2000 to detect the
current schema, and query [$db].sys.schemas instead of
[$db].dbo.sysusers for schema names on > 2000.

frew has reported that schema_name() has worked better for him for users
which aren't the owners of the schema.

12 years agointrospect ON DELETE/UPDATE for SQL Anywhere
Rafael Kitover [Tue, 16 Oct 2012 18:45:13 +0000]
introspect ON DELETE/UPDATE for SQL Anywhere

The default seems to be RESTRICT, but it's hard to tell, because the
actions are implemented as triggers and you have to query the catalog
triggers view to get at them. At least if you specify RESTRICT there is
no trigger generated.

SQL Anywhere does not support DEFERRABLE constraints. It has something
called CHECK ON COMMIT but that does not seem to have the same full
functionality, so for now we leave is_deferrable at 1.

12 years agoPg _table_fk_info to use catalog not info_schema
Rafael Kitover [Tue, 16 Oct 2012 03:00:55 +0000]
Pg _table_fk_info to use catalog not info_schema

Rewrite Pg _table_fk_info query to use the catalog views rather than the
information_schema, as a user on IRC reported that the
information_schema query does not work for readonly Pg users, but the
catalog query does work.

12 years agoupdate deps on ::Phrase and ::Tagger
Rafael Kitover [Tue, 2 Oct 2012 18:41:00 +0000]
update deps on ::Phrase and ::Tagger

Update the dep on Lingua::EN::Inflect::Phrase to 0.15 which is much
improved.

Update the dep on Lingua::EN::Tagger to the newest, 0.23 because 0.20
and earlier generated a warning which made Schema::Loader tests fail
(unescaped braces in regex) in perls version 5.17+.

12 years agoadd rel_type param for relationship_attrs coderef
Rafael Kitover [Mon, 10 Sep 2012 14:23:18 +0000]
add rel_type param for relationship_attrs coderef

Forgot to pass some sort of param for the rel type for the
relationship_attrs coderef, adding 'rel_type' with the value
'belongs_to', 'has_many' or 'might_have'.

Add tests to 45relationships.t and doc in ::Base POD.

12 years agorelease 0.07033 0.07033
Rafael Kitover [Sun, 9 Sep 2012 16:12:23 +0000]
release 0.07033

12 years agoadd a loud warning to Makefile.PL about rel attrs
Rafael Kitover [Sun, 9 Sep 2012 16:09:28 +0000]
add a loud warning to Makefile.PL about rel attrs

Print a big boxed warning when running Makefile.PL (e.g. when installing
via CPAN) about the changes to belongs_to relationship attributes in the
last few revisions at the prompting of mst.

12 years agoexpand relationship_attrs POD
Rafael Kitover [Sun, 9 Sep 2012 15:09:19 +0000]
expand relationship_attrs POD

Explain the defaults for relationship attributes, how they are
overridden by the actual database values for foreign keys and can be
overridden by the user via this attribute.

Also explain how defaults are chosen for different databases for
belongs_to rels.

12 years agorelease 0.07032 0.07032
Rafael Kitover [Sun, 9 Sep 2012 13:18:00 +0000]
release 0.07032

12 years agodetect inline deferrable FKs for SQLite
Rafael Kitover [Sun, 9 Sep 2012 13:12:08 +0000]
detect inline deferrable FKs for SQLite

The previous attempt to detect DEFERRABLE on FKs only detected for
FOREIGN KEY clauses in DDL, not for inline constraints such as:

    int foo references bar(id) deferrable

add code and tests to detect inline FKs as well.

12 years agosupport coderef for relationship_attrs
Rafael Kitover [Sun, 9 Sep 2012 01:26:38 +0000]
support coderef for relationship_attrs

Add support for passing a coderef as relationship_attrs and describe
thorougly in the ::Base POD (as well as improve the existing POD for
 it.)

This is the list of parameters:

 * rel_name

 * local_source

 * remote_source

 * local_table

 * local_cols

 * remote_table

 * remote_cols

 * attrs

The hash is passed as a list, not as a hashref.

The coderef must return a hashref of attributes or nothing.

This is thoroughly tested in t/45relationships.t.

I had to add a fallback => 1 to the DBObject.pm stringification
overload, so that eq would work, and this makes the stringification much
more functional.

12 years agoauthor dep on POD test modules, check in 02pod.t
Rafael Kitover [Thu, 6 Sep 2012 16:39:17 +0000]
author dep on POD test modules, check in 02pod.t

Use ::Optional::Dependencies for POD testing modules, so that they are
author deps and the minimum required version of Pod::Simple (3.22, which
checks that the correct =encoding is set) is also used.

12 years agochange =encoding utf8 to =encoding UTF-8 in Loader
Rafael Kitover [Thu, 6 Sep 2012 16:04:13 +0000]
change =encoding utf8 to =encoding UTF-8 in Loader

I didn't know why 02pod.t was erroneously passing for me, ilmari pointed
out that my Pod::Simple was out of date, and I needed at least 3.21.

Upgrading Pod::Simple caused 02pod.t to produce the fail when the
=encoding directive was missing.

I like using the UTF-8 encoding rather than the more lax utf8 encoding,
so change it now that I can properly test it out.

12 years agorelease 0.07031 0.07031
Rafael Kitover [Thu, 6 Sep 2012 15:10:13 +0000]
release 0.07031

12 years agofix 02pod.t fail for lack of =encoding (RT#79481)
Rafael Kitover [Thu, 6 Sep 2012 14:56:49 +0000]
fix 02pod.t fail for lack of =encoding (RT#79481)

Users report 02pod.t failing due to a UTF-8 character without an
=encoding utf8 statement (arcanez and Marcel Gruenauer.)

For some reason this test passes on my machine, even though I have the
latest Test::Pod.

Marcel Gruenauer sent me a patch to RT which adds the =encoding utf8
statement at the top of the POD, which I added.

I want to use =encoding UTF-8 instead, since that's more correct, but
since I can't test it will leave utf8.

12 years agorelease 0.07030 0.07030
Rafael Kitover [Thu, 6 Sep 2012 03:30:53 +0000]
release 0.07030

12 years agoallow user to set qualify_objects to false
André Walker [Thu, 6 Sep 2012 02:43:07 +0000]
allow user to set qualify_objects to false

The qualify_objects attribute in the DBIx::Class::Schema::Loader::Base
was automatically set to true when there were multiple db_schema's, even
if the user explicitly set it to false. This changes that behaviour,
allowing more flexibility on prefixing the names.

12 years agorelease 0.07029 0.07029
Rafael Kitover [Wed, 5 Sep 2012 16:43:45 +0000]
release 0.07029

12 years agointrospect ON DELETE and DEFERRABLE for Oracle
Rafael Kitover [Mon, 3 Sep 2012 19:36:09 +0000]
introspect ON DELETE and DEFERRABLE for Oracle

Oracle has no ON UPDATE rules, so change the default to NO ACTION so
that users have no surprises when deploying an Oracle schema to SQLite
etc.

Add support to the generic ::Loader::DBI::_table_fk_info for
introspecting ON DELETE/UPDATE rules and DEFERRABLE clauses, as much as
the DBD supports it.

For Oracle I had to get the DEFERRABLE value manually in an override, as
well as making sure the on_update was set, as the Oracle driver uses the
::Loader::DBI method.

12 years agointrospect ON DELETE/UPDATE FK clauses for DB2
Rafael Kitover [Mon, 3 Sep 2012 17:06:47 +0000]
introspect ON DELETE/UPDATE FK clauses for DB2

is_deferrable still defaults to 1 because DB2 does not have deferrable
FKs. At some point we will try to implement with_deferred_fk_checks for
DB2 in DBIC.

12 years agointrospect ON/DEFERRABLE FK clauses for SQLite
Rafael Kitover [Sun, 2 Sep 2012 21:29:01 +0000]
introspect ON/DEFERRABLE FK clauses for SQLite

The ON clauses are simple to get, pragma foreign_key_list returns them,
but for the DEFERRABLE clause we have to parse the table DDL from
sqlite_master, a bit hairy but should be correct.