public void DynamicQueryWillInterpretFieldNamesProperly()
		{

			using (var store = NewDocumentStore())
			{

				using (var session = store.OpenSession())
				{

					var foo = new Foo()
					{

						SomeProperty = "Some Data",
						Bar = new Bar() { SomeDictionary = new Dictionary<string, string>() { { "KeyOne", "ValueOne" }, { "KeyTwo", "ValueTwo" } } }

					};

					session.Store(foo);

					foo = new Foo()
					{

						SomeProperty = "Some More Data",

					};

					session.Store(foo);

					foo = new Foo()
					{

						SomeProperty = "Some Even More Data",
						Bar = new Bar() { SomeDictionary = new Dictionary<string, string>() { { "KeyThree", "ValueThree" } } }

					};

					session.Store(foo);

					foo = new Foo()
					{

						SomeProperty = "Some Even More Data",
						Bar = new Bar() { SomeOtherDictionary = new Dictionary<string, string>() { { "KeyFour", "ValueFour" } } }

					};

					session.Store(foo);

					session.SaveChanges();

					store.DatabaseCommands.PutIndex("Foos/TestDynamicQueries", new IndexDefinition()
					{
						Map = @"from doc in docs.Foos
                                from docBarSomeOtherDictionaryItem in ((IEnumerable<dynamic>)doc.Bar.SomeOtherDictionary).DefaultIfEmpty()
                                from docBarSomeDictionaryItem in ((IEnumerable<dynamic>)doc.Bar.SomeDictionary).DefaultIfEmpty()
                                select new
                                {
                                    Bar_SomeOtherDictionary_Value = docBarSomeOtherDictionaryItem.Value,
                                    Bar_SomeOtherDictionary_Key = docBarSomeOtherDictionaryItem.Key,
                                    Bar_SomeDictionary_Value = docBarSomeDictionaryItem.Value,
                                    Bar_SomeDictionary_Key = docBarSomeDictionaryItem.Key,
                                    Bar = doc.Bar
                                }"
					}, true);

					RavenQueryStatistics stats;

					var result = session.Query<Foo>("Foos/TestDynamicQueries")
						.Where(x =>
							x.Bar.SomeDictionary.Any(y => y.Key == "KeyOne" && y.Value == "ValueOne") ||
								x.Bar.SomeOtherDictionary.Any(y => y.Key == "KeyFour" && y.Value == "ValueFour") ||
									x.Bar == null)
										.Customize(x => x.WaitForNonStaleResults())
											.Statistics(out stats).ToList();

					Assert.Equal(result.Count, 3);

				}

			}

		}
示例#2
0
        public void DynamicQueryWillInterpretFieldNamesProperly()
        {
            using (var store = NewDocumentStore())
            {
                using (var session = store.OpenSession())
                {
                    var foo = new Foo()
                    {
                        SomeProperty = "Some Data",
                        Bar          = new Bar()
                        {
                            SomeDictionary = new Dictionary <string, string>()
                            {
                                { "KeyOne", "ValueOne" }, { "KeyTwo", "ValueTwo" }
                            }
                        }
                    };

                    session.Store(foo);

                    foo = new Foo()
                    {
                        SomeProperty = "Some More Data",
                    };

                    session.Store(foo);

                    foo = new Foo()
                    {
                        SomeProperty = "Some Even More Data",
                        Bar          = new Bar()
                        {
                            SomeDictionary = new Dictionary <string, string>()
                            {
                                { "KeyThree", "ValueThree" }
                            }
                        }
                    };

                    session.Store(foo);

                    foo = new Foo()
                    {
                        SomeProperty = "Some Even More Data",
                        Bar          = new Bar()
                        {
                            SomeOtherDictionary = new Dictionary <string, string>()
                            {
                                { "KeyFour", "ValueFour" }
                            }
                        }
                    };

                    session.Store(foo);

                    session.SaveChanges();

                    store.DatabaseCommands.PutIndex("Foos/TestDynamicQueries", new IndexDefinition()
                    {
                        Map = @"from doc in docs.Foos
                                from docBarSomeOtherDictionaryItem in ((IEnumerable<dynamic>)doc.Bar.SomeOtherDictionary).DefaultIfEmpty()
                                from docBarSomeDictionaryItem in ((IEnumerable<dynamic>)doc.Bar.SomeDictionary).DefaultIfEmpty()
                                select new
                                {
                                    Bar_SomeOtherDictionary_Value = docBarSomeOtherDictionaryItem.Value,
                                    Bar_SomeOtherDictionary_Key = docBarSomeOtherDictionaryItem.Key,
                                    Bar_SomeDictionary_Value = docBarSomeDictionaryItem.Value,
                                    Bar_SomeDictionary_Key = docBarSomeDictionaryItem.Key,
                                    Bar = doc.Bar
                                }"
                    }, true);

                    RavenQueryStatistics stats;

                    var result = session.Query <Foo>("Foos/TestDynamicQueries")
                                 .Where(x =>
                                        x.Bar.SomeDictionary.Any(y => y.Key == "KeyOne" && y.Value == "ValueOne") ||
                                        x.Bar.SomeOtherDictionary.Any(y => y.Key == "KeyFour" && y.Value == "ValueFour") ||
                                        x.Bar == null)
                                 .Customize(x => x.WaitForNonStaleResults())
                                 .Statistics(out stats).ToList();

                    Assert.Equal(result.Count, 3);
                }
            }
        }