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"]);
}