public void VisitSqlSubStatementExpression_WithOrderingsAndNoTopExpression()
{
var builder = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatementWithCook())
{
SelectProjection = new NamedExpression("test", Expression.Constant("test")),
Orderings = { new Ordering(Expression.Constant("order1"), OrderingDirection.Asc) }
};
var statement = builder.GetSqlStatement();
var sqlSubStatementExpression = new SqlSubStatementExpression(statement);
var stage = new DefaultSqlPreparationStage(_methodCallTransformerProvider, new ResultOperatorHandlerRegistry(), _generator);
var result = SqlPreparationFromExpressionVisitor.AnalyzeFromExpression(
sqlSubStatementExpression,
stage,
_generator,
_methodCallTransformerProvider,
_context,
info => new SqlTable(info, JoinSemantics.Inner));
var sqlTable = (SqlTable)result.SqlTable;
Assert.That(sqlTable.TableInfo, Is.TypeOf(typeof(ResolvedSubStatementTableInfo)));
Assert.That(((ResolvedSubStatementTableInfo)sqlTable.TableInfo).SqlStatement.Orderings.Count, Is.EqualTo(0));
}
private SqlCommandData GenerateSqlCommand(QueryModel queryModel)
{
ISqlPreparationContext preparationContext = new SqlPreparationContext(new SqlStatementBuilder());
IMappingResolutionContext mappingResolutionContext = new MappingResolutionContext();
var generator = new UniqueIdentifierGenerator();
var preparationStage = new DefaultSqlPreparationStage(_methodCallTransformerProvider, _resultOperatorHandlerRegistry, generator);
var preparedStatement = preparationStage.PrepareSqlStatement(queryModel, preparationContext);
var resolutionStage = new DefaultMappingResolutionStage(_mappingResolver, generator);
var resolvedStatement = resolutionStage.ResolveSqlStatement(preparedStatement, mappingResolutionContext);
var builder = new SqlCommandBuilder();
var generationStage = new DefaultSqlGenerationStage();
generationStage.GenerateTextForOuterSqlStatement(builder, resolvedStatement);
var command = builder.GetCommand();
if (_showQuery)
{
Console.WriteLine(command.CommandText);
Console.WriteLine(string.Join(", ", command.Parameters.Select(p => p.Name + "=" + p.Value)));
Console.WriteLine(command.GetInMemoryProjection <object>());
}
return(command);
}
public void SetUp()
{
_context = SqlStatementModelObjectMother.CreateSqlPreparationContext();
var querySource = ExpressionHelper.CreateMainFromClause <Cook>();
_sqlTable = new SqlTable(new UnresolvedTableInfo(typeof(Cook)), JoinSemantics.Inner);
_context.AddExpressionMapping(new QuerySourceReferenceExpression(querySource), new SqlTableReferenceExpression(_sqlTable));
_querySourceReferenceExpression = new QuerySourceReferenceExpression(querySource);
_stage = new DefaultSqlPreparationStage(
CompoundMethodCallTransformerProvider.CreateDefault(), ResultOperatorHandlerRegistry.CreateDefault(), new UniqueIdentifierGenerator());
}
public void SetUp()
{
_generator = new UniqueIdentifierGenerator();
_context = SqlStatementModelObjectMother.CreateSqlPreparationContext();
_defaultStage = new DefaultSqlPreparationStage(
CompoundMethodCallTransformerProvider.CreateDefault(), ResultOperatorHandlerRegistry.CreateDefault(), _generator);
_mainFromClause = ExpressionHelper.CreateMainFromClause <Cook>();
_selectClause = ExpressionHelper.CreateSelectClause(_mainFromClause);
_orderByClause = ExpressionHelper.CreateOrderByClause();
_queryModel = new QueryModel(_mainFromClause, _selectClause);
_stageMock = MockRepository.GenerateStrictMock <ISqlPreparationStage>();
_visitor = new TestableSqlPreparationQueryModelVisitor(_context, _stageMock);
_visitorPartialMock = MockRepository.GeneratePartialMock <TestableSqlPreparationQueryModelVisitor> (_context, _stageMock);
}
protected SqlCommandData GenerateSql(QueryModel queryModel)
{
var generator = new UniqueIdentifierGenerator();
var resultOperatorHandlerRegistry = ResultOperatorHandlerRegistry.CreateDefault();
var defaultSqlPreparationStage = new DefaultSqlPreparationStage(CompoundMethodCallTransformerProvider.CreateDefault(), resultOperatorHandlerRegistry, generator);
var sqlStatement = defaultSqlPreparationStage.PrepareSqlStatement(queryModel, null);
var resolver = new MappingResolverStub();
var mappingResolutionStage = new DefaultMappingResolutionStage(resolver, generator);
var mappingResolutionContext = new MappingResolutionContext();
var newSqlStatement = mappingResolutionStage.ResolveSqlStatement(sqlStatement, mappingResolutionContext);
var commandBuilder = new SqlCommandBuilder();
var sqlGenerationStage = new DefaultSqlGenerationStage();
sqlGenerationStage.GenerateTextForOuterSqlStatement(commandBuilder, newSqlStatement);
return(commandBuilder.GetCommand());
}
public void VisitSqlSubStatementExpression()
{
var sqlStatement = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatementWithCook())
{
SelectProjection = new NamedExpression("test", Expression.Constant("test"))
}.GetSqlStatement();
var sqlSubStatementExpression = new SqlSubStatementExpression(sqlStatement);
var stage = new DefaultSqlPreparationStage(_methodCallTransformerProvider, new ResultOperatorHandlerRegistry(), _generator);
var result = SqlPreparationFromExpressionVisitor.AnalyzeFromExpression(
sqlSubStatementExpression,
stage,
_generator,
_methodCallTransformerProvider,
_context,
info => new SqlTable(info, JoinSemantics.Inner));
Assert.That(((SqlTable)result.SqlTable).TableInfo, Is.InstanceOf(typeof(ResolvedSubStatementTableInfo)));
}
public void VisitSqlSubStatementExpression_WithNonBooleanSqlGroupingSelectExpression()
{
var sqlStatement = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatementWithCook())
{
SelectProjection =
new NamedExpression(
"test", new SqlGroupingSelectExpression(Expression.Constant("key"), Expression.Constant("element")))
}.GetSqlStatement();
var sqlSubStatementExpression = new SqlSubStatementExpression(sqlStatement);
var stage = new DefaultSqlPreparationStage(_methodCallTransformerProvider, new ResultOperatorHandlerRegistry(), _generator);
var result = SqlPreparationFromExpressionVisitor.AnalyzeFromExpression(
sqlSubStatementExpression,
stage,
_generator,
_methodCallTransformerProvider,
_context,
_tableGenerator,
_someOrderingExtractionPolicy);
Assert.That(result.SqlTable.TableInfo, Is.InstanceOf(typeof(ResolvedSubStatementTableInfo)));
}
public void VisitSqlSubStatementExpression_WithDoNotExtractOrderingsPolicy()
{
var sqlStatement = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatementWithCook())
{
SelectProjection = new NamedExpression("test", Expression.Constant("test")),
Orderings = { SqlStatementModelObjectMother.CreateOrdering() }
}.GetSqlStatement();
var sqlSubStatementExpression = new SqlSubStatementExpression(sqlStatement);
var stage = new DefaultSqlPreparationStage(_methodCallTransformerProvider, new ResultOperatorHandlerRegistry(), _generator);
var result = SqlPreparationFromExpressionVisitor.AnalyzeFromExpression(
sqlSubStatementExpression,
stage,
_generator,
_methodCallTransformerProvider,
_context,
_tableGenerator,
OrderingExtractionPolicy.DoNotExtractOrderings);
Assert.That(result.SqlTable.TableInfo, Is.InstanceOf(typeof(ResolvedSubStatementTableInfo)));
Assert.That(((ResolvedSubStatementTableInfo)result.SqlTable.TableInfo).SqlStatement.Orderings.Count, Is.EqualTo(0));
Assert.That(result.ExtractedOrderings, Is.Empty);
}
