コード例 #1
0
 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"));
 }
コード例 #2
0
        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);
        }
コード例 #3
0
        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);
        }
コード例 #4
0
        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);
        }