Exemple #1
0
        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());
        }
Exemple #2
0
        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);
        }
Exemple #3
0
        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);
        }