DanielSousa

Running Warden on Windows with WSL 2

See this Github comment thread for any issues or additional context for getting Warden running on Windows with WSL 2.

The instructions below cover how to install Warden on Windows, using WSL 2.

1. Install Ubuntu 20 LTS in WSL 2
   1. To access the shell/terminal inside of Ubuntu WSL, open the Ubuntu 20.04 program that will have been installed in the step above (If you want to be able to copy/paste, see here. Going forward, this article assumes you will run all commands inside of the Ubuntu terminal
2. Install Docker Desktop (these instructions were tested using Docker 4.9.0 on June 13th, 2022)
3. Install homebrew `

DanielSousa

Magento Cloud helper scripts

I drop them into the root project's dir and push them to the repo. Mostly they should use whatever env you've got checked out with magento-cloud command.

Tested only on Mac with Pro/Stage envs, use at your own risk YMMV.

Tip: You can adjust .gitignore like this for convenience:

DanielSousa

Here are the best startup tools of 2019 that will help you build out your startup business as quickly, cheaply, and efficiently as possible.

This is a curated list of tools for everything from productivity to web hosting to development tools to designing. Most of these tools are either free or have limited free option that is enough for startups. We love all the free services out there, but it would be good to keep it on topic. It's a bit of a grey line at times so this is a bit opinionated; feel free to suggest and contribute in this list.

Source Code Repos

• GitHub — Unlimited public repositories and unlimited private repositories (up to 3 collaborators).
• GitLab — Unlimited public and private Git repos with unlimited collaborators.
• BitBucket — Unlimited public and private repos (Git and Mercurial) for up to 5 users with Pipelines for CI/CD.
• Visual Studio — Unlimited private repos (Git a

DanielSousa

<code_scheme name="Magento 2" version="173">
  <PHPCodeStyleSettings>
    <option name="ALIGN_KEY_VALUE_PAIRS" value="true" />
    <option name="ALIGN_PHPDOC_PARAM_NAMES" value="true" />
    <option name="ALIGN_PHPDOC_COMMENTS" value="true" />
    <option name="ALIGN_ASSIGNMENTS" value="true" />
    <option name="PHPDOC_BLANK_LINES_AROUND_PARAMETERS" value="true" />
    <option name="PHPDOC_WRAP_LONG_LINES" value="true" />
    <option name="LOWER_CASE_BOOLEAN_CONST" value="true" />
    <option name="LOWER_CASE_NULL_CONST" value="true" />

DanielSousa

-- catalog_product_entity_datetime
SELECT a.*
FROM (SELECT * FROM catalog_product_entity_datetime) AS a
         -- This inner join finds all store view-specific rows that exactly match the global scope value. The b.store_id = 0 conditional is key as it targets the global row
         INNER JOIN (SELECT * FROM catalog_product_entity_datetime) AS b ON a.attribute_id = b.attribute_id AND a.row_id = b.row_id AND a.value = b.value AND b.store_id = 0
WHERE a.store_id <> 0
GROUP BY a.attribute_id, a.row_id, a.value, a.store_id;
-- catalog_product_entity_decimal
SELECT a.*

DanielSousa

########################################################################################################################

CREATE FUNCTION SANITIZE_EMAIL (email VARCHAR(255))
  RETURNS VARCHAR (255) DETERMINISTIC
  RETURN CONCAT(MD5(SUBSTRING(email, 1, LOCATE('@', email) - 1)), LEFT(UUID(), 4), '@example.com');

CREATE FUNCTION GET_RANDOM_FIRSTNAME ()
  RETURNS VARCHAR (255) DETERMINISTIC
  RETURN ELT(FLOOR(1 + RAND() * 25), 'John', 'Sheldon', 'Lindy', 'Joanna', 'Eric', 'Noah', 'Emma', 'Liam', 'Olivia', 'William', 'Ava', 'Mason', 'Sophia', 'James', 'Isabella', 'Benjamin', 'Mia', 'Jacob', 'Charlotte', 'Michael', 'Abigail', 'Elijah', 'Emily', 'Ethan', 'Harper');

DanielSousa

#!/usr/bin/env bash

set -e

NEWUSER=$1
USERPUBKEY=$2

if [ -z "$NEWUSER" ]; then
    echo "Username required"
    exit 1;

DanielSousa

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Acl/etc/acl.xsd">
    <acl>
        <resources>
            <resource id="Magento_Backend::admin">
                
            </resource>
        </resources>
    </acl>
</config>