date = {"year": int(m.group(1))} if m.group(2) is not None: date["month"] = int(m.group(2)) if m.group(3) is not None: date["day"] = int(m.group(3)) colored_out( bcolors.OKBLUE, 'Setting performance relationships dates of http://musicbrainz.org/recording/%s "%s (%s)"' % (recording["gid"], recording["name"], recording["comment"]), ) attributes = {} edit_note = 'Setting relationship dates from recording comment: "%s"' % recording["comment"] colored_out(bcolors.NONE, " * new date:", date) time.sleep(15) mb.edit_relationship( recording["rel_id"], "recording", "work", recording["link_type"], recording["link_type"], attributes, date, date, edit_note, True, )
AND lt.name = 'performance' AND r.edits_pending = 0 AND lrw.edits_pending = 0 /* Only one linked work */ AND NOT EXISTS (SELECT 1 FROM l_recording_work lrw2 WHERE lrw2.entity0 = r.id AND lrw2.entity1 <> lrw.entity1) ORDER BY r.artist_credit LIMIT 750 """ date_re = re.compile(r'live, (\d{4})(?:-(\d{2}))?(?:-(\d{2}))?:', re.I) for recording in db.execute(query): m = re.match(date_re, recording['comment']) if m is None: continue date = {'year': int(m.group(1))} if m.group(2) is not None: date['month'] = int(m.group(2)) if m.group(3) is not None: date['day'] = int(m.group(3)) colored_out(bcolors.OKBLUE, 'Setting performance relationships dates of http://musicbrainz.org/recording/%s "%s (%s)"' % (recording['gid'], recording['name'], recording['comment'])) attributes = {} edit_note = 'Setting relationship dates from recording comment: "%s"' % recording['comment'] colored_out(bcolors.NONE, " * new date:", date) time.sleep(15) mb.edit_relationship(recording['rel_id'], 'recording', 'work', recording['link_type'], recording['link_type'], attributes, date, date, edit_note, True)
AND NOT EXISTS (SELECT 1 FROM l_recording_work lrw2 WHERE lrw2.entity0 = r.id AND lrw2.entity1 <> lrw.entity1) ORDER BY r.artist_credit LIMIT 750 """ date_re = re.compile(r'live, (\d{4})(?:-(\d{2}))?(?:-(\d{2}))?:', re.I) for recording in db.execute(query): m = re.match(date_re, recording['comment']) if m is None: continue date = {'year': int(m.group(1))} if m.group(2) is not None: date['month'] = int(m.group(2)) if m.group(3) is not None: date['day'] = int(m.group(3)) colored_out(bcolors.OKBLUE, 'Setting performance relationships dates of http://musicbrainz.org/recording/%s "%s (%s)"' % (recording['r_gid'], recording['name'], recording['comment'])) attributes = {} edit_note = 'Setting relationship dates from recording comment: "%s"' % recording['comment'] colored_out(bcolors.NONE, " * new date:", date) entity0 = {'type': 'recording', 'gid': recording['r_gid']} entity1 = {'type': 'work', 'gid': recording['w_gid']} time.sleep(2) mb.edit_relationship(recording['rel_id'], entity0, entity1, recording['link_type'], attributes, date, date, edit_note, True)
""" date_re = re.compile(r'live, (\d{4})(?:-(\d{2}))?(?:-(\d{2}))?:', re.I) for recording in db.execute(query): m = re.match(date_re, recording['comment']) if m is None: continue date = {'year': int(m.group(1))} if m.group(2) is not None: date['month'] = int(m.group(2)) if m.group(3) is not None: date['day'] = int(m.group(3)) colored_out( bcolors.OKBLUE, 'Setting performance relationships dates of http://musicbrainz.org/recording/%s "%s (%s)"' % (recording['gid'], recording['name'], recording['comment'])) attributes = {} edit_note = 'Setting relationship dates from recording comment: "%s"' % recording[ 'comment'] colored_out(bcolors.NONE, " * new date:", date) time.sleep(15) mb.edit_relationship(recording['rel_id'], 'recording', 'work', recording['link_type'], recording['link_type'], attributes, date, date, edit_note, True)