flipace

Keybase proof

I hereby claim:

• I am flipace on github.
• I am flipace (https://keybase.io/flipace) on keybase.
• I have a public key ASAWzpWUBpQsE500qVOf0nxtg111lp7FY7r8qAHWRXZcVwo

To claim this, I am signing this object:

flipace

git tag --list 'v*' | xargs -I % echo "git tag -d %; git push --delete origin %" | sh

flipace

Generate UNION ALL queries for e.g create view

SELECT CONCAT('SELECT `type` COLLATE utf8mb4_unicode_ci as type, "', schema_name, '" COLLATE utf8mb4_unicode_ci as tenant FROM `', 
    schema_name, '`.`micro_sessions` UNION ALL')
FROM information_schema.schemata
WHERE schema_name NOT IN ('information_schema','mysql','performance_schema');

Convert everything to different Charset + Collation

flipace

#!/bin/bash

checkremote() {
	dir=$(pwd)

	echo "Looking for git folders in ${dir} and below. Ignoring node_modules."

	results=$(find $dir -not -path "*node_modules*" -not -path ".git/*" -name .git -type d);
	for f in $results; do 
		(cd $f/..; echo ""; echo "$f:"; git remote -v;)