[Digikam-devel] [Bug 110333] New: tag images from albumstructure

[Dominik Fritz]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=110333         
           Summary: tag images from albumstructure
           Product: digikam
           Version: unspecified
          Platform: SuSE RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: general
        AssignedTo: digikam-devel kde org
        ReportedBy: kdebugs dominikfritz de


Version:           svn 0.8 (using KDE KDE 3.4.2)
Installed from:    SuSE RPMs
Compiler:          gcc 3.3.4 
OS:                Linux

Before I used digiKam and it's great tagging features I often had subfolders of an album which contained a subset of the images i.e. a selection for a slideshow.
However since I can now use the digiKam tags to achieve this I want to get rid of these subalbums and instead tag the photos. Therefore I would like to have a feature in digikam which tags my photos based on items in an other album. 

What I basicly need is the following sql statement:
replace into ImageTags (ImageId,TagId) select id,<tagID> from Images where dirid=<targetAlbum> and name in (select name from Images where dirid=<targetAlbum> intersect select name from Images where dirid=<selectionAlbum>);

<tagID> is the ID of the tag which should be assigned to the images
<targetAlbum> contains the photos which should be tagged
<selectedAlbum> contains the subset of the images.

If one can apply this action from within digikam I could simply use the existing selections to tag my photos and get rid of redundant files.