handbook

handbook copied to clipboard

Problem

• The SHELL_PIPE env variable does not work for the db command.

Proposed solution

1. Clarify docs for how to retain ASCII table formatting with the db command.
2. Clarify docs for how to use the env variable, because not all users understand how env variables are specified; the only correct example I found was in the original issue https://github.com/wp-cli/wp-cli/issues/1102.

I have found that SHELL_PIPE is also ignored when using a command such as wp @production db size --human-readable --all-tables

Thanks for the PR, @sun ! I'll move them over to the generated docs now.

@danielbachhuber :

Although, do you think we should fix wp db query's behavior instead, and make sure the SHELL_PIPE variable is passed through?

The mysql command does not understand that, and the provided work-around is not a full replacement.