public bool Vacuum(string dbName, Parsers parser) { switch (parser.type) { case Parsers.type_texts: var textsHelper = new TextsHelper(); return(textsHelper.Vacuum(dbName)); case Parsers.type_images: var imagesHelper = new ImagesHelper(); return(imagesHelper.Vacuum(dbName)); case Parsers.type_videos: var videosHelper = new VideosHelper(); return(videosHelper.Vacuum(dbName)); case Parsers.type_snippets: var snippetsHelper = new SnippetsHelper(); return(snippetsHelper.Vacuum(dbName)); case Parsers.type_suggests: var suggestsHelper = new SuggestsHelper(); return(suggestsHelper.Vacuum(dbName)); default: return(false); } }
public bool AddParseData(string dbName, List <string> keysIds, List <string> values, Parsers parser) { string ids = string.Join(",", keysIds); string value = string.Join(",", values); switch (parser.type) { case Parsers.type_texts: var textsHelper = new TextsHelper(); textsHelper.DeleteParserRelationships(dbName, ids, parser); return(textsHelper.Add(dbName, value)); case Parsers.type_images: var imagesHelper = new ImagesHelper(); imagesHelper.DeleteParserRelationships(dbName, ids, parser); return(imagesHelper.Add(dbName, value)); case Parsers.type_videos: var videosHelper = new VideosHelper(); videosHelper.DeleteParserRelationships(dbName, ids, parser); return(videosHelper.Add(dbName, value)); case Parsers.type_snippets: var snippetsHelper = new SnippetsHelper(); snippetsHelper.DeleteParserRelationships(dbName, ids, parser); return(snippetsHelper.Add(dbName, value)); case Parsers.type_suggests: var suggestsHelper = new SuggestsHelper(); suggestsHelper.DeleteParserRelationships(dbName, ids, parser); return(suggestsHelper.Add(dbName, value)); default: return(false); } }
public bool Parse(string dbName, string keyId, Parsers parser) { Random rnd = new Random((int)DateTime.Now.Ticks); List <string> values = new List <string>(); int count = 0; bool result = false; switch (parser.type) { case Parsers.type_texts: var textsHelper = new TextsHelper(); //TODO parse algorithm count = rnd.Next(10, 20); for (int i = 0; i < count; i++) { //(key_id, text, spin, parser_id, url) if (rnd.Next(0, 2) == 0) { values.Add($"('{keyId}', 'parse_text_{DateTime.Now.Ticks + i}', '', '{parser.id}', 'parse_url_www_{DateTime.Now.Ticks + i}')"); } else { values.Add($"('{keyId}', 'parse_text_{DateTime.Now.Ticks + i}', 'parse_spin_{DateTime.Now.Ticks + i}', '{parser.id}', 'parse_url_www_{DateTime.Now.Ticks + i}')"); } } result = textsHelper.AddParseData(dbName, keyId, values, parser); break; case Parsers.type_images: var imagesHelper = new ImagesHelper(); //TODO parse algorithm count = rnd.Next(10, 50); for (int i = 0; i < count; i++) { values.Add($"('{keyId}', 'parse_text_{DateTime.Now.Ticks + i}', '{parser.id}')"); } result = imagesHelper.AddParseData(dbName, keyId, values, parser); break; case Parsers.type_videos: var videosHelper = new VideosHelper(); //TODO parse algorithm count = rnd.Next(10, 50); for (int i = 0; i < count; i++) { values.Add($"('{keyId}', 'parse_text_{DateTime.Now.Ticks + i}', '{parser.id}')"); } result = videosHelper.AddParseData(dbName, keyId, values, parser); break; case Parsers.type_snippets: var snippetsHelper = new SnippetsHelper(); //TODO parse algorithm count = rnd.Next(20, 30); for (int i = 0; i < count; i++) { values.Add($"('{keyId}', 'parse_text_{DateTime.Now.Ticks + i}', '{parser.id}')"); } result = snippetsHelper.AddParseData(dbName, keyId, values, parser); break; case Parsers.type_suggests: var suggestsHelper = new SuggestsHelper(); //TODO parse algorithm count = rnd.Next(20, 30); for (int i = 0; i < count; i++) { values.Add($"('{keyId}', 'parse_text_{DateTime.Now.Ticks + i}', '{parser.id}')"); } result = suggestsHelper.AddParseData(dbName, keyId, values, parser); break; default: result = false; break; } values.Clear(); values = null; GC.Collect(); return(result); }