Alex Richards ajtrichards

## github-cleanup-workflows.sh
run_ids=$(gh run list --limit 500 --repo=name/name --workflow=name.yml --json databaseId | jq -r '.[].databaseId')

for run_id in $run_ids; do
    gh run delete $run_id --repo name/name
done

## exchange-o365-set-calendar-permissions.ps1
pwsh -Command 'Install-Module -Name PSWSMan'
pwsh -Command 'Install-Module -Name ExchangeOnlineManagement'

sudo pwsh -Command 'Install-WSMan'

Connect-ExchangeOnline -UserPrincipalName YOUR_EMAIL_ADDRESS

foreach($user in Get-Mailbox -RecipientTypeDetails UserMailbox) {
  $cal = $user.alias+":\calendar"
  write-host $cal

## scan-list-of-aws-ips.sh
aws ec2 describe-network-interfaces --query NetworkInterfaces\[\].Association.PublicIp | jq -r '.[]' | xargs -I{} nmap -v -A -sV {}

## laravel-eloquent-dump-sql.php
<?php

$builder = MyModel::where('active', 1);

$query = str_replace(array('?'), array('\'%s\''), $builder->toSql());
$query = vsprintf($query, $query->getBindings());

dd($query);

## gist:cfab61de1b570340bb55ae8b24fff258
aws s3 rm s3://BUCKET_NAME --recursive --exclude "*" --include "FILE_PREFIX-W*"

## Find different between dates in mysql.sql
SELECT id, TIMEDIFF(ended_at, started_at) as timediff FROM ...

## gist:b918565b0c32c13ab25a63df4795e42c
### Keybase proof

I hereby claim:

  * I am ajtrichards on github.
  * I am alexrichards (https://keybase.io/alexrichards) on keybase.
  * I have a public key ASDv_Nt0itWm_BtpceiaxDWHtvVxEmNbt-THZBG5DSQDkgo

To claim this, I am signing this object:

## example-log-entry.sh
 Feb 3 19:27:50 user-api-*-* user-api WARNING [03-Feb-2018 19:27:50] WARNING: [pool www] child 958 said into stderr: "[2018-02-03 19:27:50] lumen.DEBUG: user.api.view.user.error.user-details {"action":"user.api.view.user.error.user-details","userData":{"forename":"Alex","surname":"Richards","fullname":"Alex Richards","email":"[email protected]","username":"[email protected]","enabled":true,"earn":"earn:user/users:A-UUID-4"}} []"

## byte_to_str.go
func BytesToString(data []byte) string {
  return string(data[:])
}

## clean-deleted-branches.sh
git branch --merged | egrep -v "(^\*|master|dev)" | xargs git branch -d
	run_ids=$(gh run list --limit 500 --repo=name/name --workflow=name.yml --json databaseId \| jq -r '.[].databaseId')

	for run_id in $run_ids; do
	gh run delete $run_id --repo name/name
	done
	pwsh -Command 'Install-Module -Name PSWSMan'
	pwsh -Command 'Install-Module -Name ExchangeOnlineManagement'

	sudo pwsh -Command 'Install-WSMan'

	Connect-ExchangeOnline -UserPrincipalName YOUR_EMAIL_ADDRESS

	foreach($user in Get-Mailbox -RecipientTypeDetails UserMailbox) {
	$cal = $user.alias+":\calendar"
	write-host $cal
	<?php

	$builder = MyModel::where('active', 1);

	$query = str_replace(array('?'), array('\'%s\''), $builder->toSql());
	$query = vsprintf($query, $query->getBindings());

	dd($query);
	### Keybase proof

	I hereby claim:

	* I am ajtrichards on github.
	* I am alexrichards (https://keybase.io/alexrichards) on keybase.
	* I have a public key ASDv_Nt0itWm_BtpceiaxDWHtvVxEmNbt-THZBG5DSQDkgo

	To claim this, I am signing this object:
	func BytesToString(data []byte) string {
	return string(data[:])
	}