public BetweenStructure(string text, string columnName, Interval sourceInterval, ParserRuleContext context)
{
BetweenPredicate tmpBetweenPredicate = new BetweenPredicate(sourceInterval, context, text);
_text = tmpBetweenPredicate.Text;
_columnName = columnName;
_sourceInterval = sourceInterval;
}
public void BetweenPredicate(SqlFragment parent, BetweenPredicate element)
{
this.Script.OpenParen();
element.Expression.Build(parent, this);
this.Script.Append(TSqlKeyword.BETWEEN);
element.Minimum.Build(parent, this);
this.Script.Append(TSqlKeyword.AND);
element.Maximum.Build(parent, this);
this.Script.CloseParen();
}
public void BetweenPredicate_ReturnsProperSql()
{
var pred = new BetweenPredicate<PredicateTestEntity>
{
PropertyName = "Id",
Value = new BetweenValues {Value1 = 1, Value2 = 10}
};
Dictionary<string, object> parameters = new Dictionary<string, object>();
string result = pred.GetSql(parameters);
Assert.AreEqual("([PredicateTestEntity].[Id] BETWEEN @Id_0 AND @Id_1)", result);
Assert.AreEqual(2, parameters.Count);
}
public override void EnterBetweenPredicate(MySqlParser.BetweenPredicateContext context)
{
if (_isOtherListener == 1)
{
if (context.ChildCount > 1)
{
Rules.Remove(Rules[Rules.Count - 1]);
}
BetweenPredicate betweenPredicate =
new BetweenPredicate(context.SourceInterval, context, context.GetText());
Rules.Add(betweenPredicate);
}
_isOtherListener++;
}
public void BetweenPredicate_ReturnsProperSql()
{
var pred = new BetweenPredicate <PredicateTestEntity>
{
PropertyName = "Id",
Value = new BetweenValues {
Value1 = 1, Value2 = 10
}
};
Dictionary <string, object> parameters = new Dictionary <string, object>();
string result = pred.GetSql(parameters);
Assert.AreEqual("([PredicateTestEntity].[Id] BETWEEN @Id_0 AND @Id_1)", result);
Assert.AreEqual(2, parameters.Count);
}
public void GetSql()
{
var predicate = new BetweenPredicate <TestEntity>()
{
Value = new BetweenValues()
{
Value1 = 10,
Value2 = 20,
},
Not = false,
PropertyName = "Id"
};
var dictionary = new Dictionary <string, object>();
var sql = predicate.GetSql(SqlHelper.GetSqlGenerator(), dictionary);
Assert.Equal("(Id BETWEEN @Id_0 AND @Id_1)", sql);
Assert.Equal(10, dictionary["@Id_0"]);
Assert.Equal(20, dictionary["@Id_1"]);
}
void IVisitor.VisitOnBetween(BetweenPredicate predicate, int offset)
{
this.ParentExists(predicate);
}
void IVisitor.VisitBefore(BetweenPredicate predicate)
{
this.ParentExists(predicate);
}
void IVisitor.VisitAfter(BetweenPredicate predicate)
{
this.ParentExists(predicate);
}
public static ValueExpression GetMinimum(this BetweenPredicate predicate)
{
return(predicate.Rights[0]);
}
