Gecko [ fernandoquevedodop.com ]

Name	Size	Permission
db-check.feature	3.67 KB	-rw-r--r--
db-columns.feature	3.56 KB	-rw-r--r--
db-export.feature	2.49 KB	-rw-r--r--
db-import.feature	4.9 KB	-rw-r--r--
db-prefix.feature	224 B	-rw-r--r--
db-query.feature	3.14 KB	-rw-r--r--
db-search.feature	29.69 KB	-rw-r--r--
db-size.feature	5.96 KB	-rw-r--r--
db-tables.feature	5.95 KB	-rw-r--r--
db.feature	8.63 KB	-rw-r--r--

Code Editor : db-import.feature

Feature: Import a WordPress database

Scenario: Import from database name path by default
    Given a WP install

When I run `wp db export wp_cli_test.sql`
    Then the wp_cli_test.sql file should exist

When I run `wp db import`
    Then STDOUT should be:
      """
      Success: Imported from 'wp_cli_test.sql'.
      """

Scenario: Import from database name path by default with mysql defaults
    Given a WP install

When I run `wp db export wp_cli_test.sql`
    Then the wp_cli_test.sql file should exist

When I run `wp db import --defaults`
    Then STDOUT should be:
      """
      Success: Imported from 'wp_cli_test.sql'.
      """

Scenario: Import from database name path by default with --no-defaults
    Given a WP install

When I run `wp db export wp_cli_test.sql`
    Then the wp_cli_test.sql file should exist

When I run `wp db import --no-defaults`
    Then STDOUT should be:
      """
      Success: Imported from 'wp_cli_test.sql'.
      """

Scenario: Import from STDIN
    Given a WP install

When I run `wp db import -`
    Then STDOUT should be:
      """
      Success: Imported from 'STDIN'.
      """

Scenario: Import from database name path by default and skip speed optimization
    Given a WP install

When I run `wp db export wp_cli_test.sql`
    Then the wp_cli_test.sql file should exist

When I run `wp db import --skip-optimization`
    Then STDOUT should be:
      """
      Success: Imported from 'wp_cli_test.sql'.
      """

Scenario: Import from database name path by default with passed-in dbuser/dbpass
    Given a WP install

When I run `wp db export wp_cli_test.sql`
    Then the wp_cli_test.sql file should exist

When I run `wp db import --dbuser=wp_cli_test --dbpass=password1`
    Then STDOUT should be:
      """
      Success: Imported from 'wp_cli_test.sql'.
      """

When I try `wp db import --dbuser=wp_cli_test --dbpass=no_such_pass`
    Then the return code should not be 0
    And STDERR should contain:
      """
      Access denied
      """
    And STDOUT should be empty

Scenario: Import database with passed-in options
    Given a WP install
    And a debug.sql file:
      """
      INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (999, 'testoption',  'testval',  'yes'),(999, 'testoption',  'testval',  'yes');
      """

When I try `wp db import debug.sql --force`
    Then STDOUT should be:
      """
      Success: Imported from 'debug.sql'.
      """

Scenario: Help runs properly at various points of a functional WP install
    Given an empty directory

When I run `wp help db import`
    Then STDOUT should contain:
      """
      wp db import
      """

When I run `wp core download`
    Then STDOUT should not be empty
    And the wp-config-sample.php file should exist

When I run `wp help db import`
    Then STDOUT should contain:
      """
      wp db import
      """

When I run `wp core config {CORE_CONFIG_SETTINGS}`
    Then STDOUT should not be empty
    And the wp-config.php file should exist

When I run `wp help db import`
    Then STDOUT should contain:
      """
      wp db import
      """

When I run `wp db create`
    Then STDOUT should not be empty

When I run `wp help db import`
    Then STDOUT should contain:
      """
      wp db import
      """
  Scenario: MySQL defaults are available as appropriate with --defaults flag
    Given a WP install

When I run `wp db export wp_cli_test.sql`
    Then the wp_cli_test.sql file should exist

When I try `wp db import --defaults --debug`
    Then STDERR should match #Debug \(db\): Running shell command: /usr/bin/env (mysql|mariadb) --no-auto-rehash#

When I try `wp db import --debug`
    Then STDERR should match #Debug \(db\): Running shell command: /usr/bin/env (mysql|mariadb) --no-defaults --no-auto-rehash#

When I try `wp db import --no-defaults --debug`
    Then STDERR should match #Debug \(db\): Running shell command: /usr/bin/env (mysql|mariadb) --no-defaults --no-auto-rehash#

@require-wp-4.2
  Scenario: Import db that has emoji in post
    Given a WP install

When I run `wp post create --post_title="🍣"`
    And I run `wp post list`
    Then the return code should be 0
    And STDOUT should contain:
      """
      🍣
      """

When I try `wp db export wp_cli_test.sql --debug`
    Then the return code should be 0
    And the wp_cli_test.sql file should exist
    And STDERR should contain:
      """
      Detected character set of the posts table: utf8mb4
      """
    And STDERR should contain:
      """
      Setting missing default character set to utf8mb4
      """

When I run `wp db import --dbuser=wp_cli_test --dbpass=password1`
    Then STDOUT should be:
      """
      Success: Imported from 'wp_cli_test.sql'.
      """

When I run `wp post list`
    Then the return code should be 0
    And STDOUT should contain:
      """
      🍣
      """

${this.title}

Code Editor : db-import.feature