Delete an element with cli/gmg

[janssen]

It would be nice, if elements (let’s say pictures) could be delete over a gmg command (or another cli command).

It happend, that i uploadad a picture, which could not be displayed (working on that, if it’s a bug, i’ll report that one later). so i cannot display the pictures. the problem is, i can only delete it, when i can display it.

an option would be great or even necessary.

[janssen]

+ how can i delete this picture now?

[saul]

Replying to janssen:

+ how can i delete this picture now?

This may not be the best way, but it is how I've done it in the past.

Make a backup of your mediagoblin.db file. Then open the file with sqlite3 (running interactively).

sqlite3 mediagoblin.db

Then enter the following commands, substituting the ID number of the media for the ###s.

delete from core__collection_items where media_entry=###;
delete from core__comment_subscriptions where media_entry_id=###;
delete from core__media_comments where media_entry=###;
delete from core__media_entries where id=###;
delete from core__media_tags where media_entry=###;
delete from core__mediafiles where media_entry=###;
delete from image__mediadata where media_entry=###;

[Christopher Allan Webber]

This would be pretty easy-ish to do probably. But not quite bitesized.

We already have media deletion code from the views point of view; adding that to a gmg command shouldn't be too hard.

[Christopher Allan Webber]

I'm not sure how bitesized this is, but it's bitesized *enough* to mark it I guess :)

[berkerpeksag]

I've created issue824_gmg-delete branch on Gitorious:

​https://gitorious.org/mediagoblin/berkerpeksag-mediagoblin/source/fe7d911c958e80a48ab02980a1abc590f25a90c3:

[janssen]

--> sorry, was supposed to #825

[Christopher Allan Webber]

Looks great. Merged!