deploy_inital_wdchat_postgresql_3041.yml

---
- hosts: deployed-wdchat-dma, deploy-wdchat-dma-single-host
  become: true
  tasks:
    
    - name: Patch WDCHAT 3.0.4.1_01
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/pf_3041_01_create_seq_dma_message_id_seq.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'
    
    - name: Patch WDCHAT 3.0.4.1_02
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/pf_3041_02_create_seq_dma_message_user_rel_id_seq.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'

    - name: Patch WDCHAT 3.0.4.1_03
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/pf_3041_03_create_table_dma_message.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'
            
    - name: Patch WDCHAT 3.0.4.1_04
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/pf_3041_04_create_table_dma_message_user_rel.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'
            
# update