v5.0.0

What's Changed 💡⚡️👩‍🦳

• [!] add suport for jackc/pgx/v5 by @pashagolub in #488
• [+] replace deprecated golint with revive, closes #502 by @pashagolub in #503
• [+] add /startchain and /stopchain REST API endpoints, closes #482 by @pashagolub in #498
• [+] add email sending example to the docs, closes #495 by @pashagolub in #496
• [+] bump actions/setup-go from 2 to 3 by @dependabot in #489
• [+] bump pashagolub/pgxmock/v2 to 2.4.0 by @dependabot in #513
• [+] bump spf13/viper to 1.14.0 by @dependabot in #510
• [+] bump stretchr/testify to 1.8.1 by @dependabot in #506
• [+] use sethvargo/go-retry for the reconnection logic, closes #480 by @pashagolub in #481
• [*] use pgx.RowToStructByName instead of local one, closes #514 by @pashagolub in #515
• [*] use envvar in GHA instead of deprecated set-output command, closes #499 by @pashagolub in #509

Full Changelog: v4.9.0...v5.0.0

What to do next?

• Star the repository
• Read the documentation
• Check out the blog
• Follow us on Twitter

v4.9.0

What's Changed 🔥🌻⏰

• [+] bump jackc/pgx/v4 to 4.17.0 by @dependabot in #471
• [+] bump georgysavva/scany to 1.1.0 by @dependabot in #462
• [+] bump pashagolub/pgxmock to 1.8.0 by @dependabot in #474
• [+] bump sirupsen/logrus to 1.9.0 by @dependabot in #460
• [+] provide migration script from pgAgent to pg_timetable, closes #341 by @pashagolub in #465
• [*] do not produce connection string for the current database in pgagent_to_pg_timetable.sql, fixes #467 by @pashagolub in #468
• [-] prevent running several instances with the same clientname, fixes #475 by @pashagolub in #476

Full Changelog: v4.8.0...v.4.9.0

What to do next?

• Star the repository
• Read the documentation
• Check out the blog
• Follow us on Twitter

v4.8.0

What's Changed 🤜➡️🔨

• [+] add dependabot check for GitHub actions, closes #449 by @pashagolub in #450
• [+] add txid column to timetable.execution_log, closes #436 by @pashagolub in #437
• [+] bump actions/checkout to 3 by @dependabot in #452
• [+] bump github/codeql-action to 2 by @dependabot in #451
• [+] bump go.mod to 1.18, closes #444 by @pashagolub in #454
• [+] bump goreleaser/goreleaser-action to 3 by @dependabot in #453
• [+] bump spf13/viper to 1.12.0 by @dependabot in #440
• [+] bump stretchr/testify to 1.8.0 by @dependabot in #456
• [+] provide migration tool from pg_cron to pg_timetable, closes #343 by @pashagolub in #439
• [-] add timetable.migration table to migrate_v3_to_v4.sql script, fixes #457 by @pashagolub in #458
• [-] fix migration #436 on timetable.execution_log for non-empty table, closes #442 by @pashagolub in #443

Full Changelog: v4.7.0...v4.8.0

What to do next?

• Read the documentation
• Check out the blog
• Follow us on Twitter

v4.7.0

What's Changed 🙏💙💛

• [+] add psql client to the Docker image by default, closes #429 05e5921
• [+] bump georgysavva/scany to v1.0.0 90fda6e
• [+] bump golangci/golangci-lint-action to v3, closes #421 e73168d
• [+] bump jackc/pgconn to v1.12.0 8da1cb2
• [+] bump jackc/pgtype to v1.11.0 8da1cb2
• [+] bump jackc/pgx/v4 to v4.16.1 660fcdf
• [+] bump pashagolub/pgxmock to v1.6.0 e1d4259
• [+] bump spf13/viper to v1.11.0 7db27c5
• [+] use shogo82148/actions-goveralls instead of jandelgado/gcov2lcov-action and coverallsapp/github-action 52e667e
• [*] rename LOG database log level to INFO, closes #417 4cacdab
• [-] fix "cannot fetch chains if chain.timeout field is NULL", fixes #413 d57cc64
• [-] fix Test and Build GHA workflow on Ubuntu fail, fixes #435 52e667e
• [-] prevent release workflow running on Dependabot pull requests, fixes #391 cc14480
• [-] trim possible leading or trailing white space from the command 3cb4609

New Contributors

