Chobo/ChadoData.pm

filter: Statementstmt 87.7% 158 / 180 Branchbran 68.7% 11 / 16 Conditioncond 50.0% 1 / 2 MC/DCmcdc 0.0% 0 / 1 Subroutinesub 83.8% 26 / 31 Podpod 0.0% 0 / 13 totaltotal 80.6% 196 / 243 CC 10 SCAR 6.1
CC
10
Cov
86%
_get_by_copy
4.0
_execute
3.0
__ANON__
3.0
CRAP 1.8
« Chobo/Role/ChadoStore.pm ↑ Summary Chobo.pm »
1 package PomBase::Chobo::ChadoData;
2  
3 =head1 NAME
4  
5 PomBase::Chobo::ChadoData - Read and store cv/db data from Chado
6  
7 =head1 SYNOPSIS
8  
9 =head1 AUTHOR
10  
11 Kim Rutherford C<< <kmr44@cam.ac.uk> >>
12  
13 =head1 BUGS
14  
15 Please report any bugs or feature requests to C<kmr44@cam.ac.uk>.
16  
17 =head1 SUPPORT
18  
19 You can find documentation for this module with the perldoc command.
20  
21 perldoc PomBase::Chobo::ChadoData
22  
23 =over 4
24  
25 =back
26  
27 =head1 COPYRIGHT & LICENSE
28  
29 Copyright 2012 Kim Rutherford, all rights reserved.
30  
31 This program is free software; you can redistribute it and/or modify it
32 under the same terms as Perl itself.
33  
34 =head1 FUNCTIONS
35  
36 =cut
37  
38 1 our $VERSION = '0.041'; # VERSION
39  
40 1 ▶use Mouse;
Subroutine BEGIN: called CC=1 SCAR=0.0
41  
42 1 ▶use Carp qw(confess);
Subroutine BEGIN: called CC=1 SCAR=0.0
43  
44 1 has dbh => (is => 'ro');
45  
46 1 has cv_data => (is => 'ro', init_arg => undef, lazy_build => 1);
47 1 has cvprop_data => (is => 'ro', init_arg => undef, lazy_build => 1);
48 1 has db_data => (is => 'ro', init_arg => undef, lazy_build => 1);
49  
50 1 has cvterm_data => (is => 'ro', init_arg => undef, lazy_build => 1);
51 1 has dbxref_data => (is => 'ro', init_arg => undef, lazy_build => 1);
52  
53 1 has cvtermsynonyms_by_cvterm_id => (is => 'rw', init_arg => undef, lazy_build => 1);
54  
55 1 our @cvterm_column_names = qw(cvterm_id name cv_id dbxref_id is_obsolete is_relationshiptype);
56 1 our @dbxref_column_names = qw(dbxref_id db_id accession);
57  
58 sub _execute
59 29 ▶{
Subroutine _execute: called CC=3 SCAR=11.1
60 29 my $self = shift;
61 29 my $sql = shift;
62 29 my $proc = shift;
63  
64 29 my $dbh = $self->dbh();
65  
66 29 my $sth = $dbh->prepare($sql);
67 29 my $rv = $sth->execute();
68 29 ▶ if (!$rv) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($rv) 0 29 29
69 0 die "couldn't execute() $sql: ", $dbh->errstr(), "\n";
70 }
71  
72 29 ▶ while (my $ref = $sth->fetchrow_hashref() ) {
Branch: 1 branch
BranchTrueFalseTotal
if (my $ref = $sth->fetchrow_hashref) 185 29 214
73 185 $proc->($ref);
74 }
75  
76 29 $sth->finish();
77 }
78  
79 sub _get_cv_or_db
80 28 ▶{
Subroutine _get_cv_or_db: called CC=1 SCAR=0.0
81 28 my $self = shift;
82 28 my $table_name = shift;
83  
84 28 my $table_id_column = "${table_name}_id";
85  
86 28 my %by_id = ();
87 28 my %by_name = ();
88  
89 183 ▶ my $proc = sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
90 183 my $row_ref = shift;
91  
92 183 my $id = $row_ref->{$table_id_column};
93 183 my $name = $row_ref->{name};
94  
95 183 my %data = (
96 $table_id_column, $id,
97 name => $name,
98 );
99  
100 183 $by_id{$id} = \%data;
101 183 $by_name{$name} = \%data;
102  
103 28 };
104  
105 28 $self->_execute("select $table_id_column, name from $table_name", $proc);
106  
107 28 return \%by_id, \%by_name;
108 }
109  
110 sub _build_cv_data
111 11 ▶{
Subroutine _build_cv_data: called CC=1 SCAR=0.0
112 11 my $self = shift;
113  
114 11 my ($cvs_by_cv_id, $cvs_by_cv_name) = $self->_get_cv_or_db('cv');
115 11 return { by_id => $cvs_by_cv_id, by_name => $cvs_by_cv_name };
116 }
117  
118 sub _build_cvprop_data
119 1 ▶{
Subroutine _build_cvprop_data: called CC=1 SCAR=0.0
120 1 my $self = shift;
121  
122 1 my %by_cv_id = ();
123  
124 2 ▶ my $proc = sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
125 2 my $row_ref = shift;
126  
127 2 my $cv_id = $row_ref->{cv_id};
128  
129 my %data = (
130 cv_id => $cv_id,
131 type_id => $row_ref->{type_id},
132 value => $row_ref->{value}
133 2 );
134  
135 2 push @{$by_cv_id{$cv_id}}, \%data;
136 1 };
137  
138 1 $self->_execute("select cv_id, type_id, value from cvprop", $proc);
139  
140 1 return \%by_cv_id;
141 }
142  
143 sub get_cv_by_name
144 18 ▶{
Subroutine get_cv_by_name: called CC=1 SCAR=0.0
Pod undocumented
145 18 my $self = shift;
146 18 my $cv_name = shift;
147  
148 18 return $self->cv_data()->{by_name}->{$cv_name};
149 }
150  
151 sub get_cv_names
152 2 ▶{
Subroutine get_cv_names: called CC=1 SCAR=0.0
Pod undocumented
153 2 my $self = shift;
154  
155 2 return keys %{$self->cv_data()->{by_name}};
156 }
157  
158 sub _build_db_data
159 17 ▶{
Subroutine _build_db_data: called CC=1 SCAR=0.0
160 17 my $self = shift;
161  
162 17 my ($dbs_by_db_id, $dbs_by_db_name) = $self->_get_cv_or_db('db');
163 17 return { by_id => $dbs_by_db_id, by_name => $dbs_by_db_name, };
164 }
165  
166 sub get_db_by_name
167 12 ▶{
Subroutine get_db_by_name: called CC=1 SCAR=0.0
Pod undocumented
168 12 my $self = shift;
169 12 my $db_name = shift;
170  
171 12 return $self->db_data()->{by_name}->{$db_name};
172 }
173  
174 sub get_db_names
175 2 ▶{
Subroutine get_db_names: called CC=1 SCAR=0.0
Pod undocumented
176 2 my $self = shift;
177  
178 2 return keys %{$self->db_data()->{by_name}};
179 }
180  
181 sub _get_by_copy
182 26 ▶{
Subroutine _get_by_copy: called CC=4 SCAR=14.0
183 26 my $self = shift;
184 26 my $table_name = shift;
185 26 my $column_names_ref = shift;
186 26 my @column_names = @$column_names_ref;
187 26 my $proc = shift;
188  
189 26 my $dbh = $self->dbh();
190  
191 26 my $column_names = join ',', @column_names;
192  
193 26 ▶ $dbh->do("COPY $table_name($column_names) TO STDOUT CSV")
Branch: 1 branch
BranchTrueFalseTotal
$dbh->do("COPY $table_name($column_names) TO STDOUT CSV") or die "failed to COPY ${table_name}: ", $dbh->errstr, "\n" 26 0 26
194 or die "failed to COPY $table_name: ", $dbh->errstr, "\n";
195  
196 26 my $tsv = Text::CSV->new({sep_char => ","});
197  
198 26 my $line = undef;
199  
200 26 ▶ while ($dbh->pg_getcopydata(\$line) > 0) {
Branch: 1 branch
BranchTrueFalseTotal
if ($dbh->pg_getcopydata(\$line) > 0) 346 26 372
201 346 chomp $line;
202 346 ▶ if ($tsv->parse($line)) {
Branch: 1 branch
BranchTrueFalseTotal
if ($tsv->parse($line)) { } 346 0 346
203 346 my @fields = $tsv->fields();
204 346 $proc->(\@fields);
205 } else {
206 0 die "couldn't parse this line: $line\n";
207 }
208 }
209 }
210  
211 sub _get_cvtermsynonyms
212 0 ▶{
Subroutine _get_cvtermsynonyms: not called CC=1 SCAR=6.9
213 0 my $self = shift;
214  
215 0 my $dbh = $self->dbh();
216  
217 0 my @column_names = qw(cvtermsynonym_id cvterm_id synonym type_id);
218  
219 0 my %by_cvterm_id = ();
220  
221 0 ▶ my $proc = sub {
Subroutine __ANON__: not called CC=1 SCAR=6.9
222 0 my $fields_ref = shift;
223 0 my @fields = @$fields_ref;
224 0 my ($cvtermsynonym_id, $cvterm_id, $synonym, $type_id) = @fields;
225 0 $by_cvterm_id{$cvterm_id} = \@fields;
226 0 };
227  
228 0 $self->_get_by_copy('cvtermsynonym', \@column_names, $proc);
229  
230 0 return \%by_cvterm_id
231 }
232  
233 sub _make_term
234 116 ▶{
Subroutine _make_term: called CC=1 SCAR=0.0
235 116 my $self = shift;
236 116 my $cvterm_data = shift;
237 116 my $dbxref_data = shift;
238  
239 116 my $dbxref_id = $cvterm_data->[3];
240  
241 116 my $by_dbxref_id = $dbxref_data->{by_dbxref_id};
242 116 my $termid = $by_dbxref_id->{$dbxref_id}->{termid};
243  
244 116 return bless {
245 id => $termid,
246 cvterm_id => $cvterm_data->[0],
247 name => $cvterm_data->[1],
248 cv_id => $cvterm_data->[2],
249 dbxref_id => $dbxref_id,
250 is_obsolete => $cvterm_data->[4],
251 is_relationshiptype => $cvterm_data->[5],
252 }, 'PomBase::Chobo::OntologyTerm';
253 }
254  
255 sub _build_cvterm_data
256 11 ▶{
Subroutine _build_cvterm_data: called CC=1 SCAR=0.0
257 11 my $self = shift;
258  
259 11 my %by_cvterm_id = ();
260 11 my %by_cv_id = ();
261 11 my %by_termid = ();
262  
263 11 my $dbxref_data = $self->dbxref_data();
264  
265 116 ▶ my $proc = sub {
Subroutine __ANON__: called CC=1 SCAR=0.0
266 116 my $fields_ref = shift;
267  
268 116 my $term = $self->_make_term($fields_ref, $dbxref_data);
269  
270 116 $by_cvterm_id{$term->cvterm_id()} = $term;
271 116 $by_cv_id{$term->cv_id()}->{$term->name()} = $term;
272 116 $by_termid{$term->id()} = $term;
273 11 };
274  
275 11 $self->_get_by_copy('cvterm', \@cvterm_column_names, $proc);
276  
277 return {
278 11 by_cvterm_id => \%by_cvterm_id,
279 by_cv_id => \%by_cv_id,
280 by_termid => \%by_termid,
281 };
282 }
283  
284 sub get_cvterm_by_cvterm_id
285 0 ▶{
Subroutine get_cvterm_by_cvterm_id: not called CC=1 SCAR=6.9
Pod undocumented
286 0 my $self = shift;
287  
288 0 return $self->cvterm_data()->{by_cvterm_id};
289 }
290  
291 sub get_cvterms_by_cv_id
292 7 ▶{
Subroutine get_cvterms_by_cv_id: called CC=2 SCAR=7.4
Pod undocumented
293 7 my $self = shift;
294 7 my $cv_id = shift;
295  
296 7 ▶ if (!defined $cv_id) {
Branch: 1 branch
BranchTrueFalseTotal
unless (defined $cv_id) 0 7 7
297 0 confess "undefined cv_id passed to get_cvterms_by_cv_id()";
298 }
299  
300 7 return $self->cvterm_data()->{by_cv_id}->{$cv_id};
301 }
302  
303 sub get_cvterm_by_termid
304 25 ▶{
Subroutine get_cvterm_by_termid: called CC=1 SCAR=0.0
Pod undocumented
305 25 my $self = shift;
306 25 my $termid = shift;
307  
308 25 return $self->cvterm_data()->{by_termid}->{$termid};
309 }
310  
311 sub get_all_cvterms
312 2 ▶{
Subroutine get_all_cvterms: called CC=1 SCAR=0.0
Pod undocumented
313 2 my $self = shift;
314  
315 2 return values %{$self->cvterm_data()->{by_termid}};
316 }
317  
318 sub get_cvterm_by_name
319 3 ▶{
Subroutine get_cvterm_by_name: called CC=1 SCAR=0.0
Pod undocumented
320 3 my $self = shift;
321 3 my $cv_name = shift;
322 3 my $cvterm_name = shift;
323  
324 3 my $cv = $self->get_cv_by_name($cv_name);
325  
326 3 return $self->get_cvterms_by_cv_id($cv->{cv_id})->{$cvterm_name};
327 }
328  
329 sub get_cvprop_values
330 1 ▶{
Subroutine get_cvprop_values: called CC=2 SCAR=6.9
Pod undocumented
331 1 my $self = shift;
332 1 my $cv_name = shift;
333 1 my $prop_type_name = shift;
334  
335 1 my $cv = $self->get_cv_by_name($cv_name);
336 1 my $cvprops = $self->cvprop_data()->{$cv->{cv_id}};
337 1 my $prop_type = $self->get_cvterm_by_name('cv_property_type', $prop_type_name);
338  
339 return map {
340 $_->{value}
341 1 }
342 grep {
343 $_->{type_id} == $prop_type->{cvterm_id}
344 1 ▶ } @{$cvprops // []};
Condition50%1/2
$cvprops // []
l!l
10
MC/DC0%0/1
$cvprops // []
$cvprops
Truth table50%1/2
A
A= $cvprops
Aresult
11
00
345 }
346  
347 sub get_all_termids
348 12 ▶{
Subroutine get_all_termids: called CC=1 SCAR=0.0
Pod undocumented
349 12 my $self = shift;
350  
351 12 return keys %{$self->dbxref_data()->{by_termid}};
352 }
353  
354 sub get_dbxref_by_termid
355 19 ▶{
Subroutine get_dbxref_by_termid: called CC=1 SCAR=0.0
Pod undocumented
356 19 my $self = shift;
357 19 my $termid = shift;
358  
359 19 return $self->dbxref_data()->{by_termid}->{$termid};
360 }
361  
362 sub _build_dbxref_data
363 15 ▶{
Subroutine _build_dbxref_data: called CC=1 SCAR=0.0
364 15 my $self = shift;
365  
366 15 my $dbh = $self->dbh();
367  
368 15 my $db_data = $self->db_data();
369  
370 15 my %by_dbxref_id = ();
371 15 my %by_termid = ();
372 15 my %by_db_name = ();
373  
374 230 ▶ my $proc = sub {
Subroutine __ANON__: called CC=3 SCAR=11.0
375 230 my $fields_ref = shift;
376 230 my @fields = @$fields_ref;
377 230 my ($dbxref_id, $db_id, $accession, $version) = @fields;
378  
379 230 my %data = (dbxref_id => $dbxref_id,
380 db_id => $db_id,
381 accession => $accession,
382 version => $version);
383  
384 230 my $db_name = $db_data->{by_id}->{$db_id}->{name};
385 230 ▶ if (!defined $db_name) {
Branch: 1 branch
BranchTrueFalseTotal
unless (defined $db_name) 0 230 230
386 0 die "no db name for db $db_id";
387 }
388  
389 230 my $termid;
390  
391 230 ▶ if ($db_name eq '_global') {
Branch: 1 branch
BranchTrueFalseTotal
if ($db_name eq '_global') { } 6 224 230
392 6 $termid = $accession;
393 } else {
394 224 $termid = "$db_name:$accession";
395 }
396  
397 230 $data{termid} = $termid;
398  
399 230 $by_dbxref_id{$dbxref_id} = \%data;
400 230 $by_termid{$termid} = \%data;
401 230 $by_db_name{$db_name}->{$termid} = \%data;
402 15 };
403  
404 15 $self->_get_by_copy('dbxref', \@dbxref_column_names, $proc);
405  
406 return {
407 15 by_dbxref_id => \%by_dbxref_id,
408 by_termid => \%by_termid,
409 by_db_name => \%by_db_name,
410 };
411 }
412  
413 sub _build_cvtermsynonyms_by_cvterm_id
414 0 ▶{
Subroutine _build_cvtermsynonyms_by_cvterm_id: not called CC=1 SCAR=6.9
415 0 my $self = shift;
416  
417 0 return $self->_get_cvtermsynonyms();
418 }
419  
420 sub get_cvtermsynonyms_by_cvterm_id
421 0 ▶{
Subroutine get_cvtermsynonyms_by_cvterm_id: not called CC=1 SCAR=6.9
Pod undocumented
422 0 my $self = shift;
423 0 my $cvterm_id = shift;
424  
425 0 return $self->cvtermsynonyms_by_cvterm_id()->{$cvterm_id};
426 }
427  
428 1 1;
« Chobo/Role/ChadoStore.pm ↑ Summary Chobo.pm »