Yeah, I realized that after I sent the email. Although now that I'm thinking about it I wonder if it would be bad to yield the same row from the output command so you could keep chaining operations even after the output. Going back and updating a source row isn't too uncommon and for some reason the branching operation seems strange to me.
Nathan Palmer On Wed, Jan 12, 2011 at 6:48 PM, Jason Meckley <jasonmeck...@gmail.com>wrote: > to be more precise output commands terminate the return of rows: > > https://github.com/ayende/rhino-etl/blob/master/Rhino.Etl.Core/Operations/OutputCommandOperation.cs > > On Jan 12, 8:45 pm, Jason Meckley <jasonmeck...@gmail.com> wrote: > > @nathan > > because database operations terminate the return of rows. > > @alex > > I would use any one of the inputcommandoperations. I try to use the > > conventionbulksqlcommandoperation as much as possible. but anyone will > > do. > > > > On Jan 12, 5:20 pm, Alex Brown <a...@alexjamesbrown.com> wrote: > > > > > but what should the "update from original..." operation be? > > > An AbstractDatabaseOperation? InputCommandOperation? > > > > > On Jan 12, 9:40 pm, Nathan Palmer <snowpal...@gmail.com> wrote: > > > > > > Why would you choose a branching operations instead of just 3 > operations one > > > > after another? > > > > > > register("select from original.."); > > > > register("insert into destination.."); > > > > register("update from original..."); > > > > > > On Wed, Jan 12, 2011 at 1:14 PM, Jason Meckley < > jasonmeck...@gmail.com>wrote: > > > > > > > get data and branch to insert and update > > > > > > > register("select ..."); > > > > > register(new BranchingOperation() > > > > > .Add("insert into...") > > > > > .Add("update ...")); > > > > > > > On Jan 12, 12:29 pm, Alex Brown <a...@alexjamesbrown.com> wrote: > > > > > > Hi, > > > > > > I'm currently writing a few etl processes to move rows from one > table > > > > > > to another. > > > > > > > > Firstly, I have an ImportCommandOperation that is basically doing > > > > > > "SELECT * FROM table WHERE Transferred = 0" > > > > > > This is working fine. > > > > > > > > Then, I have a write operation to insert the rows > > > > > > > > Finally, I need an operation that Updates the source table, sets > > > > > > Transferred to 1 > > > > > > > > How should I go about doing this? > > > > > > > -- > > > > > You received this message because you are subscribed to the Google > Groups > > > > > "Rhino Tools Dev" group. > > > > > To post to this group, send email to > rhino-tools-dev@googlegroups.com. > > > > > To unsubscribe from this group, send email to > > > > > rhino-tools-dev+unsubscr...@googlegroups.com<rhino-tools-dev%2bunsubscr...@googlegroups.com> > <rhino-tools-dev%2Bunsubscribe@ googlegroups.com> > > > > > . > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/rhino-tools-dev?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Rhino Tools Dev" group. > To post to this group, send email to rhino-tools-dev@googlegroups.com. > To unsubscribe from this group, send email to > rhino-tools-dev+unsubscr...@googlegroups.com<rhino-tools-dev%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/rhino-tools-dev?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to rhino-tools-dev@googlegroups.com. To unsubscribe from this group, send email to rhino-tools-dev+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
