Anass Bouassaba bouassaba

## who_listens_on_port_deb.sh
sudo apt install net-tools
netstat -ltnp | grep -w ':3306'

## gist:2ffbb659b1d9664b4ab2a677e839c132
git commit -m 'rebuild pages' --allow-empty

## mysql_create_user_and_database.sql
CREATE DATABASE mydatabase;
CREATE USER myuser IDENTIFIED BY 'mypassword';
GRANT ALL privileges ON mydatabase.* TO myuser;

## oralce_function_return_select_query.sql
CREATE TABLE product (
    col1 VARCHAR2(255),
    col2 NUMBER,
    col3 VARCHAR2(255),
    col4 NUMBER
);

INSERT INTO product (col1, col2, col3, col4)
VALUES ('A', 1, 'AA', 10);
INSERT INTO product (col1, col2, col3, col4)

## postgres_create_user_and_database.sql
CREATE DATABASE yourdbname;
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
-- Optional, grant superuser privileges
--ALTER USER youruser WITH SUPERUSER;

## Mailhog Bash Script (systemd)
#!/usr/bin/env bash

echo ">>> Installing Mailhog"

# Download binary from github
wget --quiet -O ~/mailhog https://github.com/mailhog/MailHog/releases/download/v1.0.0/MailHog_linux_amd64

# Make it executable
chmod +x ~/mailhog

## kafka_installation_and_systemd.sh
cd /opt
wget http://apache-mirror.rbc.ru/pub/apache/kafka/0.10.1.0/kafka_2.11-0.10.1.0.tgz
tar xvzf kafka_2.11-0.10.1.0.tgz
ln -s kafka_2.11-0.10.1.0/ kafka


vi /etc/systemd/system/kafka-zookeeper.service
[Unit]
Description=Apache Zookeeper server (Kafka)
Documentation=http://zookeeper.apache.org

## rabbitmq.txt
rabbitmqctl add_user test test
rabbitmqctl set_user_tags test administrator
rabbitmqctl set_permissions -p / test ".*" ".*" ".*"

## oracle_create_schema_user.sql
ALTER SESSION SET "_ORACLE_SCRIPT"= TRUE;
CREATE USER myuser IDENTIFIED BY myuser;
GRANT CONNECT, RESOURCE, DBA TO myuser;
GRANT CREATE SESSION TO myuser;

## SemverSort.ps1
#powershell script port of https://github.com/maxhauser/semver/
function toSemVer($version){
    $version -match "^(?<major>\d+)(\.(?<minor>\d+))?(\.(?<patch>\d+))?(\-(?<pre>[0-9A-Za-z\-\.]+))?(\+(?<build>[0-9A-Za-z\-\.]+))?$" | Out-Null
    $major = [int]$matches['major']
    $minor = [int]$matches['minor']
    $patch = [int]$matches['patch']

    if($matches['pre'] -eq $null){$pre = @()}
    else{$pre = $matches['pre'].Split(".")}
	CREATE DATABASE mydatabase;
	CREATE USER myuser IDENTIFIED BY 'mypassword';
	GRANT ALL privileges ON mydatabase.* TO myuser;
	CREATE TABLE product (
	col1 VARCHAR2(255),
	col2 NUMBER,
	col3 VARCHAR2(255),
	col4 NUMBER
	);

	INSERT INTO product (col1, col2, col3, col4)
	VALUES ('A', 1, 'AA', 10);
	INSERT INTO product (col1, col2, col3, col4)
	CREATE DATABASE yourdbname;
	CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';
	GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
	-- Optional, grant superuser privileges
	--ALTER USER youruser WITH SUPERUSER;
	#!/usr/bin/env bash

	echo ">>> Installing Mailhog"

	# Download binary from github
	wget --quiet -O ~/mailhog https://github.com/mailhog/MailHog/releases/download/v1.0.0/MailHog_linux_amd64

	# Make it executable
	chmod +x ~/mailhog
	cd /opt
	wget http://apache-mirror.rbc.ru/pub/apache/kafka/0.10.1.0/kafka_2.11-0.10.1.0.tgz
	tar xvzf kafka_2.11-0.10.1.0.tgz
	ln -s kafka_2.11-0.10.1.0/ kafka


	vi /etc/systemd/system/kafka-zookeeper.service
	[Unit]
	Description=Apache Zookeeper server (Kafka)
	Documentation=http://zookeeper.apache.org
	rabbitmqctl add_user test test
	rabbitmqctl set_user_tags test administrator
	rabbitmqctl set_permissions -p / test "." "." ".*"
	ALTER SESSION SET "_ORACLE_SCRIPT"= TRUE;
	CREATE USER myuser IDENTIFIED BY myuser;
	GRANT CONNECT, RESOURCE, DBA TO myuser;
	GRANT CREATE SESSION TO myuser;
	#powershell script port of https://github.com/maxhauser/semver/
	function toSemVer($version){
	$version -match "^(?<major>\d+)(\.(?<minor>\d+))?(\.(?<patch>\d+))?(\-(?<pre>[0-9A-Za-z\-\.]+))?(\+(?<build>[0-9A-Za-z\-\.]+))?$" \| Out-Null
	$major = [int]$matches['major']
	$minor = [int]$matches['minor']
	$patch = [int]$matches['patch']

	if($matches['pre'] -eq $null){$pre = @()}
	else{$pre = $matches['pre'].Split(".")}