public static List <string> GetLatestRunIds(int numberOfIds, RUN_TYPE type)
{
var runs = db?.GetCollection <AsaRun>("Runs");
var selectedRuns = runs?.Find(Query.All(Query.Descending)).Where(x => x.Type == type).Select(x => x.RunId).Take(numberOfIds).ToList() ?? new List <string>();
return(selectedRuns);
}
public static void InsertRun(string runId, List <RESULT_TYPE> typeList, RUN_TYPE type)
{
var runs = db?.GetCollection <AsaRun>("Runs");
runs?.Insert(new AsaRun(
RunId: runId,
ResultTypes: typeList,
Platform: AsaHelpers.GetPlatform(),
Timestamp: DateTime.Now,
Type: type,
Version: AsaHelpers.GetVersionString()
));
}
public static List <string> GetRuns(RUN_TYPE type)
{
_ = MainConnection ?? throw new NullReferenceException(Strings.Get("MainConnection"));
List <string> Runs = new List <string>();
using var cmd = new SqliteCommand(SQL_SELECT_RUNS, MainConnection.Connection, MainConnection.Transaction);
cmd.Parameters.AddWithValue("@type", type);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Runs.Add((string)reader["run_id"]);
}
}
return(Runs);
}
public static List <string> GetLatestRunIds(int numberOfIds, RUN_TYPE type)
{
List <string> output = new List <string>();
if (MainConnection != null)
{
using (var cmd = new SqliteCommand(SQL_SELECT_LATEST_N_RUNS, MainConnection.Connection, MainConnection.Transaction))
{
cmd.Parameters.AddWithValue("@type", type);
cmd.Parameters.AddWithValue("@limit", numberOfIds);
try
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var str = reader["run_id"].ToString();
if (!string.IsNullOrEmpty(str))
{
output.Add(str);
}
}
}
}
catch (SqliteException)
{
Log.Debug("Couldn't determine latest {0} run ids.", numberOfIds);
}
}
}
else
{
Log.Debug("Failed to GetLatestRunIds because MainConnection is null.");
}
return(output);
}
public abstract List <string> GetRuns(RUN_TYPE type);
public abstract List <string> GetLatestRunIds(int numberOfIds, RUN_TYPE type);
public AsaRun(string RunId, DateTime Timestamp, string Version, PLATFORM Platform, List <RESULT_TYPE> ResultTypes, RUN_TYPE Type)
{
this.RunId = RunId;
this.Timestamp = Timestamp;
this.Version = Version;
this.Platform = Platform;
this.ResultTypes = ResultTypes;
this.Type = Type;
}
