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); }