HWDBTestCase

最新推荐文章于 2009-08-26 16:14:00 发布

duanxy932

最新推荐文章于 2009-08-26 16:14:00 发布

阅读量329

点赞数

CC 4.0 BY-SA版权

文章标签： string constraints report user table hashmap

本文链接：https://blog.youkuaiyun.com/duanxy932/article/details/4487036

package com.huawei.oss.test.framework;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.InputStream;
import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Vector;

import org.apache.log4j.Logger;
import org.dbunit.Assertion;
import org.dbunit.DBTestCase;
import org.dbunit.DatabaseUnitException;
import org.dbunit.IDatabaseTester;
import org.dbunit.JdbcDatabaseTester;
import org.dbunit.PropertiesBasedJdbcDatabaseTester;
import org.dbunit.database.DatabaseConfig;
import org.dbunit.database.IDatabaseConnection;
import org.dbunit.database.QueryDataSet;
import org.dbunit.dataset.DataSetException;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset.ITable;
import org.dbunit.dataset.SortedTable;
import org.dbunit.dataset.xml.XmlDataSet;
import org.dbunit.ext.oracle.OracleDataTypeFactory;
import org.dbunit.operation.DatabaseOperation;

/**
* 进一步封装dbunit
* @author dKF16823
*
*/
public abstract class HWDBTestCase extends DBTestCase
{
    private Vector<File> files = new Vector<File>(); // 备份数据库数据

    private String fileName = ""; // 当前数据

    private static boolean firstFlag = true;

    private static boolean lastFlag = true;

    private static int testCount = 0;

    private static int executeCount = 0;

    private static final String USER_TOPENG = "topeng";

    private static final String PWD_TOPENG = "topeng";

    private static final String USER_CCARE = "ccare";

    private static final String PWD_CCARE = "ccare";

    private static final String USER_BILLING = "billing";

    private static final String PWD_BILLING = "billing";

    private static final String USER_REPORT = "report";

    private static final String PWD_REPORT = "report";

    private HashMap<String, IDatabaseTester> hashmap = new HashMap<String, IDatabaseTester>();

    protected final String disableSql = "SELECT 'alter table '||table_name||' disable constraint '||constraint_name FROM user_constraints t where t.constraint_type='R'";

    protected final String enableSql = "SELECT 'alter table '||table_name||' enable constraint '||constraint_name FROM user_constraints t where t.constraint_type='R'";

    private IDatabaseTester tester = null;