Re: Help with sqlite?

[Stephane Delcroix <stephane delcroix org>]

.schema photos
.schema tags
.schema photo_tags

but that's probably not the right way of doing that... I'd select
(within f-spot) all the pcitures with the right tag, then
right-click>copy photo location and do the symlink based on this...

regards

s


On Tue, 2007-06-12 at 17:45 -0400, Todd Slater wrote:
> I'd like to make symlinks to photos tagged with "background" or
> favorites in the f-spot database so my wallpaper manager will see
> them. I'm not at all familiar with sqlite but I started poking around
> today to try to figure out how I might accomplish this. I see the
> tables 'tags', 'photo_tags', and 'photos'. I can see the path to the
> photos, but I can't see how to link tags to an image path.
> 
> If somebody can provide a sample query or an idea of how the tables
> are related I'd be much obliged.
> 
> Thanks,
> 
> Todd
> _______________________________________________
> F-spot-list mailing list
> F-spot-list gnome org
> http://mail.gnome.org/mailman/listinfo/f-spot-list
> 
-- 
Stephane Delcroix
stephane delcroix org