dermatz

#!/bin/bash

mkdir wordpress-site && cd wordpress-site

touch docker-compose.yml

cat > docker-compose.yml <<EOL
version: "2"
services:
  my-wpdb:

dermatz

#!/bin/sh
parse_yaml() {
   local prefix=$2
   local s='[[:space:]]*' w='[a-zA-Z0-9_]*' fs=$(echo @|tr @ '\034')
   sed -ne "s|^\($s\)\($w\)$s:$s\"\(.*\)\"$s\$|\1$fs\2$fs\3|p" \
        -e "s|^\($s\)\($w\)$s:$s\(.*\)$s\$|\1$fs\2$fs\3|p"  $1 |
   awk -F$fs '{
      indent = length($1)/2;
      vname[indent] = $2;
      for (i in vname) {if (i > indent) {delete vname[i]}}

dermatz

Verifying that +dermatz is my blockchain ID. https://onename.com/dermatz

dermatz

Duplicate Checks
================

http://www.albertomariarossi.it/howto-solve-url-rewrite-indexing-errors-in-magento/

1- Check for duplicate SKUs
---------------------------
SELECT
DISTINCT(`sku`) as `sku`,
COUNT(`sku`) as `skuCount`, `entity_id` FROM `catalog_product_entity`

dermatz

-- clean all patches
TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;

-- clean all logs
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;

dermatz

SET FOREIGN_KEY_CHECKS=0; 

-- Customers
TRUNCATE `customer_entity`;
TRUNCATE `customer_entity_datetime`;
TRUNCATE `customer_entity_decimal`;
TRUNCATE `customer_entity_int`;
TRUNCATE `customer_entity_text`;
TRUNCATE `customer_entity_varchar`;