Ruby and PostgreSQL for Bitbucket Pipelines
This repository contains a Dockerfile as well as a simple example that shows how you can run your own Docker container with Ruby and PostgreSQL on Bitbucket Pipelines.
The Docker image is using Ruby 2.3.0 and PostgreSQL 9.4
Using the image with Bitbucket Pipelines
Just copy/paste the YML below in your bitbucket-pipelines.yml and adapt the script to your needs.
# This is a sample build configuration for Ruby. # Only use spaces to indent your .yml configuration. # ----- # You can specify a custom docker image from Dockerhub as your build environment. image: spittet/ruby-postgresql pipelines: default: - step: script: # Modify the commands below to build your repository. - /etc/init.d/postgresql start - sudo -u postgres sh -c 'createuser root & createdb ruby' - gem install 'pg' - ruby test.rb
Using this in a script
You'll find a sample script in this repository in test.rb. It simply connects to PostgreSQL and then lists the existing databases.
require 'pg' con = PG.connect :dbname => 'ruby', :user => 'root' puts con.server_version dbs = con.exec('SELECT datname FROM pg_database WHERE datistemplate = false;') dbs.each do |db| puts db end con.close
Create your own image
If you want to use a different version of Ruby you can simply create your own image for it. Just copy the content of the Dockerfile and replace the first line.
This image is built from the official Ruby image at https://hub.docker.com/_/ruby/ and you can find there all the different versions that are supported.
Your Dockerfile won't need to have an ENTRYPOINT or CMD line as Bitbucket Pipelines will run the script commands that you put in your bitbucket-pipelines.yml file instead.
FROM ruby:2.3.0 RUN apt-get update \ && apt-get install -y postgresql postgresql-contrib \ && apt-get install sudo \ && apt-get clean \ && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/* # This Dockerfile doesn't need to have an entrypoint and a command # as Bitbucket Pipelines will overwrite it with a bash script.
Build the image
docker build -t <your-docker-account>/ruby-postgresql .
Run the image locally with bash to make some tests
docker run -i -t <your-docker-account>/ruby-postgresql /bin/bash
Push the image back to the Docker Hub
docker push <your-docker-account>/ruby-postgresql
I was wondering how to create an image with Postgresql 9.5
apt-get install -y postgresql-9.5 postgresql-contrib-9.5 doesn't work as I get package not found.
And I have not found a way (within your Dockerfile template) to add extra repos to apt-get