@echo off
echo ========================================
echo Bangladesh Location Data Import Script
echo ========================================
echo.

REM Set database credentials (modify as needed)
set DB_HOST=localhost
set DB_USER=root
set DB_PASS=
set DB_NAME=cms_db

echo Importing Bangladesh location data...
echo.

REM Run the SQL script
mysql -h %DB_HOST% -u %DB_USER% %DB_PASS% %DB_NAME% < insert_bangladesh_locations.sql

if %ERRORLEVEL% EQU 0 (
    echo.
    echo ========================================
    echo SUCCESS: Bangladesh location data imported!
    echo ========================================
    echo.
    echo Data imported:
    echo - 1 Country (Bangladesh)
    echo - 8 Divisions
    echo - 64 Districts
    echo - Major Thanas for all districts
    echo.
) else (
    echo.
    echo ========================================
    echo ERROR: Failed to import data!
    echo ========================================
    echo.
    echo Please check:
    echo 1. Database connection settings
    echo 2. Database name is correct
    echo 3. MySQL is running
    echo.
)

pause

