public static double GetProbabilityValue(Sentiment sent)
{
if (sent.label == "neg")
{
return(sent.probability.neg);
}
else if (sent.label == "pos")
{
return(sent.probability.pos);
}
else
{
return(sent.probability.neutral);
}
}
public static void PrintSentiment(Sentiment sent)
{
Console.WriteLine("----------------------------------");
//Console.WriteLine(se);
Console.WriteLine(sent.label);
if (sent.label == "neg")
{
Console.WriteLine(sent.probability.neg);
}
if (sent.label == "pos")
{
Console.WriteLine(sent.probability.pos);
}
if (sent.label == "neutral")
{
Console.WriteLine(sent.probability.neutral);
}
Console.WriteLine("----------------------------------");
}
static void Main(string[] args)
{
//actions should be passed in args
bool shouldImportStatements = false;
bool shouldImportSentiments = false;
bool shouldMakeRequest = false;
string databaseName = "sentiment_tester";
var connection = DBConnection.Instance();
connection.DatabaseName = databaseName;
List <string> statementTexts = new List <string>();
List <Statement> statementMeta = new List <Statement>();
if (connection.IsConnect() && shouldMakeRequest)
{
MySqlCommand cmd = connection.Connection.CreateCommand();
cmd.CommandText = "SELECT * FROM statement";
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
statementMeta.Add(
new Statement {
statementID = reader.GetInt16(0),
content = reader.GetString(1),
date = reader.GetDateTime(2)
}
);
}
reader.Close();
foreach (var s in statementMeta)
{
Sentiment sent = new JavaScriptSerializer().Deserialize <Sentiment>(MakeRequest(s.content));
s.sentiment = sent;
Sentiment.PrintSentiment(sent);
}
}
if (connection.IsConnect() && shouldImportSentiments)
{
foreach (var s in statementMeta)
{
DBConnection.PerformInsert(
connection,
String.Format(
"INSERT INTO sentiment (label, statementID, pos, neg, neutral) VALUES('{0}', '{1}', '{2}', '{3}', '{4}')",
s.sentiment.label,
s.statementID,
s.sentiment.probability.pos,
s.sentiment.probability.neg,
s.sentiment.probability.neutral
)
);
}
}
if (connection.IsConnect() && shouldImportStatements)
{
foreach (var s in statementTexts)
{
DBConnection.PerformInsert(
connection,
String.Format(
"INSERT INTO statement (content, date) VALUES('{0}', '{1}')",
s,
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
)
);
}
Console.WriteLine("Statement Import Done");
}
Console.WriteLine("Press Enter to Continue...");
Console.ReadLine();
}
