Delete unused URI/actor/etc entries from DB when deleting an event

What do u mean by delete unused stuff?

2009/12/3 Siegfried Gevatter <email address hidden>

> Public bug reported:
>
> <KaKaRoTo> RainCT, I used REFERENCES table(column) ON DELETE CASCADE
> everywhere
>
> ** Affects: zeitgeist
> Importance: Medium
> Status: New
>
> ** Changed in: zeitgeist
> Importance: Undecided => Medium
>
> ** Changed in: zeitgeist
> Milestone: None => 0.3.1
>
> --
> Delete unused stuff from DB
> https://bugs.launchpad.net/bugs/491646
> You received this bug notification because you are subscribed to The
> Zeitgeist Project.
>
> Status in Zeitgeist Framework: New
>
> Bug description:
> <KaKaRoTo> RainCT, I used REFERENCES table(column) ON DELETE CASCADE
> everywhere
>
>

Until we see evidence that our DB indeed clutters up in lots of unused URIs and whatnot (after some DeleteEvents), then I don't think the added complexity is worth it.

A more pressing issue is to delete unused URIs after a DeleteEvents because of privacy reasons - it's fine that we delete all events about http://example.com/explicit_content, but we still have the URI in the 'uri' table. However, we have to make sure that the URI is not reffed by any other existing event before pruning it. But this seems to be another bug, although heavily related to this issue.

2009/12/3 Mikkel Kamstrup Erlandsen <email address hidden>:
> A more pressing issue is to delete unused URIs after a DeleteEvents
> because of privacy reasons

Deleting stuff that becomes unliked because of a DeleteEvents call is
the whole point of this bug.

--
Siegfried-Angel Gevatter Pujals (RainCT)
Free Software Developer 363DEAE3

s/unliked/unlinked

Implemented in revision 1392.

Uhm - Which revision is this fix in? I can't see it in the rev log...

uhm i think it ended up in some merge commit by seif.
If you want to see the code just look at the new triggers in sql.py

2010/4/8, Mikkel Kamstrup Erlandsen <email address hidden>:
> Uhm - Which revision is this fix in? I can't see it in the rev log...
>
> --
> Delete unused URI/actor/etc entries from DB when deleting an event
> https://bugs.launchpad.net/bugs/491646
> You received this bug notification because you are a direct subscriber
> of the bug.
>

--
Siegfried-Angel Gevatter Pujals (RainCT)
Free Software Developer 363DEAE3