public SqlQueryBuilder(SqlQueryRequest sqlQueryRequest)
{
_sqlQueryRequest = sqlQueryRequest;
_sqlSelectBuilder = new SqlSelectBuilder(sqlQueryRequest);
_sqlJoinBuilder = new SqlJoinBuilder(_sqlQueryRequest);
_sqlWhereBuilder = new SqlWhereBuilder(_sqlQueryRequest);
}
public void SqlQueryCommand_ShouldReturnAsExpected_WhenDataTableIsNotNull()
{
// Arrange
var input = new SqlQueryRequest();
var connectionProviderMock = AutoMocker.GetMock <ISqlServerConnectionProvider>();
var commandExecutorMock = AutoMocker.GetMock <ISqlServerCommandExecutor>();
connectionProviderMock
.Setup(mock => mock.GetConnection(new CommandOptions()))
.Returns(new SqlConnection("Server=(local)\\SQL2017;Integrated security=SSPI;"));
commandExecutorMock
.Setup(mock => mock.Execute(It.IsAny <SqlCommand>()))
.Returns(new DataTable());
var cut = new SqlServerSqlQueryCommand(connectionProviderMock.Object, commandExecutorMock.Object);
// Act
SqlQueryResult output = cut.Execute(input);
// Assert
output.ShouldNotBeNull();
}
public SqlJoinBuilder(SqlQueryRequest sqlQueryRequest)
{
_sqlQueryRequest = sqlQueryRequest;
}
public SqlWhereBuilder(SqlQueryRequest _sqlQueryRequest)
{
this._sqlQueryRequest = _sqlQueryRequest;
}
public override async Task <SqlQueryResult> ExecuteSqlAsync(SqlQueryRequest request, CancellationToken cancellationToken)
{
return(await new SqlServerSqlQueryCommand(ConnectionProvider, _commandExecutor).ExecuteAsync(request, cancellationToken));
}
public override SqlQueryResult ExecuteSql(SqlQueryRequest request)
{
return(new SqlServerSqlQueryCommand(ConnectionProvider, _commandExecutor).Execute(request));
}
public SqlSelectBuilder(SqlQueryRequest sqlQueryRequest)
{
_sqlQueryRequest = sqlQueryRequest;
}
/// <summary> /// Executes a SQL string against the database this <see cref="IDatabaseCommander"/> is connected to /// </summary> /// <param name="request">The data needed to execute the non-query command</param> /// <param name="cancellationToken">The CancellationToken from the caller</param> /// <returns>The result of the command</returns> public abstract Task <SqlQueryResult> ExecuteSqlAsync(SqlQueryRequest request, CancellationToken cancellationToken);
/// <summary> /// Executes a SQL string against the database this <see cref="IDatabaseCommander"/> is connected to /// </summary> /// <param name="request">The data needed to execute the non-query command</param> /// <returns>The result of the command</returns> public abstract SqlQueryResult ExecuteSql(SqlQueryRequest request);
public SqlWhereOperator(SqlQueryRequest sqlQueryRequest)
{
_sqlQueryRequest = sqlQueryRequest;
_sqlQueryBuilder = new SqlQueryBuilder(sqlQueryRequest);
}
public Task <SqlQueryResponse> QueryAsync(SqlQueryRequest request, CancellationToken cancellationToken = default)
{
request.BeforeRequest();
return(DoRequestAsync <SqlQueryRequest, SqlQueryResponse>(request, cancellationToken));
}
public SqlQueryResponse Query(SqlQueryRequest request)
{
request.BeforeRequest();
return(DoRequest <SqlQueryRequest, SqlQueryResponse>(request));
}
