public void HandleDatepartDateFunction_throws_when_argument_is_not_a_string() { Assert.Equal( Strings.SqlGen_InvalidDatePartArgumentExpression("My", "Function"), Assert.Throws <InvalidOperationException>( () => SqlFunctionCallHandler.HandleDatepartDateFunction( null, CreateMockDbFunctionExpression("My.Function", PrimitiveTypeKind.String, 69).Object)).Message); }
public void HandleDatepartDateFunction_throws_when_argument_does_not_contain_a_valid_date_part() { Assert.Equal( Strings.SqlGen_InvalidDatePartArgumentValue("mp4-27", "My", "Function"), Assert.Throws <InvalidOperationException>( () => SqlFunctionCallHandler.HandleDatepartDateFunction( null, CreateMockDbFunctionExpression("My.Function", PrimitiveTypeKind.String, "mp4-27").Object)).Message); }
public void HandleDatepartDateFunction_throws_when_argument_is_not_a_constant() { var mockExpression = new Mock <DbFunctionExpression>(); mockExpression.Setup(m => m.Function).Returns(CreateMockEdmFunction("My.Function").Object); mockExpression.Setup(m => m.Arguments).Returns(new[] { new Mock <DbExpression>().Object }); Assert.Equal( Strings.SqlGen_InvalidDatePartArgumentExpression("My", "Function"), Assert.Throws <InvalidOperationException>( () => SqlFunctionCallHandler.HandleDatepartDateFunction(null, mockExpression.Object)).Message); }
public void HandleDatepartDateFunction_builds_SQL_for_the_given_date_part_with_arguments() { var builder = new StringBuilder(); using (var writer = new SqlWriter(builder)) { SqlFunctionCallHandler.HandleDatepartDateFunction( null, CreateMockDbFunctionExpression("My.Function", PrimitiveTypeKind.String, "iso_week", "One", "Two").Object) .WriteSql(writer, null); Assert.Equal("[My].[Function](iso_week, One, Two)", builder.ToString()); } }