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