X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI%2FOracle.pm;h=ce9d96bc2d7deb9ede6a867cb060b0f854c848f2;hb=b327622ba07a243c4b5e10b0b7dbd17c20d75b34;hp=c819c9ddf5325195510b70abf29cbbd504066782;hpb=75a0d986c00b70def5087234630d47020bfa4a42;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 c819c9d..ce9d96b 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 @@ -123,6 +121,31 @@ sub _columns_info_for { return $self->next::method(uc $table); } +sub _extra_column_info { + my ($self, $info) = @_; + my %extra_info; + + my ($table, $column) = @$info{qw/TABLE_NAME COLUMN_NAME/}; + + my $dbh = $self->schema->storage->dbh; + 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 = ? + AND column_usage LIKE '%NEW%' AND column_usage LIKE '%OUT%' + AND trigger_type = 'BEFORE EACH ROW' AND triggering_event LIKE '%INSERT%' + }, + {}, 1); + + $sth->execute($table, $column); + if ($sth->fetchrow_array) { + $extra_info{is_auto_increment} = 1; + } + + return \%extra_info; +} + =head1 SEE ALSO L, L, @@ -132,6 +155,8 @@ L TSUNODA Kazuya C +Dagfinn Ilmari Mannsåker C + =cut 1;