debug-controller.js

const { PrismaClient } = require('@prisma/client');

async function debugController() {
  const prisma = new PrismaClient();

  try {
    // Simulate the controller logic
    const page = 1;
    const limit = 5;
    const skip = (page - 1) * limit;

    const where = {};
    const orderBy = { createdAt: 'desc' };

    console.log('Query params:', { skip, take: limit, where, orderBy });

    const [transactions, total] = await Promise.all([
      prisma.cryptoTransaction.findMany({
        skip,
        take: limit,
        where,
        orderBy,
        include: {
          user: { select: { firstName: true, lastName: true, email: true } },
          asset: true,
          network: true,
          bankAccount: true,
        },
      }),
      prisma.cryptoTransaction.count({ where }),
    ]);

    console.log('Transactions found:', transactions.length);
    console.log('Total count:', total);
    console.log('First transaction:', JSON.stringify(transactions[0], null, 2));

    const response = {
      success: true,
      data: transactions,
      pagination: {
        page,
        limit,
        total,
        pages: Math.ceil(total / limit),
        hasNext: page * limit < total,
        hasPrev: page > 1,
      },
    };

    console.log('Response structure:', JSON.stringify(response, null, 2));
  } catch (error) {
    console.error('Error:', error.message);
    console.error('Stack:', error.stack);
  } finally {
    await prisma.$disconnect();
  }
}

debugController();