DBIx::Class::Storage::DBI::Sybase
/;
use List::Util ();
+use Scalar::Util ();
-sub _dbh_last_insert_id {
- my ($self, $dbh, $source, $col) = @_;
-
- # @@identity works only if not using placeholders
- # Should this query be cached?
- return ($dbh->selectrow_array('select @@identity'))[0];
+sub _rebless {
+ my $self = shift;
+ $self->disable_sth_caching(1);
+ $self->_insert_txn(0);
}
+# this works when NOT using placeholders
+sub _fetch_identity_sql { 'SELECT @@IDENTITY' }
+
+my $number = sub { Scalar::Util::looks_like_number($_[0]) };
+
+my $decimal = sub { $_[0] =~ /^ [-+]? \d+ (?:\.\d*)? \z/x };
+
my %noquote = (
- int => sub { /^ -? \d+ \z/x },
- # TODO maybe need to add float/real/etc
+ int => sub { $_[0] =~ /^ [-+]? \d+ \z/x },
+ bit => => sub { $_[0] =~ /^[01]\z/ },
+ money => sub { $_[0] =~ /^\$ \d+ (?:\.\d*)? \z/x },
+ float => $number,
+ real => $number,
+ double => $number,
+ decimal => $decimal,
+ numeric => $decimal,
);
-sub should_quote_data_type {
+sub should_quote_value {
my $self = shift;
my ($type, $value) = @_;
- return $self->next::method(@_) if not defined $value;
+ return $self->next::method(@_) if not defined $value or not defined $type;
- if (my $key = List::Util::first { $type =~ /^$_/i } keys %noquote) {
- local $_ = $value;
- return 0 if $noquote{$key}->();
+ if (my $key = List::Util::first { $type =~ /$_/i } keys %noquote) {
+ return 0 if $noquote{$key}->($value);
+ } elsif ($self->is_datatype_numeric($type) && $number->($value)) {
+ return 0;
}
+## try to guess based on value
+# elsif (not $type) {
+# return 0 if $number->($value) || $noquote->{money}->($value);
+# }
+
return $self->next::method(@_);
}
+sub transform_unbound_value {
+ my ($self, $type, $value) = @_;
+
+ if ($type =~ /money/i && defined $value) {
+ $value =~ s/^\$//;
+ $value = '$' . $value;
+ }
+
+ return $value;
+}
+
1;
=head1 NAME
=head1 DESCRIPTION
If you're using this driver than your version of Sybase does not support
-placeholders. You can check with:
+placeholders, or your version of L<DBD::Sybase> was compiled with FreeTDS rather
+than the Sybase OpenClient libraries. You can check with:
$dbh->{syb_dynamic_supported}
+To see if you are using FreeTDS, run:
+
+ perl -MDBI -le 'my $dbh = DBI->connect($dsn, $user, $pass); print $dbh->{syb_oc_version}'
+
+You will get a warning on startup if you're using FreeTDS in any case.
+
You can also enable this driver explicitly using:
my $schema = SchemaClass->clone;