| #!/usr/bin/env bash | |
| # | |
| # simple sqlite-wrapper to have PAGER support | |
| # | |
| # install and chmod+x to ~/bin/wsqlite and load in ~/.profile PATH | |
| set -eE | |
| command -v sqlite3 >/dev/null || echo "sqlite3 not found, please install" || exit 1 | |
| command -v tmux >/dev/null || echo "tmux not found, please install" || exit 1 |
| { | |
| "s_articles_vote": { | |
| "email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')", | |
| "name": "LEFT(MD5(CONCAT(@seed, `name`)), LENGTH(`name`))" | |
| }, | |
| "s_articles_notification": { | |
| "mail": "CONCAT(LEFT(MD5(CONCAT(@seed, `mail`)), LENGTH(`mail`)), '@localhost')" | |
| }, | |
| "s_campaigns_mailaddresses": { | |
| "email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')" |
| #!/bin/bash | |
| # | |
| # dump db without contents of specific tables | |
| if test -z "$1" || test -z "$2"; then | |
| echo "usage: script.sh <user> <dbname>" | |
| exit 1 | |
| fi | |
| user="$1" |
| #!/usr/bin/env bash | |
| # | |
| # some sanity checks for shopware | |
| # | |
| # install: move to .git/hooks/pre-commit and chmod +x the file | |
| # colors for output | |
| nocolor='\033[0m' | |
| green='\033[0;32m' | |
| orange='\033[0;33m' |
| # shopware downloaders, "jq" package required | |
| alias sw-getlatest="echo '# get latest install release'; curl -s 'http://update-api.shopware.com/v1/releases/install' | jq '.[0].uri' | xargs -I{} wget --quiet --show-progress {}" | |
| alias sw-getupdate="echo '# get latest update of stable branch'; curl -s 'http://update-api.shopware.com/v1/release/update?shopware_version=5&channel=stable' | jq '.uri' | xargs wget --quiet --show-progress" | |
| sw-getrelease() { echo "# get specific release"; if [ -z "$*" ]; then echo "# no version given. usage 'sw-getrelease <version>'"; return 0; fi; VER="$1"; curl -s http://update-api.shopware.com/v1/releases/install | jq '.[] | select(.version=='\"$VER\"') | .uri' | xargs wget --quiet --show-progress; } |
