public void ThenTheWhereClauseIsAsExpected()
{
_sut.ForParameter("John Doe", "Name", SqlDbType.VarChar)
.ForParameter(35, "Age", SqlDbType.Int)
.ForDateRange(new DateRange(DateTime.Now, null), "CreationDate", SqlDbType.DateTime2)
.ForDateRange(new DateRange(DateTime.Now, DateTime.Now.AddDays(3)), "ModificationDate", SqlDbType.DateTime2)
.ForDateRange(new DateRange(null, DateTime.Now.AddDays(3)), "InstallDate", SqlDbType.DateTime2);
string expected = $"WHERE ({Environment.NewLine}";
expected += $"[Name] like @Name{Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"[Age] = @Age{Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"([CreationDate] >= @CreationDateStart){Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"([ModificationDate] >= @ModificationDateStart AND [ModificationDate] < @ModificationDateEnd){Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"([InstallDate] < @InstallDateEnd){Environment.NewLine}";
expected += $"){Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"[Deleted] = 0{Environment.NewLine}";
string actual = _sut.ToString();
Assert.AreEqual(expected, actual);
}
public void ThenTheWhereClauseIsAsExpected()
{
_sut.ForParameter("John Doe", "Name", SqlDbType.VarChar)
.ForParameter(35, "Age", SqlDbType.Int)
.ForParameter("Leuven", "Location", SqlDbType.VarChar)
.ForParameter(new DateTime(2021, 05, 29), "BirthDate", SqlDbType.DateTime2)
.ForParameter((string)null, "ShouldBeOmitted", SqlDbType.VarChar);
string expected = $"WHERE ({Environment.NewLine}";
expected += $"[Name] like @Name{Environment.NewLine}";
expected += $"OR{Environment.NewLine}";
expected += $"[Age] = @Age{Environment.NewLine}";
expected += $"OR{Environment.NewLine}";
expected += $"[Location] like @Location{Environment.NewLine}";
expected += $"OR{Environment.NewLine}";
expected += $"DATEDIFF(day, [BirthDate], @BirthDate) = 0{Environment.NewLine}";
expected += $"){Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"[Deleted] = 0{Environment.NewLine}";
string actual = _sut.ToString();
Assert.AreEqual(expected, actual);
}
protected override void AddParametersFor(ProductQuery input, WhereClauseBuilder builder) =>
builder.ForParameter(input.Id, ID_COLUMN, SqlDbType.BigInt)
.ForParameter(input.CreationDate, CREATION_DATE_COLUMN, SqlDbType.DateTime2)
.ForParameter(input.CreatedBy, CREATED_BY_COLUMN, SqlDbType.VarChar)
.ForParameter(input.ModificationDate, MODIFICATION_DATE_COLUMN, SqlDbType.DateTime2)
.ForParameter(input.ModifiedBy, MODIFIED_BY_COLUMN, SqlDbType.VarChar)
.ForParameter(input.Brand, BRAND_COLUMN, SqlDbType.VarChar)
.ForParameter(input.Type, TYPE_COLUMN, SqlDbType.VarChar);
public void ThenTheWhereClauseIsAsExpected()
{
_sut.ForParameter <int?>(null, "Whatever", SqlDbType.VarChar);
string expected = string.Empty;
string actual = _sut.ToString();
Assert.AreEqual(expected, actual);
}
protected override void AddParametersFor(SpecialOwnerQuery input, WhereClauseBuilder builder) =>
builder.ForParameter(input.Id, ID_COLUMN, SqlDbType.BigInt)
.ForParameter(input.CreationDate, CREATION_DATE_COLUMN, SqlDbType.DateTime2)
.ForParameter(input.CreatedBy, CREATED_BY_COLUMN, SqlDbType.VarChar)
.ForParameter(input.ModificationDate, MODIFICATION_DATE_COLUMN, SqlDbType.DateTime2)
.ForParameter(input.ModifiedBy, MODIFIED_BY_COLUMN, SqlDbType.VarChar)
.ForParameter(input.Name, NAME_COLUMN, SqlDbType.VarChar)
.ForParameter(input.Remark, REMARK_COLUMN, SqlDbType.VarChar);
public void ThenTheWhereClauseIsAsExpected()
{
_sut.ForParameter <int?>(null, "Whatever", SqlDbType.VarChar);
string expected = $"WHERE{Environment.NewLine}";
expected += $"[Deleted] = 0{Environment.NewLine}";
string actual = _sut.ToString();
Assert.AreEqual(expected, actual);
}
public void ThenTheWhereClauseIsAsExpected()
{
_sut.ForParameter("John Doe", "Name", SqlDbType.VarChar)
.ForParameter(35, "Age", SqlDbType.Int)
.ForParameter("Leuven", "Location", SqlDbType.VarChar)
.ForParameter((string)null, "ShouldBeOmitted", SqlDbType.VarChar);
string expected = $"WHERE{Environment.NewLine}";
expected += $"[Name] = @Name{Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"[Age] = @Age{Environment.NewLine}";
expected += $"AND{Environment.NewLine}";
expected += $"[Location] = @Location{Environment.NewLine}";
string actual = _sut.ToString();
Assert.AreEqual(expected, actual);
}
protected override void AddParametersFor(AssetHistoryQuery input, WhereClauseBuilder builder) => builder.ForParameter(input.Id, ID_COLUMN, SqlDbType.BigInt) .ForParameter(input.AssetId, ASSET_ID_COLUMN, SqlDbType.BigInt) .ForParameter(input.Tag, AssetRepository.TAG_COLUMN, SqlDbType.VarChar);