public void ConvertToLikeClause()
{
Localizable.ConvertToLikeClause("en", "pi__a", '#').Should().Be.EqualTo("%#en##pi__a#%");
Localizable.ConvertToLikeClause(new CultureInfo("en"), "pi__a", '#').Should().Be.EqualTo("%#en##pi__a#%");
// should use the DefaultKeyValueEncloser
Localizable.ConvertToLikeClause("en", "pi__a").Should().Be.EqualTo("%~en~~pi__a~%");
Localizable.ConvertToLikeClause(new CultureInfo("en"), "pi__a").Should().Be.EqualTo("%~en~~pi__a~%");
// with default values
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
"pi__a".ToLocalizableLikeClause('#')
.Should("should use the CurrentCulture").Be.EqualTo("%#en-US##pi__a#%");
"pi__a".ToLocalizableLikeClause()
.Should("should use the CurrentCulture and DefaultKeyValueEncloser").Be.EqualTo("%~en-US~~pi__a~%");
}
public void QueryWithHql()
{
FillDb();
using (ISession s = OpenSession())
{
s.CreateQuery("from EntityWithLocalizableProperty e where e.LocalizableDescriptions like :pTemplate")
.SetString("pTemplate", Localizable.ConvertToLikeClause("en-US", "H_l%"))
.List()
.Count
.Should().Be.EqualTo(1);
s.CreateQuery("from EntityWithLocalizableProperty e where e.LocalizableDescriptions like :pTemplate")
.SetString("pTemplate", Localizable.ConvertToLikeClause("en-US", "H_l_"))
.List()
.Count
.Should().Be.EqualTo(0);
}
Cleanup();
}