[neelix-devel] neelix VACUUM,NONE,1.1

[Jacob F. <lu...@us...>]

Update of /cvsroot/neelix/neelix
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28236

Added Files:
	VACUUM 
Log Message:
Fixed so ingredients are immediately deleted from DB when removed from a
recipe. They're instead orphaned and then the ingredient must be explicitly
deleted (added Ingredient.delete). Also added checks so you can't perform
operations on an ingredient that's been deleted from DB, in case a reference to
is still floats around somewhere. Added quick method to delete all observers
from an observable, gets called in ingredient deletion process to minimize the
number of those lingering references.



--- NEW FILE: VACUUM ---
orphaned ingredients = {
    select i.ingredient_id from ingredient i left join recipe r on
    i.recipe_id=r.recipe_id where r.recipe_id is null
}