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)