Exemplo n.º 1
0
        public void Full_text_search()
        {
            using (var connector = new Connector(_config))
            {
                connector.AdminInterface().DropDatabase();

                var ids = connector.GenerateUniqueIds("home_id", 103);

                var list = new List <Home>();
                for (var i = 0; i < 100; i++)
                {
                    var home = new Home
                    {
                        Id          = ids[i],
                        Town        = "Paris",
                        CountryCode = "FR",
                        Address     = "rue des malheurs",
                        Bathrooms   = 1,
                        Rooms       = 2
                    };
                    list.Add(home);
                }

                var homes = connector.DataSource <Home>();
                homes.PutMany(list);


                // manually add some items for full-text search testing
                var h1 = new Home
                {
                    Id           = ids[ids.Length - 3],
                    Address      = "14 rue de la mort qui tue",
                    Bathrooms    = 2,
                    CountryCode  = "FR",
                    PriceInEuros = 150,
                    Rooms        = 3,
                    Town         = "Paris",
                    Comments     = new List <Comment>
                    {
                        new Comment {
                            Text = "beautiful view"
                        },
                        new Comment {
                            Text = "close to the metro"
                        },
                    }
                };

                var h2 = new Home
                {
                    Id           = ids[ids.Length - 2],
                    Address      = "15 allée de l'amour",
                    Bathrooms    = 1,
                    CountryCode  = "FR",
                    PriceInEuros = 250,
                    Rooms        = 4,
                    Town         = "Paris",
                    Comments     = new List <Comment>
                    {
                        new Comment {
                            Text = "ps4"
                        },
                        new Comment {
                            Text = "close to the metro"
                        },
                    }
                };

                var h3 = new Home
                {
                    Id           = ids[ids.Length - 1],
                    Address      = "156 db du gral Le Clerc",
                    Bathrooms    = 2,
                    CountryCode  = "FR",
                    PriceInEuros = 200,
                    Rooms        = 3,
                    Town         = "Nice",
                    Comments     = new List <Comment>
                    {
                        new Comment {
                            Text = "wonderful sea view"
                        },
                        new Comment {
                            Text = "close to beach"
                        },
                    }
                };

                homes.Put(h1);
                homes.Put(h2);
                homes.Put(h3);

                var result = homes.FullTextSearch("gral le clerc");
                Assert.AreEqual(h3.Id, result.First().Id);

                result = homes.FullTextSearch("amour");
                Assert.AreEqual(h2.Id, result.First().Id);
            }
        }
Exemplo n.º 2
0
        public void Full_text_search()
        {
            using (var connector = new Connector(_clientConfig))
            {
                var dataSource = connector.DataSource <Home>();

                dataSource.PutMany(new[]
                {
                    new Home
                    {
                        Id = 10, Address = "14 rue de le pompe", Town = "Paris", Comments = new List <Comment>
                        {
                            new Comment {
                                Text = "close to the metro"
                            },
                            new Comment {
                                Text = "beautiful view"
                            }
                        }
                    },

                    new Home
                    {
                        Id = 20, Address = "10 rue du chien qui fume", Town = "Nice", Comments = new List <Comment>
                        {
                            new Comment {
                                Text = "close to the metro"
                            },
                            new Comment {
                                Text = "ps4"
                            }
                        }
                    }
                });


                var result1 = dataSource.FullTextSearch("rue de la pompe").ToList();
                Assert.AreEqual(1, result1.Count);
                Assert.AreEqual(10, result1.First().Id);

                var result2 = dataSource.FullTextSearch("close metro").ToList();
                Assert.AreEqual(2, result2.Count);

                result2 = dataSource.FullTextSearch("close metro").Take(1).ToList();
                Assert.AreEqual(1, result2.Count);

                var result3 = dataSource.FullTextSearch("close metro ps4").ToList();
                Assert.AreEqual(2, result3.Count);
                Assert.AreEqual(20, result3.First().Id, "the best match was not returned first");

                result3 = dataSource.FullTextSearch("close metro ps").ToList();
                Assert.AreEqual(2, result3.Count);
                Assert.AreEqual(20, result3.First().Id, "the best match was not the first returned");

                var result4 = dataSource.FullTextSearch("blah blah paris").ToList();
                Assert.AreEqual(10, result4.First().Id);

                //  this last one should be found by pure "same document" strategy
                result3 = dataSource.FullTextSearch("metro ps").ToList();
                Assert.AreEqual(20, result3.First().Id, "the best match was not the first returned");

                // search single token
                result3 = dataSource.FullTextSearch("ps").ToList();
                Assert.AreEqual(1, result3.Count);
                Assert.AreEqual(20, result3.Single().Id, "only one object should be returned");

                // search unknown token
                var result5 = dataSource.FullTextSearch("blah").ToList();
                Assert.AreEqual(0, result5.Count);
            }

            StopServers();
            StartServers();

            // check that full text search still works after restart

            using (var connector = new Connector(_clientConfig))
            {
                var homes = connector.DataSource <Home>();

                var result1 = homes.FullTextSearch("rue de la pompe").ToList();
                Assert.AreEqual(10, result1.First().Id);

                var updated = new Home
                {
                    Id = 20, Address = "10 rue du chien qui fume", Town = "Nice", Comments = new List <Comment>
                    {
                        new Comment {
                            Text = "close to the metro"
                        },
                        new Comment {
                            Text = "4k tv"
                        }
                    }
                };

                homes.Put(updated);

                // as the object was updated this query will return no result
                var result = homes.FullTextSearch("ps").ToList();
                Assert.AreEqual(0, result.Count);

                result = homes.FullTextSearch("4k").ToList();
                Assert.AreEqual(1, result.Count);
                Assert.AreEqual(20, result.Single().Id, "newly updated object not found");

                // now delete the object. The full-text search should not return the previous result any more
                homes.Delete(updated);
                result = homes.FullTextSearch("4k").ToList();
                Assert.AreEqual(0, result.Count);
            }
        }