public static int getTag(c_SqlFunctions cs, string name) { string url = "https://e621.net/tag/show.xml?name=" + name; var d = c_Functions.parseXML(GetPageData(url)); if (d != null) { if (d.GetElementsByTagName("success").Count == 0) { cs.insertInto("tags", new string[][] { new string[] { "id", "false", d.GetElementsByTagName("id")[0].InnerText }, new string[] { "name", "true", d.GetElementsByTagName("name")[0].InnerText }, new string[] { "count", "false", d.GetElementsByTagName("count")[0].InnerText }, new string[] { "type", "false", d.GetElementsByTagName("type")[0].InnerText }, new string[] { "updated", "true", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString() } }); } Thread t = new Thread(() => getTagData(cs, name)); t.Start(); //getTagData(cs, name); int i = -1; int.TryParse(d.GetElementsByTagName("count")[0].InnerText, out i); return(i); } else { return(-1); } }
public static int getArtistPosts(c_SqlFunctions cs, string name) { int ret = -1; ret = getTag(cs, name); return(ret); }
//==================================// // Handling table creation // //==================================// public static c_SqlFunctions initializeSQL(c_SqlFunctions csqlf) { csqlf.createDbFile(); csqlf.createInternalConnection(); foreach (KeyValuePair <string, List <SQLiteColumn> > kvp in getListOfTables()) { csqlf.createTable(kvp.Key, kvp.Value); } return(csqlf); }
public static void getTagData(c_SqlFunctions cs, string name) { string url = string.Format("https://e621.net/tag/related.xml?tags={0}&type=", name) + "{0}"; var d_General = c_Functions.parseXML(GetPageData(string.Format(url, "general"))); Thread.Sleep(1000); var d_Artist = c_Functions.parseXML(GetPageData(string.Format(url, "artist"))); Thread.Sleep(1000); var d_Copyright = c_Functions.parseXML(GetPageData(string.Format(url, "copyright"))); Thread.Sleep(1000); var d_Character = c_Functions.parseXML(GetPageData(string.Format(url, "character"))); Thread.Sleep(1000); var d_Species = c_Functions.parseXML(GetPageData(string.Format(url, "species"))); Dictionary <SQLiteColumn, string> related = new Dictionary <SQLiteColumn, string>() { { new SQLiteColumn() { columnName = "related_General", dataType = SQLiteDataType.TEXT }, string.Join("×", getArray(d_General)) }, { new SQLiteColumn() { columnName = "related_Artist", dataType = SQLiteDataType.TEXT }, string.Join("×", getArray(d_Artist)) }, { new SQLiteColumn() { columnName = "related_Copyright", dataType = SQLiteDataType.TEXT }, string.Join("×", getArray(d_Copyright)) }, { new SQLiteColumn() { columnName = "related_Character", dataType = SQLiteDataType.TEXT }, string.Join("×", getArray(d_Character)) }, { new SQLiteColumn() { columnName = "related_Species", dataType = SQLiteDataType.TEXT }, string.Join("×", getArray(d_Species)) } }; cs.update("tags", related, " name='" + name + "' "); }
public c_ImageDataHandler(c_SqlFunctions _cs) { cs = _cs; }