public void TheConnectionStringIsAllowedToBeSet()
{
const string connection = "some connection";
var deleteStatement = new Delete(SomeTable).ConnectTo(connection);
deleteStatement.GetType().GetField(ConnectionKeyword, BindingFlagsToSeeAll).GetValue(deleteStatement).ToString().Should().Be(connection);
}
public void TheConnectionStringisChangedButANewDeleteIsCreated()
{
const string connection = "some connection";
var deleteStatement = new Delete(SomeTable).ConnectTo(connection);
var record = deleteStatement.ConnectTo(connection);
deleteStatement.Should().NotBe(record);
}
public void TheConnectionStringisChangedButTheWhereContainerIsTheSame()
{
const string whereContainerName = "_whereContainer";
var whereClause = new Where()[FirstColumn.IsEqualTo(1)];
var deleteStatement = new Delete(SomeTable).Where(whereClause).ConnectTo("A");
var record = deleteStatement.ConnectTo("B");
RetrieveValueFromObject(deleteStatement, whereContainerName).Should().Be(RetrieveValueFromObject(record, whereContainerName));
}
public void TheDeleteCanCreateAValidWithAnAlsoThatContainsTheSameName()
{
var firstColumnIsEqualToFirstValue =
new Where()
[
FirstColumn.IsEqualTo(FirstValue),
Also.And(FirstColumn.IsEqualTo(FirstValue))
];
var deleteStatement =
new Delete(SomeTable)
.Where(firstColumnIsEqualToFirstValue);
deleteStatement.CreateSql().Should().NotBe("DELETE FROM " + SomeTable + " WHERE " + FirstColumn + " = @where_" + FirstColumn + " AND (" + FirstColumn + " = @where_" + FirstColumn + ")");
}
public void TheDeleteCanCreateAValidStatementWithConditions()
{
var firstColumnIsEqualToFirstValue =
new Where()
[
FirstColumn.IsEqualTo(FirstValue)
];
var deleteStatement =
new Delete(SomeTable)
.Where(firstColumnIsEqualToFirstValue);
var whereItem =
firstColumnIsEqualToFirstValue.GetType().GetProperty("WhereItems", BindingFlagsToSeeAll)
.GetValue(firstColumnIsEqualToFirstValue, BindingFlagsToSeeAll, null, null, null)
.As<IList<WhereItem>>()
.First();
deleteStatement.CreateSql().Should().Be("DELETE FROM " + SomeTable + " WHERE " + FirstColumn + " = @" + whereItem.Name + whereItem.UniqueKey);
}
public void TheWhereContainerisChangedButTheConnectionStringIsTheSame()
{
var firstColumnIsEqualToFirstValue =
new Where()
[
FirstColumn.IsEqualTo(FirstValue)
];
var deleteStatement = new Delete(SomeTable).Where(firstColumnIsEqualToFirstValue).ConnectTo("a");
var record = deleteStatement.Where(new Where()[FirstColumn.IsEqualTo(1)]);
RetrieveValueFromObject(deleteStatement, ConnectionKeyword).Should().Be(RetrieveValueFromObject(record, ConnectionKeyword));
}
public void TheWhereContainerisChangedButANewDeleteIsCreated()
{
var firstColumnIsEqualToFirstValue =
new Where()
[
FirstColumn.IsEqualTo(FirstValue)
];
var deleteStatement = new Delete(SomeTable).Where(firstColumnIsEqualToFirstValue).ConnectTo("a");
var record = deleteStatement.Where(new Where()[FirstColumn.IsEqualTo(1)]);
deleteStatement.Should().NotBe(record);
}
public void TheDeleteCanCreateAValidStatement()
{
var deleteStatement = new Delete(SomeTable);
deleteStatement.CreateSql().Should().Be("DELETE FROM " + SomeTable);
}
