// This script synchronizes the Prisma schema with the database
// Run with: npx ts-node scripts/sync-prisma-db.ts
// Or use: npx prisma db push

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function main() {
  console.log('Checking database connection...')
  
  try {
    // Test connection
    await prisma.$connect()
    console.log('Database connected successfully!')
    
    // Count users
    const userCount = await prisma.user.count()
    console.log(`Current user count: ${userCount}`)
    
    // List all users
    const users = await prisma.user.findMany({
      select: {
        id: true,
        username: true,
        discordId: true,
        role: true,
        createdAt: true,
      }
    })
    
    console.log('\nUsers in database:')
    if (users.length === 0) {
      console.log('  No users found in the database.')
      console.log('  Users are created when they log in via Discord OAuth.')
    } else {
      users.forEach(user => {
        console.log(`  - ${user.username} (${user.discordId}) - Role: ${user.role}`)
      })
    }
    
  } catch (error) {
    console.error('Database error:', error)
  } finally {
    await prisma.$disconnect()
  }
}

main()