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 LoginInMySql_Test()
{
testContextInstance.RecordTestMethod();
MySqlEntry_Accessor target = new MySqlEntry_Accessor(); // TODO: Initialize to an appropriate value
//SqlServerLoginControl.X_CollectionData data = new SqlServerLoginControl.X_CollectionData()
//{
// DbName = "MySql",
// CurType = new SqlServerLoginControl.X_LoginDbParas()
// {
// CurConnMode = CoreEA.Args.CurDbServerConnMode.Standard,
// Name = "MySql",
// },
// PWD = "noway",
// Server = "localhost",
// UID = "root",
//};
// target.txtDbName = "localhost";
target.passwordBox1.Password = "******";
target.txtUsername.Text = "root";
target.txtServername.Text = "localhost";
target.ConnectCmd_Executed(null, null);
TestGlobalExtension.RecordTestMethod();
}
public void SyncSqlServer2SSCE_ClickTest()
{
testContextInstance.RecordTestMethod();
NewSqlServer2SSCE_Accessor target = new NewSqlServer2SSCE_Accessor(); // TODO: Initialize to an appropriate value
object sender = null; // TODO: Initialize to an appropriate value
RoutedEventArgs e = null; // TODO: Initialize to an appropriate value
target.sqlServerLoginControl1.SetPwd("");
target.butGetTableList_Click(sender, e);
target.chkIsNeedCopyData.IsChecked = true;
target.tableList.SelectedItems.Add(target.tableList.Items[0]);
target.tableList.SelectedItems.Add(target.tableList.Items[1]);
target.tableList.SelectedItems.Add(target.tableList.Items[2]);
string t = new Random().Next(1000).ToString();
target.txtTargetFile.Text = string.Format("C:\\TestResult_SyncSqlserver2SSCEFile-{0}.sdf", t);
target.SyncSqlServer2SSCE(sender, e);
TestGlobalExtension.RecordTestMethod();
Assert.IsTrue(target.tableList.Items.Count > 0);
}
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 butSync_ClickTest()
{
testContextInstance.RecordTestMethod();
MySql2SDF_Accessor target = new MySql2SDF_Accessor(); // TODO: Initialize to an appropriate value
object sender = null; // TODO: Initialize to an appropriate value
RoutedEventArgs e = null; // TODO: Initialize to an appropriate value
target.SyncMysql2SSCE(sender, e);
TestGlobalExtension.RecordTestMethod();
}
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();
}
public void LoginInSqlite_Test()
{
testContextInstance.RecordTestMethod();
SqliteEntry_Accessor target = new SqliteEntry_Accessor(); // TODO: Initialize to an appropriate value
object sender = null; // TODO: Initialize to an appropriate value
RoutedEventArgs e = null; // TODO: Initialize to an appropriate value
target.FilePicker.Content = "C:\\test.db3";
target.butOpen_Click(sender, e);
TestGlobalExtension.RecordTestMethod();
}
public void SyncCSV2SSCE_Test()
{
testContextInstance.RecordTestMethod();
Csv2Sdf_Accessor target = new Csv2Sdf_Accessor(); // TODO: Initialize to an appropriate value
object sender = null; // TODO: Initialize to an appropriate value
RoutedEventArgs e = null; // TODO: Initialize to an appropriate value
target.txtSrcFile.Text = "C:\\TestData\\TestCSV.csv";
string t = new Random().Next(1000).ToString();
target.txtTargetFile.Text = string.Format("C:\\TestResult_SyncCSV2SSCEFile-{0}.sdf", t);
target.SyncCSV2SSCE(sender, e);
TestGlobalExtension.RecordTestMethod();
}
public void TestSchmea()
{
testContextInstance.RecordTestMethod();
WPFCommonControl.SqlServerLoginControl.X_CollectionData data = new WPFCommonControl.SqlServerLoginControl.X_CollectionData()
{
DbName = "Master",
CurType = new WPFCommonControl.SqlServerLoginControl.X_LoginDbParas()
{
CurConnMode = CoreEA.Args.CurDbServerConnMode.SqlServer2005Express,
Name = "SqlServer2008",
},
PWD = "1",
Server = "Leond-xp\\sql2008",
UID = "sa",
};
SqlServerEntry_Accessor main = new SqlServerEntry_Accessor();
main.LoginInSqlServer(data);
TestGlobalExtension.RecordTestMethod();
}
public void LoginInSqlServer_Test()
{
testContextInstance.RecordTestMethod();
SqlServerLoginControl.X_CollectionData data = new SqlServerLoginControl.X_CollectionData()
{
DbName = "",
CurType = new SqlServerLoginControl.X_LoginDbParas()
{
CurConnMode = CoreEA.Args.CurDbServerConnMode.SqlServer2000,
Name = "SqlServer2000",
},
PWD = "",
Server = "",
UID = "",
};
SqlServerEntry_Accessor main = new SqlServerEntry_Accessor();
main.LoginInSqlServer(data);
TestGlobalExtension.RecordTestMethod();
}