Re: [Treebase-devel] Deleting Childless treeblocks

[Rutger V. <rut...@gm...>]

Just for context: study 22 is a dummy study that Mark Jason Dominus
created when running the batch import java programs last time he ran
them. The logic of the programs should have been that all dangling
references to this study are updated, but apparently some of them were
overlooked. In the same process, many dummy taxonlabels and
taxonlabelsets with pointers to study 22 have been created - an issue
which we have discussed elsewhere on the list.

On Fri, Jan 8, 2010 at 6:28 PM, William Piel <wil...@ya...> wrote:
>
> On Jan 8, 2010, at 12:30 PM, Hilmar Lapp wrote:
>
>> two questions first: 1) Do you still have the original data file that would clearly prove that these treeblocks must be spurious?
>
> The 4,000+ orphaned treeblocks belong to study_id 22 which is not published, lacks a citation, and is owned by user "tb1" (which is for testing). Don't know how it acquired all these records. So no, I don't have any "original" data file, but then there is nothing original about this artifact.
>
>> and 2) why would we not delete only the spurious treeblocks and sub_treeblocks, rather than the entire study?00
>
> It seemed easier to me to click once (delete study_id 22) rather than making 4,000+ mouse clicks to delete the treeblocks.
>
>> Note that your join below won't work the way I think you intend it to work
>
> thanks -- I'll check it over. It seemed to work (in that doing a count(treeblock_id) produced the correct number of records).
>
> bp
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel
>



-- 
Dr. Rutger A. Vos
School of Biological Sciences
Philip Lyle Building, Level 4
University of Reading
Reading
RG6 6BX
United Kingdom
Tel: +44 (0) 118 378 7535
http://www.nexml.org
http://rutgervos.blogspot.com