forked from BRETT/BRETT
17 lines
463 B
TypeScript
17 lines
463 B
TypeScript
import { sql } from 'drizzle-orm'
|
|
import { users } from '../db/schema'
|
|
|
|
export default defineEventHandler(async () => {
|
|
try {
|
|
const db = useDb()
|
|
await db.execute(sql`SELECT 1`)
|
|
const [{ count }] = await db
|
|
.select({ count: sql<number>`count(*)` })
|
|
.from(users)
|
|
return { status: 'ok', database: 'connected', users: Number(count) }
|
|
}
|
|
catch {
|
|
throw createError({ statusCode: 503, statusMessage: 'Database unavailable' })
|
|
}
|
|
})
|