From 3e9623081f4be2a6cb6ced9edb963d2cec627d88 Mon Sep 17 00:00:00 2001 From: nickmorales Date: Mon, 4 Jun 2018 21:45:44 +0000 Subject: [PATCH] stock images with stock type info --- lib/CXGN/Chado/Stock.pm | 6 ------ 1 file changed, 6 deletions(-) diff --git a/lib/CXGN/Chado/Stock.pm b/lib/CXGN/Chado/Stock.pm index 7b10e5e..13222fc 100644 --- a/lib/CXGN/Chado/Stock.pm +++ b/lib/CXGN/Chado/Stock.pm @@ -483,12 +483,6 @@ sub set_is_obsolete { sub get_image_ids { my $self = shift; - my $ids = $self->get_schema->storage->dbh->selectcol_arrayref - ( "SELECT image_id FROM phenome.stock_image WHERE stock_id=? ", - undef, - $self->get_stock_id - ); - return @$ids; my @ids; my $q = "select distinct image_id, cvterm.name FROM phenome.stock_image JOIN stock USING(stock_id) JOIN cvterm ON(type_id=cvterm_id) WHERE stock_id = ?"; my $h = $self->schema->storage->dbh()->prepare($q); -- 2.11.4.GIT