def _getArtist(self, session, name, resolved_artist):
artist_rows = session.query(Artist).filter_by(name=name).all()
if artist_rows:
if len(artist_rows) > 1 and resolved_artist:
# Use previously resolved artist for this directory.
artist = resolved_artist
elif len(artist_rows) > 1:
# Resolve artist
try:
heading = "Multiple artists names '%s'" % \
artist_rows[0].name
artist = console.selectArtist(fg.blue(heading),
choices=artist_rows,
allow_create=True)
except PromptExit:
log.warn("Duplicate artist requires user "
"intervention to resolve.")
artist = None
else:
if artist not in artist_rows:
session.add(artist)
session.flush()
print(fg.yellow("Updating artist") + ": " + name)
resolved_artist = artist
else:
# Artist match
artist = artist_rows[0]
else:
# New artist
artist = Artist(name=name)
session.add(artist)
session.flush()
print(fg.green("Adding artist") + ": " + name)
return artist, resolved_artist
def syncImage(img, current, session):
'''Add or updated the Image.'''
def _img_str(i):
return "%s - %s" % (i.type, i.description)
for db_img in current.images:
img_info = (img.type, img.md5, img.size)
db_img_info = (db_img.type, db_img.md5, db_img.size)
if db_img_info == img_info:
img = None
break
elif (db_img.type == img.type and
db_img.description == img.description):
if img.md5 != db_img.md5:
# Update image
current.images.remove(db_img)
current.images.append(img)
session.add(current)
print(fg.green("Updating image") + ": " + _img_str(img))
img = None
break
if img:
# Add image
current.images.append(img)
session.add(current)
print(fg.green("Adding image") + ": " + _img_str(img))
def _displayArtistMusic(self, artist, albums, singles):
if albums:
print(u"%d albums by %s:" % (len(albums),
Style.bright(fg.blue(artist.name))))
for alb in albums:
print(u"%s %s" % (str(alb.getBestDate()).center(17),
alb.title))
if singles:
print(u"%d single tracks by %s" %
(len(singles), Style.bright(fg.blue(artist.name))))
for s in singles:
print(u"\t%s" % (s.title))
def promptArtist(text, name=None, default_name=None, default_city=None,
default_state=None, default_country=None, artist=None):
if text:
print(text)
if name is None:
name = prompt(fg.green("Artist name"), default=default_name)
origin = {}
for o in ("city", "state", "country"):
origin["origin_%s" % o] = prompt(" %s" % fg.green(o.title()),
default=locals()["default_%s" % o],
required=False)
if not artist:
artist = Artist(name=name, **origin)
else:
artist.name = name
for o in origin:
setattr(artist, o, origin[o])
return artist
def selectArtist(heading, choices=None, multiselect=False, allow_create=True):
color = fg.green
artist = None
name = None
if heading:
print(heading)
while artist is None:
if choices:
name = choices[0].name
for menu_num, a in enumerate(choices):
print(" %d) %s" % (menu_num + 1, a.origin()))
menu_num += 1
if not multiselect:
if allow_create:
menu_num += 1
print(" %d) Enter a new artist" % menu_num)
choice = prompt("Which artist", type_=int,
choices=range(1, menu_num + 1))
choice -= 1
if choice < len(choices):
artist = choices[choice]
# Otherwise fall through to select artist below
else:
def _validate(_resp):
try:
_ints = [_i for _i in parseIntList(_resp)
if _i in range(1, menu_num + 1)]
return bool(_ints)
except:
return False
resp = prompt(color("Choose one or more artists"),
validate=_validate)
artists = []
for choice in [i - 1 for i in parseIntList(resp)]:
artists.append(choices[choice])
# XXX: blech, returning a list here and a single value below
return artists
if artist is None:
artist = promptArtist(None, name=name)
if choices:
if not Artist.checkUnique(choices + [artist]):
print(fg.red("Artist entered is not unique, try again..."))
artist = None
assert(artist)
return artist
def deleteOrphans(session):
num_orphaned_artists = 0
num_orphaned_albums = 0
num_orphaned_tracks = 0
found_ids = set()
# Tracks
for track in session.query(Track).all():
if not os.path.exists(track.path):
print(fg.red("Removing track") + ": " + track.path)
session.delete(track)
num_orphaned_tracks += 1
log.warn("Deleting track: %s" % str(track))
session.flush()
# Artists
found_ids.clear()
for artist in session.query(Artist).all():
if (artist.id == VARIOUS_ARTISTS_ID or
artist.id in found_ids):
continue
any_track = session.query(Track).filter(Track.artist_id == artist.id) \
.first()
any_album = session.query(Album).filter(Album.artist_id == artist.id) \
.first()
if not any_track and not any_album:
log.warn("Deleting artist: %s" % str(artist))
session.delete(artist)
num_orphaned_artists += 1
else:
found_ids.add(artist.id)
session.flush()
# Albums
found_ids.clear()
for album in session.query(Album).all():
if album.id in found_ids:
continue
any_track = session.query(Track).filter(Track.album_id == album.id) \
.first()
if not any_track:
log.warn("Deleting album: %s" % str(album))
session.delete(album)
num_orphaned_albums += 1
else:
found_ids.add(album.id)
return (num_orphaned_tracks, num_orphaned_artists, num_orphaned_albums)
def _pErr(subject, msg):
print(fg.red(subject) + ": %s" % str(msg))
def _run(self):
session = self.db_session
artists = session.query(Artist)\
.filter(Artist.name == self.args.artist).all()
if not artists:
print(u"Artist not found: %s" % self.args.artist)
return 1
elif len(artists) > 1:
artist = selectArtist(fg.blue("Select which '%s' to split...") %
artists[0].name,
choices=artists, allow_create=False)
else:
artist = artists[0]
# Albums by artist
albums = list(artist.albums) + artist.getAlbumsByType(VARIOUS_TYPE)
# Singles by artist and compilations the artist appears on
singles = artist.getTrackSingles()
if len(albums) < 2 and len(singles) < 2:
print("%d albums and %d singles found for '%s', nothing to do." %
(len(albums), len(singles), artist.name))
return 0
self._displayArtistMusic(artist, albums, singles)
def _validN(_n):
return _n > 1 and _n <= len(albums)
n = prompt("\nEnter the number of distinct artists", type_=int,
validate=_validN)
new_artists = []
for i in range(1, n + 1):
print(Style.bright(u"\n%s #%d") % (fg.blue(artist.name), i))
# Reuse original artist for first
a = artist if i == 1 else Artist(name=artist.name,
date_added=artist.date_added)
a.origin_city = prompt(" City", required=False)
a.origin_state = prompt(" State", required=False)
a.origin_country = prompt(" Country", required=False,
type_=normalizeCountry)
new_artists.append(a)
if not Artist.checkUnique(new_artists):
print(fg.red("Artists must be unique."))
return 1
for a in new_artists:
session.add(a)
# New Artist objects need IDs
session.flush()
print(Style.bright("\nAssign albums to the correct artist."))
for i, a in enumerate(new_artists):
print("Enter %s%d%s for %s from %s%s%s" %
(Style.BRIGHT, i + 1, Style.RESET_BRIGHT,
a.name,
Style.BRIGHT, a.origin(country_code="iso3c",
title_case=False),
Style.RESET_BRIGHT))
# prompt for correct artists
def _promptForArtist(_text):
a = prompt(_text, type_=int,
choices=range(1, len(new_artists) + 1))
return new_artists[a - 1]
print("")
for alb in albums:
# Get some of the path to help the decision
path = commonDirectoryPrefix(*[t.path for t in alb.tracks])
path = os.path.join(*path.split(os.sep)[-2:])
a = _promptForArtist("%s (%s)" % (alb.title, path))
if alb.type != "various":
alb.artist_id = a.id
for track in alb.tracks:
if track.artist_id == artist.id:
track.artist_id = a.id
print("")
for track in singles:
a = _promptForArtist(track.title)
track.artist_id = a.id
session.flush()
def _run(self):
session = self.db_session
merge_list = []
for artist_arg in self.args.artists:
artists = session.query(Artist)\
.filter(Artist.name == artist_arg).all()
if len(artists) == 1:
merge_list.append(artists[0])
elif len(artists) > 1:
merge_list += selectArtist(
fg.blue("Select the artists to merge..."),
multiselect=True, choices=artists)
if len(merge_list) > 1:
# Reuse lowest id
artist_ids = {a.id: a for a in merge_list}
min_id = min(*artist_ids.keys())
artist = artist_ids[min_id]
mc = mostCommonItem
new_artist = promptArtist(
"Merging %d artists into new artist..." % len(merge_list),
default_name=mc([a.name for a in merge_list]),
default_city=mc([a.origin_city for a in merge_list]),
default_state=mc([a.origin_state for a in merge_list]),
default_country=mc([a.origin_country for a in merge_list]),
artist=artist)
else:
print("Nothing to do, %s" %
("artist not found" if not len(merge_list)
else "only one artist found"))
return 1
assert(new_artist in merge_list)
for artist in merge_list:
if artist is new_artist:
continue
with session.no_autoflush:
for alb in list(artist.albums):
# FIXME: use constant
if alb.type != "various":
alb.artist_id = new_artist.id
artist.albums.remove(alb)
with session.no_autoflush:
new_artist.albums.append(alb)
for track in alb.tracks:
if track.artist_id == artist.id:
# gotta check in case alb is type various
track.artist_id = new_artist.id
for track in artist.getTrackSingles():
track.artist_id = new_artist.id
# flush to get new artist ids in sync before delete, otherwise
# cascade happens.
session.flush()
session.delete(artist)
session.flush()
def handleDirectory(self, d, _):
audio_files = list(self._file_cache)
self._file_cache = []
image_files = self._dir_images
self._dir_images = []
if not audio_files:
return
d_datetime = datetime.fromtimestamp(getctime(d))
# This directory of files can be:
# 1) an album by a single artist (tag.artist, or tag.albun_srtist and
# tag.album all equal)
# 2) a comp (tag.album equal, tag.artist differ)
# 3) not associated with a collection (tag.artist and tag.album differ)
artists = set([f.tag.artist for f in audio_files if f.tag])
album_artists = set([f.tag.album_artist for f in audio_files if f.tag])
albums = set([f.tag.album for f in audio_files if f.tag])
for s in artists, album_artists, albums:
if None in s:
s.remove(None)
is_various = (len(artists) > 1 and len(album_artists) == 0 and
len(albums) == 1)
def type_hint():
hints = set()
for tag in [f.tag for f in audio_files if f.tag]:
hint_frame = tag.user_text_frames.get(TXXX_ALBUM_TYPE)
if hint_frame:
hints.add(hint_frame.text)
if len(hints) > 1:
log.warn("Inconsistent type hints: %s" % str(hints))
return None
else:
return hints.pop() if hints else None
album_type = type_hint() or LP_TYPE
if is_various and album_type not in (None, VARIOUS_TYPE):
# is_various overrides
log.warn("Using type various despite files saying %s" % album_type)
album_type = VARIOUS_TYPE if is_various else album_type
# Used when a duplicate artist is resolved for the entire directory.
resolved_artist = None
resolved_album_artist = None
album = None
session = self._db_session
for audio_file in audio_files:
path = audio_file.path
info = audio_file.info
tag = audio_file.tag
if not info or not tag:
log.warn("File missing %s, skipping: %s" %
("audio" if not info else "tag/metadata", path))
continue
elif None in (tag.title, tag.artist):
log.warn("File missing required artist and/or title "
"metadata, skipping: %s" % path)
continue
try:
track = session.query(Track).filter_by(path=path).one()
except NoResultFound:
track = None
else:
if datetime.fromtimestamp(getctime(path)) == track.ctime:
# Track is in DB and the file is not modified.
# stash the album though, we'll look for artwork
# updates later
album = track.album
continue
# Either adding the track (track == None)
# or modifying (track != None)
artist, resolved_artist = self._getArtist(session, tag.artist,
resolved_artist)
if tag.album_type != SINGLE_TYPE:
if tag.album_artist and tag.artist != tag.album_artist:
album_artist, resolved_album_artist = \
self._getArtist(session, tag.album_artist,
resolved_album_artist)
else:
album_artist = artist
if artist is None:
# see PromptExit
continue
album_artist_id = album_artist.id if not is_various \
else VARIOUS_ARTISTS_ID
album_rows = session.query(Album)\
.filter_by(title=tag.album,
artist_id=album_artist_id)\
.all()
rel_date = tag.release_date
rec_date = tag.recording_date
or_date = tag.original_release_date
if album_rows:
if len(album_rows) > 1:
# This artist has more than one album with the same
# title.
raise NotImplementedError("FIXME")
album = album_rows[0]
album.type = album_type
album.release_date = rel_date
album.original_release_date = or_date
album.recording_date = rec_date
print(fg.yellow("Updating album") + ": " + album.title)
elif tag.album:
album = Album(title=tag.album,
artist_id=album_artist_id,
type=album_type,
release_date=rel_date,
original_release_date=or_date,
recording_date=rec_date,
date_added=d_datetime)
session.add(album)
print(fg.green("Adding album") + ": " + album.title)
session.flush()
if not track:
track = Track(audio_file=audio_file)
self._num_added += 1
print(fg.green("Adding track") + ": " + path)
else:
track.update(audio_file)
self._num_modified += 1
print(fg.yellow("Updating track") + ": " + path)
genre = tag.genre
genre_tag = None
if genre:
try:
genre_tag = session.query(Tag).filter_by(name=genre.name)\
.one()
except NoResultFound:
genre_tag = Tag(name=genre.name)
session.add(genre_tag)
session.flush()
track.artist_id = artist.id
track.album_id = album.id if album else None
if genre_tag:
track.tags.append(genre_tag)
session.add(track)
if album:
# Tag images
for img in tag.images:
for img_type in art.TO_ID3_ART_TYPES:
if img.picture_type in \
art.TO_ID3_ART_TYPES[img_type]:
break
img_type = None
if img_type is None:
log.warn("Skipping unsupported image type: %s" %
img.picture_type)
continue
new_img = Image.fromTagFrame(img, img_type)
if new_img:
syncImage(new_img,
album if img_type in IMAGE_TYPES["album"]
else album.artist,
session)
else:
log.warn("Invalid image in tag")
if album:
# Directory images.
for img_file in image_files:
img_type = art.matchArtFile(img_file)
if img_type is None:
log.warn("Skipping unrecognized image file: %s" %
img_file)
continue
new_img = Image.fromFile(img_file, img_type)
if new_img:
new_img.description = os.path.basename(img_file)
syncImage(new_img, album if img_type in IMAGE_TYPES["album"]
else album.artist,
session)
else:
log.warn("Invalid image file: " + img_file)
