public void ResolveSqlTable_ResolvesTableInfo()
        {
            _stageMock
            .Expect(mock => mock.ResolveTableInfo(_unresolvedTableInfo, _mappingResolutionContext))
            .Return(_fakeResolvedSimpleTableInfo);
            _stageMock.Replay();

            _visitor.ResolveSqlTable(_sqlTable);

            _stageMock.VerifyAllExpectations();
            Assert.That(_sqlTable.TableInfo, Is.SameAs(_fakeResolvedSimpleTableInfo));
        }
        public void ApplyContext_VisitResolvedJoinInfo_SameForeignTableInfo()
        {
            var resolvedJoinInfo = SqlStatementModelObjectMother.CreateResolvedJoinInfo();

            _stageMock
            .Expect(mock => mock.ApplyContext(resolvedJoinInfo.ForeignTableInfo, SqlExpressionContext.ValueRequired, _mappingResolutionContext))
            .Return(resolvedJoinInfo.ForeignTableInfo);
            _stageMock.Replay();

            var result = SqlContextJoinInfoVisitor.ApplyContext(resolvedJoinInfo, SqlExpressionContext.ValueRequired, _stageMock, _mappingResolutionContext);

            _stageMock.VerifyAllExpectations();
            Assert.That(result, Is.SameAs(resolvedJoinInfo));
        }
Exemplo n.º 3
0
        public void VisitSqlStatement_NoExpressionChanged_SameSqlStatementIsReturned()
        {
            var sqlStatement = SqlStatementModelObjectMother.CreateSqlStatementWithCook();

            _stageMock
            .Expect(mock => mock.ApplyContext(sqlStatement.SelectProjection, SqlExpressionContext.ValueRequired, _mappingResolutionContext))
            .Return(sqlStatement.SelectProjection);
            _stageMock.Replay();

            var result = SqlContextSelectionAdjuster.ApplyContext(sqlStatement, SqlExpressionContext.ValueRequired, _stageMock, _mappingResolutionContext);

            _stageMock.VerifyAllExpectations();
            Assert.That(result.SelectProjection, Is.TypeOf(typeof(SqlTableReferenceExpression)));
            Assert.That(result.DataInfo, Is.SameAs(sqlStatement.DataInfo));
        }
Exemplo n.º 4
0
        public void ResolveMemberAccess_OnEntityRefMemberExpression_NoOptimization()
        {
            var memberInfo = typeof(Cook).GetProperty("Substitution");
            var entityRefMemberExpression = SqlStatementModelObjectMother.CreateSqlEntityRefMemberExpression();

            _resolverMock
            .Stub(mock => mock.TryResolveOptimizedMemberExpression(entityRefMemberExpression, memberInfo))
            .Return(null);

            var fakeEntityExpression = SqlStatementModelObjectMother.CreateSqlEntityDefinitionExpression(typeof(Cook));

            _stageMock
            .Expect(
                mock =>
                mock.ResolveEntityRefMemberExpression(
                    Arg.Is(entityRefMemberExpression),
                    Arg <UnresolvedJoinInfo> .Matches(j =>
                                                      j.OriginatingEntity == entityRefMemberExpression.OriginatingEntity &&
                                                      j.MemberInfo == entityRefMemberExpression.MemberInfo &&
                                                      j.Cardinality == JoinCardinality.One),
                    Arg.Is(_mappingResolutionContext)))
            .Return(fakeEntityExpression);

            var fakeResult = Expression.Constant(0);

            _resolverMock
            .Expect(mock => mock.ResolveMemberExpression(fakeEntityExpression, memberInfo))
            .Return(fakeResult);

            var result = MemberAccessResolver.ResolveMemberAccess(entityRefMemberExpression, memberInfo, _resolverMock, _stageMock, _mappingResolutionContext);

            _stageMock.VerifyAllExpectations();
            _resolverMock.VerifyAllExpectations();
            Assert.That(result, Is.SameAs(fakeResult));
        }
        public void SimplifyIfPossible_NonSimplifiableStatement()
        {
            var resolvedSqlStatement = new SqlStatementBuilder(_simplifiableResolvedSqlStatement)
            {
                IsDistinctQuery = true
            }.GetSqlStatement();
            var expression = new SqlSubStatementExpression(resolvedSqlStatement);

            _stageMock.Replay();

            var result = _groupAggregateSimplifier.SimplifyIfPossible(expression, _simplifiableUnresolvedProjection);

            _stageMock.VerifyAllExpectations();

            Assert.That(result, Is.SameAs(expression));
        }
Exemplo n.º 6
0
        public void CreateSqlQuery()
        {
            var fakePreparationResult = CreateSqlStatement();

            _preparationStageMock
            .Expect(mock => mock.PrepareSqlStatement(_queryModel, null))
            .Return(fakePreparationResult);
            var fakeResolutionResult = CreateSqlStatement();

            _resolutionStageMock
            .Expect(mock => mock.ResolveSqlStatement(Arg.Is(fakePreparationResult), Arg <MappingResolutionContext> .Is.TypeOf))
            .Return(fakeResolutionResult);
            _generationStageMock
            .Expect(mock => mock.GenerateTextForOuterSqlStatement(Arg <SqlCommandBuilder> .Is.TypeOf, Arg.Is(fakeResolutionResult)))
            .WhenCalled(mi =>
            {
                var sqlCommandBuilder = ((SqlCommandBuilder)mi.Arguments[0]);
                sqlCommandBuilder.Append("TestTest");
                sqlCommandBuilder.SetInMemoryProjectionBody(Expression.Constant(null));
            });

            var result = _sqlQueryGenerator.CreateSqlQuery(_queryModel);

            _preparationStageMock.VerifyAllExpectations();
            _resolutionStageMock.VerifyAllExpectations();
            _generationStageMock.VerifyAllExpectations();

            Assert.That(result.SqlCommand.CommandText, Is.EqualTo("TestTest"));
        }
        public void VisitConstantExpression()
        {
            var constantExpression = Expression.Constant(0);

            _stageMock.Replay();
            _resolverMock
            .Expect(mock => mock.ResolveConstantExpression(constantExpression))
            .Return(constantExpression);
            _resolverMock.Replay();

            var result = _visitor.Visit(constantExpression);

            _stageMock.VerifyAllExpectations();
            _resolverMock.VerifyAllExpectations();
            Assert.That(result, Is.SameAs(constantExpression));
        }
