import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function checkDatabase() {
  try {
    console.log('Connecting to database...')
    
    // Check projects
    const projects = await prisma.project.findMany()
    console.log(`Found ${projects.length} projects`)
    console.log('Projects:', projects.map(p => p.title))
    
    // Check blog posts
    const blogPosts = await prisma.blogPost.findMany()
    console.log(`Found ${blogPosts.length} blog posts`)
    console.log('Blog posts:', blogPosts.map(p => p.title))
    
    // Check team members
    const teamMembers = await prisma.teamMember.findMany()
    console.log(`Found ${teamMembers.length} team members`)
    console.log('Team members:', teamMembers.map(p => p.name))
    
    // Check FAQs
    const faqs = await prisma.fAQ.findMany()
    console.log(`Found ${faqs.length} FAQs`)
    console.log('FAQs:', faqs.map(p => p.question))
    
    console.log('Database check completed successfully!')
  } catch (error) {
    console.error('Error checking database:', error)
  } finally {
    await prisma.$disconnect()
  }
}

checkDatabase()