public void ShouldWriteQueryForRemoveSpecificRows()
{
var op = new RemoveRowOperation(SchemaName, TableName, Where);
const string expectedQuery = "delete from [schemaName].[tableName] where (sample meaningless where string)";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
public void ShouldWriteQueryForRemoveAllRowsWithTruncate()
{
var op = new RemoveRowOperation(SchemaName, TableName, true);
const string expectedQuery = "truncate table [schemaName].[tableName]";
Assert.AreEqual(expectedQuery, op.ToQuery());
Assert.IsTrue(op.Truncate);
}
public void ShouldWriteQueryForRemoveAllRows()
{
var op = new RemoveRowOperation(SchemaName, TableName, false);
const string expectedQuery = "delete from [schemaName].[tableName]";
Assert.AreEqual(expectedQuery, op.ToQuery());
Assert.IsFalse(op.Truncate);
}
public void ShouldSetPropertiesForRemoveAllRows()
{
var op = new RemoveRowOperation(SchemaName, TableName, true);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(TableName, op.TableName);
Assert.AreEqual(true, op.Truncate);
Assert.IsTrue(op.All);
}
public void ShouldSetPropertiesForRemoveSpecificRows()
{
var op = new RemoveRowOperation(SchemaName, TableName, Where);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(TableName, op.TableName);
Assert.AreEqual(Where, op.Where);
Assert.IsFalse(op.All);
}
