ThabetAmer

#!/bin/bash

# @description : retrieves DNS zone records for a domain hosted on AWS Route53 
# @usage       : bash get-route53-domain-records.sh example.com
# @requirements: proper awscli v2 setup
# @input       : domain name, you own!
# @output      : text formatted records

DOMAIN=$1
test -z "$DOMAIN" && { echo "ERROR: no domain value is set" && exit -1; }

ThabetAmer

aws sts --profile "${PROFILE:=default}" get-caller-identity --output text --query 'Account'

ThabetAmer

# tested on Mysql 5.7-8

# set database schema name to run against
SET @db_name = "DBNAME";

# actual query, two columns resulted: table name and its rows count
SELECT
    TABLE_NAME,
    SUM(TABLE_ROWS) as c
FROM

ThabetAmer

#!/bin/bash

BUCKET=
PROFILE_OTHER=
PROFILE_MINE=

DATE=$(date +%Y-%m-%dT%H:00:00)

IFS=$'\t'

ThabetAmer

#
# Enables SMTP Auth for Office365 emails, so you can send emails via a script for application.
# Shall be run via Powershell terminal.
#

# Define your email address that will send emails via SMTP auth
$emailAddress = 'test@test.com'

# asks for email/password
$UserCredential = Get-Credential

ThabetAmer

#!/bin/bash

# Copies all tagged images with defined tag to a new one - using Harbor Retag feature.

# config vars
SRC_TAG="latest"
DST_TAG="v1"
HARBOR_API_URL="https://hostname/api"
HARBOR_USR="username"
HARBOR_PSW="password"

ThabetAmer

#!/bin/bash

# tested on Mongo 3.6

DB='test'
USR='admin'
PSW='admin''
BACKUP_FOLDER="$DB-backup"

COLLECTIONS=$(mongo localhost:27017/$DB -u $USR -p $PSW --authenticationDatabase admin --quiet --eval "db.getCollectionNames()" | tr -d '\[\]\"[:space:]' | tr ',' ' ')

ThabetAmer

#!/usr/bin/env groovy

/*
* Runs shell command and prints back stdout and stderr
*/

command='ls -al'
println new ProcessBuilder('sh','-c',command).redirectErrorStream(true).start().text 

ThabetAmer

#!/bin/bash

# Creates Jenkins credentials with username and password,
# made for Harbor Robot Accounts, but can be used for any username/password json file

# @author thabet.amer@gmail.com
# @since Jenkins 2.222.1
# @params json file with {"name":"","token":""} tags
# @output Jenkins credential with ID name "harbor-NAME"

ThabetAmer

#!/bin/bash

aws ecr get-login --no-include-email | sh

# to read the authentication string only, so it can be used in apps.
#aws ecr get-authorization-token --output text --query 'authorizationData[].authorizationToken' --region eu-central-1 \
# | base64 -d | cut -d: -f2