public void TestQueryVariablesMssql(string expr, string expectedQuery) { Setup(expr); CalcParser.ExpressionContext context = this._calcParser.expression(); DbTranslator translator = new MssqlTranslator(); QueryVisitor visitor = new QueryVisitor(new TestMetadataResolver(), translator); string query = visitor.Visit(context); Assert.AreEqual(expectedQuery, query); }
public void TestQueryDatesMssql(string expr, string expectedQuery) { Setup(expr); CalcParser.ExpressionContext context = this._calcParser.expression(); DbTranslator translator = new MssqlTranslator(); IMetadataResolver resolver = Substitute.For <IMetadataResolver>(); QueryVisitor visitor = new QueryVisitor(resolver, translator); string query = visitor.Visit(context); Assert.AreEqual(expectedQuery, query); }
public void TestStringFldlenExpressionsMssql(string expr, string expectedQuery) { Setup(expr); CalcParser.ExpressionContext context = this._calcParser.expression(); DbTranslator translator = new MssqlTranslator(); IMetadataResolver resolver = Substitute.For <IMetadataResolver>(); resolver .GetField(Arg.Any <string>()) .Returns(callinfo => new FieldInfo { Name = callinfo.ArgAt <string>(0), Type = DFM_FIELD_TYPE.DFM_FT_STRING }); QueryVisitor visitor = new QueryVisitor(resolver, translator); string query = visitor.Visit(context); Assert.AreEqual(expectedQuery, query); }