Importing: Is there a sql script to know what is left to do

[igbar]

I was wondering if there is an sql script I can run that will let me know how many more files/songs have to be updated so I can guesstimate how much longer I have to click full scan.

Thanks
Igbar

[hakko]

Track artists we haven't fetched biographies for:

Code: Select all

select artist_name_capitalization from music.artist where id in (select mt.artist_id from library.track lt inner join music.track mt on lt.track_id = mt.id where not exists (select 1 from library.webservice_history where artist_id = mt.artist_id and calltype_id = 5) order by mt.artist_id);

Number 5 can be exchanged for 1,2,4,5 to check for artists lacking similar artists / top tracks / top tags / biography (but these would normally overlap, as they're all fetched at the same time).
1 | Last.fm artist.getSimilar
2 | Last.fm artist.getTopTracks
4 | Last.fm artist.getTopTags
5 | Last.fm artist.getInfo

Albums which we haven't fetched info for:

Code: Select all

select ma.album_name_capitalization from library.album la inner join music.album ma on la.album_id = ma.id where not exists (select 1 from library.webservice_history where album_id = la.album_id);

[igbar]

Thanks .. You're a wild man

Igbar