23 lines
667 B
Bash
Executable File
23 lines
667 B
Bash
Executable File
#!/bin/bash
|
|
|
|
echo "🗑️ Stopping containers..."
|
|
sudo docker compose down
|
|
|
|
echo "🗑️ Removing PostgreSQL volume..."
|
|
sudo docker volume rm medienkompetenz-lernplattform_postgres_data
|
|
|
|
echo "🚀 Starting containers with fresh database..."
|
|
sudo docker compose up -d
|
|
|
|
echo "⏳ Waiting for database to initialize (20 seconds)..."
|
|
sleep 20
|
|
|
|
echo "✅ Database has been reset and reseeded!"
|
|
echo ""
|
|
echo "Verify with:"
|
|
echo " sudo docker compose exec database psql -U lernplattform_user -d lernplattform -c \"SELECT lesson_key, title FROM lessons;\""
|
|
echo ""
|
|
echo "Check logs:"
|
|
echo " sudo docker compose logs database"
|
|
echo " sudo docker compose logs backend"
|