42 lines
1.1 KiB
JavaScript
42 lines
1.1 KiB
JavaScript
const { PrismaClient } = require('@prisma/client');
|
|
const { PrismaPg } = require('@prisma/adapter-pg');
|
|
|
|
// Load environment variables from .env file
|
|
require('dotenv').config();
|
|
|
|
// Create PrismaClient with PostgreSQL adapter (matching src/lib/prisma.ts)
|
|
const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL });
|
|
const prisma = new PrismaClient({ adapter });
|
|
|
|
async function listUsers() {
|
|
try {
|
|
const users = await prisma.user.findMany({
|
|
include: {
|
|
player: true,
|
|
},
|
|
orderBy: {
|
|
id: 'asc',
|
|
},
|
|
});
|
|
|
|
console.log('Users in database:');
|
|
console.log('='.repeat(80));
|
|
users.forEach(user => {
|
|
console.log(`ID: ${user.id}`);
|
|
console.log(` Email: ${user.email}`);
|
|
console.log(` Role: ${user.role}`);
|
|
console.log(` Player: ${user.player?.name || 'N/A'}`);
|
|
console.log(` Created: ${user.createdAt}`);
|
|
console.log('');
|
|
});
|
|
|
|
console.log(`Total users: ${users.length}`);
|
|
} catch (error) {
|
|
console.error('Error listing users:', error);
|
|
} finally {
|
|
await prisma.$disconnect();
|
|
}
|
|
}
|
|
|
|
listUsers();
|