gdpr.sh

#!/bin/bash

while getopts ":i:o:" opt; do
  case $opt in
    i) input="$OPTARG"
    ;;
    o) output="$OPTARG"
    ;;
    t) title="$OPTARG"
    ;;
    \?) echo "Invalid option -$OPTARG" >&2
    ;;
  esac
done

dups=$(cat $input | uniq -d)
unique_ids=$(cat $input | uniq)
num_unique_ids=$(cat $input | uniq | wc -l|  awk '{print $1}')
num_dups=$(cat $input | uniq -d | wc -l |  awk '{print $1}')
num_outputs=$(cat $output | wc -l | awk '{print $1}')

if [ $num_unique_ids -lt $num_outputs ]
then
    echo "The number of inputs is less than outputs ($num_unique_ids < $num_outputs). Please check with integrations team..."
    exit 1
fi

echo "There are $num_dups duplicates"
echo ""
echo "Removing dups for these ID's:"
echo $dups
echo ""



read -p "Gdpr title: " title
read -p "Request date (YYYY-MM-DD): " request_date
read -p "Due date (YYYY-MM-DD): " due_date
read -p "Request type (account|contact): " request_type
read -p "Account_id: " account_id


echo "insert into dwhrw.dwh_gdpr.gdpr_requests(title,request_date,due_date, request_type, account_id, gdpr_id, request_status, is_before_auto_process, request_insert_type) VALUES" > auto_bi.sql

echo "Writing $num_unique_ids ids"
for id in $unique_ids; do
    echo "('$title',date('$request_date'),date('$due_date'),'$request_type','$account_id','$id', 'Ready', True, 'Manual')," >> auto_bi.sql
done

# Opens the output file
echo "Opening the output file"
open auto_bi.sql