public void CanGetEmptyCollection()
{
using (var store = NewDocumentStore())
{
new CasinosSuspensionsIndex().Execute(store);
using (var documentSession = store.OpenSession())
{
var casino = new Casino("cities/1", "address", "name")
{
Suspensions = new List <Suspension>
{
new Suspension(DateTime.UtcNow, new List <Exemption>())
}
};
documentSession.Store(casino);
documentSession.SaveChanges();
var suspensions = documentSession.Query <CasinosSuspensionsIndex.IndexResult, CasinosSuspensionsIndex>().
Customize(x => x.WaitForNonStaleResults()).
Where(x => x.CityId == "cities/1").
OrderByDescending(x => x.DateTime).
Take(10).
AsProjection <CasinosSuspensionsIndex.IndexResult>().
ToList();
// note that suspensions[0].Exemptions will be null, because we don't have
// any values in the array, and we don't store empty arrays
Assert.NotEmpty(suspensions);
Assert.Null(suspensions.Single().Exemptions);
}
}
}
public void QueryById()
{
using (GetNewServer())
using (
var documentStore = new DocumentStore()
{
Url = "http://*****:*****@"
docs.Casinos
.SelectMany(casino => casino.Comments, (casino, comment) => new {CityId = casino.CityId, CasinoId = casino.__document_id, Id = comment.Id, DateTime = comment.DateTime, Author = comment.Author, Text = comment.Text})" ,
Stores =
{
{ "CityId", FieldStorage.Yes },
{ "CasinoId", FieldStorage.Yes },
{ "Id", FieldStorage.Yes },
{ "DateTime", FieldStorage.Yes },
{ "Author", FieldStorage.Yes },
{ "Text", FieldStorage.Yes }
}
});
var documentSession = documentStore.OpenSession();
var casino = new Casino("Cities/123456", "address", "name");
documentSession.Store(casino);
documentSession.SaveChanges();
var casinoFromDb = documentSession.Query <Casino>()
.Customize(x => x.WaitForNonStaleResults())
.Where(x => x.Id == casino.Id).Single();
Assert.NotNull(casinoFromDb);
}
}
public void QueryById()
{
using (GetNewServer())
using (
var documentStore = new DocumentStore()
{Url = "http://*****:*****@"
docs.Casinos
.SelectMany(casino => casino.Comments, (casino, comment) => new {CityId = casino.CityId, CasinoId = casino.__document_id, Id = comment.Id, DateTime = comment.DateTime, Author = comment.Author, Text = comment.Text})",
Stores =
{
{"CityId", FieldStorage.Yes},
{"CasinoId", FieldStorage.Yes},
{"Id", FieldStorage.Yes},
{"DateTime", FieldStorage.Yes},
{"Author", FieldStorage.Yes},
{"Text", FieldStorage.Yes}
}
});
var documentSession = documentStore.OpenSession();
var casino = new Casino("Cities/123456", "address", "name");
documentSession.Store(casino);
documentSession.SaveChanges();
var casinoFromDb = documentSession.Query<Casino>()
.Customize(x=>x.WaitForNonStaleResults())
.Where(x => x.Id == casino.Id).Single();
Assert.NotNull(casinoFromDb);
}
}
