# Simple upgrade - backward compatible
docker pull programzmh/chatnio:v1.9.x
docker-compose down
docker-compose up -d
 
# Update configuration for new features
cat >> .env << EOF
# New file processing settings
FILE_PROCESSING_ENGINE=v2
OCR_ENABLED=true
OCR_LANGUAGES=eng,fra,deu,spa
 
# Enhanced analytics
ANALYTICS_RETENTION_DAYS=90
ANALYTICS_DETAILED_LOGS=true
EOF
 
systemctl restart chatnio

-- Create migration tracking table
CREATE TABLE IF NOT EXISTS schema_migrations (
    version VARCHAR(255) PRIMARY KEY,
    applied_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    description TEXT
);
 
-- Check current schema version
SELECT version, applied_at FROM schema_migrations ORDER BY applied_at DESC LIMIT 1;

#!/bin/bash
# manual-migration.sh
 
CURRENT_VERSION=$(mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio \
  -N -e "SELECT version FROM schema_migrations ORDER BY applied_at DESC LIMIT 1" 2>/dev/null || echo "1.0.0")
 
TARGET_VERSION="2.0.0"
 
echo "Current version: $CURRENT_VERSION"
echo "Target version: $TARGET_VERSION"
 
# Define migration path
case $CURRENT_VERSION in
  "1.6.0")
    echo "Migrating from 1.6.0 to 1.7.0..."
    mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio < migrations/1.6-to-1.7.sql
    ;&
  "1.7.0")
    echo "Migrating from 1.7.0 to 1.8.0..."
    mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio < migrations/1.7-to-1.8.sql
    ;&
  "1.8.0")
    echo "Migrating from 1.8.0 to 1.9.0..."
    mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio < migrations/1.8-to-1.9.sql
    ;&
  "1.9.0")
    echo "Migrating from 1.9.0 to 2.0.0..."
    mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio < migrations/1.9-to-2.0.sql
    ;;
  $TARGET_VERSION)
    echo "Already at target version"
    exit 0
    ;;
  *)
    echo "Unsupported migration path from $CURRENT_VERSION to $TARGET_VERSION"
    exit 1
    ;;
esac
 
echo "Migration completed successfully"

#!/bin/bash
# migrate-config.sh
 
# Backup current configuration
cp .env .env.backup
 
# v2.0 configuration changes
sed -i 's/JWT_SECRET=/SECRET=/g' .env
sed -i 's/OPENAI_KEY=/OPENAI_API_KEY=/g' .env
 
# Add new required variables
cat >> .env << EOF
# New v2.0 settings
RBAC_ENABLED=true
MFA_ENABLED=false
API_VERSION=v2
HEALTH_CHECK_ENABLED=true
METRICS_ENABLED=true
EOF
 
# Remove deprecated variables
sed -i '/LEGACY_AUTH_ENABLED/d' .env
sed -i '/OLD_API_FORMAT/d' .env
 
echo "Configuration migrated to v2.0 format"

# docker-compose-v2.yml
version: '3.8'
services:
  chatnio:
    image: programzmh/chatnio:v2.0.0
    environment:
      # Updated environment variables
      - SECRET=${SECRET}
      - RBAC_ENABLED=true
      - API_VERSION=v2
    volumes:
      # New volume structure
      - storage:/app/storage
      - logs:/app/logs
      - certs:/app/certs  # New for v2.0
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:8000/health"]
      interval: 30s
      timeout: 10s
      retries: 3
    deploy:
      resources:
        limits:
          memory: 2G
        reservations:
          memory: 1G
 
  # New services in v2.0
  redis:
    image: redis:7-alpine
    volumes:
      - redis_data:/data
    command: redis-server --appendonly yes
 
volumes:
  storage:
  logs:
  certs:
  redis_data:

-- Migrate user preferences to new format
UPDATE users SET 
  preferences = JSON_OBJECT(
    'theme', COALESCE(JSON_EXTRACT(preferences, '$.theme'), 'auto'),
    'language', COALESCE(JSON_EXTRACT(preferences, '$.language'), 'en'),
    'default_model', COALESCE(JSON_EXTRACT(preferences, '$.default_model'), 'gpt-3.5-turbo'),
    'temperature', COALESCE(JSON_EXTRACT(preferences, '$.temperature'), 0.7),
    'max_tokens', COALESCE(JSON_EXTRACT(preferences, '$.max_tokens'), 2048)
  )
WHERE preferences IS NOT NULL;
 
-- Migrate conversation metadata
UPDATE conversations SET 
  metadata = JSON_OBJECT(
    'model', model_name,
    'token_count', total_tokens,
    'created_at', created_at,
    'updated_at', updated_at
  )
