Skip to content

Instantly share code, notes, and snippets.

@kijanawoodard

kijanawoodard/AnotherApproach.cs

Last active December 18, 2015 03:29
Show Gist options
  • Save kijanawoodard/5718623 to your computer and use it in GitHub Desktop.
Save kijanawoodard/5718623 to your computer and use it in GitHub Desktop.
Download ZIP
Using the In operator of a List<T>
Raw
AnotherApproach.cs
using System;
using System.Collections.Generic;
using System.Linq;
using Raven.Client;
using Raven.Client.Linq;
using Raven.Imports.Newtonsoft.Json;
using Raven.Tests.Helpers;
using Xunit;
namespace RavenTests
{
public class QueryInTests : RavenTestBase
{
[Fact]
public void ShouldBeAbleToQueryInUsingValueWithQuotes()
{
var profiles = JsonConvert.DeserializeObject<ProviderIdentifier[]>("[{\"Provider\":0,\"Id\":\"js-\\\"4502453\\\"\"},{\"Provider\":6,\"Id\":\"311862799506\"},{\"Provider\":4,\"Id\":\"groupon\"},{\"Provider\":3,\"Id\":\"175045424\"},{\"Provider\":6,\"Id\":\"176348809057391\"},{\"Provider\":3,\"Id\":\"34686205\"},{\"Provider\":6,\"Id\":\"125988007456412\"},{\"Provider\":6,\"Id\":\"82991127915\"},{\"Provider\":2,\"Id\":\"355611\"},{\"Provider\":4,\"Id\":\"centzy\"},{\"Provider\":6,\"Id\":\"163923827016431\"},{\"Provider\":3,\"Id\":\"301171418\"},{\"Provider\":2,\"Id\":\"2453718\"},{\"Provider\":4,\"Id\":\"coffee-meets-bagel\"},{\"Provider\":2,\"Id\":\"2504677\"},{\"Provider\":4,\"Id\":\"beachmint\"},{\"Provider\":6,\"Id\":\"127540713947214\"},{\"Provider\":4,\"Id\":\"beach-mint\"},{\"Provider\":2,\"Id\":\"1310723\"},{\"Provider\":4,\"Id\":\"babbaco\"},{\"Provider\":6,\"Id\":\"30424541055\"},{\"Provider\":3,\"Id\":\"31930195\"},{\"Provider\":6,\"Id\":\"106229596074522\"},{\"Provider\":6,\"Id\":\"73665029540\"},{\"Provider\":2,\"Id\":\"280683\"},{\"Provider\":4,\"Id\":\"benchprep\"},{\"Provider\":4,\"Id\":\"cloudbot\"},{\"Provider\":3,\"Id\":\"346725079\"},{\"Provider\":6,\"Id\":\"170216073032912\"},{\"Provider\":4,\"Id\":\"lifecrowd\"},{\"Provider\":6,\"Id\":\"188456244507673\"},{\"Provider\":4,\"Id\":\"onswipe\"},{\"Provider\":6,\"Id\":\"100858346620905\"},{\"Provider\":4,\"Id\":\"udemy\"},{\"Provider\":2,\"Id\":\"822535\"},{\"Provider\":3,\"Id\":\"883288452\"},{\"Provider\":6,\"Id\":\"168851749919862\"},{\"Provider\":4,\"Id\":\"sunnybump\"},{\"Provider\":2,\"Id\":\"2785290\"}]");
// var profiles = JsonConvert.DeserializeObject<ProviderIdentifier[]>("[{\"Provider\":0,\"Id\":\"js-\\\"4502453\\\"\"}]");
var formatted = profiles.Select(x => x.Formatted);
using (var documentStore = NewDocumentStore())
{
using (var session = documentStore.OpenSession())
{
session.Store(new FeedItem
{
Id = Guid.NewGuid(),
RelatedProfiles = new List<ProviderIdentifier>()
{
profiles[0]
}
});
session.SaveChanges();
}
using (var session = documentStore.OpenSession())
{
var items =
session
.Query<FeedItem>()
.Where(fi => fi.RelatedProfiles.Any(x => x.Formatted.In(formatted)))
.ToArray();
Assert.Equal(1, items.Length);
}
}
}
public class ProviderIdentifier
{
public string Provider { get; set; }
public string Id { get; set; }
public string Formatted { get { return string.Format("providers/{0}/{1}", Provider, Id); } }
}
public class FeedItem
{
public Guid Id { get; set; }
public IList<ProviderIdentifier> RelatedProfiles { get; set; }
}
}
}
Raw
FailingTest.cs
using System;
using System.Collections.Generic;
using System.Linq;
using Raven.Client;
using Raven.Client.Linq;
using Raven.Imports.Newtonsoft.Json;
using Raven.Tests.Helpers;
using Xunit;
namespace RavenTests
{
public class QueryInTests : RavenTestBase
{
[Fact]
public void ShouldBeAbleToQueryInUsingValueWithQuotes()
{
//var profiles = JsonConvert.DeserializeObject<ProviderIdentifier[]>("[{\"Provider\":0,\"Id\":\"js-\\\"4502453\\\"\"},{\"Provider\":6,\"Id\":\"311862799506\"},{\"Provider\":4,\"Id\":\"groupon\"},{\"Provider\":3,\"Id\":\"175045424\"},{\"Provider\":6,\"Id\":\"176348809057391\"},{\"Provider\":3,\"Id\":\"34686205\"},{\"Provider\":6,\"Id\":\"125988007456412\"},{\"Provider\":6,\"Id\":\"82991127915\"},{\"Provider\":2,\"Id\":\"355611\"},{\"Provider\":4,\"Id\":\"centzy\"},{\"Provider\":6,\"Id\":\"163923827016431\"},{\"Provider\":3,\"Id\":\"301171418\"},{\"Provider\":2,\"Id\":\"2453718\"},{\"Provider\":4,\"Id\":\"coffee-meets-bagel\"},{\"Provider\":2,\"Id\":\"2504677\"},{\"Provider\":4,\"Id\":\"beachmint\"},{\"Provider\":6,\"Id\":\"127540713947214\"},{\"Provider\":4,\"Id\":\"beach-mint\"},{\"Provider\":2,\"Id\":\"1310723\"},{\"Provider\":4,\"Id\":\"babbaco\"},{\"Provider\":6,\"Id\":\"30424541055\"},{\"Provider\":3,\"Id\":\"31930195\"},{\"Provider\":6,\"Id\":\"106229596074522\"},{\"Provider\":6,\"Id\":\"73665029540\"},{\"Provider\":2,\"Id\":\"280683\"},{\"Provider\":4,\"Id\":\"benchprep\"},{\"Provider\":4,\"Id\":\"cloudbot\"},{\"Provider\":3,\"Id\":\"346725079\"},{\"Provider\":6,\"Id\":\"170216073032912\"},{\"Provider\":4,\"Id\":\"lifecrowd\"},{\"Provider\":6,\"Id\":\"188456244507673\"},{\"Provider\":4,\"Id\":\"onswipe\"},{\"Provider\":6,\"Id\":\"100858346620905\"},{\"Provider\":4,\"Id\":\"udemy\"},{\"Provider\":2,\"Id\":\"822535\"},{\"Provider\":3,\"Id\":\"883288452\"},{\"Provider\":6,\"Id\":\"168851749919862\"},{\"Provider\":4,\"Id\":\"sunnybump\"},{\"Provider\":2,\"Id\":\"2785290\"}]");
var profiles = JsonConvert.DeserializeObject<ProviderIdentifier[]>("[{\"Provider\":0,\"Id\":\"js-\\\"4502453\\\"\"}]");
using (var documentStore = NewDocumentStore())
{
using (var session = documentStore.OpenSession())
{
session.Store(new FeedItem
{
Id = Guid.NewGuid(),
RelatedProfiles = new List<ProviderIdentifier>()
{
profiles[0]
}
});
session.SaveChanges();
}
using (var session = documentStore.OpenSession())
{
var items =
session
.Query<FeedItem>()
.Where(fi => fi.RelatedProfiles.Any(x => x.In(profiles)))
.ToArray();
Assert.Equal(1, items.Length);
}
}
}
public class ProviderIdentifier
{
public string Provider { get; set; }
public string Id { get; set; }
}
public class FeedItem
{
public Guid Id { get; set; }
public IList<ProviderIdentifier> RelatedProfiles { get; set; }
}
}
}
Raw
QueryInTests.cs
using System;
using System.Collections.Generic;
using System.Linq;
using Raven.Client;
using Raven.Client.Linq;
using Raven.Imports.Newtonsoft.Json;
using Raven.Tests.Helpers;
using Xunit;
namespace RavenTests
{
public class QueryInTests : RavenTestBase
{
[Fact]
public void ShouldBeAbleToQueryInUsingValueWithQuotes()
{
//var profiles = JsonConvert.DeserializeObject<ProviderIdentifier[]>("[{\"Provider\":0,\"Id\":\"js-\\\"4502453\\\"\"},{\"Provider\":6,\"Id\":\"311862799506\"},{\"Provider\":4,\"Id\":\"groupon\"},{\"Provider\":3,\"Id\":\"175045424\"},{\"Provider\":6,\"Id\":\"176348809057391\"},{\"Provider\":3,\"Id\":\"34686205\"},{\"Provider\":6,\"Id\":\"125988007456412\"},{\"Provider\":6,\"Id\":\"82991127915\"},{\"Provider\":2,\"Id\":\"355611\"},{\"Provider\":4,\"Id\":\"centzy\"},{\"Provider\":6,\"Id\":\"163923827016431\"},{\"Provider\":3,\"Id\":\"301171418\"},{\"Provider\":2,\"Id\":\"2453718\"},{\"Provider\":4,\"Id\":\"coffee-meets-bagel\"},{\"Provider\":2,\"Id\":\"2504677\"},{\"Provider\":4,\"Id\":\"beachmint\"},{\"Provider\":6,\"Id\":\"127540713947214\"},{\"Provider\":4,\"Id\":\"beach-mint\"},{\"Provider\":2,\"Id\":\"1310723\"},{\"Provider\":4,\"Id\":\"babbaco\"},{\"Provider\":6,\"Id\":\"30424541055\"},{\"Provider\":3,\"Id\":\"31930195\"},{\"Provider\":6,\"Id\":\"106229596074522\"},{\"Provider\":6,\"Id\":\"73665029540\"},{\"Provider\":2,\"Id\":\"280683\"},{\"Provider\":4,\"Id\":\"benchprep\"},{\"Provider\":4,\"Id\":\"cloudbot\"},{\"Provider\":3,\"Id\":\"346725079\"},{\"Provider\":6,\"Id\":\"170216073032912\"},{\"Provider\":4,\"Id\":\"lifecrowd\"},{\"Provider\":6,\"Id\":\"188456244507673\"},{\"Provider\":4,\"Id\":\"onswipe\"},{\"Provider\":6,\"Id\":\"100858346620905\"},{\"Provider\":4,\"Id\":\"udemy\"},{\"Provider\":2,\"Id\":\"822535\"},{\"Provider\":3,\"Id\":\"883288452\"},{\"Provider\":6,\"Id\":\"168851749919862\"},{\"Provider\":4,\"Id\":\"sunnybump\"},{\"Provider\":2,\"Id\":\"2785290\"}]");
var profiles = JsonConvert.DeserializeObject<ProviderIdentifier[]>("[{\"Provider\":0,\"Id\":\"js-\\\"4502453\\\"\"}]");
var ids = profiles.Select(x => x.Id).ToArray();
using (var documentStore = NewDocumentStore())
{
using (var session = documentStore.OpenSession())
{
session.Store(new FeedItem
{
Id = Guid.NewGuid(),
RelatedProfiles = new List<ProviderIdentifier>()
{
profiles[0]
}
});
session.SaveChanges();
}
using (var session = documentStore.OpenSession())
{
RavenQueryStatistics stats;
var items =
session
.Query<FeedItem>()
.Customize(x => x.WaitForNonStaleResultsAsOfNow())
.Statistics(out stats)
.Where(fi => fi.RelatedProfiles.Any(rp => rp.Id.In(ids)))
.ToArray();
Assert.Equal(1, items.Length);
}
}
}
public class ProviderIdentifier
{
public string Provider { get; set; }
public string Id { get; set; }
}
public class FeedItem
{
public Guid Id { get; set; }
public IList<ProviderIdentifier> RelatedProfiles { get; set; }
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment