---
# file: roles/quartz_scheduler/tasks/main.yml

- name: Create the Postgresql Database
  postgresql_db: name={{ db_name }}
                 encoding='UTF-8'
  become_user: postgres

- name: create password file on vagrant box
  become: true
  become_user: postgres
  lineinfile:
    dest: ~/.pgpass
    state: present
    create: yes
    line: "{{ item }}"
    mode: 0600
  with_items:
      - "#hostname:port:database:username:password"
      - "localhost:5432:{{ db_name }}:{{ db_user }}:{{ db_user_pw }}"

- name: Copy Quartz Table Creation Script
  become: true
  become_user: postgres
  copy: src=../files/quartz_tables_postgres.sql
        dest=~
        owner=postgres
        group=postgres
        mode=0775

- name: Creating Quartz Tables
  become: true
  become_user: postgres
  command: "psql -U vagrant -w -f {{ item }} -d {{ db_name }}"
  with_items: 
   - ~/quartz_tables_postgres.sql