private bool CheckInDB(byte[] blob, string path, out Result info)
{
info = null;
using (var db = new ResultContext())
{
var query = db.Results.Where(a => a.Path == path);
if (query.Count() == 0)
{
return(false);
}
foreach (var result in query)
{
info = new Result {
Label = result.Label, Confidence = result.Confidence, Path = result.Path, Blob = new ImageData {
Data = blob
}
};
if (result.Blob.Data.Length != blob.Length)
{
return(false);
}
for (int i = 0; i < blob.Length; ++i)
{
if (blob[i] != result.Blob.Data[i])
{
return(false);
}
}
}
return(true);
}
}
private void Postprocess(Result result)
{
counter += 1;
using (var db = new ResultContext())
{
Console.WriteLine("Added new entity");
db.Add(result);
db.SaveChanges();
}
}
public void ClearDatabase()
{
this.Stop();
Console.WriteLine("Clearing database");
using (var db = new ResultContext())
{
foreach (var result in db.Results)
{
db.Remove(result);
}
db.SaveChanges();
}
}
public string DatabaseStats()
{
string ret = "";
using (var db = new ResultContext())
{
foreach (var classLabel in LabelClass.Labels)
{
int count = db.Results.Count(a => a.Label == classLabel);
if (count > 0)
{
ret += $"{classLabel}: {count}\r\n";
}
}
return(ret);
}
}
