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(); }