from flask import request, Response
from playlister.app import application
import json
from playlister.models.persister import get_spotify_playlist_day_from_db
from playlister.logic import spotify
from utils.sql_alchemy_json_encoder import SQLAlchemyJSONEncoder


@application.route('/')
def index():
    return application.send_static_file('index.html')


@application.route('/playlister', methods=['GET'])
def get_playlister():
    isrc = request.args.get('isrc')
    time_period = request.args.get('time_period') # 1d, 7d, 30d
    country = request.args.get('country')
    db_recs = get_spotify_playlist_day_from_db(isrc, time_period)

    json_response = {}
    playlists_response_json = []

    for db_rec in db_recs:
        playlist_user_id = db_rec['playlist_user_id']
        playlist_id = db_rec['playlist_id']
        spotify_response = spotify.get_playlists_by_isrc(
            playlist_user_id, playlist_id, isrc, db_rec['streams'])
        playlist_json = {}
        playlist_json['db_record'] = db_rec
        playlist_json['spotify_record'] = spotify_response
        playlists_response_json.append(playlist_json)

    json_response['track'] = spotify.get_track_by_isrc(isrc)
    json_response['playlists'] = playlists_response_json

    return Response(
        response=json.dumps(json_response, cls=SQLAlchemyJSONEncoder),
        status=200,
        mimetype="application/json")


@application.route(
    '/hello',
    methods=['GET'])
def hello_world():
    return 'Hello World!', 200