public static async Task <Tweet> Peek()
{
Tweet tweet = null;
var table = await AbbysqlClient.FetchSQL($"SELECT * FROM `twitter`.`archive` ");
if (table.Count < 1)
{
throw new Exception("no tweets in list");
}
//Console.WriteLine($"You have {table.Count} items in the tweetarchive");
AbbyRow row = table[r.Next(0, table.Count)];
tweet = new Tweet()
{
id = (int)row["Id"],
url = (row["ImgUrl"] is string i) ? i : "",
sourceurl = (row["SrcUrl"] is string s) ? s : "",
message = (row["Description"] is string m) ? m : "",
priority = (sbyte)row["Priority"] == 1,
GelId = (row["GelId"] is int gild ? gild : 0),
md5 = (row["md5"] is string smd5) ? smd5 : "",
source = "tweetarchive"
};
return(tweet);
}
public static async Task <(string favoritecharacter, bool isLewd, ulong marriedid)> GetUserData(ulong Id)
{
var table = await AbbysqlClient.FetchSQL($"SELECT `UserId` FROM `user`.`users` WHERE `UserId` = '{Id}';");
if (table.Count < 1)
{
await AbbysqlClient.RunSQL($"INSERT INTO `user`.`users`(UserId, FavoriteCharacter) VALUES ('{Id}','Abigail_Williams*');");
}
table = await AbbysqlClient.FetchSQL($"SELECT `user`.`users`.* FROM `user`.`users` WHERE users.UserId = {Id};");
AbbyRow row = table[0];
(string favoritecharacter, bool isLewd, ulong marriedid)gol = ("Abigail_Williams*", true, 0);
gol.favoritecharacter = (row["FavoriteCharacter"] is string s) ? s : "abigail_williams*";
gol.isLewd = row["IsLewd"] is ulong il && il == 1;
gol.marriedid = row["MarriedUserId"] is ulong mid ? mid : 0;
return(gol);
}
