public void GenerateSql_ForJoinedTable ()
{
var originalTable = new SqlTable (new ResolvedSimpleTableInfo (typeof (Kitchen), "KitchenTable", "t1"), JoinSemantics.Inner);
var kitchenCookMember = typeof (Kitchen).GetProperty ("Cook");
var joinedTable = originalTable.GetOrAddLeftJoin (CreateResolvedJoinInfo (typeof (Cook), "t1", "ID", "CookTable", "t2", "FK"), kitchenCookMember);
joinedTable.JoinInfo = CreateResolvedJoinInfo (typeof (Cook), "t1", "ID", "CookTable", "t2", "FK");
_stageMock
.Expect (mock => mock.GenerateTextForJoinCondition (_commandBuilder, ((ResolvedJoinInfo) joinedTable.JoinInfo).JoinCondition))
.WhenCalled (mi => ((SqlCommandBuilder) mi.Arguments[0]).Append ("([t1].[ID] = [t2].[FK])"));
_stageMock.Replay();
SqlTableAndJoinTextGenerator.GenerateSql (originalTable, _commandBuilder, _stageMock, true);
_stageMock.VerifyAllExpectations();
Assert.That (
_commandBuilder.GetCommandText(), Is.EqualTo ("[KitchenTable] AS [t1] LEFT OUTER JOIN [CookTable] AS [t2] ON ([t1].[ID] = [t2].[FK])"));
}
public void GenerateSql_ForJoinedTable_Recursive ()
{
var originalTable = new SqlTable (new ResolvedSimpleTableInfo (typeof (Kitchen), "KitchenTable", "t1"), JoinSemantics.Inner);
var memberInfo1 = typeof (Kitchen).GetProperty ("Cook");
var memberInfo2 = typeof (Cook).GetProperty ("Substitution");
var joinedTable1 = originalTable.GetOrAddLeftJoin (CreateResolvedJoinInfo (typeof (Cook), "t1", "ID", "CookTable", "t2", "FK"), memberInfo1);
var joinedTable2 = joinedTable1.GetOrAddLeftJoin (CreateResolvedJoinInfo (typeof (Cook), "t2", "ID2", "CookTable2", "t3", "FK2"), memberInfo2);
_stageMock
.Expect (mock => mock.GenerateTextForJoinCondition (_commandBuilder, ((ResolvedJoinInfo) joinedTable1.JoinInfo).JoinCondition))
.WhenCalled (mi => ((SqlCommandBuilder) mi.Arguments[0]).Append ("X"));
_stageMock
.Expect (mock => mock.GenerateTextForJoinCondition (_commandBuilder, ((ResolvedJoinInfo) joinedTable2.JoinInfo).JoinCondition))
.WhenCalled (mi => ((SqlCommandBuilder) mi.Arguments[0]).Append ("Y"));
_stageMock.Replay();
SqlTableAndJoinTextGenerator.GenerateSql (originalTable, _commandBuilder, _stageMock, true);
_stageMock.VerifyAllExpectations();
Assert.That (
_commandBuilder.GetCommandText(),
Is.EqualTo (
"[KitchenTable] AS [t1] LEFT OUTER JOIN "
+ "[CookTable] AS [t2] ON X LEFT OUTER JOIN "
+ "[CookTable2] AS [t3] ON Y"));
}
public void GenerateSql_WithUnresolvedCollectionJoinInfo ()
{
var originalTable = new SqlTable (new ResolvedSimpleTableInfo (typeof (Cook), "CookTable", "c"), JoinSemantics.Inner);
var memberInfo = typeof (Restaurant).GetProperty ("Cooks");
var collectionJoinInfo = new UnresolvedCollectionJoinInfo (Expression.Constant (new Cook[] { }), memberInfo);
originalTable.GetOrAddLeftJoin (collectionJoinInfo, memberInfo);
Assert.That (
() => SqlTableAndJoinTextGenerator.GenerateSql (originalTable, _commandBuilder, _stageMock, false),
Throws.TypeOf<InvalidOperationException>().With.Message.EqualTo ("UnresolvedCollectionJoinInfo is not valid at this point."));
}
public void GenerateSql_WithUnresolvedJoinInfo ()
{
var originalTable = new SqlTable (new ResolvedSimpleTableInfo (typeof (Cook), "CookTable", "c"), JoinSemantics.Inner);
var kitchenCookMember = typeof (Kitchen).GetProperty ("Cook");
var entityExpression = SqlStatementModelObjectMother.CreateSqlEntityDefinitionExpression (typeof (Kitchen));
var unresolvedJoinInfo = new UnresolvedJoinInfo (entityExpression, kitchenCookMember, JoinCardinality.One);
originalTable.GetOrAddLeftJoin (unresolvedJoinInfo, kitchenCookMember);
Assert.That (
() => SqlTableAndJoinTextGenerator.GenerateSql (originalTable, _commandBuilder, _stageMock, false),
Throws.TypeOf<InvalidOperationException>().With.Message.EqualTo ("UnresolvedJoinInfo is not valid at this point."));
}