v2.2.1

Changelog

[+] create workflow to push docker image bea8f55
[+] log output for sql and built-in tasks in case of error 086b261
[-] fix "sql and built-in tasks have returncode 0 even in case of error" 086b261
[-] if task output is empty, log error as output effdfea

v2.2.0

Changelog

[!] add --init command line argument fixes #128, closes #129 f441bfc
[!] add --no-help command line argument to suppress help output 18768b0
[!] add Grafana dashboard to monitor chain execution stats dd8608c
[!] implement custom startup script support with --file, closes #131 e66ece0
[!] implement autonomous tasks
[+] add context argument to InitAndTestConfigDBConnection() 4acfaf5
[+] add context arguments to migrations routines 4acfaf5
[+] add context arguments to transactions, access and shell routines #118 9b599c2 4acfaf5
[+] add context to pgengine.ReconnectDbAndFixLeftovers() and use channels
[+] add context to scheduler.Run()
[+] add pgengine.IsAlive() method
[+] add reconnection routine to the main()
[+] add sample for autonomous task
[+] make cmdparser 100% covered with tests, resolves #126 8e787f8
[+] make built-in 100% tasks 5778939
[+] make download task 100% covered with tests 1f193e1
[+] make mail task 100% covered with tests febeb1f
[+] pass derived contexts to chain workers goroutines
[+] return ConnectionDropped after failed pgengine.IsAlive()
[+] rewrite reconnecting routing with channels and context #118 787628a c2cc25d
[+] set timeout for initial connection to 90 sec #118 19dbca7 9d4c5c4
[*] improve log messages for reconnection tries #118 4ee0cc3
[*] make InitAndTestConfigDBConnection() return boolean 4e1e2c8
[*] make MigrateDb() and CheckNeedMigrateDb() return boolean #118 4e1e2c8 828f8f2
[*] make pgengine.WaitTime public const 032ab3e a1c63ce
[*] pass context argument to InitAndTestConfigDBConnection() in tests #118 223f1d9 693e817
[*] prettify log strings 65afcb1
[*] refactor command line handling b87995f
[*] remove reconnection routine from pgengine.LogToDB()
[*] set cyclomatic complexity to 16 for linter; resolves #122 73d29fa
[-] fix "if block ends with a return statement, so drop this else and outdent its block" 16fa2ee 3f8c518
[-] fix "Cannot log to the database: pq: relation "timetable.log" does not exist" #118 25df3de 74ee9e6
[-] fix "exported func Run returns unexported type scheduler.runStatus, which can be annoying to use" 310fd5d 3363398
[-] fix "Host in --pgurl parameter ignored if port is not specified" f441bfc
[-] fix "interval chains are not rescheduled if a database error occurs" f6dcb97
[-] fix "return" to "continue" in scheduler.intervalChainWorker() 8226433
[-] fix "S1039: unnecessary use of fmt.Sprintf" 8226433
[-] fix tests connection string 3106fa4 e32cb76
[-] fix verbose level output
[-] make scheduler.Run() return runStatus type #118 20c08e0 d07a486
[-] reschedule interval chains in a separate goroutines acf02ec

v2.1.0

Changelog

[+] add "output" column to the timetable.execution_log table; fixes #86 067e893
[+] add .yml files as action triggers b258934
[+] log client name and PID of worker at the start of a session cae0572
[+] make REPAIR pseudo log level red a3fccd6
[+] PostgreSQL license used 23f27ef
[+] resolves #108: add client_name to run_status and execution_log tables cae0572
[+] resolves #115: Implement color output cc1fb64
[+] test only if GoLang files were affected e843dbc
[+] unshallow step is required for the changelog to work correctly b40beea
[+] update golangci-lint version to 1.24.0 7fd8db4
[*] add link to PR's fdab874
[*] new pgengine/log.go file added cc1fb64
[*] remove setup-go action since Go is preinstalled 7fd8db4
[*] templated license used 4faf8ff
[*] update golangci-lint settings 7fd8db4
[-] do not produce db objects, use db.Ping() instead of sqlx.Connect() 8662f94
[-] fix "Cannot stop execution if connection lost" #119 #120 2eb6193
[-] fix "Cannot stop execution inside RECONNECTING cycle" 2eb6193
[-] fix "S1039: unnecessary use of fmt.Sprintf" 1bb1080
[-] fix pgengine test 581ad8a
[-] fix workflow with including paths e4b1d8c
[-] fixes #113: "STARTED deleted from run_status during crash" cae0572
[-] merge pull request #121 from cybertec-postgresql/120_connection_lost_terminate 19b4a93

v2.0.2

Changelog

47faf73 - fix error date in the log #111

v2.0.1

Changelog

fc150de Merge pull request #107 from cybertec-postgresql/100_fix_crash

v2.0.0

The new major v2 release introduces:

• brand new cron-style schedules;
• @reboot, @every and @after jobs;
• disallow executing the shell tasks using --no-shell-tasks command line parameter;
• continuos testing implemented with GitHub Actions;
• release packages for different platforms available (.rpm, .deb, .tar.gz, .zip; Linux, macOS, Windows)
• no external .sql files for bootstrapping, only single binary shipped;
• upgrade machinery with database migrations implemented, see --upgrade option;
• notice processing added, e.g., RAISE NOTICE ... from tasks collected into the log

v0.1.2

Changelog

6b99ed9 - fix insert statements in samples #70

v0.1.0

Embedded SQL and migrations