Exemplo n.º 8
0
        public void VisitSqlSubStatementExpression_LeavesSqlSubStatementExpression_ForStreamedSequenceInfo()
        {
            var sqlStatement = SqlStatementModelObjectMother.CreateSqlStatement(Expression.Constant(new Cook()));
            var expression   = new SqlSubStatementExpression(sqlStatement);

            _stageMock
            .Expect(mock => mock.ResolveSqlStatement(sqlStatement, _mappingResolutionContext))
            .Return(sqlStatement);
            _groupAggregateSimplifier
            .Expect(mock => mock.SimplifyIfPossible(expression, sqlStatement.SelectProjection))
            .Return(expression);

            var visitor = CreateVisitor(new SqlStatementBuilder(sqlStatement));
            var result  = visitor.VisitExpression(expression);

            _stageMock.VerifyAllExpectations();
            _groupAggregateSimplifier.VerifyAllExpectations();
            Assert.That(result, Is.TypeOf(typeof(SqlSubStatementExpression)));
            Assert.That(((SqlSubStatementExpression)result).SqlStatement, Is.SameAs(sqlStatement));
        }
        public void ResolveTableInfo_SubStatementTableInfo_SubStatementUnmodified()
        {
            var sqlSubStatementTableInfo = new ResolvedSubStatementTableInfo("c", _sqlStatement);

            _stageMock
            .Expect(mock => mock.ResolveSqlStatement(_sqlStatement, _mappingResolutionContext))
            .Return(_sqlStatement);
            _resolverMock.Replay();

            var result = (ResolvedSubStatementTableInfo)ResolvingTableInfoVisitor.ResolveTableInfo(sqlSubStatementTableInfo, _resolverMock, _generator, _stageMock, _mappingResolutionContext);

            _stageMock.VerifyAllExpectations();
            Assert.That(result, Is.SameAs(sqlSubStatementTableInfo));
        }
        public void ApplyContext_ResolvedSubStatementTableInfo_SameTableInfo()
        {
            var subStatement          = SqlStatementModelObjectMother.CreateSqlStatement_Resolved(typeof(Cook));
            var subStatementTableInfo = new ResolvedSubStatementTableInfo("c", subStatement);

            _stageMock
            .Expect(mock => mock.ApplySelectionContext(subStatement, SqlExpressionContext.ValueRequired, _mappingresolutionContext))
            .Return(subStatement);
            _stageMock.Replay();

            var result = SqlContextTableInfoVisitor.ApplyContext(subStatementTableInfo, SqlExpressionContext.ValueRequired, _stageMock, _mappingresolutionContext);

            Assert.That(result, Is.SameAs(subStatementTableInfo));
            _stageMock.VerifyAllExpectations();
        }
        public void ResolvePotentialEntity_EntityRefMember_NonOptimizable_ResolvesToJoinAndIdentity()
        {
            _resolverMock
            .Expect(mock => mock.TryResolveOptimizedIdentity(_entityRefMemberExpression))
            .Return(null);

            var fakeResolvedEntity = SqlStatementModelObjectMother.CreateSqlEntityDefinitionExpression();

            _stageMock
            .Expect(
                mock => mock.ResolveEntityRefMemberExpression(
                    Arg.Is(_entityRefMemberExpression),
                    Arg <UnresolvedJoinInfo> .Matches(
                        e => e.OriginatingEntity == _entityRefMemberExpression.OriginatingEntity &&
                        e.MemberInfo == _entityRefMemberExpression.MemberInfo &&
                        e.Cardinality == JoinCardinality.One),
                    Arg.Is(_context)))
            .Return(fakeResolvedEntity);

            var result = _entityIdentityResolver.ResolvePotentialEntity(_entityRefMemberExpression);

            _stageMock.VerifyAllExpectations();
            SqlExpressionTreeComparer.CheckAreEqualTrees(fakeResolvedEntity.GetIdentityExpression(), result);
        }
Exemplo n.º 12
0
        public void ResolveJoinInfo_ResolvesUnresolvedJoinInfo()
        {
            var foreignTableInfo = new ResolvedSimpleTableInfo(typeof(string), "Cook", "c");
            var condition        = ExpressionHelper.CreateExpression(typeof(bool));

            var resolvedJoinInfo = new ResolvedJoinInfo(foreignTableInfo, condition);

            _resolverMock
            .Expect(mock => mock.ResolveJoinInfo(_unresolvedJoinInfo, _generator))
            .Return(resolvedJoinInfo);

            _stageMock
            .Expect(mock => mock.ResolveTableInfo(foreignTableInfo, _mappingResolutionContext))
            .Return(foreignTableInfo);
            _stageMock
            .Expect(mock => mock.ResolveJoinCondition(condition, _mappingResolutionContext))
            .Return(condition);

            var result = ResolvingJoinInfoVisitor.ResolveJoinInfo(_unresolvedJoinInfo, _resolverMock, _generator, _stageMock, _mappingResolutionContext);

            Assert.That(result, Is.SameAs(resolvedJoinInfo));
            _resolverMock.VerifyAllExpectations();
            _stageMock.VerifyAllExpectations();
        }