On 10/09/2016 8:42pm, Stefan Seelmann wrote: > On 09/10/2016 03:52 AM, Aristedes Maniatis wrote: >> On 5/08/2016 10:51am, Aristedes Maniatis wrote: >>> Apache Cayenne runs tests against a couple of in-memory databases under >>> Jenkins: >>> >>> https://builds.apache.org/job/cayenne-master >>> >>> >>> I'd like to set up tests against other common databases since database >>> integration tests are absolutely critical to the Cayenne project. At the >>> very least MS-SQL, mysql, mariadb and postgresql would be lovely. Even more >>> would be better... >>> >>> Do we already have this sort of infrastructure available to us? >>> >> >> >> Is there any database infrastructure available for Jenkins builds? > > At least for the open source databases (mysql, mariadb, postgres) you > can consider to use Docker, there already exists "official" Docker images. > > In your Jenkins job you can start e.g. a Postgres Docker container > before the main build and stop/remove it after the build. > > Or, as Cayenne uses a Maven build: I made good experience with [1], > that's a Maven plugin that starts a Docker container in > pre-integration-test phase and stops it in post-integration-test phase. > > Kind Regards, > Stefan > > [1] https://dmp.fabric8.io/ >
Thanks Stefan, I'll give it a go. Do you know of any projects running on Jenkins I can look at that do something similar? I've actually never used docker and maven drives me up the wall (but not yet quite enough to put the effort into migrating Cayenne to gradle). So a bit of copy and paste would help. I am assuming I'll want to pull the Docker images from somewhere on local Apache infrastructure rather than downloading them from the internet for every build? Ari -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
