public void TestInitializeDBTarget()
{
DBConfig dbConfig = new DBConfig("System.Data.OleDb", String.Format(@"Provider=Microsoft.JET.OLEDB.4.0;data source={0}\DatabaseTarget.mdb", AppDomain.CurrentDomain.BaseDirectory));
DBTarget.Initialize(dbConfig);
Assert.IsNotNull(DBTarget.ProviderFactory);
Assert.IsNotNull(DBTarget.Connection);
Assert.AreEqual(DBTarget.Connection.State, ConnectionState.Open);
}
public void TestGetSQLCreateColumnsInTable()
{
DBConfig dbConfigSource = new DBConfig("System.Data.OleDb", String.Format(@"Provider=Microsoft.JET.OLEDB.4.0;data source={0}\DatabaseSource.mdb", AppDomain.CurrentDomain.BaseDirectory));
IDBConnection dbConnectionSource = new DBConnection();
dbConnectionSource.Initialize(dbConfigSource);
ColumnMigrator columnMigrator = new ColumnMigrator(new ConvertName());
Assert.AreEqual(columnMigrator.GetSQLCreateColumnsInTable(dbConnectionSource.Connection, "TABLE1_TEST"), "(COLUMN1_VARCHAR VARCHAR(100) ,COLUMN2_VARCHAR VARCHAR(255) NOT NULL,COLUMN3_DATE DATE ,COLUMN4_BIT VARCHAR(1) ,COLUMN5_INTEGER INTEGER ,COLUMN6_DECIMAL NUMBER )");
}
public void InitializeConnection(DBConfig dbConfigSource, DBConfig dbConfigTarget)
{
IDBConnection DBConnectionSource = new DBConnection();
DBConnectionSource.Initialize(dbConfigSource);
IDBConnection DBConnectionTarget = new DBConnection();
DBConnectionTarget.Initialize(dbConfigTarget);
this.TableMigration.DBConnectionSource = DBConnectionSource;
this.TableMigration.DBConnectionTarget = DBConnectionTarget;
}
public void Execute(DBConfig dbConfigSource, DBConfig dbConfigTarget)
{
try
{
databaseMigration.InitializeConnection(dbConfigSource, dbConfigTarget);
databaseMigration.TableMigration.Execute();
}
catch(Exception ex)
{
logger.Error(ex.Message);
}
}
public void TestInitializeConnection()
{
TableMigration tableMigration = new TableMigration(new ConvertName(), new ColumnMigrator(new ConvertName()), new Log4NetLogger());
DBMigration dbMigration = new DBMigration(tableMigration);
DBConfig dbConfigSource = new DBConfig("System.Data.OleDb", String.Format(@"Provider=Microsoft.JET.OLEDB.4.0;data source={0}\DatabaseSource.mdb", AppDomain.CurrentDomain.BaseDirectory));
DBConfig dbConfigTarget = new DBConfig("System.Data.OleDb", String.Format(@"Provider=Microsoft.JET.OLEDB.4.0;data source={0}\DatabaseTarget.mdb", AppDomain.CurrentDomain.BaseDirectory));
dbMigration.InitializeConnection(dbConfigSource, dbConfigTarget);
Assert.IsTrue(dbMigration.TableMigration.DBConnectionSource.IsInitialized);
Assert.IsTrue(dbMigration.TableMigration.DBConnectionTarget.IsInitialized);
}
public void InitializeCreateConfigTest()
{
DBConfig dbConfigSource = new DBConfig("System.Data.OleDb", String.Format(@"Provider=Microsoft.JET.OLEDB.4.0;data source={0}\DatabaseSource.mdb", AppDomain.CurrentDomain.BaseDirectory));
dbConnectionSource = new DBConnection();
dbConnectionSource.Initialize(dbConfigSource);
DBConfig dbConfigTarget = new DBConfig("System.Data.OleDb", String.Format(@"Provider=Microsoft.JET.OLEDB.4.0;data source={0}\DatabaseTarget.mdb", AppDomain.CurrentDomain.BaseDirectory));
dbConnectionTarget = new DBConnection();
dbConnectionTarget.Initialize(dbConfigTarget);
convertName = new ConvertName();
columnMigrator = new ColumnMigrator(convertName);
logger = new Log4NetLogger();
}
public void Initialize(DBConfig dbConfig)
{
ProviderFactory = DbProviderFactories.GetFactory(dbConfig.Client);
try
{
Connection = ProviderFactory.CreateConnection();
Connection.ConnectionString = dbConfig.ConnectionString;
Connection.Open();
}
catch (Exception ex)
{
throw new DataException(string.Format(ResourceManager.GetMessage("FailedOpenDatabase"),dbConfig.ConnectionString, ex.Message));
}
IsInitialized = true;
}
public void InitializeCreateConfigTest()
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US", true);
dbConfig = new DBConfig("System.Data.OleDb", "Provider=Microsoft.JET.OLEDB.4.0;data source=DatabaseMigrator.mdb");
createConfig = new CreateConfig();
}
