sgargel

## gist:e99ec8966c161545fd8eb5973683144d
SQLCONN="user/pass@//db_ip:db_port/service_name"
while true ; do OUT=$(echo "SELECT /*json*/ * FROM DUAL;" | sql -s $SQLCONN 2>&1) ; echo $OUT |  jq -e '(.results[].items[].dummy == "X")' && (echo -e '\a'; echo "$(date) PONG" ; sleep 1) || (echo "$(date)   : $OUT"; sleep 5); done

## Install-OpenSSH.ps1
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Invoke-WebRequest -OutFile OpenSSH-Win64.zip https://github.com/PowerShell/Win32-OpenSSH/releases/download/v8.0.0.0p1-Beta/OpenSSH-Win64.zip;
Expand-Archive .\OpenSSH-Win64.zip;
$openSSHDir='C:\Program Files\OpenSSH';
md $openSSHDir;
mv .\OpenSSH-Win64\OpenSSH-Win64\* $openSSHDir;
powershell -ExecutionPolicy Bypass -File $openSSHDir\install-sshd.ps1;
$openSSHDir\ssh-keygen.exe -A;
powershell -ExecutionPolicy Bypass ". `'$openSSHDir\FixHostFilePermissions.ps1`' -Confirm:0";
New-NetFirewallRule -Protocol TCP -LocalPort 22 -Direction Inbound -Action Allow -DisplayName SSH;

## analisi_swot.html
<html>
    <head><title>Analisi SWOT</title></head>
    <body>
        <h1>SWOT: argomento</h1>
        <table border="1">
            <tr>
                <td>Forza:<br>
                    <ul>
                        <li></li>
                        <li></li>
	SQLCONN="user/pass@//db_ip:db_port/service_name"
	while true ; do OUT=$(echo "SELECT /json/ * FROM DUAL;" \| sql -s $SQLCONN 2>&1) ; echo $OUT \| jq -e '(.results[].items[].dummy == "X")' && (echo -e '\a'; echo "$(date) PONG" ; sleep 1) \|\| (echo "$(date) : $OUT"; sleep 5); done
	[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
	Invoke-WebRequest -OutFile OpenSSH-Win64.zip https://github.com/PowerShell/Win32-OpenSSH/releases/download/v8.0.0.0p1-Beta/OpenSSH-Win64.zip;
	Expand-Archive .\OpenSSH-Win64.zip;
	$openSSHDir='C:\Program Files\OpenSSH';
	md $openSSHDir;
	mv .\OpenSSH-Win64\OpenSSH-Win64\* $openSSHDir;
	powershell -ExecutionPolicy Bypass -File $openSSHDir\install-sshd.ps1;
	$openSSHDir\ssh-keygen.exe -A;
	powershell -ExecutionPolicy Bypass ". `'$openSSHDir\FixHostFilePermissions.ps1`' -Confirm:0";
	New-NetFirewallRule -Protocol TCP -LocalPort 22 -Direction Inbound -Action Allow -DisplayName SSH;
	<html>
	<head><title>Analisi SWOT</title></head>
	<body>
	<h1>SWOT: argomento</h1>
	<table border="1">
	<tr>
	<td>Forza:<br>
	<ul>
	<li></li>
	<li></li>