Re: [Treebase-devel] Dummy studies in TaxonLabelSet

[Vladimir G. <vla...@du...>]

On Mar 19, 2010, at 4:44 PM, William Piel wrote:

> I see that not all taxonlabelsets got changed from id 22 to whatever  
> they should be -- the taxonlabelsets created by trees blocks did not  
> get changed.
>

Here are the counts of the dummy studies that still show up in  
TaxonLabelSet:

select study_id, count(*)
from taxonlabelset where study_id in (22, 2264, 10215)
group by study_id

  study_id | count
----------+-------
     10215 |   285
      2264 |   690
        22 |  8615

So, there are quite a few.  Unlike we did with matrices, they do not  
seem to be reachable from legitimate studies via the  Study ->  
Phylotree -> Treeblock -> Taxonlabelset chain, i.e.

select s.study_id, pt.phylotree_id, tb.treeblock_id, tls.*
from study s, phylotree pt, treeblock tb, taxonlabelset tls
where s.study_id = pt.study_id and  pt.treeblock_id = tb.treeblock_id  
and tb.taxonlabelset_id = tls.taxonlabelset_id
   and s.study_id <> tls.study_id
order by s.study_id

returns zero results.

I can continue poking in this, but I admit I don't quite grasp what is  
the end result we are looking for...

Please keep me updated on how I could be useful with data cleaning.   
If you think a phone call could be useful, please call -- I am here  
till about 6 - 6:10 pm

Scripts that I collect for Jon to apply to production are in SVN in  
treebase-core/db/cleaning/pre-release_hotfixes

--Vladimir