vanWittlaer

#!/usr/bin/env bash
#
# usage: ./dbdump5.sh <shopware project root dir> <target file for dump>
#
# note this script requires PHP and gzip
#
root=${1:-/var/www/shopware/shopware}
target=${2:-test.sql.gz}
config=${3:-php}
#

vanWittlaer

# Being stuck by PhpStorm indexing on all CPUs? On Ubuntu, you can limit PhpStorm to using just say 4 of your CPUs by amending
# the Exec directive with 'taskset -a -c 0,1,2,3' in its desktop file (usually located in /usr/share/applications)

[Desktop Entry]
Version=1.0
Type=Application
Name=PhpStorm
Icon=/opt/PhpStorm-212.5080.71/bin/phpstorm.svg
Exec="taskset -a -c 0,1,2,3 /opt/PhpStorm-212.5080.71/bin/phpstorm.sh" %f
Comment=Lightning-smart PHP IDE

vanWittlaer

#!/usr/bin/env bash

# What it does:
# - Creates a local Shopware installation using the Symfony Flex template for local development of client projects
# - Prerequisites: ddev installed on your machine, see https://ddev.com/get-started/
#
# How to use:
# - create a project folder
# - copy this file into the project folder
# - chmod +x install.sh

vanWittlaer

Shopware admin API requests can be enriched with a query.
For example, to retrieve only snippets for a particular snippet set, use this query:

{{HOST}}/api/snippet?query[0][query][type]=equals&query[0][query][field]=setId&query[0][query][value]=685f610ee07544feb28b6a5abf38cf7c

vanWittlaer

composer symfony:sync-recipes --force

vanWittlaer

-- list all docker log entries with particular status code
SELECT
    STRFTIME(TO_TIMESTAMP(ts )::TIMESTAMP,'%Y-%m-%d %H:%M:%S') AS datetime,
    request.headers."X-Real-Ip" as source,
    request.method,
    status,
    request.host as target,
    request.uri,
    request.headers."User-Agent" as userAgent
FROM logs