@Before
 public void setUp() throws Exception {
   IDataSet dataSet =
       new FlatXmlDataSetBuilder().build(new File("src/test/resources/CustomerTest.xml"));
   databaseTester.setDataSet(dataSet);
   databaseTester.setSetUpOperation(DatabaseOperation.CLEAN_INSERT);
   databaseTester.setTearDownOperation(DatabaseOperation.DELETE_ALL);
   databaseTester.onSetup();
 }
 @BeforeClass
 public static void setUpBeforeClass() throws Exception {
   // NOTE: since you also have a physical database you may not want to load data in the database,
   // but, you may as well
   final Properties environment = new Properties();
   databaseTester =
       new JndiDatabaseTester(
           environment, GeneralJpaSpringConfig.JNDI_DATASOURCE_LOOKUP_NAME, SCHEMA_NULL);
   final IDataSet dataSet =
       new FlatXmlDataSetBuilder().build(PaymentProcessorIT.class.getResource("/orders_data.xml"));
   databaseTester.setDataSet(dataSet);
   databaseTester.setSetUpOperation(DatabaseOperation.CLEAN_INSERT);
   databaseTester.setTearDownOperation(DatabaseOperation.DELETE_ALL);
 }
  private void initialize(DataSource dataSource) throws AmbiguousTableNameException {
    databaseTester = new DataSourceDatabaseTester(dataSource);
    databaseTester.setSetUpOperation(DatabaseOperation.CLEAN_INSERT);
    databaseTester.setTearDownOperation(DatabaseOperation.DELETE_ALL);
    DefaultDataSet dataSet = new DefaultDataSet();
    dataSet.addTable(new DefaultTable("agents"));

    dataSet.addTable(new DefaultTable("pipelines"));
    dataSet.addTable(new DefaultTable("materials"));
    dataSet.addTable(new DefaultTable("modifications"));
    dataSet.addTable(new DefaultTable("pipelineMaterialRevisions"));
    dataSet.addTable(new DefaultTable("modifiedFiles"));

    dataSet.addTable(new DefaultTable("notificationfilters"));
    dataSet.addTable(new DefaultTable("users"));
    dataSet.addTable(new DefaultTable("artifactPropertiesGenerator"));
    dataSet.addTable(new DefaultTable("stages"));
    dataSet.addTable(new DefaultTable("buildCauseBuffer"));
    dataSet.addTable(new DefaultTable("pipelineLabelCounts"));
    dataSet.addTable(new DefaultTable("environmentVariables"));
    dataSet.addTable(new DefaultTable("properties"));
    dataSet.addTable(new DefaultTable("artifactPlans"));
    dataSet.addTable(new DefaultTable("buildStateTransitions"));
    dataSet.addTable(new DefaultTable("resources"));
    dataSet.addTable(new DefaultTable("builds"));

    dataSet.addTable(new DefaultTable("oauthclients"));
    dataSet.addTable(new DefaultTable("oauthauthorizations"));
    dataSet.addTable(new DefaultTable("oauthtokens"));

    dataSet.addTable(new DefaultTable("gadgetOauthClients"));
    dataSet.addTable(new DefaultTable("gadgetOauthAuthorizationCodes"));
    dataSet.addTable(new DefaultTable("gadgetOauthAccessTokens"));
    dataSet.addTable(new DefaultTable("stageArtifactCleanupProhibited"));
    dataSet.addTable(new DefaultTable("serverBackups"));

    databaseTester.setDataSet(dataSet);
  }