public void DataTransfer_Excel2MySql() { DataExchangeWizard_Accessor target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Excel).X_Handler; //srcHandle.Open(new LoginInfo_Excel() { Database = GlobalInfo.Excel_TestFile}); srcHandle.Open(new LoginInfo_Excel() { Database = "C:\\1.xlsx", CurrentOleDBVersion = OleDBVersion.Is2007 , IsFirstRowIsColumnName = true }); CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler; targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_MySql() { Server = "localhost", Username = "******", Database = "TestDemo", Pwd = "noway", }); //List<string> tableList = srcHandle.GetTableListInDatabase(); List <string> tableList = new List <string>() { "Sheet1$", }; bool result = target.DoExchangeData(srcHandle, targetHandle, tableList, false); Assert.AreEqual(true, result); }
public void DataTransfer_SSCE2CSV() { DataExchangeWizard_Accessor target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; srcHandle.Open(new LoginInfo_SSCE() { DbName = GlobalInfo.SqlCE_TestFile }); CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.CSV).X_Handler; string targetFile = "C:\\a11.csv"; if (File.Exists(targetFile)) { File.Delete(targetFile); } targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_CSV() { Database = targetFile, IsFirstRowIsColumnName = true, }); List <string> tableList = srcHandle.GetTableListInDatabase(); bool result = target.DoExchangeData(srcHandle, targetHandle, tableList, false); Assert.AreEqual(true, result); }
public void DataTransfer_Sqlite2SSCE() { testContextInstance.RecordTestMethod(); DataExchangeWizard_Accessor target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Sqlite).X_Handler; srcHandle.Open(new LoginInfo_Sqlite() { DbFile = GlobalInfo.Sqlite_TestFile, IsUnicode = true }); CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; string targetFile = "C:\\a8.sdf"; if (File.Exists(targetFile)) { File.Delete(targetFile); } targetHandle.CreateDatabase(new CoreEA.LoginInfo.LoginInfo_SSCE() { DbName = targetFile, IsCaseSensitive = true }); targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_SSCE() { DbName = targetFile }); List <string> tableList = srcHandle.GetTableListInDatabase(); bool result = target.DoExchangeData(srcHandle, targetHandle, tableList, false); Assert.AreEqual(true, result); }
public void DataTransfer_MySQL2SSCE() { testContextInstance.RecordTestMethod(); DataExchangeWizard_Accessor target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler; srcHandle.Open(new LoginInfo_MySql() { Server = "localhost", Username = "******", Pwd = "noway", Database = "test" }); CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; string targetFile = "C:\\a6.sdf"; if (File.Exists(targetFile)) { File.Delete(targetFile); } targetHandle.CreateDatabase(new CoreEA.LoginInfo.LoginInfo_SSCE() { DbName = targetFile, IsCaseSensitive = true }); targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_SSCE() { DbName = targetFile }); List <string> tableList = srcHandle.GetTableListInDatabase(); target.DoExchangeData(srcHandle, targetHandle, tableList); TestGlobalExtension.RecordTestMethod(); }
public void DataTransfer_SSCE2SqlServer() { testContextInstance.RecordTestMethod(); DataExchangeWizard_Accessor target = null; try { target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value } catch { } CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; string srcCEFile = GlobalInfo.SqlCE_TestFile; srcHandle.Open(new LoginInfo_SSCE() { DbName = srcCEFile }); List <string> tableList = srcHandle.GetTableListInDatabase(); targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_SqlServer() { X_Server = @"VincentNotebook\SQL2008EXPRESS", X_UserName = "******", X_Pwd = "dfbbybf", X_Database = "MyTestDB", IsTrustedConn = false, X_CurDbConnectionMode = CoreEA.Args.CurDbServerConnMode.SqlServer2000 }); List <string> targetDbList = targetHandle.GetTableListInDatabase(); foreach (var tableName in tableList) { BaseTableSchema schemaInfo = srcHandle.GetTableSchemaInfoObject(tableName); if (!targetDbList.Contains(tableName)) { targetHandle.CreateTable(schemaInfo); try { CommonUtil_Accessor.ExchangeDataBetweenAnyDbs(srcHandle, targetHandle, tableName); } catch { targetHandle.DeleteTable(tableName); } } } TestGlobalExtension.RecordTestMethod(); }
public void DataTransfer_SSCE2MySQL() { DataExchangeWizard_Accessor target = null; try { target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value } catch { } CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler; srcHandle.Open(new LoginInfo_SSCE() { DbName = GlobalInfo.SqlCE_TestFile }); List <string> tableList = srcHandle.GetTableListInDatabase(); targetHandle.Open(new LoginInfo_MySql() { Database = "category", Server = "localhost", Username = "******", Pwd = "noway", }); List <string> targetDbList = targetHandle.GetTableListInDatabase(); bool isHasError = false; foreach (var tableName in tableList) { BaseTableSchema schemaInfo = srcHandle.GetTableSchemaInfoObject(tableName); if (!targetDbList.Contains(tableName, new MyStringComparer())) { targetHandle.CreateTable(schemaInfo); try { bool result = CommonUtil_Accessor.ExchangeDataBetweenAnyDbs(srcHandle, targetHandle, tableName); if (result == false) { isHasError = true; } } catch { targetHandle.DeleteTable(tableName); } } } Assert.AreEqual(false, isHasError); }
public void DataTransfer_SqlServer2SSCE() { testContextInstance.RecordTestMethod(); DataExchangeWizard_Accessor target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value List <string> tableList = new List <string>(); CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; srcHandle.Open(new CoreEA.LoginInfo.LoginInfo_SqlServer() { X_Server = "", X_UserName = "", X_Pwd = "", X_Database = "", IsTrustedConn = false, X_CurDbConnectionMode = CoreEA.Args.CurDbServerConnMode.SqlServer2000 }); if (srcHandle.IsOpened) { tableList = srcHandle.GetTableListInDatabase(); } tableList = tableList.Take(4).ToList(); CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; string targetFile = "C:\\a3.sdf"; if (File.Exists(targetFile)) { File.Delete(targetFile); } targetHandle.CreateDatabase(new CoreEA.LoginInfo.LoginInfo_SSCE() { DbName = targetFile, IsCaseSensitive = true }); targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_SSCE() { DbName = targetFile }); if (targetHandle.IsOpened) { target.DoExchangeData(srcHandle, targetHandle, tableList); } TestGlobalExtension.RecordTestMethod(); }
public void DataTransfer_SSCE2Sqlite() { testContextInstance.RecordTestMethod(); DataExchangeWizard_Accessor target = null; try { target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value } catch { } CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Sqlite).X_Handler; string srcCEFile = GlobalInfo.SqlCE_TestFile; srcHandle.Open(new LoginInfo_SSCE() { DbName = srcCEFile }); List <string> tableList = srcHandle.GetTableListInDatabase(); targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_Sqlite() { DbFile = "C:\\1.sqlite", }); List <string> targetDbList = targetHandle.GetTableListInDatabase(); foreach (var tableName in tableList) { BaseTableSchema schemaInfo = srcHandle.GetTableSchemaInfoObject(tableName); if (!targetDbList.Contains(tableName)) { targetHandle.CreateTable(schemaInfo); try { CommonUtil_Accessor.ExchangeDataBetweenAnyDbs(srcHandle, targetHandle, tableName); } catch { targetHandle.DeleteTable(tableName); } } } TestGlobalExtension.RecordTestMethod(); }