How can I properly mock neon with Jest in a Next.js application?
I need to add a unit test for this query:
SELECT COUNT(*) as count FROM posts
import { neon } from '@neondatabase/serverless'
const sql = neon(process.env.DATABASE_URL as string)
// Get the total count of posts
export async function getTotalPostCount() {
const data = await sqlSELECT COUNT(*) as count FROM posts
return data[0]?.count ? data[0]?.count - 1 : 0
}
