aboritskiy

#!/bin/bash

set -eu

git fetch -ap

git branch -r --merged origin/master | grep -v master | grep -v dev | grep -v HEAD | sed 's/^  origin\///' | xargs git push --delete origin

aboritskiy

curl -X DELETE 'http://localhost:9200/_all'

aboritskiy

#!/bin/bash
#
# Script to remove GPG key from git-crypt
#
# It will re-initialize git-crypt for the repository and re-add all keys except
# the one requested for removal.
#
# Note: You still need to change all your secrets to fully protect yourself.
# Removing a user will prevent them from reading future changes but they will
# still have a copy of the data up to the point of their removal.

aboritskiy

TOKEN=""
curl "https://slack.com/api/channels.list?token=$TOKEN&exclude_archived=true&pretty=1" > /tmp/channels.list
IDS=$(cat /tmp/channels.list | jq '.channels[] | select(.num_members == 0) | .id' | sed -e 's/"//g')
for ID in $IDS; do
    CHANNEL_DATA=$(cat /tmp/channels.list | jq ".channels[] | select(.id == \"$ID\") | \"\(.id) \(.name) \(.num_members)\"")
    echo "$CHANNEL_DATA"
    read -p " proceed? " -n 1 -r
    if [[ $REPLY =~ ^[Yy]$ ]]
    then
        echo " archiving..."

aboritskiy

#!/bin/bash

set -eu

AWS_ACCOUNT_ID=657433956652


echo "Snapshots exist for following images: "
aws ec2 describe-snapshots --filters Name=description,Values="Created by CreateImage*" --owner-id=$AWS_ACCOUNT_ID --output=text | grep "^SNAPSHOTS" | sed  's/.*\(ami-[0-9a-z]\+\).*/\1/' | sort | uniq | sort > /tmp/snapshot-cleanup-existing-snapshots

aboritskiy

#!/bin/bash

SUBMODULES_LIST=$(git submodule status | awk '{print $2}');

echo "Status before:"
echo
git submodule status
echo

for SUBMODULE_PATH in $SUBMODULES_LIST

aboritskiy

SELECT table_schema as `Database`, table_name AS `Table`, 
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
WHERE table_schema = "PUT-YOUR-DB-NAME-HERE"
ORDER BY (data_length + index_length) DESC;

aboritskiy

#!/bin/bash
yum update -y
yum install -y httpd
echo "<VirtualHost *:80>
    ServerName default
    ServerAdmin anton.boritskiy@gmail.com
    DocumentRoot /var/www/html/
    <Directory '/var/www/html/'>
        Options FollowSymLinks Includes ExecCGI
        AllowOverride All

aboritskiy

RewriteRule ^/\.             - [L,R=403]
RewriteRule ^/app/           - [L,R=403]
RewriteRule ^/dev/           - [L,R=403]
RewriteRule ^/downloader/    - [L,R=403]
RewriteRule ^/includes/      - [L,R=403]
RewriteRule ^/lib/           - [L,R=403]
RewriteRule ^/shell/         - [L,R=403]
RewriteRule ^/pkginfo/       - [L,R=403]
RewriteRule ^/var/           - [L,R=403]
RewriteRule ^/rss/           - [L,R=403]

aboritskiy

mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"
mysqladmin -u root -p shutdown

sudo yum remove mysql55\*
sudo yum install mysql56-server

sudo service mysqld start

sudo mysql_upgrade -u root -p