Skip to content

Add postgres to the Travis CI build#558

Merged
javornikolov merged 3 commits intomasterfrom
topic/add-postgres-to-travis-ci
Mar 18, 2017
Merged

Add postgres to the Travis CI build#558
javornikolov merged 3 commits intomasterfrom
topic/add-postgres-to-travis-ci

Conversation

@javornikolov
Copy link
Copy Markdown
Contributor

@javornikolov javornikolov commented Mar 18, 2017

Add postgresql to the Travis CI environment and include postgres integration tests to the Travis build.

@javornikolov javornikolov added this to the Next milestone Mar 18, 2017
@javornikolov javornikolov force-pushed the topic/add-postgres-to-travis-ci branch 2 times, most recently from 8fef786 to 1b0b7e0 Compare March 18, 2017 14:31
build.gradle Outdated
fastbuild,
':dbfit-java:db2:integrationTest',
':dbfit-java:mysql:integrationTest',
':dbfit-java:postgres:integrationTest',
Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Any particular reason for running before Oracle?

Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Not really a great reason. I'll change the order.

@MMatten
Copy link
Copy Markdown
Contributor

MMatten commented Mar 18, 2017

Looks good. Can we merge this before getting the tests passing though?

@javornikolov javornikolov force-pushed the topic/add-postgres-to-travis-ci branch from 1b0b7e0 to c392aff Compare March 18, 2017 15:14
@javornikolov
Copy link
Copy Markdown
Contributor Author

Looks good. Can we merge this before getting the tests passing though?

Good that you asked since I already got wondering about how to fix the tests. However I already have enough confidence that this PR is working fine (it fires up the postgresql tests) - perhaps no reason to wait further. What do you think?

@@ -0,0 +1,8 @@
CREATE TABLE IF NOT EXISTS changelog (
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Perhaps that script can be reused from the postgres Chef recipe to avoid duplication.

@MMatten
Copy link
Copy Markdown
Contributor

MMatten commented Mar 18, 2017 via email

Extract posgresql test-schema objects setup into a separate sql script
in order to be able to reuse it outside the chef recipe
@javornikolov javornikolov force-pushed the topic/add-postgres-to-travis-ci branch from e50796d to c5ece27 Compare March 18, 2017 16:04
@javornikolov
Copy link
Copy Markdown
Contributor Author

I just did some refactoring and force pushed-it - to keep the schema objects setup in a single place ( 0f26a09)

@MMatten
Copy link
Copy Markdown
Contributor

MMatten commented Mar 18, 2017

As we've recently done for DB2 and Oracle, should we move other files from dbfit/dbfit-java/postgres/src/integration-test/resources/ to under test_vm? One issue I've noticed with this is when running gradlew eclipse the projects include entries in the build paths that don't exist. It's another issue though. Perhaps we can leave an empty directory instead.

@javornikolov
Copy link
Copy Markdown
Contributor Author

resources are embedded in the jar files and is something which can be used at runtime. In general it seems cleaner to me to keep the scripts outside jars, yet it might be maybe relevant for the databases where we're using dbdeploy.
So I'm not quite sure about a universal guideline. We may keep reorganizing these on demand.

@javornikolov
Copy link
Copy Markdown
Contributor Author

javornikolov commented Mar 18, 2017

Here b76b7cc I committed an experiment with gradle --continue option. We may move it to another PR if we'd like to keep it. The intent is to see that other integration tests are green even in case of postgres failure here.

I'm not quite sure if that feature is already done (https://discuss.gradle.org/t/new-feature-continue-execution-on-task-failure/7604) since I thing it doesn't have effect on our project.

@MMatten
Copy link
Copy Markdown
Contributor

MMatten commented Mar 18, 2017 via email

@javornikolov javornikolov force-pushed the topic/add-postgres-to-travis-ci branch from b76b7cc to c5ece27 Compare March 18, 2017 17:19
@javornikolov javornikolov merged commit de14e60 into master Mar 18, 2017
@javornikolov javornikolov deleted the topic/add-postgres-to-travis-ci branch March 18, 2017 17:21
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants