using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using Sony.Filtr.Database;

namespace Sony.Filtr.PlaylistGeneration.Autocomplete
{
    //public class LastFMDataFactory : IAutocompleteFactory
    //{
    //    public IEnumerable<string> SearchArtists(string search, int count)
    //    {
    //        List<string> artists = new List<string>();
    //        using (MySqlConnection conn = new MySqlConnection(DatabaseHandler.GetConnectionString()))
    //        {
    //            conn.Open();
    //            MySqlCommand cmd =
    //                new MySqlCommand(
    //                    "SELECT strArtistName FROM tblAutocompleteArtistsLastFM WHERE strArtistName LIKE '@search%' LIMIT @count",
    //                    conn);
    //            cmd.Parameters.AddWithValue("@search", search);
    //            cmd.Parameters.AddWithValue("@count", count);

    //            var reader = cmd.ExecuteReader();
    //            while (reader.Read())
    //            {
    //                artists.Add(reader.GetString(0));
    //            }

    //            conn.Close();
    //        }
    //        return artists;
    //    }

    //    public async Task IndexArtistAsync(string artistName, double popularity)
    //    {
    //        using (var conn = DatabaseHandler.GetOpenConnection())
    //        {
    //            var cmd = conn.CreateCommand();
    //            cmd.CommandText =
    //                "INSERT IGNORE INTO tblAutocompleteArtistsLastFM (strArtistName, dblPopularity) VALUES (@strArtistName, @dblPopularity)";
    //            cmd.Parameters.AddWithValue("@strArtistName", artistName);
    //            cmd.Parameters.AddWithValue("@dblPopularity", popularity);

    //            await cmd.ExecuteNonQueryAsync();
    //        }
    //    }
    //}
}