initial_data_wdchat.yml

- name: Create WDCHAT Table
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/1_Create.WDCHAT.Table.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'
         
- name: Initial WDCHAT DB
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/2_Initial.WDCHAT.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'
            
- name: Create WDAUTHEN Tables
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/3_Create.WDAUTHEN.Table.sql
        responses:
            'Password for user wdauthen': 'BBEcLWu5Cdzy3aeH'
            
- name: Initial WDAUTHEN DB 
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/4_Initial.WDAUTHEN.sql
        responses:
            'Password for user wdauthen': 'BBEcLWu5Cdzy3aeH'