nDump.Export.UseFilterIfPresentStrategy.TearDownFilterTables C# (CSharp) Méthode

TearDownFilterTables() public méthode

public TearDownFilterTables ( IList filtertableSelects ) : void
filtertableSelects IList
Résultat void
        public void TearDownFilterTables(IList<SqlTableSelect> filtertableSelects)
        {
            bool fail = false;
            string failedSteps = string.Empty;
            _logger.Log("Tearing Down:");
            foreach (var table in filtertableSelects)
            {
                _logger.Log("     " + table.TableName);
                try
                {
                    _queryExecutor.ExecuteNonQueryStatement(String.Format(DropTableSqlFormat, table.TableName));
                }
                catch (Exception)
                {
                    _logger.Log("         Failed " + table.TableName);
                    fail = true;
                    failedSteps += " " + table.TableName;
                }
            }
            if (fail)
                throw new TearDownException("one or more teardown steps failed:" + failedSteps);
        }

Usage Example

        public void ShouldExecuteDeleteQueryForEachFilterSelect()
        {
            var queryExecutor = new Mock<IQueryExecutor>();

            var filterStrategy = new UseFilterIfPresentStrategy(queryExecutor.Object, new NullLogger());
            var select1 = new SqlTableSelect("1", null, false);
            var select2 = new SqlTableSelect( "2", null, false);
            queryExecutor.Setup(q => q.ExecuteNonQueryStatement("drop table 1"));
            queryExecutor.Setup(q => q.ExecuteNonQueryStatement("drop table 2"));
            filterStrategy.TearDownFilterTables(new List<SqlTableSelect> { select1, select2 });
            queryExecutor.VerifyAll();
        }
All Usage Examples Of nDump.Export.UseFilterIfPresentStrategy::TearDownFilterTables