public void TsHeadline()
{
using (var context = new BloggingContext(ConnectionString))
{
context.Database.Log = Console.Out.WriteLine;
var blog1 = new Blog
{
Name = "cooky cookie piano pianos"
};
context.Blogs.Add(blog1);
var blog2 = new Blog
{
Name = "blue crab denominates elephant"
};
context.Blogs.Add(blog2);
context.SaveChanges();
var headlines = context
.Blogs
.Select(
x => NpgsqlTextFunctions.TsHeadline(
x.Name,
NpgsqlTextFunctions.ToTsQuery("cookie"),
"StartSel=<i> StopSel=</i>"))
.ToList();
Assert.That(headlines.Count, Is.EqualTo(2));
Assert.That(headlines[0], Is.EqualTo("<i>cooky</i> <i>cookie</i> piano pianos"));
Assert.That(headlines[1], Is.EqualTo(blog2.Name));
headlines = context
.Blogs
.Select(
x => NpgsqlTextFunctions.TsHeadline(
"english",
x.Name,
NpgsqlTextFunctions.ToTsQuery("piano"),
"StartSel=<i> StopSel=</i>"))
.ToList();
Assert.That(headlines.Count, Is.EqualTo(2));
Assert.That(headlines[0], Is.EqualTo("cooky cookie <i>piano</i> <i>pianos</i>"));
Assert.That(headlines[1], Is.EqualTo(blog2.Name));
}
}