• @sh1der made their first contribution in #416
• @paulovieira made their first contribution in #424

Full Changelog: v4.6.0...v4.7.0

v4.6.1

[-] small fix for elgohr/Publish-Docker-Github-Action/issues/155

What to do next?

• Read the documentation
• Check out the blog
• Follow us on Twitter

v4.6.0

What's Changed 🇺🇦💪🕊️

• [+] use the latest Go v1.18 for workflows, closes #410 by @pashagolub in #411
• [+] bump stretchr/testify to 1.7.1 by @dependabot in #404
• [+] add CopyToFile built-in command, closes #405 by @pashagolub in #406
• [-] fix failed Update Docker workflow, closes #408 by @pashagolub in #409

Full Changelog: v4.5.0...v4.6.0

What to do next?

• Read the documentation
• Check out the blog
• Follow us on Twitter

v4.5.0

What's Changed 🚢👋🍆

• [+] add started_at column to active_session and active_chain tables, closes #394 f6771ef
• [+] add version arguments to Update Docker workflow e67c687
• [+] bump jackc/pgx/v4 to 4.15.0 12cc52a
• [+] bump pashagolub/pgxmock to 1.4.4 1c28407
• [*] add star history to readme 0ae08c9
• [*] improve TestLogHook() test case dad8820
• [*] start REST API server immediately after config parsing, fixes #392 9e68353
• [*] update ER-schema in docs a203bcb
• [*] use Max() in getTimeoutContext() instead of direct comparison 209ad5f
• [-] protect concurrent read and write of interval chains map, fixes #400 [*] remove obsolete intervalChainMutex 884778b

Full Changelog: v4.4.0...v4.5.0

v4.4.0

Changelog 🚦🕸️🚄

[!] add REST API, resolves #378 by @pashagolub in #379
[!] provide migration script from v3 to v4 transition, resolves #338 by @pashagolub in #377
[!] rewrite active chain handling by @pashagolub in #382
[+] bump georgysavva/scany 0.3.0 by @dependabot in #374
[+] bump jackc/pgx/v4 to 4.14.0 by @dependabot in #357
[+] bump pashagolub/pgxmock to 1.4.3 by @dependabot in #362
[+] bump spf13/viper to 1.10.1 by @dependabot in #366
[+] bump jackc/puddle to 1.2.1 by @pashagolub in #376
[+] output version information on demand, closes #385 by @pashagolub in #386
[*] save some space for big tables by @ukolovda in #373
[*] use constants for exit codes by @pashagolub in #365

Full Changelog: v4.3.0...v4.4.0
[!] add REST API, resolves #378 83ac6e9
[!] introduce internal web-server for REST API 4ecff4b
[!] provide migration script from v3 to v4 transition, resolves #338 9310da2
[+] add 00381 migration b03b2be
[+] add RestApi section and --rest-port command-line option 83ac6e9
[+] add Scheduler.IsReady() method to be used in REST API 83ac6e9
[+] add Scheduler.status property and RunningStatus constant 83ac6e9
[+] add TestRemoveChainRunStatus() test case 7237986
[+] add timetable.active_chain table and remove timetable.run_status, closes #381, fixes #370 b12c922
[+] add REST API documentation 63c8bee
[+] bump georgysavva/scany to 0.3.0 4888e75
[+] bump jackc/pgx/v4 to 4.14.1 0ce5cff
[+] bump jackc/pgtype to 1.9.1 0ce5cff
[+] bump pashagolub/pgxmock to 1.4.2 740b5e6
[+] bump pashagolub/pgxmock to 1.4.3, merge #362 f1bfbec
[+] bump spf13/viper to 1.10.1 951361b
[+] bump jackc/puddle to 1.2.1 b0f060f
[+] output version information on demand, closes #385 52e1217
[*] enhance PgEngine.Finalize() with cleaning dead chains b12c922
[*] enhance timetable.try_lock_client_name() with cleaning dead chains b12c922
[*] remove Chain.RunStatusID field b12c922
[*] remove PgEngine.FixSchedulerCrash() b12c922
[*] rewrite PgEngine.InsertChainRunStatus() b12c922
[*] remove timetable.get_chain_running_statuses() and timetable.health_check() b12c922
[*] rename and update PgEngine.AddChainRunStatus() to PgEngine.RemoveChainRunStatus() b12c922
[*] return ExitCodeDBEngineError if cannot reconnect in main() b12c922
[*] save some space for big 34a1944
[*] use constants for exit codes 817ec74
[-] fix "error: cannot insert multiple commands into a prepared statement (SQLSTATE 42601)" 81b1f3b
[-] fix parameter naming in dockerfile 8767c87
[-] fix S1023: redundant return statement (gosimple) 672452b

