/// <summary>
/// Searches for all the cached systems asyncronously.
/// </summary>
/// <returns></returns>
public static async Task <HashSet <SystemWorld> > SearchCachedSystemsAsync(DbContext context)
{
var systems = await context.ExecuteAsync <SystemWorld>("SELECT min(z) as z, x, y FROM !worlds GROUP BY x, y", (reader) =>
{
var s = new SystemWorld();
s.Z = reader.GetInt64("z");
s.X = reader.GetInt64("x");
s.Y = reader.GetInt64("y");
return(s);
});
return(new HashSet <SystemWorld>(systems));
}
/// <summary>
/// Searches for all the cached systems asyncronously within the bounds.
/// </summary>
/// <returns></returns>
public static async Task <HashSet <SystemWorld> > SearchCachedSystemsAsync(DbContext context, long?xMin, long?xMax, long?yMin, long?yMax)
{
var arguments = new Dictionary <string, object>()
{
["xmin"] = xMin.GetValueOrDefault(long.MinValue),
["xmax"] = xMax.GetValueOrDefault(long.MaxValue),
["ymin"] = yMin.GetValueOrDefault(long.MinValue),
["ymax"] = yMax.GetValueOrDefault(long.MaxValue),
};
var systems = await context.ExecuteAsync <SystemWorld>($"SELECT min(z) as z, x, y FROM !worlds x > :xmin AND x < :xmax AND y > :ymin AND y < :ymin GROUP BY x, y", (reader) =>
{
var s = new SystemWorld();
s.Z = reader.GetInt64("z");
s.X = reader.GetInt64("x");
s.Y = reader.GetInt64("y");
return(s);
}, arguments);
return(new HashSet <SystemWorld>(systems));
}
