6cf5b0dae1
- Add PostgreSQL remote connection setup section to DEPLOY_FROM_SCRATCH.md - Update deploy_from_scratch.sh to display PostgreSQL remote connection instructions - Remove blocking pause from deployment script (informational only) - Update admin-frontend API client to handle empty VITE_API_URL for proxy setups
Scripts Directory
This directory contains utility scripts organized by purpose.
Directory Structure
db/ - Database Utilities
Database management and migration scripts:
drop_all_tables.py- Drop all database tablesdrop_all_tables_web.py- Drop all web database tablesgrant_auth_db_permissions.py- Grant permissions on auth databasemigrate_sqlite_to_postgresql.py- Migrate from SQLite to PostgreSQLrecreate_tables_web.py- Recreate web database tablesshow_db_tables.py- Display database table information
debug/ - Debug and Analysis Scripts
Debugging and analysis tools:
analyze_all_faces.py- Analyze all faces in databaseanalyze_pose_matching.py- Analyze face pose matchinganalyze_poses.py- Analyze face posescheck_database_tables.py- Check database table structurecheck_identified_poses_web.py- Check identified poses in web databasecheck_two_faces_pose.py- Compare poses of two facescheck_yaw_angles.py- Check face yaw anglesdebug_pose_classification.py- Debug pose classificationdiagnose_frontend_issues.py- Diagnose frontend issuestest_eye_visibility.py- Test eye visibility detectiontest_pose_calculation.py- Test pose calculation
utils/ - Utility Scripts
General utility scripts:
fix_admin_password.py- Fix admin user passwordupdate_reported_photo_status.py- Update reported photo status
Root-Level Scripts
Project-specific scripts remain in the repository root:
install.sh- Installation scriptrun_api_with_worker.sh- Start API with workerstart_backend.sh- Start backend serverstop_backend.sh- Stop backend serverrun_worker.sh- Run RQ workerdemo.sh- Demo helper script
Database Shell Scripts
Database-related shell scripts remain in scripts/:
drop_auth_database.sh- Drop auth databasegrant_auth_db_delete_permission.sh- Grant delete permissionssetup_postgresql.sh- Set up PostgreSQL
Usage
Most scripts can be run directly:
# Database utilities
python scripts/db/show_db_tables.py
# Debug scripts
python scripts/debug/analyze_all_faces.py
# Utility scripts
python scripts/utils/fix_admin_password.py
Some scripts may require environment variables or database connections. Check individual script documentation or comments for specific requirements.