daniDLL
/ anonymize_local_customer_emails
Last active
June 1, 2022 12:18
anonymize-local-customer-emails
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE customer_entity SET email = CONCAT(SUBSTRING(MD5(UUID()), 1, 15) , '@example.com') where entity_id > 0; | |
| UPDATE sales_order SET customer_email = CONCAT(SUBSTRING(MD5(UUID()), 1, 15) , '@example.com') where entity_id > 0; |
eckelon
/ git-weekly.sh
Created
November 14, 2019 11:33
script for generating a markdown styled report based on the last 7 days git activity, on all the repos inside the current dir. Inspired by https://twitter.com/climagic/status/1194712444201054209?s=12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| CUR_DIR=$(pwd) | |
| GIT_USER="JA Samitier" | |
| report="# Git report from last week\n" | |
| printf "Generating git report...\n\n" | |
| repos=$(find . -name ".git" | cut -c 3-) | |
| for i in $repos; do |