Raku CLI::Wordpress

This module provides a simple abstraction to the Wordpress command line interface (wpcli) for site launch and maintenance.

If you encounter a feature you want that's not implemented by this module (and there are many), please consider sending a pull request.

Prerequisites

ubuntu server with docker, docker-compose, raku and zef (e.g. by using raws-ec2)
located at a static IP address (e.g. raws-ec2 --eip launch) with ssh access (e.g. via raws-ec2 connect)
domain name DNS set with A records @ and www to the target's IP address

Getting Started

ssh in and install CLI::Wordpress on server to get the rawp command zef install https://github.com/p6steve/raku-CLI-Wordpress.git [or CLI::Wordpress]
edit vi ~/.rawp-config/wordpress-launch.yaml with your domain name and wordpress configuration
launch a new instance of Wordpress & setup ssl certificate rawp setup && rawp launch
view your new Wordpress site frontend at https://yourdomain.com and configure basics
setup ssl cert renewals via letsencrypt rawp renewal

wordpress-launch.yaml

        instance:
            domain-name: your_domain
            admin-email: 'adminyour_domain'
            db-image: mysql:8.0
            wordpress-image: wordpress:php8.0-fpm-alpine
            webserver-image: nginx:1.15.12-alpine
            certbot-image: certbot/certbot
            wpcli-image: wordpress:cli-php8.0

WP CLI Examples

rawp wp '--info'

OS:	Linux 5.15.0-1031-aws #35-Ubuntu SMP Fri Feb 10 02:07:18 UTC 2023 x86_64
Shell:	
PHP binary:	/usr/local/bin/php
PHP version:	8.0.28
php.ini used:	
MySQL binary:	/usr/bin/mysql
MySQL version:	mysql  Ver 15.1 Distrib 10.6.12-MariaDB, for Linux (x86_64) using readline 5.1
SQL modes:	
WP-CLI root dir:	phar://wp-cli.phar/vendor/wp-cli/wp-cli
WP-CLI vendor dir:	phar://wp-cli.phar/vendor
WP_CLI phar path:	/var/www/html
WP-CLI packages dir:	
WP-CLI cache dir:	/.wp-cli/cache
WP-CLI global config:	
WP-CLI project config:	
WP-CLI version:	2.7.1

rawp wp 'search-replace "test" "experiment" --dry-run'

Table	Column	Replacements	Type
wp_commentmeta	meta_key	0	SQL
wp_commentmeta	meta_value	0	SQL
wp_comments	comment_author	0	SQL
...
wp_links	link_rss	0	SQL
wp_options	option_name	0	SQL
wp_options	option_value	3	PHP
wp_options	autoload	0	SQL
...
wp_users	display_name	0	SQL
Success: 3 replacements to be made.

CMDs

setup # position all config files for docker-compose and render wordpress-launch.yaml info
launch # docker-compose up staging server, if OK then get ssl and restart
renewal # configure crontab for ssl cert renewal
up # docker-compose up -d
wp 'cmd' # run wpcli command - viz. https://developer.wordpress.org/cli/commands/
down # docker-compose down
ps # docker-compose ps
connect # docker exec to wordpress server
terminate # rm volumes & reset

Usage

  rawp <cmd> [<wp>]
  
    <cmd>     One of <setup launch renewal up wp down ps connect terminate>
    [<wp>]    A valid wp cli cmd (viz. https://developer.wordpress.org/cli/commands/)