def search_albums(): """ 根据专辑名称查询专辑 """ result = copy.copy(success_json) try: db = core.DB() connection = db.get_connction() name = request.args.get("name") page_size = request.args.get("page_size") page = request.args.get("page") if name is None or name is "": result["albums"] = dbutil.select_album_by_page( connection=connection, page_size=int(page_size), page=int(page)) else: name_ = urllib.unquote(name) result["albums"] = dbutil.select_album_by_name( connection=connection, album=str(name_), page_size=int(page_size), page=int(page)) except Exception, exp: result = copy.copy(fail_json) result["albums"] = exp.message
def search_songs(): """ 根据歌曲名搜索歌曲 """ result = copy.copy(success_json) try: db = core.DB() connection = db.get_connction() name = request.args.get("name") page_size = request.args.get("page_size") page = request.args.get("page") if name is None or name is "": result["tracks"] = dbutil.select_track_by_page( connection=connection, page_size=int(page_size), page=int(page)) else: name_ = urllib.unquote(name) result["tracks"] = dbutil.select_track_by_name( connection=connection, title=str(name_), page_size=int(page_size), page=int(page)) except Exception, exp: result = copy.copy(fail_json) result["error"] = exp.message
def find_songs(): """ 根据条件查找歌曲 """ result = copy.copy(success_json) try: db = core.DB() connection = db.get_connction() track_id = request.args.get("track_id") album = request.args.get("album") artist = request.args.get("artist") page_size = request.args.get("page_size") page = request.args.get("page") if track_id is not None and track_id is not "": result["tracks"] = dbutil.select_track_by_id(connection=connection, id=str(track_id)) if artist is not None and artist is not "": artist_ = urllib.unquote(artist) result["tracks"] = dbutil.select_track_by_artist( connection=connection, artist=str(artist_), page_size=int(page_size), page=int(page)) if album is not None and album is not "": album_ = urllib.unquote(album) result["tracks"] = dbutil.select_track_by_album( connection=connection, album=str(album_), page_size=int(page_size), page=int(page)) if (album is None or album is "") and (artist is None or artist is "") and (track_id is None or track_id is ""): result["tracks"] = dbutil.select_track_by_page( connection=connection, page_size=int(page_size), page=int(page)) except Exception, exp: result = copy.copy(fail_json) result["error"] = exp.message
def db_rescan(): result = copy.copy(success_json) try: global PLAYER db = core.DB() conn = db.get_connction() dbutil.delete_track(conn) dbutil.delete_album(conn) dbutil.delete_artist(conn) dbutil.insert_tracks(server=SERVER, connection=conn) dbutil.insert_albums(server=SERVER, connection=conn) dbutil.insert_artist(server=SERVER, connection=conn) except Exception, exp: result = copy.copy(fail_json) result["error"] = exp.message
base_path = os.path.abspath('.') sys.path.append(base_path) sys.path.append(base_path + os.sep + 'click') sys.path.append(base_path + os.sep + 'config') sys.path.append(base_path + os.sep + 'controller') sys.path.append(base_path + os.sep + 'flask') sys.path.append(base_path + os.sep + 'itsdangerous') sys.path.append(base_path + os.sep + 'jinja2') sys.path.append(base_path + os.sep + 'lms') sys.path.append(base_path + os.sep + 'markupsafe') sys.path.append(base_path + os.sep + 'script') sys.path.append(base_path + os.sep + 'utils') sys.path.append(base_path + os.sep + 'werkzeug') sys.path.append(base_path + os.sep + 'db') except Exception as e: print e from lms.server import Server from lms.player import Player from db import dbutil from db import core import urllib server = Server(hostname="192.168.1.105", port=9090) server.connect() print dbutil.select_track_by_artist(core.DB().get_connction(), "Taylor Swift", 3, 2)