db-command/features/db-status.feature at dc552dd75ba38eb465782b130d79ad8b1097760f · wp-cli/db-command · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
Feature: Display database status overview

  Scenario: Display database status for a WordPress install
    Given a WP install

    When I run `wp db status`
    Then STDOUT should contain:
      """
      Database Name:     wp_cli_test
      """
    And STDOUT should match /^Tables:\s+\d+$/m
    And STDOUT should match /^Total Size:\s+[\d.]+ \wB$/m
    And STDOUT should contain:
      """
      Prefix:            wp_
      """
    And STDOUT should match /^Engine:\s+\w+$/m
    And STDOUT should match /^Charset:\s+\w+$/m
    And STDOUT should match /^Collation:\s+\w+$/m
    And STDOUT should contain:
      """
      Check Status:      OK
      """

  Scenario: Run db status with MySQL defaults to check the database
    Given a WP install

    When I run `wp db status --defaults`
    Then STDOUT should contain:
      """
      Database Name:
      """
    And STDOUT should contain:
      """
      Check Status:      OK
      """

  Scenario: Run db status with --no-defaults to check the database
    Given a WP install

    When I run `wp db status --no-defaults`
    Then STDOUT should contain:
      """
      Database Name:
      """
    And STDOUT should contain:
      """
      Check Status:      OK
      """

  Scenario: Run db status with passed-in options
    Given a WP install

    When I run `wp db status --dbuser=wp_cli_test`
    Then STDOUT should contain:
      """
      Database Name:
      """
    And STDOUT should contain:
      """
      Check Status:      OK
      """

    When I run `wp db status --dbpass=password1`
    Then STDOUT should contain:
      """
      Database Name:
      """
    And STDOUT should contain:
      """
      Check Status:      OK
      """

    When I run `wp db status --dbuser=wp_cli_test --dbpass=password1`
    Then STDOUT should contain:
      """
      Database Name:
      """
    And STDOUT should contain:
      """
      Check Status:      OK
      """

    When I try `wp db status --dbuser=no_such_user`
    Then the return code should not be 0

    When I try `wp db status --dbpass=no_such_pass`
    Then the return code should not be 0