Beside using single php files, this lib need to have sqlite or mysql entegration

[kaerer]

I am searching these kind of libs to implement into a symfony project.
I like the most this lib comparing to others, it is simple and easy to use but when i define the rule, it should save into a list (like sqlite, mysql or even into a single file) so it will be more controllable by programmatically. Generating task files dynamically may create issues and also not convenient for large projects.

[fluchi]

Hi @kaerer ,

I see your point about storing rules.
If I got it right, I've done it saving on both a yaml file and database.

I've used a yaml file to storage the system rules and from the database I got info about when something must run.
In other words, I generate and return a task on the fly, then it'll run on the appropriate time based on my db rules.

Hope that makes sense for you.

cheers

[PabloKowalczyk]

Hello guys,
@kaerer if i understand correctly, would you like to change tasks' "backend" from files to SQL database?

[judodan]

I'd like to second this. I want to be able to set rules programmatically. I'd also like to be able to show the last time a task was run (I can do that by checking the log file) as well programmatically forcing a job to run. I suppose I could circumvent this all using "when" ?

@fluchi I'd be interested in seeing how you've done this.

[fluchi]

Hi @judodan ,

on my case, I have a set of rules on a database that tells me "when" to run a command, something like "run foobar after noon". Based on these set of rules, I check what should be running and inject commands on run's argument and create a tasks as described here. This verifications are done in a task file.

Basically, it is main schedule triggers every tasks and Tasks checking is something should run or not.

Hope that helps.

[pixobit]

I believe this is redundant, because this is completely possible at the moment, just as @fluchi pointed out the solution.

As for logging when something ran, you just need to write your own logger, which is also possible

[oularrea]

Hi guys, I want to use this library to generate multiple commands, but these commands will depend on a query to the DB. Do you know how I can inject symfony doctrine from a task file?

I am trying to do something like this, but instead of an http client do it with the query directly:
Reference

[PabloKowalczyk]

Hello @oularrea
First, create Symfony CLI command and write all your logic here, you will have access to everything in your app, then just use Crunz to run your Symfony's commands.