DeleteQuarantineTableProcessorTest.java example

Explorer
codjo-data-process-master
package net.codjo.dataprocess.server.imports;
import static net.codjo.test.common.matcher.JUnitMatchers.assertThat;
import static net.codjo.test.common.matcher.JUnitMatchers.equalTo;
import org.junit.Test;
/**
 *
 */
public class DeleteQuarantineTableProcessorTest {
    @Test
    public void getFinalTableName() {
        DeleteQuarantineTableProcessor deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor();

        assertThat("AP_JE_SUIS_UNE_TABLE",
                   equalTo(deleteQuarantineTableProcessor.quarantineToFinalTableName(
                         "Q_AP_JE_SUIS_UNE_TABLE")));
        assertThat("PM_MULTIPART",
                   equalTo(deleteQuarantineTableProcessor.quarantineToFinalTableName("Q_PM_MULTIPART")));
    }


    @Test
    public void getUserQuarantineTableName() throws Exception {
        DeleteQuarantineTableProcessor deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor();

        assertThat("Q_AP_USER_JE_SUIS_UNE_TABLE",
                   equalTo(deleteQuarantineTableProcessor.quarantineToUserQuarantineTableName(
                         "Q_AP_JE_SUIS_UNE_TABLE")));
        assertThat("Q_PM_USER_MULTIPART",
                   equalTo(deleteQuarantineTableProcessor.quarantineToUserQuarantineTableName(
                         "Q_PM_MULTIPART")));
    }


    @Test
    public void buildQuery() throws Exception {
        DeleteQuarantineTableProcessor deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor(
              true);
        assertThat("truncate table Q_AP_C84_BALAVL",
                   equalTo(deleteQuarantineTableProcessor.buildDeleteQuarantineQuery("Q_AP_C84_BALAVL")));
        assertThat("truncate table Q_AP_USER_C84_BALAVL",
                   equalTo(deleteQuarantineTableProcessor.buildDeleteQUserQuery("Q_AP_C84_BALAVL")));

        deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor(false);
        assertThat(
              " set rowcount 1000  while exists (select 1 from Q_AP_C84_BALAVL ) begin  begin tran      delete from Q_AP_C84_BALAVL      if @@error > 0          rollback      else          commit  end  set rowcount 0 ",
              equalTo(deleteQuarantineTableProcessor.buildDeleteQuarantineQuery("Q_AP_C84_BALAVL")));
        assertThat(
              " set rowcount 1000  while exists (select 1 from Q_AP_USER_C84_BALAVL ) begin  begin tran     delete from Q_AP_USER_C84_BALAVL      if @@error > 0          rollback      else          commit  end  set rowcount 0 ",
              equalTo(deleteQuarantineTableProcessor.buildDeleteQUserQuery("Q_AP_C84_BALAVL")));

        deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor();
        assertThat(
              " set rowcount 1000  while exists (select 1 from Q_AP_C84_BALAVL ) begin  begin tran      delete from Q_AP_C84_BALAVL      if @@error > 0          rollback      else          commit  end  set rowcount 0 ",
              equalTo(deleteQuarantineTableProcessor.buildDeleteQuarantineQuery("Q_AP_C84_BALAVL")));
        assertThat(
              " set rowcount 1000  while exists (select 1 from Q_AP_USER_C84_BALAVL ) begin  begin tran     delete from Q_AP_USER_C84_BALAVL      if @@error > 0          rollback      else          commit  end  set rowcount 0 ",
              equalTo(deleteQuarantineTableProcessor.buildDeleteQUserQuery("Q_AP_C84_BALAVL")));

        deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor(true);
        assertThat("truncate table Q_AP_C84_BALAVL",
                   equalTo(deleteQuarantineTableProcessor.buildDeleteQuarantineQuery("Q_AP_C84_BALAVL")));
        assertThat("truncate table Q_AP_USER_C84_BALAVL",
                   equalTo(deleteQuarantineTableProcessor.buildDeleteQUserQuery("Q_AP_C84_BALAVL")));

        String whereClause = "where PERIODE = 'NO_PER' or PLAN_COMPTE = 'NO_P'";
        deleteQuarantineTableProcessor = new DeleteQuarantineTableProcessor(whereClause);
        assertThat(
              " set rowcount 1000  while exists (select 1 from Q_AP_C84_BALAVL where PERIODE = 'NO_PER' or PLAN_COMPTE = 'NO_P') begin  begin tran      delete from Q_AP_C84_BALAVL where PERIODE = 'NO_PER' or PLAN_COMPTE = 'NO_P'     if @@error > 0          rollback      else          commit  end  set rowcount 0 ",
              equalTo(deleteQuarantineTableProcessor.buildDeleteQuarantineQuery("Q_AP_C84_BALAVL")));
        assertThat(
              " set rowcount 1000  while exists (select 1 from Q_AP_USER_C84_BALAVL where PERIODE = 'NO_PER' or PLAN_COMPTE = 'NO_P') begin  begin tran     delete from Q_AP_USER_C84_BALAVL where PERIODE = 'NO_PER' or PLAN_COMPTE = 'NO_P'     if @@error > 0          rollback      else          commit  end  set rowcount 0 ",
              equalTo(deleteQuarantineTableProcessor.buildDeleteQUserQuery("Q_AP_C84_BALAVL")));
    }
}