38 lines
992 B
JavaScript
38 lines
992 B
JavaScript
const { PrismaClient } = require('@prisma/client');
|
|
|
|
const prisma = new PrismaClient();
|
|
|
|
async function testQuery() {
|
|
const clientId = 'cmm48jpy60000qf5n7htsblly'; // Dupont Jeqn
|
|
|
|
console.log('\n=== TEST PRISMA QUERY ===');
|
|
console.log('Recherche des patients pour clientId:', clientId);
|
|
|
|
const patients = await prisma.patient.findMany({
|
|
where: { clientId: clientId },
|
|
include: {
|
|
ordonnances: {
|
|
include: {
|
|
fichiers: true
|
|
}
|
|
}
|
|
},
|
|
orderBy: {
|
|
dateCreation: 'desc'
|
|
}
|
|
});
|
|
|
|
console.log('Nombre de patients trouvés:', patients.length);
|
|
patients.forEach((p, index) => {
|
|
console.log(`\nPatient ${index + 1}:`);
|
|
console.log(` ID: ${p.id}`);
|
|
console.log(` clientId: ${p.clientId}`);
|
|
console.log(` OD Sphere: ${p.odSphere}, OD Cylindre: ${p.odCylindre}`);
|
|
console.log(` OG Sphere: ${p.ogSphere}, OG Cylindre: ${p.ogCylindre}`);
|
|
});
|
|
|
|
await prisma.$disconnect();
|
|
}
|
|
|
|
testQuery().catch(console.error);
|