It doesn’t seem to work that way, however.
In ~/Pictures/2020/04/27 there’s a photo called “20200427_084229.jpg”. It’s of some wild-yeast bread that I made earlier this year. I have tagged it “Bread”. According to the sqlite3:
sqlite> select * from TagTable;
We take “thumb0000000000007016” and strip it back to 7016.
sqlite> select filename from PhotoTable where id = 7016;
Hmm … not the filename we were expecting.
sqlite> select * from PhotoTable where filename = ‘/home/bugmagnet/Pictures/2020/04/27/20200427_084229.jpg’;
So I’m still a bit confused about how things work in shotwell. It’s not as intuitive as I might have hoped.