gormus

-- 1. Reset all code snippets to use '<pre><code>' as opening tags.
UPDATE wp_posts
SET post_content = REGEXP_REPLACE(post_content, '<pre[^>]*>(<code[^>]*>)*', '<pre><code>') 
WHERE post_status = 'publish' 
	AND post_type = 'post' 
	AND post_content RLIKE '<pre[^>]*>(<code[^>]*>)*';

-- 2. Reset all closing tags.
UPDATE wp_posts
SET post_content = REGEXP_REPLACE(post_content, '(<\/code>)*<\/pre>>', '</code></pre>') 

gormus

/**
 * Add rel="noopener" to all "A" tags for external links.
 *
 * Selection rules:
 *  - "A" tag must have "href" attribute, exclude anchors.
 *  - "href" attribute must not start with a "."
 *  - "href" attribute must not start with a "/"
 *  - "A" tag must not have rel="noopener" set.
 *  - "A" tag must not have rel="noreferrer" set.
 *

gormus

#!/usr/bin/env bash

wp search-replace '<pre[^>]*>(<code[^>]*>)*' '<pre><code>' 'wp_posts' \
  --regex \
  --regex-flags='i' \
  --skip-plugins \
  --skip-themes \
  --skip-packages \
  --color \
  --include-columns='post_content' \

gormus

#!/usr/bin/env bash

#
#
# Drupal Deployment Script for Platform.sh Environments
# ==============================================================================
# Authored by osman gormus <[email protected]> on Oct 5, 2021
#
#
# deploy: |