from app import create_app, db
from app.models import DevelopmentHistory
import sqlalchemy

app = create_app()
with app.app_context():
    # check if column exists
    inspector = sqlalchemy.inspect(db.engine)
    columns = [col['name'] for col in inspector.get_columns('development_history')]
    if 'image_url' not in columns:
        with db.engine.begin() as conn:
            conn.execute(sqlalchemy.text('ALTER TABLE development_history ADD COLUMN image_url VARCHAR(256)'))
        print("Added image_url column")
    else:
        print("Column already exists")