public void InnerJoinWithDefaultLeftJoin() { var items = new List <Row>(); var result = new TestProcess( new GenericEnumerableOperation(left), new InnerJoinUsersToPeopleByEmail().Right(new GenericEnumerableOperation(right)), new ResultsOperation(items) ); result.Execute(); Assert.Single(items); Assert.Equal(3, items[0]["person_id"]); }
public void InnerJoinWithDefaultLeftJoin() { var items = new List<Row>(); var result = new TestProcess( new GenericEnumerableOperation(left), new InnerJoinUsersToPeopleByEmail().Right(new GenericEnumerableOperation(right)), new ResultsOperation(items) ); result.Execute(); Assert.Equal(1, items.Count); Assert.Equal(3, items[0]["person_id"]); }
public void LeftJoinWithDefaultLeftJoin() { var items = new List <Row>(); var result = new TestProcess( new GenericEnumerableOperation(left), new LeftJoinUsersToPeopleByEmail().Right(new GenericEnumerableOperation(right)), new ResultsOperation(items) ); result.Execute(); Assert.Equal(2, items.Count); Assert.Equal(3, items[0]["person_id"]); Assert.Null(items[1]["person_id"]); Assert.Equal("bar", items[1]["name"]); }