WHERE metadata IS NULL;

#!/bin/bash
# migrate-storage.sh
 
OLD_STORAGE="/old/storage"
NEW_STORAGE="/new/storage"
 
# Create new directory structure
mkdir -p $NEW_STORAGE/{uploads,processed,cache,temp}
 
# Migrate files with new naming convention
find $OLD_STORAGE -type f | while read file; do
  # Extract file metadata
  basename=$(basename "$file")
  extension="${basename##*.}"
  
  # Generate new filename with hash
  new_name=$(echo "$basename" | sha256sum | cut -d' ' -f1)
  new_path="$NEW_STORAGE/uploads/${new_name}.${extension}"
  
  # Copy file and update database
  cp "$file" "$new_path"
  
  # Update database with new path
  mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio \
    -e "UPDATE files SET file_path='uploads/${new_name}.${extension}' WHERE original_name='$basename';"
done
 
echo "File storage migration completed"

#!/bin/bash
# validate-migration.sh
 
echo "=== Migration Validation ==="
 
# Test database connectivity
echo "Testing database connection..."
if mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio -e "SELECT 1;" >/dev/null 2>&1; then
  echo "✅ Database connection successful"
else
  echo "❌ Database connection failed"
  exit 1
fi
 
# Test API endpoints
echo "Testing API endpoints..."
if curl -f http://localhost:8000/health >/dev/null 2>&1; then
  echo "✅ Health endpoint working"
else
  echo "❌ Health endpoint failed"
  exit 1
fi
 
# Test chat functionality
echo "Testing chat functionality..."
response=$(curl -s -X POST http://localhost:8000/v1/chat/completions \
  -H "Authorization: Bearer $TEST_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "model": "gpt-3.5-turbo",
    "messages": [{"role": "user", "content": "Hello"}],
    "max_tokens": 10
  }')
 
if echo "$response" | jq -e '.choices[0].message.content' >/dev/null 2>&1; then
  echo "✅ Chat functionality working"
else
  echo "❌ Chat functionality failed"
  echo "Response: $response"
  exit 1
fi
 
# Test file upload
echo "Testing file upload..."
test_file=$(mktemp)
echo "This is a test file" > $test_file
 
upload_response=$(curl -s -X POST http://localhost:8000/v1/files \
  -H "Authorization: Bearer $TEST_API_KEY" \
  -F "file=@$test_file" \
  -F "purpose=chat")
 
if echo "$upload_response" | jq -e '.id' >/dev/null 2>&1; then
  echo "✅ File upload working"
else
  echo "❌ File upload failed"
  echo "Response: $upload_response"
fi
 
rm $test_file
 
# Check data integrity
echo "Checking data integrity..."
user_count=$(mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio \
  -N -e "SELECT COUNT(*) FROM users;")
conversation_count=$(mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio \
  -N -e "SELECT COUNT(*) FROM conversations;")
 
echo "Users: $user_count"
echo "Conversations: $conversation_count"
 
if [ "$user_count" -gt 0 ] && [ "$conversation_count" -gt 0 ]; then
  echo "✅ Data integrity check passed"
else
  echo "⚠️  Data integrity check: verify data migration"
fi
 
echo "=== Validation Complete ==="

#!/bin/bash
# emergency-rollback.sh
 
echo "Starting emergency rollback..."
 
# Stop current service
systemctl stop chatnio
 
# Restore database
mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio < /backups/pre-migration-backup.sql
 
# Restore application
docker pull programzmh/chatnio:previous-version
docker-compose down
docker-compose up -d
 
# Restore configuration
cp /backups/.env.backup .env
 
# Restore file storage
rm -rf /storage/*
tar -xzf /backups/storage.tar.gz -C /
 
# Start service
systemctl start chatnio
 
echo "Rollback completed. Please verify system functionality."

#!/bin/bash
# graceful-rollback.sh
 
# Maintenance mode
curl -X POST http://localhost:8000/v1/admin/maintenance \
  -H "Authorization: Bearer $ADMIN_API_KEY" \
  -d '{"enabled": true, "message": "System maintenance in progress"}'
 
# Export current data (if any new data was created)
mysqldump -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio > post-migration-data.sql
 
# Restore previous version
mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD chatnio < pre-migration-backup.sql
 
# Merge any new data if needed
# (This requires careful analysis of what data can be safely merged)
 
# Disable maintenance mode
curl -X POST http://localhost:8000/v1/admin/maintenance \
  -H "Authorization: Bearer $ADMIN_API_KEY" \
  -d '{"enabled": false}'
 
echo "Graceful rollback completed"