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(); }