- name: Create sqlrelay directory
  file:
    path: "{{ DEVORCH_BASE_PATH }}/{{ DEVORCH_HOME_DIR }}/sqlrelay"
    state: directory

- name: Generate sqlrelay config from template
  template:
    src: "{{ playbook_dir }}/templates/sqlrelay/sqlrelay_snowflake.conf.j2"
    dest: "{{ DEVORCH_BASE_PATH }}/{{ DEVORCH_HOME_DIR }}/sqlrelay/sqlrelay_snowflake.conf"

- name: Generate odbc.ini from template
  template:
    src: "{{ playbook_dir }}/templates/sqlrelay/odbc.ini.j2"
    dest: "{{ DEVORCH_BASE_PATH }}/{{ DEVORCH_HOME_DIR }}/sqlrelay/odbc.ini"

- name: Generate odbcinst.ini from template
  template:
    src: "{{ playbook_dir }}/templates/sqlrelay/odbcinst.ini.j2"
    dest: "{{ DEVORCH_BASE_PATH }}/{{ DEVORCH_HOME_DIR }}/sqlrelay/odbcinst.ini"

- name: Copy private key
  copy:
    src: "{{ SNOWFLAKE_PRIVATE_KEY_PATH }}"
    dest: "{{ DEVORCH_BASE_PATH }}/{{ DEVORCH_HOME_DIR }}/sqlrelay/snowflake.p8"