public XElement GetQueryXml(WorkItemContext context, FieldList fields)
        {
            var parser = new LexalParser(this.QueryText);
            var nodes = parser.ProcessWherePart();
            nodes.Optimize();
            nodes.ExtractOperatorForward();
            nodes.FixFields(fields);
            nodes.FillFieldTypes(fields);

            var manager = new ParameterManager(context);
            manager.EvalParameters(nodes);

            var xmlTransformer = new NodesToXml(nodes);
            return XElement.Parse(xmlTransformer.WriteXml());
        }
        public void RPN1()
        {
            XElement el = XElement.Parse(@"<f>select [System.Id], [Phoenix.DueDate], [Phoenix.MagicDueDate], [System.WorkItemType], [System.State], [System.Title], [System.IterationPath] 
from WorkItems 
where ([System.State] = 'New' 
    or [System.State] = 'Active') 
    and ([System.AssignedTo] = 'Ventsislav Mladenov' or [System.TeamProject] = 'TestProject') 
order by [System.Id]</f>");
            var parser = new LexalParser(el.Value);
            var nodes = parser.ProcessWherePart();
            nodes.Optimize();
            nodes.ExtractOperatorForward();
            var xmlTransformer = new NodesToXml(nodes);
            var result = xmlTransformer.WriteXml();
            Console.WriteLine(result);
            Assert.Equal("<Group GroupOperator=\"And\">\r\n  <Group GroupOperator=\"Or\">\r\n    <Expression Column=\"System.State\" FieldType=\"0\" Operator=\"equals\">\r\n      <String>New</String>\r\n    </Expression>\r\n    <Expression Column=\"System.State\" FieldType=\"0\" Operator=\"equals\">\r\n      <String>Active</String>\r\n    </Expression>\r\n  </Group>\r\n  <Group GroupOperator=\"Or\">\r\n    <Expression Column=\"System.AssignedTo\" FieldType=\"0\" Operator=\"equals\">\r\n      <String>Ventsislav Mladenov</String>\r\n    </Expression>\r\n    <Expression Column=\"System.TeamProject\" FieldType=\"0\" Operator=\"equals\">\r\n      <String>TestProject</String>\r\n    </Expression>\r\n  </Group>\r\n</Group>", result);
        }
 public void NodesToXml3()
 {
     string val = "where (([f] = 2 and [a] = 2) or [s] = 1) and ([b] = 3 or ([x] = 1 and [s] = 3))";
     var parser = new LexalParser(val);
     var nodes = parser.ProcessWherePart();
     nodes.Optimize();
     nodes.ExtractOperatorForward();
     var xmlTransformer = new NodesToXml(nodes);
     var output = xmlTransformer.WriteXml();
     Console.WriteLine(output);
 }
 public void NodesToXml2()
 {
     string val = "where ([f] = 2 and [a] = 2) or ([b] = 3 and [x] = 1)";
     var parser = new LexalParser(val);
     var nodes = parser.ProcessWherePart();
     nodes.Optimize();
     nodes.ExtractOperatorForward();
     var xmlTransformer = new NodesToXml(nodes);
     var output = xmlTransformer.WriteXml();
     Console.WriteLine(output);
     Assert.Equal("<Group GroupOperator=\"Or\">\r\n  <Group GroupOperator=\"And\">\r\n    <Expression Column=\"f\" FieldType=\"0\" Operator=\"equals\">\r\n      <Number>2</Number>\r\n    </Expression>\r\n    <Expression Column=\"a\" FieldType=\"0\" Operator=\"equals\">\r\n      <Number>2</Number>\r\n    </Expression>\r\n  </Group>\r\n  <Group GroupOperator=\"And\">\r\n    <Expression Column=\"b\" FieldType=\"0\" Operator=\"equals\">\r\n      <Number>3</Number>\r\n    </Expression>\r\n    <Expression Column=\"x\" FieldType=\"0\" Operator=\"equals\">\r\n      <Number>1</Number>\r\n    </Expression>\r\n  </Group>\r\n</Group>", output);
 }
 public void NodesToXml1()
 {
     string val = "where [f] = 2";
     var parser = new LexalParser(val);
     var nodes = parser.ProcessWherePart();
     nodes.Optimize();
     nodes.ExtractOperatorForward();
     var xmlTransformer = new NodesToXml(nodes);
     var output = xmlTransformer.WriteXml();
     Console.WriteLine(output);
     Assert.Equal("<Expression Column=\"f\" FieldType=\"0\" Operator=\"equals\">\r\n  <Number>2</Number>\r\n</Expression>", output);
 }
Exemplo n.º 6
0
        public void RPN4()
        {
            XElement el = XElement.Parse(@"<f>select [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State]
            from WorkItems
            where [System.TeamProject] = @project
            and [System.WorkItemType] &lt;&gt; ''
            and ([System.ChangedDate] &lt; @today - 30
              or [System.CreatedDate] &gt; @today - 7)
            and [Microsoft.VSTS.Common.ResolvedBy] = @me
            and [System.WorkItemType] in ('Bug', 'Task')
            and [System.State] &lt;&gt; ''
            order by [System.Id]</f>");

            var parser = new LexalParser(el.Value);
            var nodes = parser.ProcessWherePart();
            nodes.Optimize();
            nodes.ExtractOperatorForward();
            var xmlTransformer = new NodesToXml(nodes);
            var result = xmlTransformer.WriteXml();
            Console.WriteLine(result);
        }
Exemplo n.º 7
0
 public void RPN3()
 {
     string val = "where [Microsoft.VSTS.Common.ResolvedBy] = 'Ventsislav Mladenov' and [Microsoft.VSTS.CMMI.CalledBy] = 'Ventsislav Mladenov' or [Microsoft.VSTS.Common.ClosedBy] = 'Ventsislav Mladenov'";
     var parser = new LexalParser(val);
     var nodes = parser.ProcessWherePart();
     nodes.Optimize();
     nodes.ExtractOperatorForward();
     var xmlTransformer = new NodesToXml(nodes);
     var result = xmlTransformer.WriteXml();
     Console.WriteLine(result);
 }