public void TestRapporteringsvolumSisteÅrForArt()
{
using (var store = GetDocumentStore())
{
store.ExecuteIndex(new LoadDataFromAo.RavenIndexes.RapporteringsvolumIndex());
using (var session = store.OpenSession())
{
session.Store(AOStuff.GetObsMalvik(1, AOStuff.Hoem, AOStuff.KornSpurv, new DateTime(2019, 2, 2)));
session.Store(AOStuff.GetObsMalvik(2, AOStuff.Hoem, AOStuff.KornSpurv, new DateTime(2019, 1, 2)));
session.Store(AOStuff.GetObsMalvik(3, AOStuff.Pedersen, AOStuff.KornSpurv, new DateTime(2019, 1, 2)));
session.SaveChanges();
}
WaitForIndexing(
store); //If we want to query documents sometime we need to wait for the indexes to catch up
using (var session = store.OpenSession())
{
var quary = session
.Query <LoadDataFromAo.RavenIndexes.RapporteringsvolumIndex.Result,
LoadDataFromAo.RavenIndexes.RapporteringsvolumIndex>().Where(x => x.Year == 2019 && x.Taxons.Contains(AOStuff.KornSpurv)).Select(y => new
{ Brukerid = y.BrukerId, TaxonId = AOStuff.KornSpurv, Count = y.TaxonCounts.First(z => z.TaxonId == AOStuff.KornSpurv).Count }).OrderByDescending(i => i.Count);
var query = quary.ToArray();
Assert.AreEqual(AOStuff.Hoem, query.First().Brukerid, "hoems");
Assert.AreEqual(AOStuff.Pedersen, query[1].Brukerid, "pedersens");
Assert.AreEqual(2, query.First().Count, "hoems 2 funn");
Assert.AreEqual(1, query[1].Count, "hoems 2 funn");
}
}
}
public void TestRapporteringsvolumSisteÅr()
{
using (var store = GetDocumentStore())
{
store.ExecuteIndex(new LoadDataFromAo.RavenIndexes.RapporteringsvolumIndex());
using (var session = store.OpenSession())
{
session.Store(AOStuff.GetObsMalvik(1, AOStuff.Hoem, AOStuff.KornSpurv, new DateTime(2019, 2, 2)));
session.Store(AOStuff.GetObsMalvik(2, AOStuff.Hoem, AOStuff.KornSpurv, new DateTime(2010, 2, 2)));
session.Store(AOStuff.ObsPedersenStjordal(3));
session.SaveChanges();
}
WaitForIndexing(
store); //If we want to query documents sometime we need to wait for the indexes to catch up
using (var session = store.OpenSession())
{
var query = session
.Query <LoadDataFromAo.RavenIndexes.RapporteringsvolumIndex.Result,
LoadDataFromAo.RavenIndexes.RapporteringsvolumIndex>().Where(x => x.Year == 2020).OrderByDescending(x => x.Count).ToArray();
Assert.AreEqual(AOStuff.Pedersen, query.First().BrukerId, "pedersen vinner 2020");
Assert.AreEqual(1, query.First().Count, "pedersens ene art");
Assert.AreEqual(1, query.Count(), "kun en brukerkonto i 2020 på topplista");
}
}
}
