#!/usr/bin/env bash
# Sets up the AgriFound database end-to-end.
# Usage: ./setup.sh [mysql_user] [mysql_password]
set -e

USER="${1:-root}"
PASS="${2:-}"
PASS_ARG=""
if [ -n "$PASS" ]; then PASS_ARG="-p$PASS"; fi

echo "== 1/4: Creating schema =="
mysql -u "$USER" $PASS_ARG < database/schema.sql

echo "== 2/4: Loading reference data (orchards, regions, sensor nodes, catalogs) =="
mysql -u "$USER" $PASS_ARG < database/seed_reference.sql

echo "== 3/4: Running the Python simulation + analytics pipeline =="
cd python
pip install -r requirements.txt --break-system-packages 2>/dev/null || pip install -r requirements.txt
python3 run_pipeline.py
cd ..

echo "== 4/4: Loading generated sensor/analytics data =="
mysql -u "$USER" $PASS_ARG agrifound < database/data_generated.sql

echo ""
echo "Done! Now:"
echo "  1. php web/create_users.php     # seed demo login accounts"
echo "  2. php -S localhost:8000 -t web # serve the dashboard"
echo "  3. open http://localhost:8000"