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