File Coverage

lib/Test/DBIC/ExpectedQueries/Query.pm

Criterion	Covered	Total	%
statement	29	29	100.0
branch	12	12	100.0
condition	5	6	83.3
subroutine	5	5	100.0
pod	0	4	0.0
total	51	56	91.0

package Test::DBIC::ExpectedQueries::Query;
$Test::DBIC::ExpectedQueries::Query::VERSION = '2.002';
use Moo;



has sql                     => ( is => "ro", required => 1 );
has stack_trace             => ( is => "ro", required => 1 ); # Just a string
has report_subselect_tables => (is => "ro", required => 1);

has table       => ( is => "rw" );
has operation   => ( is => "rw" );

sub BUILD { shift->analyze_sql() }

sub analyze_sql {
    my $self = shift;
    my $sql = $self->sql;

    my $table = qr/
                [^\w.]*     # optional quote
                ([\w.]+)  # capture table
        /x;
    my $select_table = qr/^ \s* select\s+ .+? \s? from \s+ $table (.*) /ixsm;

    if($sql =~ /^ \s* insert\s+ into \s+ $table /ixsm) {
        $self->table($1);
        $self->operation("insert");
    }
    elsif($sql =~ /^ \s* update\s+ $table /ixsm) {
        $self->table($1);
        $self->operation("update");
    }
    elsif($sql =~ /^ \s* delete\s+ from \s+ $table /ixsm) {
        $self->table($1);
        $self->operation("delete");
    }
    elsif($sql =~ $select_table) {
        my ($table, $rest_sql) = ($1, $2);

        if ($self->report_subselect_tables) {
            while ( uc($table) eq "SELECT" && ("select $rest_sql" =~ $select_table) ) {
                ($table, $rest_sql) = ($1, $2);
            }
            if ($table && uc($table) ne "SELECT") {
                $self->table($table);
                $self->operation("select");
            }
        }
        else {
            $self->table($table);
            $self->operation("select");
        }
    }

    return $self;
}

sub display_sql {
    my $self = shift;
    return "SQL: (" . $self->sql . ")";
}

sub display_stack_trace {
    my $self = shift;
    return "     " . $self->stack_trace;
}

1;