pages/api/database/stats.js

import { DatabaseManager } from '../../lib/database-manager';

export default function handler(req, res) {
  if (req.method !== 'GET') {
    return res.status(405).json({ error: 'Method not allowed' });
  }

  try {
    const db = new DatabaseManager();
    const stats = db.getStats();

    res.status(200).json(stats);
  } catch (error) {
    console.error('Database error:', error);
    res.status(500).json({ error: 'Failed to fetch stats' });
  }
}