CyberSecutor

Dump a sanitized version of the database

Excludes and stips are taken fron the asset snc project: https://bitbucket.youweagency.com/projects/YWEDO/repos/asset-sync/browse/scripts/magento2/db

More excludes can be found in the projects source. They can be specified in the project specific file: app/etc/n98-magerun2.yaml

vendor/bin/n98-magerun2 db:dump \

CyberSecutor

This file has some usefull commands in bash that I may need again.

Download all images from a list and put them in a directory structure following the URL path:

$ for i in `cat ~/imageList-karrepad.txt`; do echo $i | perl -e 'while (<>) {chomp $_; $url = $_; $path = $url; $path =~ s/.*\:\/\/(.*)\?.*/$1/g; system ("mkdir -p `dirname $path` 2> /dev/null") == 0 or die "failed to create $path. exiting...\n"; print "$url -O $path\n"; }' | xargs wget; done

Alternative for when the 'tree' command is not available

CyberSecutor

-- Sets the timezone for the current session.
SET time_zone = '+02:00';

-- Orders Per Year --
SELECT period_date as year, order_count, gross_revenue, ROUND(gross_revenue / order_count, 2) AS gross_aov
FROM (
         SELECT
             COUNT(*) AS order_count,
             ROUND(SUM(base_grand_total), 2) AS gross_revenue,
             DATE_FORMAT(o.created_at, '%Y') AS period_date

CyberSecutor

use magento;

##########################################################
# PRODUCTS
##########################################################
DELETE FROM `catalog_product_bundle_option`;
DELETE FROM `catalog_product_bundle_option_value`;
DELETE FROM `catalog_product_bundle_selection`;
DELETE FROM `catalog_product_entity_datetime`;
DELETE FROM `catalog_product_entity_decimal`;

CyberSecutor

<?php

class Engine
{
    private $pk;

    public function __construct(int $pk)
    {
        $this->pk = $pk;
    }

CyberSecutor

Keybase proof

I hereby claim:

• I am CyberSecutor on github.
• I am cybersecutor (https://keybase.io/cybersecutor) on keybase.
• I have a public key whose fingerprint is A840 EE0A 9641 8244 8D07 6127 AF2C 3985 5EAF 7336

To claim this, I am signing this object: