public void AppendFilterEntry_does_not_create_comparison_for_missing_catalog_schema_or_name_if_any_specified()
{
Assert.Equal(
"(alias.SchemaName LIKE @p0 AND alias.Name LIKE @p1)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry(null, "schema", "name"),
new Dictionary <string, string>()).ToString());
Assert.Equal(
"(alias.CatalogName LIKE @p0 AND alias.Name LIKE @p1)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry("catalog", null, "name"),
new Dictionary <string, string>()).ToString());
Assert.Equal(
"(alias.CatalogName LIKE @p0 AND alias.SchemaName LIKE @p1)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry("catalog", "schema", null),
new Dictionary <string, string>()).ToString());
}
public void AppendFilterEntry_uses_OR_to_connect_multiple_filters()
{
var parameterMap = new Dictionary <string, string>();
var filterBuilder = new StringBuilder();
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
filterBuilder,
"alias",
new EntityStoreSchemaFilterEntry(null, null, null),
parameterMap);
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
filterBuilder,
"alias",
new EntityStoreSchemaFilterEntry("catalog", "schema", null),
parameterMap);
Assert.Equal(
"(alias.Name LIKE @p0) OR (alias.CatalogName LIKE @p1 AND alias.SchemaName LIKE @p2)",
filterBuilder.ToString());
Assert.Equal(3, parameterMap.Count);
Assert.Equal(parameterMap["%"], "p0");
Assert.Equal(parameterMap["catalog"], "p1");
Assert.Equal(parameterMap["schema"], "p2");
}
public void AppendFilterEntry_uses_OR_to_connect_multiple_filters()
{
var parameters = new EntityCommand().Parameters;
var filterBuilder = new StringBuilder();
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
filterBuilder,
"alias",
new EntityStoreSchemaFilterEntry(null, null, null),
parameters);
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
filterBuilder,
"alias",
new EntityStoreSchemaFilterEntry("catalog", "schema", null),
parameters);
Assert.Equal(
"(alias.Name LIKE @p0) OR (alias.CatalogName LIKE @p1 AND alias.SchemaName LIKE @p2)",
filterBuilder.ToString());
Assert.Equal(3, parameters.Count);
Assert.Equal("p0,p1,p2", string.Join(",", parameters.OfType <EntityParameter>().Select(p => p.ParameterName)));
Assert.Equal("%,catalog,schema", string.Join(",", parameters.OfType <EntityParameter>().Select(p => p.Value)));
}
public void AppendFilterEntry_uses_OR_to_connect_multiple_filters()
{
var parameters = CreateParameters();
var filterBuilder = new StringBuilder();
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
filterBuilder,
"alias",
new EntityStoreSchemaFilterEntry(null, null, null),
parameters);
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
filterBuilder,
"alias",
new EntityStoreSchemaFilterEntry("catalog", "schema", null),
parameters);
Assert.Equal(
"(alias.Name LIKE @p0) OR (alias.CatalogName LIKE @p1 AND alias.SchemaName LIKE @p2)",
filterBuilder.ToString());
Assert.Equal(3, parameters.Count);
Assert.Equal("p0", parameters[0].ParameterName);
Assert.Equal("p1", parameters[1].ParameterName);
Assert.Equal("%", parameters["p0"].Value);
Assert.Equal("catalog", parameters["p1"].Value);
Assert.Equal("schema", parameters["p2"].Value);
}
public void AppendFilterEntry_creates_filter_for_catalog_schema_and_name_if_all_specified()
{
var parameters = new EntityCommand().Parameters;
Assert.Equal(
"(alias.CatalogName LIKE @p0 AND alias.SchemaName LIKE @p1 AND alias.Name LIKE @p2)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry("catalog", "schema", "name"),
parameters).ToString());
Assert.Equal(3, parameters.Count);
}
public void AppendFilterEntry_uses_wildcard_parameter_value_if_schema_catalog_and_name_are_null()
{
var parameterMap = new Dictionary <string, string>();
Assert.Equal(
"(alias.Name LIKE @p0)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry(null, null, null),
parameterMap).ToString());
Assert.Equal(1, parameterMap.Count);
Assert.Equal(parameterMap["%"], "p0");
}
public void AppendFilterEntry_uses_wildcard_parameter_value_if_schema_catalog_and_name_are_null()
{
var parameters = new EntityCommand().Parameters;
Assert.Equal(
"(alias.Name LIKE @p0)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry(null, null, null),
parameters).ToString());
Assert.Equal(1, parameters.Count);
Assert.Equal("p0", parameters[0].ParameterName);
Assert.Equal("%", parameters[0].Value);
}
public void AppendFilterEntry_creates_filter_for_catalog_schema_and_name_if_all_specified()
{
var parameterMap = new Dictionary <string, string>();
Assert.Equal(
"(alias.CatalogName LIKE @p0 AND alias.SchemaName LIKE @p1 AND alias.Name LIKE @p2)",
EntityStoreSchemaQueryGenerator.AppendFilterEntry(
new StringBuilder(),
"alias",
new EntityStoreSchemaFilterEntry("catalog", "schema", "name"),
parameterMap).ToString());
Assert.Equal(3, parameterMap.Count);
Assert.Equal(parameterMap["catalog"], "p0");
Assert.Equal(parameterMap["schema"], "p1");
Assert.Equal(parameterMap["name"], "p2");
}
