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