company_official/backend/migrate_carousel.py

from app import create_app, db
from sqlalchemy import text

app = create_app()

with app.app_context():
    print("Adding columns to carousel table...")
    try:
        db.session.execute(text('ALTER TABLE carousel ADD COLUMN title_image_url VARCHAR(256);'))
        print("Added title_image_url")
    except Exception as e:
        print("title_image_url might already exist:", e)
        
    try:
        db.session.execute(text('ALTER TABLE carousel ADD COLUMN element_image_url VARCHAR(256);'))
        print("Added element_image_url")
    except Exception as e:
        print("element_image_url might already exist:", e)
    
    db.session.commit()
    print("Migration completed.")