/// <summary>
/// Trivial logic for cleanup tasks with filter.
/// </summary>
/// <param name="query">Prepared query</param>
/// <returns>Number of affected entries.</returns>
private static int ApplySimpleCleanFilter(string query)
{
try
{
AnalyticsDatabaseHelper.MakeConstraintsCascade();
int processed = AnalyticsDatabaseHelper.ExecuteNonQuery(query);
AnalyticsDatabaseHelper.RemoveUnusedGlobalSessions();
return(processed);
}
finally
{
AnalyticsDatabaseHelper.MakeConstraintsStandard();
}
}
/// <summary>
/// Removes the BOTs sessions.
/// </summary>
/// <returns>Number of affected entries.</returns>
public static int RemoveBotSessions()
{
Log.Audit(Context.User, "'RemoveBotSessions' task started");
try
{
AnalyticsDatabaseHelper.MakeConstraintsCascade();
string getSqlQuery = Util.GetSqlQueryFromItem(RemoveBotVisitsQueryItem, Util.SqlProviderName);
int processed = AnalyticsDatabaseHelper.ExecuteNonQuery(getSqlQuery);
return(processed);
}
finally
{
AnalyticsDatabaseHelper.MakeConstraintsStandard();
}
}
public static int CleanAllCollectedData(bool cleanIps, out int ipOwnersRemoved)
{
Log.Audit(Context.User, "Clean all task started with cleanIps={0}", cleanIps.ToString());
string getSqlQuery = Util.GetSqlQueryFromItem(CleanAllCollectedDataQueryItem, Util.SqlProviderName);
string getSqlQueryHelperPart = Util.GetSqlQueryFromItem(CleanCollectedHelperDataQueryItem, Util.SqlProviderName);
string getSqlQueryIpsPart = Util.GetSqlQueryFromItem(CleanCollectedIpsQueryItem, Util.SqlProviderName);
try
{
AnalyticsDatabaseHelper.MakeConstraintsCascade();
int processed = AnalyticsDatabaseHelper.ExecuteNonQuery(getSqlQuery);
ipOwnersRemoved = cleanIps ? AnalyticsDatabaseHelper.ExecuteNonQuery(getSqlQueryIpsPart) : 0;
AnalyticsDatabaseHelper.ExecuteNonQuery(getSqlQueryHelperPart);
return(processed);
}
finally
{
AnalyticsDatabaseHelper.MakeConstraintsStandard();
}
}
