//public static string GetSqlOJRankSelectAll(OjRankEntity entity, string OJTableName)
//{
// string sql = string.Format("REPLACE INTO `{0}` VALUES (NULL, '{1}', '{2}', '{3}', '{4}', '{5}')",
// OJTableName, entity.UserName, entity.Ac, entity.Submit, DateTime.Today, DateTime.Today);
// return sql;
//}
public static string UpdateCodeforcesUser(RankInAll.Core.OnlineContest.Codeforces.User user)
{
string sql = string.Format("REPLACE INTO `rank_in_all`.`cf` (`user_name`, `rating`, `last_contest`) VALUES ('{0}', '{1}', '{2}')",
user.UserName, user.Rating, null);
return sql;
}
public static string UpdateTopcoderUser(RankInAll.Core.OnlineContest.Topcoder.User user)
{
string sql = string.Format("REPLACE INTO `rank_in_all`.`tc` (`id`, `user_name`, `rating`, `volatility`, `last_contest`) VALUES (NULL, '{0}', '{1}', '{2}', '{3}')",
user.UserName, user.Rating, user.Volatility, user.MostRecentEvent);
return sql;
}
public void UpdateOJRank(RankInAll.Core.OnlineJudge.OjRankEntity entity, string OJTableName)
{
mySqlCommand.CommandText = SQL.UpdateOJRank(entity, OJTableName);
mySqlCommand.ExecuteNonQuery();
}
public void UpdateTopcoder(RankInAll.Core.OnlineContest.Topcoder.User user)
{
mySqlCommand.CommandText = SQL.UpdateTopcoderUser(user);
mySqlCommand.ExecuteNonQuery();
}
public void UpdateCodeforce(RankInAll.Core.OnlineContest.Codeforces.User user)
{
mySqlCommand.CommandText = SQL.UpdateCodeforcesUser(user);
mySqlCommand.ExecuteNonQuery();
}
