private string SuperClean(string inStr) { string t = ParseJSONObjects.cleanTextforSQL(inStr); string s = ""; foreach (char x in t) { if (x != '?') { s += x; } } return(s); }
public void Pop() { foreach (KeyValuePair <string, List <KeyValuePair <string, Hashtable> > > tmpp in stack) { List <KeyValuePair <string, Hashtable> > tmp = tmpp.Value as List <KeyValuePair <string, Hashtable> >; foreach (KeyValuePair <string, Hashtable> t in tmp) { List <KeyValuePair <string, List <string> > > temp; if (!cat.Contains(ParseJSONObjects.repSpac2Und(t.Key))) { cat.Add(ParseJSONObjects.repSpac2Und(t.Key)); temp = asemb(t); } else { temp = findDuc(ParseJSONObjects.repSpac2Und(t.Key)); } } } rela.Clear(); foreach (KeyValuePair <string, KeyValuePair <string, Hashtable> > tmpp in chunk) { List <string> tables = new List <string>(); KeyValuePair <string, Hashtable> tmp = tmpp.Value; //If cat does not contain the category List <KeyValuePair <string, List <string> > > temp = findsDuc(tmp); //write mysql query of saved cates and required parameters as recorded, and save those queries to local *.sql file. foreach (KeyValuePair <string, List <string> > product in temp) { if (!tables.Contains(ParseJSONObjects.repSpac2Und(product.Key))) { tables.Add(ParseJSONObjects.repSpac2Und(product.Key)); string query = "Insert into " + ParseJSONObjects.repSpac2Und(product.Key.ToString()) + " set business_id='" + ParseJSONObjects.cleanTextforSQL(tmpp.Key) + "',"; int before = query.Length; foreach (string s in (product.Value as List <string>)) { query += ParseJSONObjects.repSpac2Und(s) + "='" + ParseJSONObjects.cleanTextforSQL((tmp.Value as Hashtable)[ParseJSONObjects.repSpac2Und(s)].ToString()) + "',"; } query = query.Substring(0, query.Length - 1) + ";"; using (StreamWriter w = File.AppendText(Parser.dataDir + "/sub/insertIntoCatTables.sql")) { w.WriteLine(query); } } //end inner 'foreach' } //end outter 'foreach' } this.sortMeow(); //end func }