company_official/backend/seed_placeholders.py

from app import create_app, db
from app.models import Carousel, StrategicCooperation, Partner, CaseCategory, CooperationCase
import sys

app = create_app()

with app.app_context():
    print("Clearing old data...")
    Carousel.query.filter_by(location='home').delete()
    StrategicCooperation.query.delete()
    Partner.query.delete()
    CooperationCase.query.delete()
    CaseCategory.query.delete()
    
    print("Seeding Home Carousel...")
    c1 = Carousel(location='home', image_url='https://picsum.photos/1920/600?random=1', sort_order=1)
    db.session.add(c1)
    
    print("Seeding Strategic Cooperation...")
    sc1 = StrategicCooperation(
        name="西交人工智能应用工程推广中心",
        description="校企/企业联合打造产教融合的新技术产业和创新实践应用，赋能 AI 工程师人才培养及产学研深度融合。",
        image_url="https://picsum.photos/400/300?random=11"
    )
    sc2 = StrategicCooperation(
        name="阿里云人工智能产业中心",
        description="构建云端协同的产教融合生态体系，专业 AI 领域人才培养，实现产学研协同发展闭环。",
        image_url="https://picsum.photos/400/300?random=12"
    )
    sc3 = StrategicCooperation(
        name="工信部教考中心授权生成式人工智能应用工程师认证运营中心",
        description="面向高校和企业开展专业 AI 技能及资格认证服务，为技术/应用工程师提供权威背书。",
        image_url="https://picsum.photos/400/300?random=13"
    )
    sc4 = StrategicCooperation(
        name="中电广通(四川)科技有限公司联合运营合作伙伴",
        description="基于资源互补，全方位开展区域内项目拓展、落地服务及运营，打造 AI 创新应用及产教融合标杆项目。",
        image_url="https://picsum.photos/400/300?random=14"
    )
    db.session.add_all([sc1, sc2, sc3, sc4])
    
    print("Seeding Cooperation Cases...")
    cat_edu = CaseCategory(name="产教融合案例", section="education")
    cat_srv = CaseCategory(name="产业服务案例", section="service")
    db.session.add_all([cat_edu, cat_srv])
    db.session.flush() # to get IDs
    
    case1 = CooperationCase(
        title="数智工坊",
        description="与华西口腔医院合作开展和专业诊疗大模型，构建数智口腔应用示范，服务于推广场景，打造人机共融的新型专科，高效的产学研用。",
        image_url="https://picsum.photos/800/600?random=21",
        section="education",
        category_id=cat_edu.id
    )
    case2 = CooperationCase(
        title="智能制造产教融合项目",
        description="联合多家制造企业，将真实的工业互联网平台与AI质检应用引入高校实训课堂，实现学生技能与企业需求的无缝对接。",
        image_url="https://picsum.photos/800/600?random=22",
        section="education",
        category_id=cat_edu.id
    )
    case3 = CooperationCase(
        title="企业AI智能客服系统",
        description="为某大型电商企业定制开发基于大语言模型的智能客服系统，大幅降低人工成本，提升客户满意度及问题解决效率。",
        image_url="https://picsum.photos/800/600?random=23",
        section="service",
        category_id=cat_srv.id
    )
    db.session.add_all([case1, case2, case3])
    
    print("Seeding Partners...")
    partners = []
    partner_names = ["火山引擎", "百度", "Microsoft", "腾讯", "复旦大学", "清华大学", "Redmi", "Seguros", "Klara", "章鱼", "西瓜视频", "Bradesco"]
    for i, name in enumerate(partner_names):
        p = Partner(
            name=name,
            image_url=f"https://via.placeholder.com/180x80/ffffff/333333?text={name}"
        )
        partners.append(p)
    db.session.add_all(partners)
    
    db.session.commit()
    print("Seeding completed successfully!")