Account deletion does not delete the media entries

[joar]

When removing your account via your account settings page, the media files are deleted, but *not* the media entries themselves.

[joar]

Stacktace: ​https://gist.github.com/c8725614b1e870ddee9a

[Elrond]

My time is currently very limited. So if someone else wants to take this, go ahead, without asking me.

Anyway, idea:

1. Have user A and B.
2. User B creates media M.
3. User A post a comment on M.
4. User A deletes his own account.

Solution:
In MediaComment:

-    get_author = relationship(User)
+    get_author = relationship(User,
+                              backref=backref("posted_comments",
+                                              cascade="all, delete-orphan"))

And take a deep look at ​http://docs.sqlalchemy.org/en/rel_0_7/orm/collections.html#largecollections because the number of comments by a user might be very large, so we should probably use a subquery instead of loading them on access of the attribute.

Bonus points for a testcase!

[Elrond]

Okay, fixed in ff68ca9fc2b329d1c2ec395abf50358845c4e5fc.