X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FSybase.pm;h=c7031a1f11dfb5f25c66e843bc73ec0883e708d6;hb=bf77e171c05a74f4fd6941090707ba08a1d1a5f1;hp=cb7408bac00237c84376830ba6b2ae28b75f40a7;hpb=00c937a24ecd01b75997dd3e0211f2377fcd84ff;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Storage/DBI/Sybase.pm b/lib/DBIx/Class/Storage/DBI/Sybase.pm index cb7408b..c7031a1 100644 --- a/lib/DBIx/Class/Storage/DBI/Sybase.pm +++ b/lib/DBIx/Class/Storage/DBI/Sybase.pm @@ -3,15 +3,33 @@ package DBIx::Class::Storage::DBI::Sybase; use strict; use warnings; -use base qw/DBIx::Class::Storage::DBI::NoBindVars/; +use base qw/ + DBIx::Class::Storage::DBI::Sybase::Base + DBIx::Class::Storage::DBI::NoBindVars +/; +use mro 'c3'; -my %noquote = map { $_ => 1 } qw(int integer); +sub _rebless { + my $self = shift; -sub should_quote_data_type { - my $self = shift; - my ($type) = @_; - return 0 if $noquote{$type}; - return $self->next::method(@_); + my $dbtype = eval { + @{$self->last_dbh + ->selectrow_arrayref(qq{sp_server_info \@attribute_id=1}) + }[2] + }; + unless ( $@ ) { + $dbtype =~ s/\W/_/gi; + my $subclass = "DBIx::Class::Storage::DBI::Sybase::${dbtype}"; + if ($self->load_optional_class($subclass) && !$self->isa($subclass)) { + bless $self, $subclass; + $self->_rebless; + } + } +} + +sub _dbh_last_insert_id { + my ($self, $dbh, $source, $col) = @_; + return ($dbh->selectrow_array('select @@identity'))[0]; } 1; @@ -26,10 +44,21 @@ This subclass supports L for real Sybase databases. If you are using an MSSQL database via L, see L. +=head1 CAVEATS + +This storage driver uses L as a base. +This means that bind variables will be interpolated (properly quoted of course) +into the SQL query itself, without using bind placeholders. + +More importantly this means that caching of prepared statements is explicitly +disabled, as the interpolation renders it useless. + =head1 AUTHORS Brandon L Black +Justin Hunter + =head1 LICENSE You may distribute this code under the same terms as Perl itself.