This project allows you to run parallex CRON jobs in Go. The CRON system is written in pure Go.
Basically, you have a master config file, let's call it config.json which:
A) Either sits in the same folder as the executable or the file, called, called config.json;
Or B) You can pass to the executable.
This JSON file is an array with objects that look like the ones you see in config.json of this project,
for example:
[
{
"sql_type": "MYSQL",
"exec_time": {
"days": [26, 27, 28],
"hours": [],
"minutes": [13, 15, 16],
"all_minutes": false,
"all_hours": true,
"all_days": false
},
"config_path": "./example/runner_test.json"
}
]
The array can contain as many objects as you desire. If you don't wanna pass a day and want to check "all_days", pass an empty array. Same is true about hour and day. Otherwise pass days, hours, and minutes; and it will run the job at that time.
Supported SQL types are: MYSQL, MSSQL, POSTGRESQL (keep in mind, it should be in capital!)
The sub-config file looks like this:
{
"username": "superchubak",
"password": "supsup",
"host": "localhost",
"database": "test_db",
"port": "3306",
"commands": [
"CREATE TABLE Test (firstname varchar(255))",
"INSERT INTO Suppose (firstname) VALUES ('zuzie')"
],
"queries": [
"SELECT * FROM Test",
],
"save_file": "~/dump.json"
}
Comamnd is something you execute. Query is something that gets you results. These results are savd in
save_file.
There's one in example folder.
You can have as many configs as you like, it will run in parallel ;)
If you have a question direct them to Chubak#7400 on Discord.
This is only tested for MySQL but it should work for MSSQL and PostgreSQL the same because they use the same backend.
Run:
go run . [optional: config file]
Or build first with go build . then run. Or build and install with go install ..... I mean there are dozens ways --- well, three ways!! But you get the gist.