public static DataSet Run()
{
using (var mysql = new MySqlData())
{
return mysql.ExecuteDataSet("GetRetweetRank", commandType: CommandType.StoredProcedure);
}
}
public static void Insert(TwitterStream data)
{
using (var mysql = new MySqlData())
{
string sql = "INSERT INTO `toketee`.`twitterstream` " +
"(`Id`, `CreateDate`,`UpdateDate`,`SoftDeleted`," +
"`Data`,`Serializable`,`DataType`,`StatusId`,`Sent`,`SenderId`," +
"`RecipientId`,`InReplyToStatusId`) VALUES " +
"(@Id, @CreateDate, @UpdateDate, @SoftDeleted, @Data, @Serializable," +
"@DataType, @StatusId, @Sent, @SenderId, @RecipientId, @InReplyToStatusId)";
MySqlCommand cmd = new MySqlCommand(sql, mysql.Context);
cmd.Parameters.AddWithValue("@Id", data.Id);
cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@SoftDeleted", 0);
cmd.Parameters.AddWithValue("@Data", data.Data);
cmd.Parameters.AddWithValue("@Serializable", data.Serializable);
cmd.Parameters.AddWithValue("@DataType", data.DataType);
cmd.Parameters.AddWithValue("@StatusId", data.StatusId);
cmd.Parameters.AddWithValue("@Sent", data.Sent);
cmd.Parameters.AddWithValue("@SenderId", data.SenderId);
cmd.Parameters.AddWithValue("@RecipientId", data.RecipientId);
cmd.Parameters.AddWithValue("@InReplyToStatusId", data.InReplyToStatusId);
cmd.ExecuteNonQuery();
}
}
public static string GetMaxId()
{
using (var mysql = new MySqlData())
{
string sql = "SELECT max(Id) FROM twitterstatus ";
return mysql.ExecuteScalar(sql).ToString();
}
}
public static string GetMaxId()
{
using (var mysql = new MySqlData())
{
string sql = "SELECT max(Id) FROM toketee.twitterstream ";
var cmd = new MySqlCommand(sql, mysql.Context);
return cmd.ExecuteScalar().ToString();
}
}
public static DataSet Run(DateTime startTime, DateTime endTime)
{
using (var mysql = new MySqlData())
{
return mysql.ExecuteDataSet("GetRetweetRankTimeFilter", commandType: CommandType.StoredProcedure,
list: new []
{
new MySqlParameter("@StartTime", startTime),
new MySqlParameter("@EndTime", endTime)
});
}
}
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)
});
}
}
public static DataSet Select(string since, bool fromApi = true, string where = null)
{
using (var mysql = new MySqlData())
{
string whereClause = "";
if (where != null)
{
whereClause = " AND Data LIKE @Like ";
}
// LIKE CONCAT('\'%' + in_arg + '%\''))
string sql = "SELECT Id, Data FROM twitterstatus " +
" WHERE Id > @Id " + whereClause +
"ORDER BY Id";
if (fromApi) sql += " LIMIT 500";
return mysql.ExecuteDataSet(sql, new[] { new MySqlParameter("@Id", long.Parse(since)),
(where != null) ? new MySqlParameter("@Like", "%" + where + "%") : null});
}
}
public static DataSet Select(string since, bool fromApi = true)
{
using (var mysql = new MySqlData())
{
string sql = "SELECT Id, Data FROM toketee.twitterstream " +
" WHERE Id > @Id AND DataType = 'status'" +
"ORDER BY Id";
if (fromApi) sql += " LIMIT 500";
var cmd = new MySqlCommand(sql, mysql.Context);
cmd.Parameters.AddWithValue("@Id", since);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
//var reader = cmd.ExecuteReader().
return ds;
}
}
