def push_data(): mb = MusicBrainzClient(cfg.MB_USERNAME, cfg.MB_PASSWORD, cfg.MB_SITE) for row in aClient.get_mb_data(): gid, workid, iswc, artist, work = row note = 'Data taken from ' + aClient.search_url(str(workid), 'i') mb.edit_work(gid, {'iswc': iswc}, note) print artist + ' work: ' + work + ' Done!'
def push_data(): mb = MusicBrainzClient(cfg.MB_USERNAME, cfg.MB_PASSWORD, cfg.MB_SITE) for row in aClient.get_mb_data(): gid, workid, iswc, artist, work = row note = 'Data taken from ' + aClient.search_url(str(workid), 'i') mb.edit_work(gid, {'iswc': iswc}, note) print artist + ' work: ' + work + ' Done!'
shs_work = shs.lookup_work(int(m.group(1))) else: continue if 'language' in shs_work: work = dict(work) shs_lang = shs_work['language'] if shs_lang not in SHS_MB_LANG_MAPPING: colored_out(bcolors.FAIL, ' * No mapping defined for language ''%s' % shs_lang) else: work['iswcs'] = [] for (iswc,) in db.execute(iswcs_query, work['id']): work['iswcs'].append(iswc) work['language'] = SHS_MB_LANG_MAPPING[shs_lang] update = ('language',) colored_out(bcolors.HEADER, ' * using %s, found language: %s' % (work['shs_url'], shs_lang)) edit_note = 'Setting work language from attached SecondHandSongs link (%s)' % work['shs_url'] out(' * edit note: %s' % (edit_note,)) mb.edit_work(work, update, edit_note) else: colored_out(bcolors.NONE, ' * using %s, no language has been found' % (work['shs_url'],)) if work['processed'] is None: db.execute("INSERT INTO bot_shs_work_lang (work) VALUES (%s)", (work['gid'],)) else: db.execute("UPDATE bot_shs_work_lang SET processed = now() WHERE work = %s", (work['gid'],))
colored_out(bcolors.FAIL, ' * No mapping defined for language ' '%s' % shs_lang) else: work['iswcs'] = [] for (iswc, ) in db.execute(iswcs_query, work['id']): work['iswcs'].append(iswc) work['language'] = SHS_MB_LANG_MAPPING[shs_lang] update = ('language', ) colored_out( bcolors.HEADER, ' * using %s, found language: %s' % (work['shs_url'], shs_lang)) edit_note = 'Setting work language from attached SecondHandSongs link (%s)' % work[ 'shs_url'] out(' * edit note: %s' % (edit_note, )) mb.edit_work(work, update, edit_note) else: colored_out( bcolors.NONE, ' * using %s, no language has been found' % (work['shs_url'], )) if work['processed'] is None: db.execute("INSERT INTO bot_shs_work_lang (work) VALUES (%s)", (work['gid'], )) else: db.execute( "UPDATE bot_shs_work_lang SET processed = now() WHERE work = %s", (work['gid'], ))