AnalysisAdaptor.pm 3.55 KB
Newer Older
1
2
3
4
=pod

=head1 NAME

5
    Bio::EnsEMBL::Hive::DBSQL::AnalysisAdaptor
6
7
8

=head1 SYNOPSIS

9
    $analysis_adaptor = $db_adaptor->get_AnalysisAdaptor;
10

11
    $analysis_adaptor = $analysis_object->adaptor;
12

13
14
=head1 DESCRIPTION

15
16
17
18
19
    Module to encapsulate all db access for persistent class Analysis.
    There should be just one such adaptor per application and database connection.

=head1 LICENSE

20
    Copyright [1999-2014] Wellcome Trust Sanger Institute and the EMBL-European Bioinformatics Institute
21
22
23
24
25
26
27
28
29

    Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License.
    You may obtain a copy of the License at

         http://www.apache.org/licenses/LICENSE-2.0

    Unless required by applicable law or agreed to in writing, software distributed under the License
    is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    See the License for the specific language governing permissions and limitations under the License.
30
31
32

=head1 CONTACT

33
    Please subscribe to the Hive mailing list:  http://listserver.ebi.ac.uk/mailman/listinfo/ehive-users  to discuss Hive-related questions or to be notified of our updates
34
35
36
37
38
39
40

=cut


package Bio::EnsEMBL::Hive::DBSQL::AnalysisAdaptor;

use strict;
41
use warnings;
42
43
use Bio::EnsEMBL::Hive::Analysis;
use Bio::EnsEMBL::Hive::URLFactory;
44
use Bio::EnsEMBL::Hive::Utils ('throw');
45

46
use base ('Bio::EnsEMBL::Hive::DBSQL::ObjectAdaptor');
47

48
49
50
51
52
53
54
55
56
57
58
59
60
61

sub default_table_name {
    return 'analysis_base';
}


sub default_insertion_method {
    return 'INSERT';
}


sub object_class {
    return 'Bio::EnsEMBL::Hive::Analysis';
}
Leo Gordon's avatar
Leo Gordon committed
62

63

64
65
66
67
68
69
70
sub fetch_all_failed_analyses {
    my $self = shift;

    return $self->fetch_all( "JOIN analysis_stats s USING(analysis_id) WHERE s.status='FAILED'" );
}


71
72
73
74
75
76
77
=head2 fetch_by_logic_name_or_url

    Description: given a URL gets the analysis from URLFactory, otherwise fetches it from the db

=cut

sub fetch_by_logic_name_or_url {
Leo Gordon's avatar
Leo Gordon committed
78
    my $self                = shift @_; # can either be $self or class name
79
80
    my $logic_name_or_url   = shift @_;

81
    if($logic_name_or_url =~ m{^\w*://}) {
Leo Gordon's avatar
Leo Gordon committed
82
        return Bio::EnsEMBL::Hive::URLFactory->fetch($logic_name_or_url, ref($self) && $self->db);
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
110
111
112
113
    } else {
        return $self->fetch_by_logic_name($logic_name_or_url);
    }
}


=head2 fetch_by_url_query

    Description: fetches the analysis either by logic_name or by dbID (either coming from the tail of the URL)

=cut

sub fetch_by_url_query {
    my ($self, $field_name, $field_value) = @_;

    if(!$field_name or !$field_value) {

        return;

    } elsif($field_name eq 'logic_name') {

        return $self->fetch_by_logic_name($field_value);

    } elsif($field_name eq 'dbID') {

        return $self->fetch_by_dbID($field_value);

    }
}


114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
sub fetch_all_by_pattern {
    my ($self, $pattern) = @_;

    my $analyses;

    if( $pattern=~/^\d+$/ ) {

        $analyses = $self->fetch_all_by_analysis_id( $pattern );

    } elsif( $pattern=~/^(\d+)\.\.(\d+)$/ ) {

        $analyses = $self->fetch_all( "analysis_id BETWEEN $1 AND $2" );

    } elsif( $pattern=~/^(\d+)\.\.$/ ) {

        $analyses = $self->fetch_all( "$1<analysis_id" );

    } elsif( $pattern=~/^\.\.(\d+)$/ ) {

        $analyses = $self->fetch_all( "analysis_id<$1" );

    } elsif( $pattern=~/^\w+$/) {

        $analyses = $self->fetch_all_by_logic_name( $pattern );

    } elsif( $pattern=~/^[\w\%]+$/) {

        $analyses = $self->fetch_all( "logic_name LIKE '$pattern'" );

    } else {

        throw( "Pattern '$pattern' not recognized" );

    }

    return $analyses;
}


153
1;