Storing Groovy scripts through FileDescriptor and using them in Scheduled Task

Hi,

i tried out the Scripting feature which allows me to dynamically run code that sits in configuration directories outside the war file. Using that together with scheduled tasks is pretty interesting.

But i was thinking about one feature that would be a little more convenient: Instead of referencing the groovy scripts just by name in the scheduled task, would it be also possible to store the information in the database (the source code) or just as references to a sys$FileDescriptor which holds the groovy file. This way the administrator would be able to execute code while not having the need to access the filesystem of the server directly, but instead go through the UI of CUBA. This might either be because of laziness or perhaps because of security or organisational reasons as well (the tomcat admin doesn’t need to be the same person as the app admin).

Since pretty much all building blocks are already there (like sys$FileDescriptor entity, the SourceCodeEditor as well as the scheduled tasks or the scripting interface to execute code dynamically), it would be cool to see coming all of this together and create another cool feature.

It could be up to the app dev to decide to develop something like this, but perhaps this is something a lot of people are interested about.

Bye
Mario

Hi Mario,

We’ve thought about some convenient facilities to execute Groovy and/or JPQL scripts from administrative UI and scheduled tasks, but never had time to implement it. So I’ve created an issue, hopefully we’ll deal with it in the near future.

:ticket: See the following issue in our bug tracker:

https://youtrack.cuba-platform.com/issue/PL-8687