import { NextRequest, NextResponse } from 'next/server'
import { clearUserSession, SESSION_ID_COOKIE } from '../../_helpers/session'
import { getDb } from '@/server/db'
import { USER_AUTH_SQL } from '@/server/userAuthSql'

export const runtime = 'nodejs'

export async function POST(req: NextRequest) {
    try {
        const sessionId = req.cookies.get(SESSION_ID_COOKIE)?.value
        if (sessionId) {
            const db = await getDb()
            await db.run(
                USER_AUTH_SQL.deleteSessionById,
                [sessionId]
            )
        }
        clearUserSession()
        return NextResponse.json({ ok: true })
    } catch (error) {
        console.error('Logout error:', error)
        return NextResponse.json({ ok: false, message: '登出失敗' }, { status: 500 })
    }
}