1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109
|
package DBIx::Class::Storage::DBI::SQLAnywhere::Cursor;
use strict;
use warnings;
use base 'DBIx::Class::Storage::DBI::Cursor';
use mro 'c3';
=head1 NAME
DBIx::Class::Storage::DBI::SQLAnywhere::Cursor - GUID Support for SQL Anywhere
over L<DBD::SQLAnywhere>
=head1 DESCRIPTION
This class is for normalizing GUIDs retrieved from SQL Anywhere via
L<DBD::SQLAnywhere>.
You probably don't want to be here, see
L<DBIx::Class::Storage::DBI::SQLAnywhere> for information on the SQL Anywhere
driver.
Unfortunately when using L<DBD::SQLAnywhere>, GUIDs come back in binary, the
purpose of this class is to transform them to text.
L<DBIx::Class::Storage::DBI::SQLAnywhere> sets
L<cursor_class|DBIx::Class::Storage::DBI/cursor_class> to this class by default.
It is overridable via your
L<connect_info|DBIx::Class::Storage::DBI/connect_info>.
You can use L<DBIx::Class::Cursor::Cached> safely with this class and not lose
the GUID normalizing functionality,
L<::Cursor::Cached|DBIx::Class::Cursor::Cached> uses the underlying class data
for the inner cursor class.
=cut
sub _dbh_next {
my ($storage, $dbh, $self) = @_;
my $next = $self->next::can;
my @row = $next->(@_);
my $col_info = $storage->_resolve_column_info($self->args->[0]);
my $select = $self->args->[1];
for my $select_idx (0..$#$select) {
my $selected = $select->[$select_idx];
next if ref $selected;
my $data_type = $col_info->{$selected}{data_type};
if ($storage->_is_guid_type($data_type)) {
my $returned = $row[$select_idx];
if (length $returned == 16) {
$row[$select_idx] = $storage->_uuid_to_str($returned);
}
}
}
return @row;
}
sub _dbh_all {
my ($storage, $dbh, $self) = @_;
my $next = $self->next::can;
my @rows = $next->(@_);
my $col_info = $storage->_resolve_column_info($self->args->[0]);
my $select = $self->args->[1];
for my $row (@rows) {
for my $select_idx (0..$#$select) {
my $selected = $select->[$select_idx];
next if ref $selected;
my $data_type = $col_info->{$selected}{data_type};
if ($storage->_is_guid_type($data_type)) {
my $returned = $row->[$select_idx];
if (length $returned == 16) {
$row->[$select_idx] = $storage->_uuid_to_str($returned);
}
}
}
}
return @rows;
}
1;
=head1 AUTHOR
See L<DBIx::Class/AUTHOR> and L<DBIx::Class/CONTRIBUTORS>.
=head1 LICENSE
You may distribute this code under the same terms as Perl itself.
=cut
# vim:sts=2 sw=2:
|