migrate_sections.py 1.3 KB

12345678910111213141516171819202122232425262728
  1. from app import create_app, db
  2. from app.models import SectionTitle
  3. app = create_app()
  4. with app.app_context():
  5. db.create_all()
  6. defaults = [
  7. {'key': 'strategic_cooperation', 'name': '战略合作版块', 'title': '对外战略合作与联合运营载体', 'subtitle': '构建"产研+合作+认证+竞赛"四位一体的 AI 产教融合生态体系'},
  8. {'key': 'core_services', 'name': '核心服务版块', 'title': '核心服务', 'subtitle': '赋能行业数智升级,培育AI创新人才'},
  9. {'key': 'cooperation_cases', 'name': '合作案例版块', 'title': '合作案例', 'subtitle': '经典案例 见证实力 用数据说话'},
  10. {'key': 'partners', 'name': '合作伙伴版块', 'title': '合作伙伴', 'subtitle': '携手合作伙伴,共创美好未来'}
  11. ]
  12. for item in defaults:
  13. existing = SectionTitle.query.filter_by(section_key=item['key']).first()
  14. if not existing:
  15. new_sec = SectionTitle(
  16. section_key=item['key'],
  17. section_name=item['name'],
  18. title=item['title'],
  19. subtitle=item['subtitle']
  20. )
  21. db.session.add(new_sec)
  22. db.session.commit()
  23. print("Section titles initialized successfully.")