Scheduler proposal

[vitalii-honchar]

OrientDB Version: 3.1.0-SNAPSHOT

Java Version: OpenJDK 1.8

OS: Ubuntu 18.04

Hello. I used OrientDB scheduler for schedule some regular tasks which need perform on data, but right now in OrientDB 3 looks that JavaScript API is deprecated, so I can't use it anymore in scheduler. But I like idea that OrientDB can schedule tasks

Proposal is this:
Allow schedule not only SQL commands, but Java tasks too.

What do you think about this?

[andrii0lomakin]

I am sorry but that creates big security issues unlikely that will be possible.

[andrii0lomakin]

@WeaxMe what exactly do you want to do with scheduled function?

[vitalii-honchar]

Hello @Laa

I want scheduled function which updates records periodically. For example:

1. Move some data to archive.
2. Update user status
   And so on.

This functions must contains logic only for working with database and ideally must executes under specified user (not from admin as now).

I'm OK for write scheduled functions with JavaScript, but looks that JavaScript functions was deprecated in OrientDB 3, so I want analog, because I like to use OrientDB scheduler.

I don't see security issues here. Because:

1. Scheduled functions will be executed not from admin, but under specified user, so there function can do only that things which can do user.
2. Only user with given permission can create scheduled function, so there is no possibility for create access to server throughout this function, because user with this permission must be admin or administrator.

As I see scheduler can execute any function which is subclass of OFunction. May be it will be better add support for Java functions.

Design proposal

1. Interface IFunction
2. Implementation of interface OFunction - this is function which is stored in database
3. Allow implement IFunction by developers. For use pure Java
4. Restrict function execution. So execute function only under specified user

Thanks

[vitalii-honchar]

@Laa what do you think?
If this is not need inside OrientDB, please just close issue

[vitalii-honchar]

@Laa what do you think? If this is not need, please close issue

[tglman]

Hi,
I think is OK and possible to run SQL scripts as a scheduled function, as Java code we would not allow the creations of Java functions from the API, but probably we could allow functions inject from plugins deployed in the server.

Regards