initial_data_dma.yml

- name: Create Database WDCHAT DB & USER
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=postgres -f /tmp/configuration/0_Create.User.sql
        responses:
            'Password for user postgres': 'password'
    
- name: Create Tables in WDCHAT DB
      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: Create DMA Tables in WDCHAT DB
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/Create.DMA.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'