public void SaveArticles(List <Article> articles)
{
connection = new MySqlConnection(this.urlConnection);
connection.Open();
MySqlCommand cmd = this.connection.CreateCommand();
YandexTranslator translator = new YandexTranslator();
DatumboxAPI DatumboxAPI = new DatumboxAPI("35e089c310ba09d172e9aee276877ba4");
foreach (Article article in articles)
{
string texte = translator.translate(article.Description);
Category category = JsonConvert.DeserializeObject <Category>(DatumboxAPI.TopicClassification(texte));
int categorie = getTextCategory(category.output.result);
string statement = String.Empty;
if (article.Image == null)
{
statement = "INSERT INTO article (source, titre, link, description, categorie) values ('"
+ article.Source.Replace("'", "''") + "', '" + article.Titre.Replace("'", "''") + "', '"
+ article.Link.Replace("'", "''") + "', '" + article.Description.Replace("'", "''") + "', "
+ categorie + ")";
}
else
{
statement = "INSERT INTO article (source, titre, link, description, image, categorie) values ('"
+ article.Source.Replace("'", "''") + "', '" + article.Titre.Replace("'", "''") + "', '"
+ article.Link.Replace("'", "''") + "', '" + article.Description.Replace("'", "''") + "', '"
+ article.Image.Replace("'", "''") + "', "
+ categorie + ")";
}
try
{
cmd.CommandText = statement;
cmd.ExecuteNonQuery();
cmd.CommandText = String.Empty;
}
catch (MySqlException e)
{
Console.WriteLine("Cette requête cause problème : " + statement
+ " \n The exception say " + e.Message);
}
}
}
public string TranslateText(string input)
{
YandexTranslator yandexTranslator = new YandexTranslator();
return(yandexTranslator.translate(@input, "trnsl.1.1.20190711T150343Z.58bc9e7bb4409821.e42fded912dd04452d0e0efbeb771da70d10deb6", lang));
}
