private void writeFailedQueries(ref SQLParser sp)
{
if(sp.FailedQueries.Count > 0)
{
using (var file = new StreamWriter(FAILEDQUERIES_FILENAME, true))
{
foreach (Tuple<string, string> pair in sp.FailedQueries)
{
//item1 = query item2 = exception
file.WriteLine(pair.Item1);
file.WriteLine(pair.Item2);
}
}
}
sp.clearFailedQueries();
}
public void writeToSQLServer()
{
SQLParser sp = new SQLParser(SCRAPEDATA_FILENAME);
DBConnection DBCon = DBConnection.Instance();
DBCon.DatabaseName = "1306913159_Companies";
if (DBCon.IsConnect())
{
foreach (string query in sp.Queries)
{
try
{
MySqlCommand cmd = new MySqlCommand(query, DBCon.GetConnection());
Console.WriteLine(cmd.ExecuteNonQuery().ToString());
Console.WriteLine("Insertion: Success");
}
catch (Exception e)
{
writeLog(e.ToString());
sp.addFailedQuery(query, e.ToString());
Console.WriteLine("Insertion: Failure");
}
}
}
writeFailedQueries(ref sp);
clearData();
}
