import { eq } from 'drizzle-orm'
import { useDB, schema } from '../../../utils/db.js'
import { requireAdmin } from '../../../utils/auth.js'

export default defineEventHandler(async (event) => {
  requireAdmin(event)

  const id = Number(getRouterParam(event, 'id'))
  const db = useDB()

  const item = db.select().from(schema.articles).where(eq(schema.articles.id, id)).get()

  if (!item) {
    throw createError({ statusCode: 404, message: '文章不存在' })
  }

  let tags = []
  if (item.tags) {
    try {
      const parsed = JSON.parse(item.tags)
      tags = Array.isArray(parsed) ? parsed : []
    } catch { tags = [] }
  }

  return { ...item, tags }
})