#!/bin/bash
# Run SQL to disable bounced users on production
KEY="/tmp/shamra.pem"
cp /mnt/c/Users/shadisaleh/Documents/linux/shamramain_user.pem "$KEY" 2>/dev/null
chmod 600 "$KEY"

ssh -i "$KEY" -o StrictHostKeyChecking=no azureuser@20.241.4.71 bash -s << 'REMOTE'
echo "=== Running disable bouncers SQL ==="
cd /var/www/html/academia_v2

# Write a runner script on the server
cat > /tmp/run_sql.sh << 'INNER'
#!/bin/bash
SQL=$(cat /tmp/disable_bouncers.sql)
sudo -u www-data php /var/www/html/academia_v2/bin/console dbal:run-sql --env=prod "$SQL"
INNER
chmod +x /tmp/run_sql.sh
/tmp/run_sql.sh

echo "=== Also marking newsletter_log entries as bounced ==="
sudo -u www-data php /var/www/html/academia_v2/bin/console dbal:run-sql --env=prod "UPDATE newsletter_log SET status = 'bounced' WHERE LOWER(recipient_email) IN ('brababah904@yahoo.com','waleed.elnahas@yahoo.com','ali498hunter@gmail.com','yd_saad2010@yahoo.com','dr_maan92@yahoo.com','www.alikhallof.6@hotmail.com','strong.hero_31@yahoo.com','rabouaarabia28@yahoo.com','noornero655@gmail.com','belalaljemaa@yahoo.com','hekmt1999@yahoo.com','ragwan3000@yahoo.com','almayahianas@yahoo.com','elisabet25elisa@yahoo.fr','poyol97@yahoo.com','the_hakers2000@yahoo.com','zt_199310@yahoo.com','remaz-1994@hotmail.com','raj3hadam@outlook.sa','love-syr22@hotmail.com','bana-ma-02@hotmail.com','mindshunter007@yahoo.com','behzadali92@yahoo.com','mehmedfener@yahoo.com','souaadch05@gmail.com','yaso32112@gmail.com','nonanann@yahoo.com','yblgasem@yahoo.com','mimita20020@gmail.com','nadotaher44@yahoo.com','mimididi84@yahoo.com','alaarusol12345@gmail.com','amalgory@yahoo.com','ilyesprince12@yahoo.fr','ahmed_lornes@yahoo.com','islam_gx2@yahoo.com','maha-lily@hotmail.com','spot.light25@yahoo.com','tala-_.fahmawi2002@hotmail.com','kriterabdou10@hotmail.fr','dr.alihanora@yahoo.com','m5556666888@gmail.com','duhaaboody@gmail.com','amira4@arab-lady.com','mohamedabdelali92@yahoo.com','ahmed.elkersh66@icloud.com','dodohany_d@yahoo.com','moga110@yahoo.com','ramzy_alamery@yahoo.com','nancysafwathelmy@yahoo.com','nour.sy.2002@mail.ru','mawwad@bethlehem.edu','a.abdo.yadem230@gmail.com','bananasser_1@hotmail.com')"

echo "=== Done ==="
REMOTE