public async Task <Dictionary <string, object> > GetLatestSentiment(SentimentTopic topic)
{
Dictionary <string, object> ret = new Dictionary <string, object>();
using (NpgsqlConnection connection = new NpgsqlConnection(NoiseConfigurations.PostgresConnectionString))
{
await connection.OpenAsync();
using (NpgsqlCommand command = new NpgsqlCommand())
{
command.Connection = connection;
command.CommandText = @"
SELECT *
FROM sentiments
ORDER BY date DESC
LIMIT 1";
using (var reader = await command.ExecuteReaderAsync())
{
if (await reader.ReadAsync())
{
ret["topic"] = topic.ToString();
ret["domain"] = reader.GetFieldValueAsync <string>(3).Result;
ret["valence"] = reader.GetFieldValueAsync <double>(2).Result;
ret["date"] = reader.GetFieldValueAsync <DateTime>(1).Result;
}
}
}
}
return(ret);
}
public async Task <ObjectResult> GetLatestSentiment(SentimentTopic topic)
{
Dictionary <string, object> ret = await IOCSentimentManager.GetLatestSentiment(topic);
return(Ok(ret));
}
