version: '3.1'
volumes:
  bundle:
    driver: local
services:
  db: &db
    image: postgres:9.5-alpine
    environment:
      - POSTGRES_USER=dev
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=dev
    #volumes:
      #- ./postgres:/var/lib/postgresql/data
      #- /usr/share/zoneinfo:/usr/share/zoneinfo
  dbtest:
    <<: *db

  dev: &dev
    image: chgu82837/rails-ready-ruby
    ports:
      - '3000:3000'
    volumes:
      - .:/usr/src/app
      - bundle:/usr/local/bundle
    depends_on:
      - db
    environment:
      - DB_HOST=db
      - DATABASE_URL=postgres://dev:password@db/dev
      - RAILS_ENV=development
    working_dir: /usr/src/app
    command:
      - 'sh'
      - '-c'
      - 'bundle; rails s -b 0.0.0.0'
  test:
    <<: *dev
    depends_on: [dbtest]
    environment:
      - DB_HOST=dbtest
      - DATABASE_URL=postgres://dev:password@dbtest/dev
      - RAILS_ENV=test
    command:
      - bundle
      - exec
      - rspec
  sql: &db_client
    image: postgres:9.5-alpine
    depends_on:
      - db
    working_dir: /tmp
    volumes:
      - .:/tmp
    environment: &db_connection
      - PGHOST=db
      - PGUSER=dev
      - PGPASSWORD=password
      - PGDATABASE=dev
      - PAGER='less'
    entrypoint: ["psql", "-f"]
    command: []
  dump:
    <<: *db_client
    volumes:
      - ./postgres/:/tmp
    entrypoint: []
    command: bash -c "pg_dump -Fc > /tmp/$$(date +%Y%m%d%H%M%S).gz"
  restore:
    <<: *db_client
    entrypoint: ["pg_restore", "-d", "dev"]
    command: []
  pgcli:
    image: pygmy/pgcli
    depends_on:
      - db
    environment: *db_connection
    entrypoint: ['sh', '-c']
    command: ['pgcli postgres://$$PGUSER:$$PGPASSWORD@$$PGHOST/$$PGDATABASE']