public void test_THAT_order_by_IS_translated_correctly() { string xml = " <OrderBy>" + " <FieldRef Name=\"Modified\" Ascending=\"False\" />" + " </OrderBy>"; var b = new ReOperandBuilderFromCaml(); var t = new ReTranslatorFromCaml(null, new ReArrayAnalyzer(XmlHelper.Get(xml), b), null, null, null, null); var expr = t.TranslateOrderBy(); Assert.That(expr.ToString(), Is.EqualTo("x => (x.get_Item(\"Modified\") As Desc)")); }
public void test_WHEN_view_field_is_specified_THEN_expressions_are_linked_correctly() { string viewFields = "<ViewFields>" + "<FieldRef Name=\"field1\" />" + "</ViewFields>"; var l = new ReLinkerFromCaml(null, null, null, XmlHelper.Get(viewFields), null, null); var g = new GroupByParams(); var expr = l.Link(null, null, null, (Expression <Func <SPListItem, object> >)(x => x["field1"]), null, null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().ViewFields(x => x.get_Item(\"field1\"), True)")); }
public void test_WHEN_where_and_order_by_are_specified_THEN_expressions_are_linked_correctly() { var orderBy = " <OrderBy>" + " <FieldRef Name=\"Title\" Ascending=\"True\" />" + " </OrderBy>"; var l = new ReLinkerFromCaml(null, XmlHelper.Get(orderBy), null, null, null, null); var g = new GroupByParams(); var expr = l.Link((Expression <Func <SPListItem, bool> >)(x => (int)x["foo"] == 1), (Expression <Func <SPListItem, object> >)(x => x["Title"] as Camlex.Asc), null, null, null, null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().Where(x => (Convert(x.get_Item(\"foo\")) = 1)).OrderBy(x => (x.get_Item(\"Title\") As Asc))")); }
public void test_WHEN_group_by_is_specified_THEN_expressions_are_linked_correctly() { var groupBy = " <GroupBy>" + " <FieldRef Name=\"field1\" />" + " </GroupBy>"; var l = new ReLinkerFromCaml(null, null, XmlHelper.Get(groupBy), null, null, null); var g = new GroupByParams(); var expr = l.Link(null, null, (Expression <Func <SPListItem, object> >)(x => x["field1"]), null, null, null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().GroupBy(x => x.get_Item(\"field1\"))")); }
public void test_THAT_where_IS_translated_correctly() { string xml = " <Eq>" + " <FieldRef Name=\"Title\" />" + " <Value Type=\"Text\">testValue</Value>" + " </Eq>"; var b = new ReOperandBuilderFromCaml(); var t = new ReTranslatorFromCaml(new ReEqAnalyzer(XmlHelper.Get(xml), b), null, null, null, null, null); var expr = t.TranslateWhere(); Assert.That(expr.ToString(), Is.EqualTo("x => (Convert(x.get_Item(\"Title\")) = \"testValue\")")); }
public void test_WHEN_several_order_by_are_specified_THEN_expressions_are_linked_correctly() { var orderBy = " <OrderBy>" + " <FieldRef Name=\"Title\" />" + " <FieldRef Name=\"Date\" Ascending=\"False\" />" + " </OrderBy>"; var l = new ReLinkerFromCaml(null, XmlHelper.Get(orderBy), null, null, null, null); var g = new GroupByParams(); var expr = l.Link(null, (Expression <Func <SPListItem, object[]> >)(x => new[] { x["Title"], x["Date"] as Camlex.Desc }), null, null, null, null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().OrderBy(x => new [] {x.get_Item(\"Title\"), (x.get_Item(\"Date\") As Desc)})")); }
public void test_WHEN_user_id_tag_is_specified_THEN_expression_is_valid() { var xml = "<Eq>" + " <FieldRef Name=\"foo\"/>" + " <Value Type=\"Integer\"><UserID /></Value>" + "</Eq>"; var operandBuilder = new ReOperandBuilderFromCaml(); var analyzer = new ReEqAnalyzer(XmlHelper.Get(xml), operandBuilder); var operation = (EqOperation)analyzer.GetOperation(); Assert.That(operation.ToExpression().ToString(), Is.EqualTo( "(x.get_Item(\"foo\") == Convert(Convert(Camlex.UserID)))")); }
public void test_WHEN_1_projected_field_is_specified_THEN_expressions_are_linked_correctly() { string xml = "<ProjectedFields>" + "<Field Name=\"test\" Type=\"Lookup\" List=\"foo\" ShowField=\"bar\" />" + "</ProjectedFields>"; var l = new ReLinkerFromCaml(null, null, null, null, null, XmlHelper.Get(xml)); var g = new GroupByParams(); Expression <Func <SPListItem, object> > ex = x => x["test"].List("foo").ShowField("bar"); var expr = l.Link(null, null, null, null, null, (new[] { (LambdaExpression)ex }).ToList(), g); Assert.That(expr.ToString(), Is.EqualTo("Query().ProjectedFields().Field(x => x.get_Item(\"test\").List(\"foo\").ShowField(\"bar\"))")); }
public void test_WHEN_group_by_with_collapse_and_group_limit_is_specified_THEN_expressions_are_linked_correctly() { var groupBy = " <GroupBy Collapse=\"True\" GroupLimit=\"1\">" + " <FieldRef Name=\"field1\" />" + " </GroupBy>"; var l = new ReLinkerFromCaml(null, null, XmlHelper.Get(groupBy), null, null, null); var g = new GroupByParams { HasCollapse = true, Collapse = true, HasGroupLimit = true, GroupLimit = 1 }; var expr = l.Link(null, null, (Expression <Func <SPListItem, object> >)(x => x["field1"]), null, null, null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().GroupBy(x => x.get_Item(\"field1\"), True, 1)")); }
public void test_WHEN_type_is_user_id_and_value_is_specified_THEN_expression_is_valid() { var xml = "<Eq>" + " <FieldRef Name=\"foo\" LookupId=\"True\" />" + " <Value Type=\"User\">123</Value>" + "</Eq>"; var operandBuilder = new ReOperandBuilderFromCaml(); var analyzer = new ReEqAnalyzer(XmlHelper.Get(xml), operandBuilder); var operation = (EqOperation)analyzer.GetOperation(); Assert.That(operation.ToExpression().ToString(), Is.EqualTo( "(x.get_Item(\"foo\") = Convert(Convert(\"123\")))")); }
public void test_THAT_group_by_IS_translated_correctly() { string xml = " <GroupBy>" + " <FieldRef Name=\"field1\" />" + " </GroupBy>"; var b = new ReOperandBuilderFromCaml(); var t = new ReTranslatorFromCaml(null, null, new ReArrayAnalyzer(XmlHelper.Get(xml), b), null, null, null); var g = new GroupByParams(); var expr = t.TranslateGroupBy(out g); Assert.That(expr.ToString(), Is.EqualTo("x => x.get_Item(\"field1\")")); Assert.IsFalse(g.HasCollapse); Assert.IsFalse(g.HasGroupLimit); }
public void test_WHEN_group_by_with_group_limit_is_specified_with_several_fied_refs_THEN_expressions_are_linked_correctly() { var groupBy = " <GroupBy GroupLimit=\"1\">" + " <FieldRef Name=\"field1\" />" + " <FieldRef Name=\"field2\" />" + " </GroupBy>"; var l = new ReLinkerFromCaml(null, null, XmlHelper.Get(groupBy), null, null, null); var g = new GroupByParams { HasGroupLimit = true, GroupLimit = 1 }; var expr = l.Link(null, null, (Expression <Func <SPListItem, object[]> >)(x => new[] { x["field1"], x["field2"] }), null, null, null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().GroupBy(x => new [] {x.get_Item(\"field1\"), x.get_Item(\"field2\")}, null, 1)")); }
public void test_WHEN_1_join_is_specified_THEN_expressions_are_linked_correctly() { string xml = "<Joins>" + "<Join Type=\"LEFT\" ListAlias=\"Customers\">" + "<Eq>" + "<FieldRef Name=\"CustomerName\" RefType=\"Id\" />" + "<FieldRef List=\"Customers\" Name=\"Id\" />" + "</Eq>" + "</Join>" + "</Joins>"; var l = new ReLinkerFromCaml(null, null, null, null, XmlHelper.Get(xml), null); var g = new GroupByParams(); Expression <Func <SPListItem, object> > ex = x => x["CustomerName"].ForeignList("Customers"); var expr = l.Link(null, null, null, null, (new[] { new KeyValuePair <LambdaExpression, JoinType>(ex, JoinType.Left) }).ToList(), null, g); Assert.That(expr.ToString(), Is.EqualTo("Query().Joins().Left(x => x.get_Item(\"CustomerName\").ForeignList(\"Customers\"))")); }
public void test_THAT_1_join_ARE_translated_correctly() { string xml = "<Joins>" + "<Join Type=\"LEFT\" ListAlias=\"Customers\">" + "<Eq>" + "<FieldRef Name=\"CustomerName\" RefType=\"Id\" />" + "<FieldRef List=\"Customers\" Name=\"Id\" />" + "</Eq>" + "</Join>" + "</Joins>"; var b = new ReOperandBuilderFromCaml(); var t = new ReTranslatorFromCaml(null, null, null, null, new ReJoinAnalyzer(XmlHelper.Get(xml), b), null); var expr = t.TranslateJoins(); Assert.That(expr[0].Key.ToString(), Is.EqualTo("x => x.get_Item(\"CustomerName\").ForeignList(\"Customers\")")); Assert.That(expr[0].Value, Is.EqualTo(JoinType.Left)); }
public void test_THAT_view_fields_ARE_translated_correctly() { string xml = "<ViewFields>" + "<FieldRef Name=\"Title\" />" + "</ViewFields>"; var b = new ReOperandBuilderFromCaml(); var t = new ReTranslatorFromCaml(null, null, null, new ReArrayAnalyzer(XmlHelper.Get(xml), b), null, null); var expr = t.TranslateViewFields(); Assert.That(expr.ToString(), Is.EqualTo("x => x.get_Item(\"Title\")")); }