cgartner-redstage

# Get product SKU by url key
select e.entity_id,e.sku,v.value from catalog_product_entity e
inner join catalog_product_entity_varchar v on e.entity_id = v.entity_id and 
attribute_id = (select attribute_id from eav_attribute where attribute_code = 'url_key' and entity_type_id = 4)
where v.value = '<url_key>';

cgartner-redstage

##########################################################
# 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`;
DELETE FROM `catalog_product_entity_gallery`;
DELETE FROM `catalog_product_entity_int`;

cgartner-redstage

<script>
    var jsContext = JSON.parse({{jsContext}});
    var entities = jsContext.products.map(function (product) {
        return product.id
    });

    fetch('/graphql', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json',

cgartner-redstage

# Mailhog
MAIL_DRIVER=smtp
MAIL_HOST=0.0.0.0
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

cgartner-redstage

<?php

use Magento\Cms\Model\Block;
use Magento\Cms\Model\BlockRepository;
use Magento\Cms\Model\BlockFactory;

// contruct
public function __construct(
    BlockRepository $blockRepository,
    BlockFactory $blockFactory

cgartner-redstage

#!/usr/bin/env bash

#styles
VP_NONE='\033[00m'
VP_RED='\033[01;31m'
VP_GREEN='\033[01;32m'
VP_YELLOW='\033[01;33m'
VP_PURPLE='\033[01;35m'
VP_CYAN='\033[01;36m'
VP_WHITE='\033[01;37m'

cgartner-redstage

// By @coderitual
// https://twitter.com/coderitual/status/1112297299307384833

//  Remove any duplicates from an array of primitives.
const unique = [...new Set(arr)]

// Sleep in async functions. Use: await sleep(2000).
const sleep = (ms) => (new Promise(resolve => setTimeout(resolve, ms)));

// Type this in your code to break chrome debugger in that line.

cgartner-redstage

Multiple SSH Keys settings for different github account

create different public key

create different ssh key according the article Mac Set-Up Git

$ ssh-keygen -t rsa -C "your_email@youremail.com"