Tools for Handling WordPress Database by Docker and WP-CLI.
npm install wpdbTools for Handling WordPress Database by Docker and WP-CLI.



You must install Docker for this module to work.
``bash`
$ npm install wpdb --save
``
Options:
--version, -v show this version. [boolean]
--help, -h show this help. [boolean]
#### Initialize
Install the Docker files.
`bash`
$ wpdb
#### Start
Start Docker.
`bash`
$ docker-compose build
$ docker-compose up -d
#### Stop
Stop Docker.
`bash`
$ docker-compose down -v
#### Restart
Restart Docker (When fixed php.ini etc.).
`bash`
$ docker-compose restart
#### Reset
Reset Database.
`bash`
$ docker-compose exec wordpress wp db reset --allow-root
#### Import
Import the SQL file.
`bash`
$ docker-compose exec wordpress wp db import /var/lib/mysql/import.sql --allow-root
#### Export
Export the SQL file.
`bash`
$ docker-compose exec wordpress wp db export /var/lib/mysql/export.sql --allow-root
#### Replace
##### Import
`bash`
$ docker-compose exec wordpress wp db import /var/lib/mysql/import.sql --allow-root
$ docker-compose exec wordpress wp search-replace http://example.com http://localhost --allow-root
##### Export
`bash`
$ docker-compose exec wordpress wp db export /var/lib/mysql/export.sql --allow-root
###### Upload
`bash`
$ docker-compose exec wordpress wp search-replace http://localhost http://example.com --allow-root
$ docker-compose exec wordpress wp db export /var/lib/mysql/upload.sql --allow-root
$ docker-compose exec wordpress wp search-replace http://example.com http://localhost --allow-root
`bash`
$ docker-compose exec wordpress wp search-replace http://localhost http://example.com --export=/var/lib/mysql/upload.sql --allow-root
##### ACF Block
`bash`
$ docker-compose exec wordpress wp search-replace 'http:\/\/example.com' 'http:\/\/localhost' --allow-root
##### Change PHP Version
Please change the first line of /docker/wordpress/Dockerfile.
`Default
FROM wordpress:latest
Please refer to the link below for usable containers.
WordPress Docker Official Images
##### Docker Logs
`bash
$ docker-compose logs | grep wordpress
`##### Bash
`bash
$ docker-compose exec wordpress /bin/bash
`##### Composer
`bash
$ docker-compose exec wordpress composer -v
`##### PHP CodeSniffer
`bash
$ docker-compose exec wordpress ./vendor/bin/phpcs --standard=PSR2 ./wp-content/themes/my-theme/
`##### PHP CS Fixer
`bash
$ docker-compose exec wordpress ./vendor/bin/php-cs-fixer fix --dry-run --diff --diff-format udiff ./wp-content/themes/my-theme/
$ docker-compose exec wordpress ./vendor/bin/php-cs-fixer fix ./wp-content/themes/my-theme/
`$3
#### Rename docker-comopse-ssl.yml and WordPress Docker file
`bash
$ cp ./docker-comopse-ssl.yml ./docker-compose.yml
$ cp ./docker/wordpress/Dockerfile-ssl ./docker/wordpress/Dockerfile
`#### Install mkcert
`bash
$ brew install mkcert
$ brew install nss
$ mkcert -install
`#### make SSL Certificate
`bash
$ cd ./docker/certs/
$ mkcert localhost 127.0.0.1
$ ls
---
localhost+1-key.pem
localhost+1.pem
`#### Docker Build & Start
`bash
$ docker-compose build
$ docker-compose up -d
`Access SSL URL !!!
$3
`js
wpdb().then(() => {
console.log('Complete!!');
});
`$3
* WordPress
* WordPress(SSL)
Please Edit Hosts File. Then you will be able to access it with the URL you want.
`bash
$ sudo vi /etc/hosts
---
127.0.0.1 example.com
``* phpMyAdmin
* MailHog