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"); }