public void MySqlSourceConstructorTest_SourceAlias()
{
MySqlSource target = new MySqlSource("Table", "a");
Assert.AreEqual <string>(string.Format("`{0}`", target.Alias), target.Fullname);
Assert.AreEqual <string>(string.Format("{0} AS `{1}`", target.Object.SqlString, target.Alias), target.SqlString);
}
public void MySqlSourceConstructorTest_SourceName()
{
MySqlSource target = new MySqlSource("Table");
Assert.AreEqual <string>(string.Format("`{0}`", target.Name), target.Fullname);
Assert.AreEqual <string>(string.Format("`{0}`", target.Name), target.SqlString);
}
public void MySqlFieldConstructorTest_FieldAlias()
{
ISqlObject source = new MySqlSource("Table");
SqlAliasObject field = new MySqlField(source, "Field", "ID");
Assert.AreEqual <string>(field.Object.Fullname, field.Fullname);
Assert.AreEqual <string>(string.Format("{0} AS `{1}`", field.Object.SqlString, field.Alias), field.SqlString);
}
public void MySqlFieldConstructorTest_FieldName()
{
ISqlObject source = new MySqlSource("Table");
ISqlObject field = new MySqlField(source, "Field");
Assert.AreEqual <string>(string.Format("{0}.`{1}`", source.Fullname, field.Name), field.Fullname);
Assert.AreEqual <string>(string.Format("{0}.`{1}`", source.Fullname, field.Name), field.SqlString);
}
public void MySqlSourceConstructorTest_SourceOwnerAlias()
{
MySqlSource owner = new MySqlSource("INFORMATION_SCHEMA");
MySqlSource target = new MySqlSource(owner, "Table", "a");
Assert.AreEqual <string>(string.Format("`{0}`", target.Alias), target.Fullname);
Assert.AreEqual <string>(string.Format("{0} AS `{1}`", target.Object.SqlString, target.Alias), target.SqlString);
}
public void MySqlSourceConstructorTest_SourceOwnerName()
{
MySqlSource owner = new MySqlSource("INFORMATION_SCHEMA");
MySqlSource target = new MySqlSource(owner, "Table");
Assert.AreEqual <string>(string.Format("{0}.`{1}`", owner.Fullname, target.Name), target.Fullname);
Assert.AreEqual <string>(string.Format("{0}.`{1}`", owner.Fullname, target.Name), target.SqlString);
}
public void MySqlSourceConstructorTest_Subquery()
{
MySqlSource source = new MySqlSource("Table");
ISqlSelectStatement statement = new MySqlSelectStatement();
statement.SelectClause.AddExpressions(new SqlAllField(source));
statement.FromClause.Source = source;
MySqlSource target = new MySqlSource(statement, "Source");
Assert.AreEqual <string>(string.Format("`{0}`", target.Name), target.Fullname);
Assert.AreEqual <string>(string.Format("({0}) AS `{1}`", statement.SqlString, target.Name), target.SqlString);
}
public void CountTest()
{
ISqlObject source = new MySqlSource("Table");
ISqlObject field = new MySqlField(source, "ID");
MySqlSelectStatement target = new MySqlSelectStatement();
target.SelectClause.AddExpressions(field);
target.FromClause.SetSource(source);
target.Count = 13;
Assert.AreEqual <string>(string.Format("{0} {1} {2}", target.SelectClause.SqlString, target.FromClause.SqlString, target.LimitClause.SqlString),
target.SqlString);
}
public void TestDataflow_MySql_to_List()
{
string ServerName = "";
if (string.IsNullOrEmpty(ServerName))
{
return;
}
MySqlConnectionManager MyTestDb = new MySqlConnectionManager(ServerName, "TestDB", "", "");
using (MyTestDb)
{
MySqlSource <Datensatz_MySql_to_List> MySqlDBSource = new MySqlSource <Datensatz_MySql_to_List>(MyTestDb.getNewMySqlConnection()
, "SELECT Tag, Monat FROM test"
);
MySqlDBSource.DataMappingMethod = ReaderAdapter_MySql_to_List.Read;
ListDestination <Datensatz> destination = new ListDestination <Datensatz>();
Graph g = new Graph();
g.GetVertex(0, MySqlDBSource);
g.GetVertex(1, new RowTransformation <Datensatz_MySql_to_List>(RowTransformationDB));
g.GetVertex(2, new RowTransformation <Datensatz_MySql_to_List>(RowTransformationDB2));
g.GetVertex(3, destination);
g.AddEdge(0, 1); // connect 0 to 1
g.AddEdge(1, 2); // connect 1 to 2
g.AddEdge(2, 3); // connect 2 to 3
DataFlowTask <Datensatz> .Execute("Test dataflow task", 10000, 1, g);
//TestHelper.VisualizeGraph(g);
//Assert.AreEqual(4, new ExecuteSQLTask(MyTestDb.MySqlConnection).ExecuteScalar(string.Format("select count(*) from {0}", destObject)));
}
}
