NitorCreations / nflow

88%

master: 83%

LAST BUILD ON BRANCH postgresql-wf-update2

branch: postgresql-wf-update2

CHANGE BRANCH

x

Reset

• postgresql-wf-update2
• 2.0.0
• 3.0.0
• 3.1.0
• 3.1.1
• 3.2.0
• 3.3.0
• 3.3.1-h2-fix
• 4.0.0
• 4.1.0
• 4.2.0
• 4.2.1-SNAPSHOT
• 5.0.0
• 5.0.1
• 5.2.0
• 5.2.0-SNAPSHOT
• 5.3.0
• abstract-workflow-definition
• action-description
• actions
• actions-executor-id
• adal
• add-application-listener-to-netty
• add-health-checks
• add-if-exists-to-postgresql-create-scriptl
• add-java-package-descriptions
• add-option-to-disable-batch-updates
• add-priority-to-workflow
• add-workflows
• allow-non-final-error-states
• allow-void
• archive-type-filter
• archiving
• archiving-rewrite
• archiving2
• autocommit
• bulk-workflow
• bump-spring-and-netty-versions
• busy-loop-next-activation
• camel-case-beans
• changelog-5.0.0-improvements
• check-autocommit-on-startup
• check-stop-state-type
• check-transaction-manager
• component-scan-demo-workflow
• configurable-await-termination
• configurable-cors
• constant-named-beans
• cors-config
• cors-headers
• cors-headers-jersey
• coveralls-plugin-3
• create-instance-for-demo
• create-workflow-fix
• cron
• cron-disabled
• cron-wait
• cron-workflow
• custom-ui-content
• customizable-instance-result-columns
• db-created-stacktrace
• db-properties
• db2
• db2-tzissue
• ddl-improvements
• default-next-activation
• default-prio
• definition-digest
• definition-digest2
• demo
• deny-duplicate-failure-state
• dependabot/maven/com.fasterxml.jackson.core-jackson-databind-2.9.10.1
• dependabot/maven/com.h2database-h2-2.0.206
• dependabot/maven/io.projectreactor.netty-reactor-netty-0.8.12.RELEASE
• dependabot/maven/jetty.version-9.4.31.v20200723
• dependabot/maven/jetty.version-9.4.35.v20201120
• dependabot/maven/junit-junit-4.13.1
• dependabot/npm_and_yarn/nflow-explorer/bl-1.2.3
• dependabot/npm_and_yarn/nflow-explorer/fstream-1.0.12
• dependabot/npm_and_yarn/nflow-explorer/grunt-1.3.0
• dependabot/npm_and_yarn/nflow-explorer/http-proxy-1.18.1
• dependabot/npm_and_yarn/nflow-explorer/ini-1.3.7
• dependabot/npm_and_yarn/nflow-explorer/is-svg-4.3.1
• dependabot/npm_and_yarn/nflow-explorer/jszip-3.7.1
• dependabot/npm_and_yarn/nflow-explorer/lodash-4.17.19
• dependabot/npm_and_yarn/nflow-explorer/lodash-4.17.21
• dependabot/npm_and_yarn/nflow-explorer/socket.io-2.4.1
• dependabot/npm_and_yarn/nflow-explorer/tar-2.2.2
• dependabot/npm_and_yarn/nflow-explorer/urijs-1.19.5
• dependabot/npm_and_yarn/nflow-explorer/urijs-1.19.6
• dependabot/npm_and_yarn/nflow-explorer/websocket-extensions-0.1.4
• dependency-updates
• deprecate-get-name
• deprecated
• deps-updates
• detect-concurrent-update
• disallow-overloaded-state-methods
• dispatcher-cleanup
• dispatcher-logging
• distinct
• do-not-deploy-tests
• doc-updates
• docs
• documentation/update-screenshots
• drop-runtime-swagger
• dynamic-workflow-definition
• dynamic_state_text_length
• dynamic_state_text_length2
• eclipse-process-resources
• embed-nflow-viz
• embededd-postgresql-for-testing
• error-states-must-be-final
• examples
• exception-mapping
• exclude-dummyworkflow
• executing-status
• execution-start
• executor-dao-prepared-statement
• executor-group-filter
• executor-group-unique
• executor-host-field
• executor-listener
• executor-listener-chain
• executor-page-timestamp
• executor-recovery-test
• executor-recovery-test-new
• executor-stopped
• executorid-to-metrics-key
• explicit-max-lengths
• explorer
• explorer-improved-tables
• explorer-lib-updates
• explorer-return-url
• exponential-retry-delay
• extend-lib
• external-configuration
• external-id-in-list-workflows
• external-location-config
• external_activation
• faster-shutdown
• fb-fixes
• feature/re
• findbugs-contrib
• fix-0.3.0-issues
• fix-1-minute-guide
• fix-action-history-delete
• fix-apidocs-redirect-release.sh
• fix-binary-backoff-delay
• fix-blocking-webflux
• fix-database-connection-before-start
• fix-eclipse-warnings
• fix-explorer-vulnerability-warnings
• fix-graceful-shutdown
• fix-history-cleanup-issues
• fix-jetty-deps
• fix-keep-current-state
• fix-lifecycle-restart
• fix-minor-graph-issues
• fix-mysql-migration-570
• fix-nflow-explorer-bugs
• fix-oracle-sql
• fix-quickstart-dependency
• fix-recovery
• fix-requestparam-required
• fix-sql-select-before-nflow-start
• fix-svg-pan-zoom
• fix-swagger-urls
• fix-transactions
• fix-unstable-unit-test
• fix-warnings
• fix-webflux-error-handling
• fix_definitions_init_too_late
• get-instance
• get-parent
• get-state-variable
• get-variable-fix
• graceful-shutdown
• guice-module
• guice-nflow-710
• h2-rollback
• h2-update
• handle-unknown-state
• handle-wakeup-failure
• history-cleanup-fix
• honor-include-statevars
• hybris-compatibility
• hybris-compatibility-fix
• illegal-state-change
• improve-logging
• improve-recovery-test
• improve-statistics
• improve-statistics-tests
• improve-test-coverage
• improve-tests
• improved-cors-config
• improved-polling
• index-improvements
• indices
• infinite-state-processing-retry
• inject-improvements
• injection
• instance-created
• instance-start
• instance-start-time
• instance-state-save-retry
• invalid-state-update
• issue-212
• issue-217
• issue-306
• java11
• java8-time-api
• java9-support
• java9and10
• javadoc
• jersey-compatible-rest-api
• jodatime-current-millis
• junit5
• junit5-nflow-tests
• kotlin-example
• kotlin-workflow-support
• let-override-properties-override-everything
• lib-update
• lib-updates
• library-updates
• log-context
• log-create-db
• log-level-tuning
• log-stuck-threads
• logback-update
• logger
• long_ids
• mariadb
• mariadb-docker
• master
• materialized-workflow-definitions
• maven-coveralls-plugin
• max-actions
• max-results
• minor-explorer-tuning
• minor-version-bump
• model-object
• move-exception-mappers
• mssql
• multiple-start-states
• mysql-5.7
• netty-add-override-port
• netty-explorer
• new-engine-model
• nflow-0.3.0
• nflow-1.0.0
• nflow-1.1.0
• nflow-annotated-beans
• nflow-engine-starter
• nflow-root-0.3.1
• nflow-spring-boot-examples
• no-mariadb-for-mysql
• nodejs-bump
• non-retryable-errors
• obey-max-retry
• optional-history-cleanup
• optional-state-var
• oracle-batch-update
• oracle-support
• parallel-build
• parametrize-access-log
• partial-poll
• pause-and-resume
• pause-and-unpause-to-workflow-lifecycle
• perf
• perf-improvements
• perf-test
• perf-test-ansible
• perf-test-once-more
• perf-test-pr
• period
• persist-instance-query-to-url
• polling-queue-tuning
• postgres94
• postgresql-poll
• postgresql-wf-update
• potential-resource-leaks
• prepare-2.0.0
• process-error-maxretry
• profiles
• psql-driver
• query-archived
• queue-stats
• queue-stats-new
• readme-updates
• recovery-action
• reduce-lagging-logging
• refactor-recovery
• reflections-downgrade
• registerHikariPoolToMetricRegistry
• release-3.0.0-preparation
• remove-action-type-defaults
• remove-archiving-index
• remove-autoinit
• remove-deprecated
• remove-invalid-statistics
• remove-invalid-upgrade-comments
• remove-nflow-workflow-action-type-default
• remove-pause-and-stop
• remove-property-defaults
• rename-owner
• rename-packages
• rename-workflow-id
• reorganize-engine-configuration-packages
• replace-ncsarequestlog
• rest-api-context
• rest-api-wakeup
• rest-state-vars
• rest-version-v1
• rest-workflow-executors
• rest-workflow-status-fix
• retryable-logging
• retryable-logging-v2
• retryable-logging-v3
• return-newest-instances
• search-statevar
• set-active-and-expires
• set-datasource-transactionmanager
• set-next-state
• signal
• simple-executor-listener-chain
• skip-javadoc-on-some-packages
• skip-locked
• skip-nflow-tests-coverage
• skipDefinitionPersisting
• small-usability-improvements
• spring-5-1-4-upgrade
• spring-5.1.0
• spring-boot
• spring-boot-2
• state-executions
• state-refactor
• state-text-null
• state-value-len
• state-var-len-rest
• state-variable-boxed-primitive
• statevar-rest-fix
• stats-rest
• status-criteria
• stop-workflow
• stop-workflow2
• stop-workflow3
• stream-query-results
• stuck-handler
• sub-workflows
• support-save-trace
• swagger-2
• swagger-feature
• swagger-java-packages
• swagger2markup
• swaggerui-cleanup
• test-merge-nflow-explorer
• test-spring-workflow-definitions
• travis-container
• travis-jdk11
• travis-new-infra
• travis-openjdk10
• travis-remove-jdk10
• travis-xenial
• tune-exception-analyzer-method-visibility
• tune-explorer-zoom
• tune-periodic-logger
• tune-polling
• tune-sql
• ui-notifications
• update-batch
• update-business-key
• update-business-key-from-state
• update-configuration
• update-configuration2
• update-deps
• update-deps2
• update-deps3
• update-deps4
• update-explorer
• update-jetty
• update-nflow-explorer
• update-readme-md
• update-spring-boot-java-examples
• update-state
• update-state-text
• update-workflow-message
• upgrade-spring-5-1-3
• upgrade-to-spring-5.1.2
• use-official-maven-mirror
• v1.2.0
• v1.3.0
• version-bump
• version-bump-5-5-1
• version-updates
• wake-dispatcher
• wakeup-parent-states
• workflow-action-processor
• workflow-archive-item-limit
• workflow-instance-404
• workflow-instance-action-type
• workflow-instance-action-type2
• workflow-instance-action-type4
• workflow-instance-action-type5
• workflow-instance-action-type6
• workflow-instance-fields
• workflow-instance-started
• workflow-optimistic-lock
• workflow-statistics-url
• workflow-status
• workflowid-from-stateexecution

Use updateable cte to do workflow update, action insert and new variables inserts in one statement

Conflicts:
	CHANGELOG.md
	nflow-engine/src/main/java/com/nitorcreations/nflow/engine/internal/executor/WorkflowStateProcessor.java
	nflow-engine/src/main/java/com/nitorcreations/nflow/engine/internal/storage/db/H2DatabaseConfiguration.java
	nflow-engine/src/main/java/com/nitorcreations/nflow/engine/internal/storage/db/MysqlDatabaseConfiguration.java
	nflow-engine/src/main/java/com/nitorcreations/nflow/engine/internal/storage/db/PgDatabaseConfiguration.java
	nflow-engine/src/main/java/com/nitorcreations/nflow/engine/internal/storage/db/SQLVariants.java
	nflow-engine/src/test/java/com/nitorcreations/nflow/engine/internal/executor/WorkflowStateProcessorTest.java