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