public void ThrowExceptionOnSqlStatementBuilderCreateCountIfTheTableIsWhitespace()
{
// Setup
var statementBuilder = new SqlServerStatementBuilder();
var queryBuilder = new QueryBuilder();
var tableName = " ";
// Act
statementBuilder.CreateCount(queryBuilder: queryBuilder,
tableName: tableName,
hints: null);
}
public void TestSqlStatementBuilderCreateCountWithQuotedTableSchema()
{
// Setup
var statementBuilder = new SqlServerStatementBuilder();
var queryBuilder = new QueryBuilder();
var tableName = "[dbo].[Table]";
// Act
var actual = statementBuilder.CreateCount(queryBuilder: queryBuilder,
tableName: tableName,
hints: null);
var expected = "SELECT COUNT_BIG (1) AS [Counted] FROM [dbo].[Table] ;";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestSqlStatementBuilderCreateCountWithHints()
{
// Setup
var statementBuilder = new SqlServerStatementBuilder();
var queryBuilder = new QueryBuilder();
var tableName = "Table";
var hints = "WITH (NOLOCK)";
// Act
var actual = statementBuilder.CreateCount(queryBuilder: queryBuilder,
tableName: tableName,
hints: hints);
var expected = "SELECT COUNT_BIG (1) AS [Counted] FROM [Table] WITH (NOLOCK) ;";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestSqlStatementBuilderCreateCountWithWhereExpression()
{
// Setup
var statementBuilder = new SqlServerStatementBuilder();
var queryBuilder = new QueryBuilder();
var tableName = "Table";
var where = new QueryGroup(new QueryField("Id", 1));
// Act
var actual = statementBuilder.CreateCount(queryBuilder: queryBuilder,
tableName: tableName,
where : where);
var expected = $"" +
$"SELECT COUNT_BIG (1) AS [Counted] " +
$"FROM [Table] " +
$"WHERE ([Id] = @Id) ;";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestSqlStatementBuilderCreateCountWithWhereExpressionAndWithHints()
{
// Setup
var statementBuilder = new SqlServerStatementBuilder();
var queryBuilder = new QueryBuilder();
var tableName = "Table";
var where = new QueryGroup(new QueryField("Id", 1, Helper.DbSetting), Helper.DbSetting);
var hints = "WITH (NOLOCK)";
// Act
var actual = statementBuilder.CreateCount(queryBuilder: queryBuilder,
tableName: tableName,
where : where,
hints: hints);
var expected = $"" +
$"SELECT COUNT_BIG (1) AS [Counted] " +
$"FROM [Table] WITH (NOLOCK) " +
$"WHERE ([Id] = @Id) ;";
// Assert
Assert.AreEqual(expected, actual);
}
