56 lines
1.5 KiB
Bash
56 lines
1.5 KiB
Bash
#!/bin/bash
|
|
|
|
# Colors for better display
|
|
RED='\033[0;31m'
|
|
GREEN='\033[0;32m'
|
|
YELLOW='\033[1;33m'
|
|
NC='\033[0m'
|
|
|
|
# Function to display messages
|
|
print_message() {
|
|
echo -e "${GREEN}[INFO]${NC} $1"
|
|
}
|
|
|
|
# Function to display errors
|
|
print_error() {
|
|
echo -e "${RED}[ERROR]${NC} $1"
|
|
}
|
|
|
|
# Function to display warnings
|
|
print_warning() {
|
|
echo -e "${YELLOW}[WARNING]${NC} $1"
|
|
}
|
|
|
|
# Wait for MySQL to be ready
|
|
print_message "Waiting for MySQL to be ready..."
|
|
while ! docker-compose exec -T db mysqladmin ping -h localhost -u root -proot_password --silent; do
|
|
sleep 1
|
|
done
|
|
|
|
# Import initial database structure
|
|
print_message "Importing initial database structure..."
|
|
if [ -f "hesabixBackup/databasefiles/hesabix-db-default.sql" ]; then
|
|
docker-compose exec -T db mysql -u root -proot_password hesabix_db < hesabixBackup/databasefiles/hesabix-db-default.sql
|
|
if [ $? -eq 0 ]; then
|
|
print_message "Initial database structure imported successfully."
|
|
else
|
|
print_error "Failed to import initial database structure."
|
|
exit 1
|
|
fi
|
|
else
|
|
print_error "Initial database file not found at hesabixBackup/databasefiles/hesabix-db-default.sql"
|
|
exit 1
|
|
fi
|
|
|
|
# Update database schema
|
|
print_message "Updating database schema..."
|
|
docker-compose exec -T web php /var/www/html/hesabixCore/bin/console doctrine:schema:update --force
|
|
|
|
if [ $? -eq 0 ]; then
|
|
print_message "Database schema updated successfully."
|
|
else
|
|
print_error "Failed to update database schema."
|
|
exit 1
|
|
fi
|
|
|
|
print_message "Database initialization completed successfully." |