| """ | |
| Database Initialization Script | |
| Run this once to create all tables and populate with sample data | |
| """ | |
| import sys | |
| from pathlib import Path | |
| sys.path.append(str(Path(__file__).parent)) | |
| from utils.database import init_database | |
| def main(): | |
| print("🚀 Initializing Women Empowerment Hub Database...") | |
| print("=" * 60) | |
| success = init_database() | |
| if success: | |
| print("\n✅ Database initialized successfully!") | |
| print("\n📊 All tables created:") | |
| print(" - users") | |
| print(" - jobs") | |
| print(" - courses") | |
| print(" - success_stories") | |
| print(" - resources") | |
| print(" - mentors") | |
| print(" - community_posts") | |
| print(" - emergency_contacts") | |
| print(" - health_records") | |
| print(" - legal_rights") | |
| print("\n🎉 You're all set! Run 'streamlit run streamlit_app.py' to start the app.") | |
| else: | |
| print("\n❌ Database initialization failed. Please check your DATABASE_URL in .env file.") | |
| if __name__ == "__main__": | |
| main() | |