migrate_sections_icon.py 442 B

123456789101112131415
  1. from app import create_app, db
  2. from sqlalchemy import text
  3. app = create_app()
  4. with app.app_context():
  5. print("Adding icon_url column to section_title table...")
  6. try:
  7. db.session.execute(text('ALTER TABLE section_title ADD COLUMN icon_url VARCHAR(256);'))
  8. print("Added icon_url")
  9. except Exception as e:
  10. print("icon_url might already exist:", e)
  11. db.session.commit()
  12. print("Migration completed.")