company_official/backend/seed_products.py

import json
from app import create_app, db
from app.models import PageContent

app = create_app()

with app.app_context():
    product_data = [
      {
        "name": "高校标注实训平台",
        "subItems": ["课程教学", "毕业设计", "学科竞赛", "教师培训", "校企合作"]
      },
      {
        "name": "高校 MaaS 平台",
        "subItems": ["模型训练", "模型部署", "API服务", "算力调度"]
      },
      {
        "name": "高校人工智能通讯实践平台",
        "subItems": ["5G通讯", "物联网实践", "信号处理", "网络协议"]
      },
      {
        "name": "中小学人工智能通识课",
        "subItems": ["编程启蒙", "机器人控制", "AI科普", "创客教育"]
      }
    ]
    
    existing = PageContent.query.filter_by(page_key='products').first()
    if existing:
        existing.content = json.dumps(product_data, ensure_ascii=False)
    else:
        new_page = PageContent(
            page_key='products', 
            page_name='产品', 
            content=json.dumps(product_data, ensure_ascii=False)
        )
        db.session.add(new_page)
    
    db.session.commit()
    print("Product page data seeded successfully.")