deploy_inital_wdchat_postgresql.yml

----
- hosts: all
  become: true
  tasks:
    - name: 1 Create Database WDCHAT & WDAUTHEN & USER
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=postgres -f /tmp/configuration/1_Create.User.sql
        responses:
            Password for user postgres: 'password'
    - name: 2 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/2_Create.WDCHAT.Table.sql
        responses:
            Password for user postgres: 'BBRyAPNh6g4H9qte'
    - name: 3 Initial WDCHAT
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/3_Initial.WDCHAT.sql
        responses:
            Password for user postgres: 'BBRyAPNh6g4H9qte'
    - name: 4 Update WDCHAT SysConfig
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/4_Update.WDCHAT.SysConfig.sql
        responses:
            Password for user postgres: 'BBRyAPNh6g4H9qte'
            
    - name: 5 Create WDAUTHEN Table 
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/5_Create.WDAUTHEN.Table.sql
        responses:
            Password for user postgres: 'BBEcLWu5Cdzy3aeH'

    - name: 6 Initial WDAUTHEN 
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/6_Initial.WDAUTHEN.sql
        responses:
            Password for user postgres: 'BBEcLWu5Cdzy3aeH'