X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FPK%2FAuto%2FOracle.pm;h=45e4b0dfd0e9184b523025fc34efac4a1bff6ea9;hb=4f8c967809333fc5378171094166600b2a3a5121;hp=f1b318bee0c2ad46f218151c3ca280ba48f30439;hpb=66d9ef6bf10ccbdc9391e81e5b1ad1b615fb67f7;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/PK/Auto/Oracle.pm b/lib/DBIx/Class/PK/Auto/Oracle.pm index f1b318b..45e4b0d 100644 --- a/lib/DBIx/Class/PK/Auto/Oracle.pm +++ b/lib/DBIx/Class/PK/Auto/Oracle.pm @@ -1,4 +1,5 @@ -package DBIx::Class::PK::Auto::Oracle; +package # hide package from pause + DBIx::Class::PK::Auto::Oracle; use strict; use warnings; @@ -7,69 +8,22 @@ use base qw/DBIx::Class/; __PACKAGE__->load_components(qw/PK::Auto/); -sub last_insert_id { - my $self = shift; - $self->get_autoinc_seq unless $self->{_autoinc_seq}; - my $sql = "SELECT " . $self->{_autoinc_seq} . ".currval FROM DUAL"; - my ($id) = $self->result_source->storage->dbh->selectrow_array($sql); - return $id; -} - -sub get_autoinc_seq { - my $self = shift; - - # return the user-defined sequence if known - if ($self->sequence) { - return $self->{_autoinc_seq} = $self->sequence; - } - - # look up the correct sequence automatically - my $dbh = $self->result_source->storage->dbh; - my $sql = qq{ - SELECT trigger_body FROM ALL_TRIGGERS t - WHERE t.table_name = ? - AND t.triggering_event = 'INSERT' - AND t.status = 'ENABLED' - }; - # trigger_body is a LONG - $dbh->{LongReadLen} = 64 * 1024 if ($dbh->{LongReadLen} < 64 * 1024); - my $sth = $dbh->prepare($sql); - $sth->execute( uc($self->result_source->name) ); - while (my ($insert_trigger) = $sth->fetchrow_array) { - if ($insert_trigger =~ m!(\w+)\.nextval!i ) { - $self->{_autoinc_seq} = uc($1); - } - } - unless ($self->{_autoinc_seq}) { - die "Unable to find a sequence INSERT trigger on table '" . $self->_table_name . "'."; - } -} - 1; -=head1 NAME +=head1 NAME -DBIx::Class::PK::Auto::Oracle - Automatic Primary Key class for Oracle +DBIx::Class::PK::Auto::Oracle - (DEPRECATED) Automatic primary key class for Oracle =head1 SYNOPSIS - # In your table classes - __PACKAGE__->load_components(qw/PK::Auto::Oracle Core/); - __PACKAGE__->set_primary_key('id'); - -=head1 DESCRIPTION +Just load PK::Auto instead; auto-inc is now handled by Storage. -This class implements autoincrements for Oracle. +=head1 AUTHOR AND CONTRIBUTORS -=head1 AUTHORS - -Andy Grundman - -Scott Connelly +See L and L in DBIx::Class =head1 LICENSE You may distribute this code under the same terms as Perl itself. =cut -