Current path: home/webdevt/www/wdp/wp-content/plugins/wdp-facture-groupe/vendor/wp-cli/db-command/features/
?? Go up: /home/webdevt/www/wdp/wp-content/plugins/wdp-facture-groupe/vendor/wp-cli/db-command
Feature: Query the database with WordPress' MySQL config
Scenario: Database querying shouldn't load any plugins
Given a WP install
And a wp-content/mu-plugins/error.php file:
"""
<?php
WP_CLI::error( "Plugin loaded." );
"""
When I try `wp option get home`
Then STDERR should be:
"""
Error: Plugin loaded.
"""
When I run `wp db query "SELECT COUNT(ID) FROM wp_users;"`
Then STDOUT should be:
"""
COUNT(ID)
1
"""
Scenario: Database querying with passed-in options
Given a WP install
When I run `wp db query "SELECT COUNT(ID) FROM wp_posts;" --dbuser=wp_cli_test --html`
Then STDOUT should contain:
"""
<TABLE
"""
When I try `wp db query "SELECT COUNT(ID) FROM wp_posts;" --dbuser=no_such_user`
Then the return code should not be 0
And STDERR should contain:
"""
Access denied
"""
And STDOUT should be empty
Scenario: Database querying with MySQL defaults and passed-in options
Given a WP install
When I run `wp db query --defaults "SELECT COUNT(ID) FROM wp_posts;" --dbuser=wp_cli_test --html`
Then STDOUT should contain:
"""
<TABLE
"""
When I try `wp db query --defaults "SELECT COUNT(ID) FROM wp_posts;" --dbuser=no_such_user`
Then the return code should not be 0
And STDERR should contain:
"""
Access denied
"""
And STDOUT should be empty
Scenario: Database querying with --nodefaults and passed-in options
Given a WP install
When I run `wp db query --no-defaults "SELECT COUNT(ID) FROM wp_posts;" --dbuser=wp_cli_test --html`
Then STDOUT should contain:
"""
<TABLE
"""
When I try `wp db query --no-defaults "SELECT COUNT(ID) FROM wp_posts;" --dbuser=no_such_user`
Then the return code should not be 0
And STDERR should contain:
"""
Access denied
"""
And STDOUT should be empty
Scenario: MySQL defaults are available as appropriate with --defaults flag
Given a WP install
When I try `wp db query --defaults --debug`
Then STDERR should contain:
"""
Debug (db): Running shell command: /usr/bin/env mysql --no-auto-rehash
"""
When I try `wp db query --debug`
Then STDERR should contain:
"""
Debug (db): Running shell command: /usr/bin/env mysql --no-defaults --no-auto-rehash
"""
When I try `wp db query --no-defaults --debug`
Then STDERR should contain:
"""
Debug (db): Running shell command: /usr/bin/env mysql --no-defaults --no-auto-rehash
"""
Scenario: SQL modes do not include any of the modes incompatible with WordPress
Given a WP install
When I try `wp db query 'SELECT @@SESSION.sql_mode;' --debug`
Then STDOUT should not contain:
"""
NO_ZERO_DATE
"""
And STDOUT should not contain:
"""
ONLY_FULL_GROUP_BY
"""
And STDOUT should not contain:
"""
STRICT_TRANS_TABLES
"""
And STDOUT should not contain:
"""
STRICT_ALL_TABLES
"""
And STDOUT should not contain:
"""
TRADITIONAL
"""
And STDOUT should not contain:
"""
ANSI
"""