v4.3.0

Changelog 🛑🪜📎

[!] add built-in "Shutdown" task to stop pg_timetable session, closes #322 716be98 e4cd1b0
[!] refactor timetable.task as plain schema without tree-like dependencies, resolves #334 7ca9a44
[+] add job_exclusive parameter to timetable.add_job() cf20851
[+] add Scheduler.SendChain() and Scheduler.SendIntevalChain() methods 8216879
[+] add Scheduler.Shutdown() method e4cd1b0
[+] add scheduler.ShutdownStatus constant e4cd1b0
[+] add Scheduler.terminateChains() method e4cd1b0
[+] add Shutdown.sql sample e4cd1b0
[+] add Shutdown definition to the manual 716be98
[+] add Gitpod workspaces support, closes #351 (#352) d05c634 0321faa
[+] built-in "SendMail" task now can read attachments data from parameters by @ukolovda d7d227b
[+] bump jackc/pgconn to 1.10.1 181e26b
[+] bump jackc/pgtype to 1.9.0 181e26b
[+] increase chain channels capacity to prevent possible deadlock eba52fd
[+] "Open in Gitpod" button added 1240517
[*] add database migration and comments to functions 5882ffa
[*] add function comments to the migration script 6ce5823
[*] adopt TestSampeScripts() to the new Shutdown.sql sample 7d0e84b
[*] improve scheduler package coverage 6ee6c69
[*] prettify migrator tests 022046d
[*] rename PgEngine.MustCommitTransaction() to PgEngine.CommitTransaction() e4cd1b0
[*] rename PgEngine.MustRollbackTransaction() to PgEngine.RollbackTransaction() e4cd1b0
[*] rewrite samples according to the new schema ec378cd
[-] fix "cannot stop chain execution with timetable.notify_chain_stop()", closes #332 2c36ef6
[-] fix failed migration to plain ordering if task table was not empty, fixes #344 17a2055
[-] fix query in PgEngine.GetChainParamValues() 26d9b90
[-] fix task marked as successful even if retCode != 0 and IgnoreError is False, fixes #336 bad99d0
[-] implement non-blocking channel sending to avoid deadlock 56dd433
[-] increase connConfig.MaxConns property value to avoid deadlock, fixed #350 3cf7b7a

Full Changelog: v4.2.0...v4.3.0

v4.2.0

This release fixes the bug in database logging functionality. Please, update immediately!

Changelog 🔧🐛🪵

[!] upgrade to Go 1.17, closes #311 b653cc4
[*] add darwin/386 and windows/386 to the ignore list for goreleaser 429edff
[*] add windows/arm64 to the ignore list for goreleaser 18766e2
[*] bump jandelgado/gcov2lcov-action to v1.0.8 dccf63a
[*] bump pashagolub/pgxmock to 1.4.0 c7f5322
[*] bump spf13/viper to 1.9.0 990601b
[*] provide more informative message for cancelled connection ca64b99
[*] use goreleaser/goreleaser-action@v2 instead of master 993f94b
[+] add --timeout connection option with default value of 90 seconds 7806cb9
[+] add move_task_up() and move_task_down() functions, closes #314 a113894
[+] add function to delete task from the chain, closes #316 57798da
[+] append SQL function timetable.delete_job to delete chain and its tasks a297aa1
[+] create codeql-analysis.yml 04e7588
[+] increase go-version in the Build action 1a420a0
[+] increase go-version in the Release action 4a4c106
[+] update config example with timeout option 22c8e80
[+] update readme.rst with --timeout description 2f69950
[-] add missing migrations for some added functions, fixes #329 e55987e
[-] fix cron rule typo 8240b5d
[-] fix initial schema for tests bbeffaa
[-] fix logging to the database being stopped after several minutes, closes #327 7806cb9
[-] fix using env variable $PGTT_CLIENTNAME as --clientname 0288f10
[-] update manual for SendMail task, fixes #313 04ee108

New Contributors 🙏

• @bruce-one made their first contribution in #321
• @ukolovda made their first contribution in #324

Full Changelog: v4.1.0...v4.2.0