Simon
bea288e414
== 已部署上线 (9项) == - 代办事项真实数据源集成 (企微审批API 8bug修复链) - H5/坐席端 Logo样式统一+绿色背景 - 视频引导页修复 (localStorage key v2) - 坐席端 v9 Vue版本修复 (ElMessage._context) - 截图按钮 v10 修复 (getDisplayMedia user gesture) - 扫码样式恢复+H5扫码登录跳转修复 - H5截图快捷键提示 == 代码完成待部署 (3项) == - 知识迭代3Bug修复 (#8 POST端点/#7 MERGE幂等/#6 过期检查) - 会议室预定-小鱼易联终端 (40文件, 40/40测试通过) - IT资产升级审批推送 (asset_service.py) == 需求文档 (2项) == - 坐席端AI辅助消息框-PRD (4项新功能确认) - 坐席端布局优化建议 v2.0 (7天计划) == 新增文档 == - 日报-2026-07-11.md - 知识迭代Bug修复报告-20260711.md - 会议室预定-部署指南.md - CHANGELOG.md 更新 == 测试 == - test_todo_integration.py: 40/40 - test_meetingroom.py: 40/40 - test_bugfix_ki_suggestions.py: 21/21
50 lines
1.6 KiB
Python
50 lines
1.6 KiB
Python
#!/usr/bin/env python3
|
|
# 临时脚本：为 dev-agent-001 创建 Agent 表记录，使本地 dev login 可用于坐席端测试
|
|
import sys
|
|
import asyncio
|
|
from datetime import datetime
|
|
from uuid import uuid4
|
|
|
|
sys.path.insert(0, r'D:\资料\03-项目开发\wecom_it_smart_desk\backend')
|
|
|
|
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
|
|
from sqlalchemy.orm import sessionmaker
|
|
from sqlalchemy import select
|
|
|
|
from app.models.agent import Agent
|
|
from app.database import Base
|
|
|
|
DB_URL = 'sqlite+aiosqlite:///D:/资料/03-项目开发/wecom_it_smart_desk/backend/it_smart_desk.db'
|
|
|
|
async def main():
|
|
engine = create_async_engine(DB_URL, echo=False, future=True)
|
|
async_session = sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
|
|
|
|
async with async_session() as session:
|
|
# 检查是否已存在
|
|
stmt = select(Agent).where(Agent.user_id == 'dev-agent-001')
|
|
result = await session.execute(stmt)
|
|
existing = result.scalars().first()
|
|
if existing:
|
|
print(f'Agent dev-agent-001 已存在: id={existing.id}, status={existing.status}')
|
|
return
|
|
|
|
agent = Agent(
|
|
id=str(uuid4()),
|
|
user_id='dev-agent-001',
|
|
name='李四(IT坐席)',
|
|
status='online',
|
|
current_load=0,
|
|
max_load=5,
|
|
created_at=datetime.now(),
|
|
updated_at=datetime.now(),
|
|
role='agent',
|
|
skill_tags=[],
|
|
)
|
|
session.add(agent)
|
|
await session.commit()
|
|
print(f'Agent dev-agent-001 创建成功: id={agent.id}')
|
|
|
|
if __name__ == '__main__':
|
|
asyncio.run(main())
|