106 lines
2.8 KiB
YAML
106 lines
2.8 KiB
YAML
# DI Portal Common database
|
|
- name: run dip migrations
|
|
shell: 'php /var/www/mtinfo3000/dip/scripts/migrate.php'
|
|
become: true
|
|
become_user: "{{ php_fpm_pool_user }}"
|
|
|
|
# Time Registration database
|
|
- name: run tr migrations
|
|
shell: 'php /var/www/mtinfo3000/tr/scripts/migrate.php'
|
|
become: true
|
|
become_user: "{{ php_fpm_pool_user }}"
|
|
|
|
# Ticket System database
|
|
- shell: mysql -h '{{ db_host }}' -u '{{ db_ts_user_migrate }}' -p'{{ db_ts_pass_migrate }}' '{{ db_ts_name }}' -e 'show tables;' | grep ticket
|
|
register: dbstatus
|
|
ignore_errors: yes
|
|
|
|
- copy:
|
|
src: "ticket_system.sql"
|
|
dest: "/tmp/ticket_system.sql"
|
|
force: no
|
|
- mysql_db:
|
|
login_host: '{{ db_host }}'
|
|
login_password: '{{ db_ts_pass_migrate }}'
|
|
login_user: '{{ db_ts_user_migrate }}'
|
|
name: '{{ db_ts_name }}'
|
|
state: import
|
|
target: /tmp/ticket_system.sql
|
|
when: dbstatus.rc != 0
|
|
|
|
# Action Point Tool database
|
|
- shell: mysql -h '{{ db_host }}' -u '{{ db_apt_user_migrate }}' -p'{{ db_apt_pass_migrate }}' '{{ db_apt_name }}' -e 'show tables;' | grep action_point
|
|
register: dbstatus
|
|
ignore_errors: yes
|
|
|
|
- copy:
|
|
src: "apt.sql"
|
|
dest: "/tmp/apt.sql"
|
|
force: no
|
|
|
|
- mysql_db:
|
|
login_host: '{{ db_host }}'
|
|
login_password: '{{ db_apt_pass_migrate }}'
|
|
login_user: '{{ db_apt_user_migrate }}'
|
|
name: '{{ db_apt_name }}'
|
|
state: import
|
|
target: /tmp/apt.sql
|
|
when: dbstatus.rc != 0
|
|
|
|
- name: run apt migrations
|
|
shell: 'php /var/www/mtinfo3000/apt/scripts/migrate.php'
|
|
become: true
|
|
become_user: "{{ php_fpm_pool_user }}"
|
|
|
|
# BuDget Tool database
|
|
- shell: mysql -h '{{ db_host }}' -u '{{ db_bdg_user_migrate }}' -p'{{ db_bdg_pass_migrate }}' '{{ db_bdg_name }}' -e 'show tables;' | grep article
|
|
register: dbstatus
|
|
ignore_errors: yes
|
|
|
|
- copy:
|
|
src: "bdg_data.sql"
|
|
dest: "/tmp/bdg_data.sql"
|
|
force: no
|
|
|
|
- copy:
|
|
src: "bdg_structure.sql"
|
|
dest: "/tmp/bdg_structure.sql"
|
|
force: no
|
|
|
|
- mysql_db:
|
|
login_host: '{{ db_host }}'
|
|
login_password: '{{ db_bdg_pass_migrate }}'
|
|
login_user: '{{ db_bdg_user_migrate }}'
|
|
name: '{{ db_bdg_name }}'
|
|
state: import
|
|
target: "/tmp/bdg_structure.sql"
|
|
when: dbstatus.rc != 0
|
|
|
|
- mysql_db:
|
|
login_host: '{{ db_host }}'
|
|
login_password: '{{ db_bdg_pass_migrate }}'
|
|
login_user: '{{ db_bdg_user_migrate }}'
|
|
name: '{{ db_bdg_name }}'
|
|
state: import
|
|
target: "/tmp/bdg_data.sql"
|
|
when: dbstatus.rc != 0
|
|
|
|
# Wiki database
|
|
- shell: mysql -h '{{ db_host }}' -u '{{ db_wiki_user }}' -p'{{ db_wiki_pass }}' '{{ db_wiki_name }}' -e 'show tables;' | grep user
|
|
register: dbstatus
|
|
ignore_errors: yes
|
|
|
|
- copy:
|
|
src: "wiki.sql"
|
|
dest: "/tmp/wiki.sql"
|
|
force: no
|
|
|
|
- mysql_db:
|
|
login_host: '{{ db_host }}'
|
|
login_password: '{{ db_wiki_pass }}'
|
|
login_user: '{{ db_wiki_user }}'
|
|
name: '{{ db_wiki_name }}'
|
|
state: import
|
|
target: "/tmp/wiki.sql"
|
|
when: dbstatus.rc != 0
|