public void LookupEasy(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.ConnectionManager connection)
{
LibDF.Lookup Lookup = new LibDF.Lookup("Lookup Easy", connection, "SQL")
.AddComponent(dataFlow);
new LibDF.Path(output, Lookup.DefaultInput).Connect(dataFlow);
Lookup.AddReadOnlyInputColumn("ColumnName")
.AddLookupMapping(new LibDF.LookupMapping("inputColumn", "lookupColumn"));
}
public void EventHandler(LibCF.Package package, Lib.ConnectionManager connection)
{
LibCF.Sequence seq = new LibCF.Sequence("Sequence")
.AddComponent(package);
Lib.EventHandlerWrap postExecute = seq.GetPostExecuteEventHandler();
LibCF.SQLTask sqlTask = new LibCF.SQLTask("sql task", connection)
.AddComponent(seq)
.AddDirectInput("SQL");
postExecute.AddTask(sqlTask);
}
public void PrecedenceConstraint(LibCF.Sequence seq, Lib.ConnectionManager connection)
{
LibCF.SQLTask sql1 = new LibCF.SQLTask("sql task", connection)
.AddComponent(seq)
.AddDirectInput("SQL");
LibCF.SQLTask sql2 = new LibCF.SQLTask("sql task", connection)
.AddComponent(seq)
.AddDirectInput("SQL");
new LibCF.PrecedenceConstraint(sql1, sql2, "condition, e.g. 1 > 0")
.AddComponent(seq);
}
public void LookupAdvanced(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.ConnectionManager connection)
{
LibDF.Lookup lkp = new LibDF.Lookup(
"Lookup", connection, "LOOKUP SQL",
LibDF.NoMatchBehaviour.RedirectRowsToNoMatchOutput,
LibDF.CacheType.Partial)
.AddComponent(dataFlow);
new LibDF.Path(output, lkp.DefaultInput).Connect(dataFlow);
lkp.AddReadOnlyInputColumn("inputColumn");
lkp.AddLookupMapping(new LibDF.LookupMapping("inputColumn", "lookupColumn"));
LibDF.LookupAdvancedParameters advPars = new LibDF.LookupAdvancedParameters("select Advanced SQL Query");
advPars.AddParameter("Parameter");
lkp.SetAdvancedParameters(advPars);
}