from mbbot.source.secondhandsongs import SHSWebService from picard.similarity import similarity2 from kitchen.text.converters import to_unicode import pprint import urllib import urllib2 import time from utils import mangle_name, join_names, out, colored_out, bcolors import config as cfg engine = sqlalchemy.create_engine(cfg.MB_DB) db = engine.connect() db.execute("SET search_path TO musicbrainz, %s" % cfg.BOT_SCHEMA_DB) mb = MusicBrainzClient(cfg.MB_USERNAME, cfg.MB_PASSWORD, cfg.MB_SITE) shs = SHSWebService() """ CREATE TABLE mbbot.bot_shs_link_artist ( artist uuid NOT NULL, processed timestamp with time zone DEFAULT now(), CONSTRAINT bot_shs_link_artist_pkey PRIMARY KEY (artist) ); """ query = """ WITH artists_wo_shs AS ( SELECT DISTINCT a.id AS artist_id, a.gid AS artist_gid, w.id AS work_id, w.gid AS work_gid, u.url AS shs_url FROM artist a JOIN l_artist_work law ON law.entity0 = a.id AND law.link IN (SELECT id FROM link WHERE link_type in (167,168,165))
import sqlalchemy import solr from editing import MusicBrainzClient from mbbot.source.secondhandsongs import SHSWebService import pprint import urllib import time from utils import mangle_name, join_names, out, colored_out, bcolors import config as cfg engine = sqlalchemy.create_engine(cfg.MB_DB) db = engine.connect() db.execute("SET search_path TO musicbrainz, %s" % cfg.BOT_SCHEMA_DB) mb = MusicBrainzClient(cfg.MB_USERNAME, cfg.MB_PASSWORD, cfg.MB_SITE) shs = SHSWebService() """ CREATE TABLE bot_shs_work_lang ( work uuid NOT NULL, processed timestamp with time zone DEFAULT now(), CONSTRAINT bot_shs_work_lang_pkey PRIMARY KEY (work) ); """ query = """ WITH works_wo_lang AS ( SELECT w.id AS work_id, u.url AS shs_url FROM work w JOIN l_url_work l ON l.entity1 = w.id AND l.link IN (SELECT id FROM link WHERE link_type = 280)
import sqlalchemy import solr from editing import MusicBrainzClient from mbbot.source.secondhandsongs import SHSWebService import pprint import urllib import time from utils import mangle_name, join_names, out, colored_out, bcolors import config as cfg engine = sqlalchemy.create_engine(cfg.MB_DB) db = engine.connect() db.execute("SET search_path TO musicbrainz, %s" % cfg.BOT_SCHEMA_DB) mb = MusicBrainzClient(cfg.MB_USERNAME, cfg.MB_PASSWORD, cfg.MB_SITE) shs = SHSWebService() """ CREATE TABLE bot_shs_work_lang ( work uuid NOT NULL, processed timestamp with time zone DEFAULT now(), CONSTRAINT bot_shs_work_lang_pkey PRIMARY KEY (work) ); """ query = """ WITH works_wo_lang AS ( SELECT w.id AS work_id, u.url AS shs_url FROM work w JOIN l_url_work l ON l.entity1 = w.id AND l.link IN (SELECT id FROM link WHERE link_type = 280) JOIN url u ON u.id = l.entity0