jocay
3c9b65d982
- Nuxt 4 + Nuxt UI 4 + AI SDK 7 + Drizzle/SQLite - 主编规划大纲与章节简报、选派作家；作家流式写入章节文件并实时推送前端 - 逐章确认模式（默认）与自动模式；摘要与故事记忆 - 酒馆角色卡（PNG/JSON，V1-V3）与世界书导入 - 自定义最高优先级系统提示词、审稿/修改/多版本、任务日志与提示词检视 - 模拟 LLM 服务与端到端测试脚本 Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
21 lines
856 B
TypeScript
21 lines
856 B
TypeScript
import { desc, sql } from 'drizzle-orm'
|
|
|
|
export default defineEventHandler(() => {
|
|
const db = useDb()
|
|
const rows = db.select().from(tables.projects).orderBy(desc(tables.projects.updatedAt)).all()
|
|
const stats = db.select({
|
|
projectId: tables.chapters.projectId,
|
|
total: sql<number>`count(*)`,
|
|
approved: sql<number>`sum(case when ${tables.chapters.status} = 'approved' then 1 else 0 end)`,
|
|
words: sql<number>`coalesce(sum((select word_count from chapter_versions v where v.id = ${tables.chapters.activeVersionId})), 0)`
|
|
}).from(tables.chapters).groupBy(tables.chapters.projectId).all()
|
|
return rows.map(p => ({
|
|
id: p.id,
|
|
title: p.title,
|
|
description: p.description,
|
|
updatedAt: p.updatedAt,
|
|
stats: stats.find(s => s.projectId === p.id) ?? { total: 0, approved: 0, words: 0 },
|
|
running: getActiveRun(p.id)
|
|
}))
|
|
})
|