public void Query(string query, ContentUnit cu)
{
using (var mysqlConn = new MySqlConnection())
{
if (query.Contains("SELECT"))
{
throw new Exception("WRONG TYPE OF SQL QUERY, NEED INSERT / UPDATE / DELETE");
}
lock (threadLock)
{
mysqlConn.ConnectionString = mysqlCSB.ConnectionString;
mysqlConn.Open();
MySqlCommand com = new MySqlCommand(@query, mysqlConn);
com.Parameters.AddWithValue("@header", cu.header);
com.Parameters.AddWithValue("@description", cu.description);
com.Parameters.AddWithValue("@imgUrl", cu.imgUrl);
com.Parameters.AddWithValue("@URL", cu.URL);
com.Parameters.AddWithValue("@tags", cu.tags);
com.Parameters.AddWithValue("@source", cu.source);
com.Parameters.AddWithValue("@date", cu.date);
com.Parameters.AddWithValue("@time_of_addition", cu.time_of_addition.ToShortDateString());
MySqlDataReader dataReader = com.ExecuteReader();
dataReader.Read();
dataReader.Close();
}
}
}
private static void CheckForOF(ContentUnit cu_this)
{
curr_news_cnt++;
if (curr_news_cnt >= Row_limit)
{
Archive(cu_this);
}
}
protected SiteForPars(string _link)
{
link = _link;
cu = new ContentUnit();
parser = new HtmlParser();
config = Configuration.Default.WithDefaultLoader();
document = BrowsingContext.New(config).OpenAsync(link).Result;
Source = link;
cu.source = link;
}
private static void Archive(ContentUnit cu_this)
{
cu_this.client.Query("INSERT INTO content_arch (id, header, description, imgUrl, URL, tags, source, date, time_of_addition)"
+ " SELECT * FROM content");
cu_this.client.Query("DELETE FROM content");
}
