company_official/backend/migrate_carousel_text.py

from app import create_app, db
from sqlalchemy import text

app = create_app()

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