deploy/deploy_db.yml
author ymh <ymh.work@gmail.com>
Fri, 14 Jun 2019 14:36:17 +0200
changeset 14 30f2ac9a7656
child 20 36bdc6e0deb1
permissions -rw-r--r--
Add command to deploy batabase
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
14
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     1
# vendor/bin/wp option delete _site_transient_update_themes
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     2
# vendor/bin/wp option delete _site_transient_theme_roots
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     3
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     4
- hosts: remote
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     5
  vars:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     6
    src_dir: "{{playbook_dir}}/build/tmp/rc/src/"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     7
  tasks:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     8
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     9
    - name: create temporary file
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    10
      tempfile:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    11
        state: file
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    12
        suffix: sql
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    13
      register: sql_tmp_path
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    14
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    15
    - name: transfer sql file
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    16
      copy:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    17
        src: "{{db_file_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    18
        dest: "{{sql_tmp_path.path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    19
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    20
    - name: load database
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    21
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    22
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    23
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    24
          - db
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    25
          - import
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    26
          - "{{sql_tmp_path.path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    27
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    28
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    29
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    30
    - name: delete temporary file
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    31
      file:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    32
        path: "{{sql_tmp_path.path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    33
        state: absent
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    34
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    35
    - name: search and replace url
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    36
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    37
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    38
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    39
          - search-replace
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    40
          - "{{origin_url}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    41
          - "{{rc_wp_home}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    42
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    43
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    44
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    45
    - name: set template_root
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    46
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    47
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    48
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    49
          - option
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    50
          - set
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    51
          - template_root
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    52
          - "{{remote_path}}/web/wp/wp-content/themes"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    53
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    54
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    55
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    56
    - name: delete _site_transient_update_themes option
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    57
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    58
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    59
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    60
          - option
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    61
          - delete
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    62
          - _site_transient_update_themes
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    63
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    64
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    65
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    66
    - name: delete _site_transient_theme_roots option
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    67
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    68
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    69
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    70
          - option
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    71
          - delete
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    72
          - _site_transient_theme_roots
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    73
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    74
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    75
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    76
    - name: update admin password
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    77
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    78
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    79
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    80
          - user
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    81
          - update
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    82
          - "{{rc_admin_user_id}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    83
          - "--user_pass={{rc_admin_user_pswd}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    84
          - --skip-email
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    85
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    86
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    87
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    88
    - name: flush cache
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    89
      command:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    90
        argv:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    91
          - "{{remote_path}}/vendor/bin/wp"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    92
          - cache
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    93
          - flush
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    94
      args:
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    95
        chdir: "{{remote_path}}"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    96