The DB backend is ready from 0.60.
Steps for GUI support:
1. Add in the Categories Tree before 'Categories' root node another one root node saying "Albums" and add as child nodes to it all rows to be found in
Code: Select all
select AlbumID, AlbumName from albums where AlbumID>1 order by AlbumName; -- no Tag album (hmmm...)
2. Add a right-click menu for 'Albums' node and his children with the following options:
- Add New...
- Delete
- Rename...
- Empty
- Get Tagged Files
Explanations:
Add New...
Add new album. Similar with adding a new category.
Delete
Deletes the album. See the category code.
Rename...
Similar with the category.
Empty
Empties the album. After a confirmation message box ("Do you want to empty the album?") the following is issued:
Code: Select all
DELETE from AlbumsLink WHERE AlbumID = ?CurrentAlbumID
Moves the tag selection to the current album. It needs refresh to clear the tag from the thumbnails (if any tagged file is in the current dir). The query is
Code: Select all
UPDATE AlbumsLink SET AlbumID= ?CurrentAlbumID WHERE AlbumID=1;
Something is missing?
...perhaps at the beginning (first run with the new engine) add a 'Unnamed Album' child node in order to invite the users.
Also, does someone feels the need for temporary albums (collections) - ie the ones which are deleted at the end of the session?