elsa-core icon indicating copy to clipboard operation
elsa-core copied to clipboard

Elsa 3 - SQL Activities Missing

Open KnibbsyMan opened this issue 1 year ago • 1 comments

Unless I’ve missed the package, there does not seem to be SQL activities like in Elsa 2. I used them to run periodic table cleansing activities and for inserting records during workflows. This for me is a really core feature missing from Elsa 3. Is there a plan to include SQL activities anytime soon?

Furthermore, to build on the Elsa 2 SQL activities, I have a few features that would be nice on the Elsa 3 Designer side, if they are even possible:

  • Select the “Name” of a connection string from a drop down of preconfigured connection strings.
  • Display configured DbContexts in a drop down and use that as the connection string.
  • I think Elsa 2 did this already but implement SQL syntax highlighting in the query activity.
  • Support for running transactions, with monitoring for if it passed or failed as outcomes.

KnibbsyMan avatar Jan 10 '24 01:01 KnibbsyMan

You're right, the SQL activities have yet to be ported to Elsa 3. Your additional suggestions about selecting a connection from a dropdown makes sense. If I'm not mistaken, this was already implemented for Elsa 2 using the Secrets module.

sfmskywalker avatar Jun 08 '24 16:06 sfmskywalker