#!/bin/bash

echo "🚀 Starting Database Search Scripts..."
echo "=========================================="

# الدخول لمجلد المشروع
cd /var/www/zoho/zoho_quality/

# تفعيل البيئة الافتراضية
source /home/ubuntu/myenv/bin/activate

# إضافة المجلد الحالي إلى PYTHONPATH
export PYTHONPATH="/var/www/zoho/zoho_quality:$PYTHONPATH"

echo ""
echo "▶ Running SAM Search..."
python3 sam.py
echo ""

echo "▶ Running OFAC Search..."
python3 ofac.py
echo ""

echo "▶ Running Exclusions Search..."
python3 exclusions.py
echo ""

echo "▶ Sending Email Report..."
python3 Sendmail.py
echo ""

echo "=========================================="
echo "✅ All scripts finished successfully!"
echo "=========================================="