[Ignore] // test case issue, request uri and service root in this case is null.
public void RequestQueryParserTestFilterTest()
{
var service = new OpenWebDataService <CustomDataContext>();
service.AttachHost(new TestServiceHost2());
CustomDataContext context = ServiceModelData.InitializeAndGetContext(service);
Prov.ResourceType customerType = GetResourceTypeForContainer(service, "Customers");
object customerSet = GetResourceSetWrapper(service, "Customers");
IQueryable result = InvokeWhere(service, GetRequestDescription(customerType, customerSet, "Customers"), context.Customers, "ID eq 5");
XmlDocument document = CreateDocumentFromIQueryable(result);
Trace.WriteLine(document.InnerXml);
UnitTestsUtil.VerifyXPaths(document,
"/Source//*[@NodeType='Lambda']",
"/Source//*[@NodeType='Lambda']/Body[@Type='System.Boolean']",
"/Source//*[@NodeType='Lambda']/Body[@Type='System.Boolean']/*[@NodeType='Constant' and @Value='5']",
"/Source//*[@NodeType='Lambda']/Body[@Type='System.Boolean']/*[@NodeType='MemberAccess' and contains(@Member, 'ID')]");
}
public void RequestQueryParserTestNegativeTests()
{
// Repro Protocol: filter throws NYI when using null with arithmetic operators
var service = new OpenWebDataService <CustomDataContext>();
service.AttachHost(new TestServiceHost2());
CustomDataContext context = ServiceModelData.InitializeAndGetContext(service);
string[] predicates = new string[]
{
"1 eq 1 and not not 2 eq 1 add 1",
"1 eq FakePropertyName",
"1 eq '1'",
"1 add",
"'",
"?",
"1 add 1",
"#",
"endswith(123, 'abc')",
"endswith('abc')",
"endswith('abc', 123)",
"0xaa eq 0xa",
"0xaa eq 0xag",
"null add 4 eq 1",
"'a' add 'b' eq 'ab'",
"endswith(Name add 'b', 'b')",
"BestFriend add null",
};
// This way of getting the type is less ideal than getting it based on the
// container name (see GetResourceTypeForContainer), because it does not work
// for custom IDataServiceProvider implementations. In this case there seems to be
// no other option.
Prov.ResourceType customerType = GetResourceType(service, context.Customers.ElementType.FullName);
object customerSet = GetResourceSetWrapper(service, "Customers");
VerifyExceptionForWhere(service, customerSet, customerType, context.Customers, predicates);
}
[Ignore] // test case issue, request uri and service root in this case is null.
public void RequestQueryParserTestBasicTests()
{
using (OpenWebDataServiceHelper.AcceptReplaceFunctionInQuery.Restore())
{
OpenWebDataServiceHelper.AcceptReplaceFunctionInQuery.Value = true;
TestUtil.ClearConfiguration();
// Repro Protocol: Filter - replace not implemented?
// Repro Protocol: Can't cast simple primitive value in filter expression
CombinatorialEngine engine = CombinatorialEngine.FromDimensions(
new Dimension("ServiceModelData", ServiceModelData.Values));
TestUtil.RunCombinatorialEngineFail(engine, delegate(Hashtable values)
{
ServiceModelData modelData = (ServiceModelData)values["ServiceModelData"];
object service = Activator.CreateInstance(typeof(OpenWebDataService <>).MakeGenericType(modelData.ServiceModelType));
service.GetType().GetMethod("AttachHost", BindingFlags.Public | BindingFlags.Instance).Invoke(service, new object[] { new TestServiceHost2() });
object context = ServiceModelData.InitializeAndGetContext(service);
object provider = ServiceModelData.CreateProvider(context, service);
if (!modelData.ContainerNames.Contains("Customers"))
{
return;
}
string customerNameProperty = modelData.IsUnitTestProvider ? "Name" : "CompanyName";
string integerProperty = modelData.IsUnitTestProvider ? "ID" : "1";
string[] predicates = new string[]
{
"1 eq 1",
"1 add 1 eq 2",
"2 eq 1 add 1",
"3.5 eq 3 add 0.5",
"3.5 eq 3 add 0.5",
"1 add 2 mul 2 eq 5",
"(1 add 2) mul 2 eq 6",
"2 sub 1 eq 1",
"2 sub 1 add 1 ne 1",
"1 add 1 lt 5",
"1 add 1 le 2",
"1 add 1 ge 2",
"1 add 1 gt 1",
"1 lt " + Int64.MaxValue + "L",
"1 gt " + Int64.MinValue + "L",
///TODO: these 2 should succeed, (double, double, single) shouldn't get -1 from
///private static int CompareConversions(Type source, Type targetA, Type targetB) , this method needs some fixing.
///"1 lt " + decimal.MaxValue + "00",
///"1 gt " + decimal.MinValue + "00",
"not (1 add 1 eq 1)",
"1 eq 1 or 2 eq 1",
"1 eq 1 and 2 eq 1 add 1",
"1 eq 1 and not not (2 eq 1 add 1)",
"1 eq 0 sub -1",
"1 eq 0 sub - 1",
"0 sub 3 eq -(3)",
"'a' eq 'a'",
"'abc' eq 'abc'",
"'''' eq ''''",
"-" + integerProperty + " eq 1 sub 2",
customerNameProperty + " eq 'John' or 1 eq 1",
"10 div 2 eq 5",
"3 mod 2 eq 1",
"1 gt " + XmlConvert.ToString(10.1E-9),
"1 lt " + XmlConvert.ToString(10.1E+3),
"binary'12AABBff' eq Binary'12aabbFF'",
"binary'000102030405060708090A0B0C0D0E0F' eq BINARY'000102030405060708090a0b0c0d0e0f'",
"binary'12AABBff' ne binary'22aabbFF'",
// String functions.
"endswith('abc', 'bc')",
"startswith('abc', 'ab')",
"not startswith('abc', 'aab')",
"contains('abc','b')",
"indexof('abc', 'b') ge 1",
"replace('foo','o','g') eq 'fgg'",
"substring('123', 1) eq '23'",
"substring('123', 1, 1) eq '2'",
"tolower('ABC') eq 'abc'",
"toupper('AbC') eq 'ABC'",
"length(toupper('aBc')) eq length(tolower('aBc'))",
"concat('a', 'b') eq 'ab'",
"'a' lt 'b'",
"'a' le 'a'",
"'a' ge 'a'",
"'b' ge 'a'",
// "'a' add 'b' eq 'ab'",
// Repro Protocol: can't call date function in filter expressions on LinqToSql
"startswith(" + customerNameProperty + ", 'C')",
"endswith(concat(" + customerNameProperty + ", 'b'), 'b')",
"contains(" + customerNameProperty + ",'C')",
"trim(" + customerNameProperty + ") eq substring(" + customerNameProperty + ", 0)",
// DateTime functions.
"year(2007-08-08) eq 2007",
"month(2007-08-10) eq 08",
"day(2007-08-10) eq 10",
"hour(2007-08-10T14:11:12Z) eq 14",
"minute(2007-08-10T14:11:12Z) eq 11",
"second(2007-08-10T14:11:12Z) eq 12",
// Math functions.
"round(1.1) eq 1",
"round(42) eq 42",
"floor(1.1M) eq 1",
"ceiling(1.1f) eq 2",
};
if (modelData.IsUnitTestProvider)
{
// Refer to some specific types.
string[] customDataContextPredicates = new string[]
{
// "(BestFriend ne null and BestFriend/Name eq 'John') or 1 eq 1",
"GuidValue ne 5dc82c04-570a-41f5-b48f-c8a4e436f716",
"GuidValue ne 5dc82c04-570a-41f5-b48f-c8a4e436f716",
"GuidValue ne 5dc82c04-570a-41f5-b48f-c8a4e436f716 and GuidValue ne 5dc82c04-570a-41f5-b48f-c8a4e436f716",
// Type functions.
"ID eq cast(1, 'Edm.Int32')",
String.Format("not isof(1, '{0}')", UnitTestsUtil.ConvertTypeNames("AstoriaUnitTests.Stubs.Customer", context)),
String.Format("isof('{0}')", UnitTestsUtil.ConvertTypeNames("AstoriaUnitTests.Stubs.Customer", context)),
String.Format("isof('{0}') and cast('{0}')/Birthday gt 1960-01-01", UnitTestsUtil.ConvertTypeNames("AstoriaUnitTests.Stubs.CustomerWithBirthday", context))
};
if (!(context is CustomRowBasedOpenTypesContext))
{
predicates = predicates.Concat(new string[] {
"ID eq cast(1, 'Edm.Int64')",
"ID eq 1L"
}).ToArray();
}
predicates = predicates.Concat(customDataContextPredicates).ToArray();
}
else if (context is NorthwindModel.NorthwindContext)
{
string[] northwindPredicates = new string[]
{
// Repro 602210 - Exception when filter expression contains null
"((((CustomerID) eq ('ALFKI')) and ((CustomerID) eq ('ANATR')))) or ((Region) ne (null))"
};
predicates = predicates.Concat(northwindPredicates).ToArray();
}
else if (context is AstoriaUnitTests.Stubs.Sql.SqlNorthwindDataContext)
{
string[] sqlNorthwindPredicates = new string[]
{
// Repro Protocol: Can't compare properties to null in LinqToSql filter expression
"Categories|CategoryName eq null or 1 add 1 eq 2",
"Categories|null eq CategoryName or 1 add 1 eq 2",
// Repro Protocol: error trying to use Link property in filter expression (LinqToSql)
//"Categories|contains('Beer',CategoryName)",
//"Products|contains('Beer',Categories/CategoryName)",
// Repro Protocol: can't call date function in filter expressions on LinqToSql
//"Employees|month(HireDate) eq 5",
};
predicates = sqlNorthwindPredicates;
// predicates = predicates.Concat(sqlNorthwindPredicates).ToArray();
}
VerifyResultsExistForWhere(service, context, "Customers", predicates);
});
}
}
