| 123456789101112131415 |
- 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")
|
