public static void Run(string id)
{
using (var mysql = new MySqlData())
{
mysql.Execute("IncrementRetweetCount",
commandType: CommandType.StoredProcedure,
list: new[]
{
new MySqlParameter("@id", id),
new MySqlParameter("@date", DateTime.Now.ToUniversalTime())
});
}
}
public static void Insert(string id, DateTime sent, string data)
{
using (var mysql = new MySqlData())
{
string sql = "INSERT INTO TwitterStatus (Id, Sent, Data) VALUES " +
"(@Id, @Sent, @Data)";
mysql.Execute(sql, list: new[] {
new MySqlParameter("@Id", long.Parse(id)),
new MySqlParameter("@Sent", sent),
new MySqlParameter("@Data", data)});
}
}
public static void Insert(long retweetId, long originalTweetId, int secondsSinceOriginal, DateTime retweetTime)
{
using (var mysql = new MySqlData())
{
string sql = "INSERT INTO retweettrack (retweetid, originaltweetid, secondssinceoriginal, retweettime)" +
" VALUES (@retweetid, @originaltweetid, @secondssinceoriginal, @retweettime)";
mysql.Execute(sql, list: new [] {
new MySqlParameter("@retweetid", retweetId),
new MySqlParameter("@originaltweetid", originalTweetId),
new MySqlParameter("@secondssinceoriginal", secondsSinceOriginal),
new MySqlParameter("@retweettime", retweetTime)
});
}
}
