X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FCursor.pm;h=5800113d7e0b4e1289397d6e1688d39052c86e96;hb=43919f423fba30ae065ba4617a2e1f9e5aae1640;hp=e6ff5dd5e6be843b4c0d26c75025e32fefc734d9;hpb=19fb85209b09245427780b1979f144370c621280;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Storage/DBI/Cursor.pm b/lib/DBIx/Class/Storage/DBI/Cursor.pm index e6ff5dd..5800113 100644 --- a/lib/DBIx/Class/Storage/DBI/Cursor.pm +++ b/lib/DBIx/Class/Storage/DBI/Cursor.pm @@ -36,8 +36,8 @@ Returns a new L object. sub new { my ($class, $storage, $args, $attrs) = @_; - #use Data::Dumper; warn Dumper(@_); $class = ref $class if ref $class; + my $new = { storage => $storage, args => $args, @@ -49,6 +49,32 @@ sub new { return bless ($new, $class); } +=head2 as_query + +=over 4 + +=item Arguments: none + +=item Return Value: \[ $sql, @bind ] + +=back + +Returns the SQL statement and bind vars associated with the invocant. + +=cut + +sub as_query { + my $self = shift; + + my $storage = $self->{storage}; + my $sql_maker = $storage->sql_maker; + local $sql_maker->{for}; + + my @args = $storage->_select_args(@{$self->{args}}); + my ($sql, $bind) = $storage->_prep_for_execute(@args[0 .. 2], [@args[4 .. $#args]]); + return \[ "($sql)", @{ $bind || [] }]; +} + =head2 next =over 4 @@ -124,7 +150,10 @@ sub _dbh_all { sub all { my ($self) = @_; - return $self->SUPER::all if $self->{attrs}{rows}; + if ($self->{attrs}{software_limit} + && ($self->{attrs}{offset} || $self->{attrs}{rows})) { + return $self->next::method; + } $self->{storage}->dbh_do($self->can('_dbh_all'), $self); }