Re: [Shotwell] How to delete a photo from the shotwell databse


The tombstonetable is for images that got deleted from disk without Shotwell

Also please note that I plan to clean-up the database scheme this unstable cycle, getting rid of those generated ids, the odd tag handling and to properly add
geolocation information.

On 03/04/18 01:24, Larry Bradley wrote:
However, there are other tables that refer to photos (eventtable,

Eventtable is referenced from phototable: <=> Phototable.event_id.

tagtable) that will need to be updated. Can someone tell me how Shotwell
deletes entries in these tables?

Tagtable.photo_id_list contains a list of images associated with that
tag. For photos they look like this: thumb0000000000000cc1 – i.e.
"thumb" + the hex representation of the photo id. Or in printf-terms:

For videos it is the same (IIRC), though with "video-" instead of
"thumb" and from the

For example, the tag table. Given the photo id, I know the thumbnail
name. The problem is to find that name (eg thumb00000007f) in the tag
table's photo_id_list. Also, I need to find the photoid in the list as
well, to delete the Folders entry.

Any help on deleting entries from the various shotwell tables, given a photo id, would be appreciated

Other things... just noting from looking at the database:
 - There is a link <=> eventtable.primary_source_id as
well. I guess it either sets the date of the event and/or thumbnail.
 - Reference from backingphototable: <=>

There is a tombstonetable which I cannot quite figure out does or how
it is referenced....

The saved search table I have not looked at so much... but also seems
simple, though not needed for your application, I guess.

Hope that helps.


shotwell-list mailing list
shotwell-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]