public static Like ( |
||
left | ||
right | ||
리턴 |
public static void VisitStringMatch() { var exp = SqlExpression.Like(SqlExpression.Constant(SqlObject.String(new SqlString("antonello"))), SqlExpression.Constant(SqlObject.String(new SqlString("an%"))), null); Visit(exp); }
public void StringLikesPattern(string input, string patern, bool expected) { var exp1 = SqlExpression.Constant(Field.String(patern)); var exp2 = SqlExpression.Constant(Field.String(input)); var likeExp = SqlExpression.Like(exp1, exp2); SqlExpression resultExp = null; Assert.DoesNotThrow(() => resultExp = likeExp.Evaluate()); Assert.IsNotNull(resultExp); Assert.IsInstanceOf <SqlConstantExpression>(resultExp); var constExp = (SqlConstantExpression)resultExp; Assert.IsNotNull(constExp.Value.Value); Assert.IsInstanceOf <BooleanType>(constExp.Value.Type); Assert.IsInstanceOf <SqlBoolean>(constExp.Value.Value); var actual = ((SqlBoolean)constExp.Value.Value); var expectedResult = new SqlBoolean(expected); Assert.AreEqual(expectedResult, actual); }