X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FODBC%2FDB2_400_SQL.pm;h=29e9da9d81b13541804f1bc5885dff8fff82afb0;hb=7f4433eb9bbe0650b4f5e2dff8bf817f4d28d3df;hp=e84c0879faaf5b8af4db54fdeae788b75941a1c9;hpb=a9f32dbced12b2b6c4f8b8a7aa142d5922350830;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Storage/DBI/ODBC/DB2_400_SQL.pm b/lib/DBIx/Class/Storage/DBI/ODBC/DB2_400_SQL.pm index e84c087..29e9da9 100644 --- a/lib/DBIx/Class/Storage/DBI/ODBC/DB2_400_SQL.pm +++ b/lib/DBIx/Class/Storage/DBI/ODBC/DB2_400_SQL.pm @@ -3,33 +3,49 @@ use strict; use warnings; use base qw/DBIx::Class::Storage::DBI::ODBC/; - -sub last_insert_id -{ - my ($self) = @_; - - $self->dbh_do(sub { - my $dbh = shift; - - # get the schema/table separator: - # '.' when SQL naming is active - # '/' when system naming is active - my $sep = $dbh->get_info(41); - my $sth = $dbh->prepare_cached( - "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM${sep}SYSDUMMY1", {}, 3); - $sth->execute(); - - my @res = $sth->fetchrow_array(); - - return @res ? $res[0] : undef; - }); +use mro 'c3'; + +warn 'Major advances took place in the DBIC codebase since this driver' + .' (::Storage::DBI::ODBC::DB2_400_SQL) was written. However since the' + .' RDBMS in question is so rare it is not possible for us to test any' + .' of the "new hottness". If you are using DB2 on AS-400 please get' + .' in contact with the developer team:' + .' http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class.pm#GETTING_HELP/SUPPORT' + ."\n" +; + +# FIXME +# Most likely all of this code is redundant and unnecessary. We should +# be able to simply use base qw/DBIx::Class::Storage::DBI::DB2/; +# Unfortunately nobody has an RDBMS engine to test with, so keeping +# things as-is for the time being + +sub _dbh_last_insert_id { + my ($self, $dbh, $source, $col) = @_; + + # get the schema/table separator: + # '.' when SQL naming is active + # '/' when system naming is active + my $sep = $dbh->get_info(41); + my $sth = $dbh->prepare_cached( + "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM${sep}SYSDUMMY1", {}, 3); + $sth->execute(); + + my @res = $sth->fetchrow_array(); + + return @res ? $res[0] : undef; } sub _sql_maker_opts { my ($self) = @_; - + $self->dbh_do(sub { - { limit_dialect => 'FetchFirst', name_sep => shift->get_info(41) } + my ($self, $dbh) = @_; + + return { + limit_dialect => 'FetchFirst', + name_sep => $dbh->get_info(41) + }; }); } @@ -42,8 +58,8 @@ over ODBC =head1 SYNOPSIS - # In your table classes - __PACKAGE__->load_components(qw/PK::Auto Core/); + # In your result (table) classes + use base 'DBIx::Class::Core'; __PACKAGE__->set_primary_key('id'); @@ -56,7 +72,7 @@ for connections using either SQL naming or System naming. =head1 AUTHORS -Marc Mims C<< >> +Marc Mims C<< >> Based on DBIx::Class::Storage::DBI::DB2 by Jess Robinson.