'jewel case': 1,
'slim jewel case': 2,
'digipak': 3,
'cardboard/paper sleeve': 4,
'other': 5,
'keep case': 6,
'none': 7,
}
for release in db.execute(query):
colored_out(bcolors.OKBLUE, 'Looking up release "%s" by "%s" http://musicbrainz.org/release/%s' % (release['name'], release['ac_name'], release['gid']))
m = re.match(r'http://www.discogs.com/release/([0-9]+)', release['discogs_url'])
if m:
discogs_release = discogs.Release(int(m.group(1)))
discogs_packaging = discogs_get_release_packaging(discogs_release)
if discogs_packaging:
colored_out(bcolors.OKGREEN, ' * using %s, found packaging: %s' % (release['discogs_url'], discogs_packaging))
edit_note = 'Setting release packaging from attached Discogs link (%s)' % release['discogs_url']
out(' * edit note: %s' % (edit_note,))
mb.set_release_packaging(release['gid'], release['packaging'], DISCOGS_MB_PACKAGING_MAPPING[discogs_packaging], edit_note, True)
else:
colored_out(bcolors.NONE, ' * using %s, no matching packaging has been found' % (release['discogs_url'],))
time.sleep(2)
if release['processed'] is None:
db.execute("INSERT INTO bot_discogs_release_packaging (release) VALUES (%s)", (release['gid'],))
else:
db.execute("UPDATE bot_discogs_release_packaging SET processed = now() WHERE release = %s", (release['gid'],))
m = re.match(r'http://www.discogs.com/release/([0-9]+)',
release['discogs_url'])
if m:
discogs_release = discogs.Release(int(m.group(1)))
discogs_packaging = discogs_get_release_packaging(discogs_release)
if discogs_packaging:
colored_out(
bcolors.OKGREEN, ' * using %s, found packaging: %s' %
(release['discogs_url'], discogs_packaging))
edit_note = 'Setting release packaging from attached Discogs link (%s)' % release[
'discogs_url']
out(' * edit note: %s' % (edit_note, ))
mb.set_release_packaging(
release['gid'], release['packaging'],
DISCOGS_MB_PACKAGING_MAPPING[discogs_packaging], edit_note, True)
else:
colored_out(
bcolors.NONE, ' * using %s, no matching packaging has been found' %
(release['discogs_url'], ))
time.sleep(2)
if release['processed'] is None:
db.execute(
"INSERT INTO bot_discogs_release_packaging (release) VALUES (%s)",
(release['gid'], ))
else:
db.execute(
"UPDATE bot_discogs_release_packaging SET processed = now() WHERE release = %s",
(release['gid'], ))
