Re: Help with sqlite?

.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...



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
Stephane Delcroix
stephane delcroix org

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