SQLBranchOperator

[jeffolsi]

Airflow has SQLSensor and PythonBranchOperator it seems that the logic of both can be combined to create SQLBranchOperator

SQLSenor knows to take single sql query and wait for condition on it. it can be copied and changed so that it won't wait (like sensor) but simply return true false. According to the value returned from the query it will follow the chosen branch.

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[pujaji]

Hey! I would like to work on this

[potiuk]

Please do !

[samuelkhtu]

Hey! I would like to work on this

Hey @pujaji just wondering if you get a chance to work on this?

[samuelkhtu]

Hi @potiuk , sorry to bother you. I am just wondering what will be a good way to write unit tests for this type of SQL related operators? I looked at the existing unit test for MsSqlOperator and found that the unit test only initialize the MsSqlOperator and call the "get_hook()" method and assert on hook.class.

Thanks.

[jeffolsi]

I would assume that the tests should be similar to SQLSensor which already utilises various of databases options into single sensor.
The SQL part itself (taking query and run it) is the same between the SQLSensor and the SQLBranchOperator the difference comes after the query run and returned value.

[potiuk]

Yep. Thanks @jeffolsi for the explanation. Yep. I think this is about right.

[samuelkhtu]

Thank you both!

[pujaji]

Hey! I would like to work on this

Hey @pujaji just wondering if you get a chance to work on this?

Hello @samuelkhtu Please don't bother working on this. Please continue to finish this.
regards,
Puja

[samuelkhtu]

Thanks @pujaji , sounds like you've got this. I will circle back in a few days. Can't wait to see this new operator!

[pujaji]

@samuelkhtu No Samuel You have got me wrong. I have stopped working on this. I urge you to accomplish this ans present this to the community

[samuelkhtu]

Hi @pujaji , I am sorry I misunderstood you. Sounds good. I will give this a try!

[pujaji]

No regrets! Happy coding-contributing!! 👍