org.mule.module.db.integration.executeddl.AbstractExecuteDdlTestCase.java Source code

Introduction

Here is the source code for org.mule.module.db.integration.executeddl.AbstractExecuteDdlTestCase.java

Source

/*
 * Copyright (c) MuleSoft, Inc.  All rights reserved.  http://www.mulesoft.com
 * The software in this package is published under the terms of the CPAL v1.0
 * license, a copy of which has been included with this distribution in the
 * LICENSE.txt file.
 */

package org.mule.module.db.integration.executeddl;

import static org.junit.Assert.assertEquals;
import static org.mule.module.db.integration.DbTestUtil.selectData;
import static org.mule.module.db.integration.TestRecordUtil.assertRecords;
import org.mule.module.db.integration.AbstractDbIntegrationTestCase;
import org.mule.module.db.integration.model.AbstractTestDatabase;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.junit.Before;

public abstract class AbstractExecuteDdlTestCase extends AbstractDbIntegrationTestCase {

    public AbstractExecuteDdlTestCase(String dataSourceConfigResource, AbstractTestDatabase testDatabase) {
        super(dataSourceConfigResource, testDatabase);
    }

    @Before
    public void deleteTestDdlTable() throws Exception {

        Connection connection = null;
        try {
            DataSource dataSource = getDefaultDataSource();
            connection = dataSource.getConnection();

            QueryRunner qr = new QueryRunner(dataSource);
            qr.update(connection, "DROP TABLE TestDdl");
        } catch (SQLException e) {
            // Ignore: table does not exist
        } finally {
            if (connection != null) {
                connection.close();
            }
        }
    }

    protected void assertTableCreation(Object payload) throws SQLException {
        assertEquals(0, payload);

        List<Map<String, String>> result = selectData("select * from TestDdl", getDefaultDataSource());
        assertRecords(result);
    }
}