Skip to content

ansible / dma-playbook

Go to a project
Switch branch/tag
initial_data_dma.yml 858 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 
- 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'