Thabet Amer ThabetAmer

## docker-compose.yml
#
# Based on https://hub.docker.com/_/sonarqube
#

version: "3.7"

services:

  sonarqube:
    container_name: sonarqube

## get-route53-domain-records.sh
#!/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; }

## list-git-branches.groovy
#!/usr/bin/env groovy

/**
 * List all Git branches of a repo.
 * @author thabet.amer@gmail.com
 * @since Jenkins 2.204.1
 * @params String url for Git repo URL, String credentialID, Bool activeChoice if ActiveChoice plugin used, String defaultBranch
 * @return String array of branch names
 *
 * Dependencies:

## harbor-retag-all.sh
#!/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"

## get-last-successful-build-no.groovy
#!/usr/bin/env groovy

/**
 * Gets last successful build number
 * @author thabet.amer@gmail.com
 * @since Jenkins 2.204.1
 * @param String job name
 * @return String number of build number
 *
 */

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

## get_tables_counts.sql
# 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

## s3-make-public-from-other.sh
#!/bin/bash

BUCKET=
PROFILE_OTHER=
PROFILE_MINE=

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

IFS=$'\t'

## office365-enableSMTP.ps1
#
# 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

## mongo-export.sh
#!/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 ',' ' ')
	#
	# Based on https://hub.docker.com/_/sonarqube
	#

	version: "3.7"

	services:

	sonarqube:
	container_name: sonarqube
	#!/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; }
	#!/usr/bin/env groovy

	/**
	* List all Git branches of a repo.
	* @author thabet.amer@gmail.com
	* @since Jenkins 2.204.1
	* @params String url for Git repo URL, String credentialID, Bool activeChoice if ActiveChoice plugin used, String defaultBranch
	* @return String array of branch names
	*
	* Dependencies:
	#!/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"
	#!/usr/bin/env groovy

	/**
	* Gets last successful build number
	* @author thabet.amer@gmail.com
	* @since Jenkins 2.204.1
	* @param String job name
	* @return String number of build number
	*
	*/
	# 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
	#!/bin/bash

	BUCKET=
	PROFILE_OTHER=
	PROFILE_MINE=

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

	IFS=$'\t'
	#
	# 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
	#!/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 ',' ' ')