/// <summary>
/// Removes all rows form the given table
/// </summary>
public static void DeleteAll(this MantisDatabase db, string what, MantisTable table)
{
using (var cmd = db.CreateCommand())
{
cmd.CommandText = $"DELETE FROM {db.Table(table)}";
int count = cmd.ExecuteNonQuery();
LogService.Info($"Deleted {count} {what}");
}
}
public static void DeleteMatching <T>(this MantisDatabase db, string what, string commandText, IEnumerable <T> ids)
{
using (var cmd = db.CreateCommand())
{
cmd.CommandText = commandText;
cmd.AddArrayParameters("@@ids", ids);
int count = cmd.ExecuteNonQuery();
LogService.Info($"Deleted {count} {what}");
}
}
public void Run(MantisDatabase db, CleanOptions options, TaskDataStore store)
{
try
{
using (var cmd = db.CreateCommand())
{
cmd.CommandText = $"SELECT value FROM {db.Table(MantisTable.config)} WHERE config_id = 'database_version'";
var vr = cmd.ExecuteScalar();
LogService.Info("Mantis database version is " + vr?.ToString() ?? "");
}
}
catch (Exception e)
{
throw new TaskFailedException(false, "Connection test failed: " + e.Message);
}
}
public static List <T> ReadList <T>(this MantisDatabase db, string commandText)
{
List <T> list = new List <T>();
using (var cmd = db.CreateCommand())
{
cmd.CommandText = commandText;
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
list.Add(dr.Get <T>(0));
}
}
}
return(list);
}
public void Run(MantisDatabase db, CleanOptions options, TaskDataStore store)
{
ExecuteCommand(db, db.CreateCommand(), options, store);
}