X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI%2FOracle.pm;h=52d5c4f45a041f00b0362359486990446d3de5f5;hb=c7bf4194447f499ab28dd4c0b944faf874367968;hp=957dd36ebbf632eacabcb467096c0e272ea17550;hpb=fb328d1a79d2c6187169909b074426e24aa04cac;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/DBI/Oracle.pm b/lib/DBIx/Class/Schema/Loader/DBI/Oracle.pm index 957dd36..52d5c4f 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI/Oracle.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI/Oracle.pm @@ -1,6 +1,4 @@ -package # hide from pause/cpan for now, as there's a permissions - # issue and it's screwing the rest of the package - DBIx::Class::Schema::Loader::DBI::Oracle; +package DBIx::Class::Schema::Loader::DBI::Oracle; use strict; use warnings; @@ -8,7 +6,7 @@ use base 'DBIx::Class::Schema::Loader::DBI'; use Carp::Clan qw/^DBIx::Class/; use Class::C3; -our $VERSION = '0.04999_01'; +our $VERSION = '0.04999_05'; =head1 NAME @@ -80,10 +78,10 @@ sub _table_uniq_info { my $sth = $dbh->prepare_cached( q{ - SELECT constraint_name, ucc.column_name - FROM user_constraints JOIN user_cons_columns ucc USING (constraint_name) - WHERE ucc.table_name=? AND constraint_type='U' - ORDER BY ucc.position + SELECT constraint_name, acc.column_name + FROM all_constraints JOIN all_cons_columns acc USING (constraint_name) + WHERE acc.table_name=? AND constraint_type='U' + ORDER BY acc.position }, {}, 1); @@ -133,8 +131,8 @@ sub _extra_column_info { my $sth = $dbh->prepare_cached( q{ SELECT COUNT(*) - FROM user_triggers ut JOIN user_trigger_cols utc USING (trigger_name) - WHERE utc.table_name = ? AND utc.column_name = ? + FROM all_triggers ut JOIN all_trigger_cols atc USING (trigger_name) + WHERE atc.table_name = ? AND atc.column_name = ? AND column_usage LIKE '%NEW%' AND column_usage LIKE '%OUT%' AND trigger_type = 'BEFORE EACH ROW' AND triggering_event LIKE '%INSERT%' },