EnsEMBL::Web::Data HcReport
Included librariesPackage variablesGeneral documentationMethods
Toolbar
WebCvsRaw content
Package variables
No package variables defined.
Included modules
EnsEMBL::Web::DBSQL::HcDBConnection ( __PACKAGE__->species_defs )
Inherit
EnsEMBL::Web::Data
Synopsis
No synopsis!
Description
No description!
Methods
count_tests
No description
Code
database_names
No description
Code
failed_by_species
No description
Code
failed_tests
No description
Code
reports
No description
Code
Methods description
None available.
Methods code
count_testsdescriptionprevnextTop
sub count_tests {
  my ($self, @args) = @_;
  my $where = ' database_name = ? AND last_session_id = ?';
  if ($args[2]) {
    $where .= ' AND result IN (?)';
  }
  return $self->sql_count_tests($where)->select_val(@args);
}
database_namesdescriptionprevnextTop
sub database_names {
  my ($self, @args) = @_;
  my $dbs = [];

  my $where = ' species = ? AND last_session_id = ?';
  my $sth = $self->sql_database_names($where);
  $sth->execute(@args);
  while (my $row = $sth->fetchrow_arrayref) {
    push @$dbs, $row->[0];
  }
  return $dbs;
}
failed_by_speciesdescriptionprevnextTop
sub failed_by_species {
  my ($self, $session_type, @args) = @_;

  $session_type .= '_session_id';

  my $where = " AND species = ? AND $session_type = ?";

  return $self->sql_failed_by_species($where)->select_val(@args);
}
failed_testsdescriptionprevnextTop
sub failed_tests {
  my ($self, $database, $session_id, $type, $tc_action, $unannotated) = @_;
  my $result = join "', '", @$type if $type;
  my $action = join "', '", @$tc_action if $tc_action;

  my $where = " database_name = ? AND last_session_id = ? AND r.result IN ('$result')";
  my $isnull = $unannotated  ? "or isnull(a.action)" : '';
  if ($tc_action) {
    $where .= qq(AND (a.action IN ('$action') $isnull ));
  }

  my $results = [];
  my $sth = $self->sql_failed_tests($where);
  $sth->execute($database, $session_id);
  while (my $row = $sth->fetchrow_arrayref) {
    push @$results, $row;
  }
  return $results;
}
reportsdescriptionprevnextTop
sub reports {
  my ($self, $database, $session_id, $type, $tc_action, $unannotated) = @_;
  my $result = join "', '", @$type if $type;
  my $action = join "', '", @$tc_action if $tc_action;

  my $where = ' database_name = ? AND last_session_id = ? ';
  if ($result) {
    $where .= " AND r.result IN ('$result')";
  }
  my $isnull = $unannotated  ? 'or isnull(a.action)' : '';
  if ($tc_action) {
    $where .= qq(AND (a.action IN ('$action') $isnull ));
  }
  my $sth = $self->sql_reports($where);
  $sth->execute($database, $session_id);

  my @results = $self->sth_to_objects($sth);
  return @results;
}

1;
}
General documentation
No general documentation available.