Re: [Treebase-devel] Deleting Childless treeblocks

[William P. <wil...@ya...>]

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