const express = require('express');
const router = express.Router();
const pool = require('../db');

router.get('/:numAccount',
    async (req, res) => {
        const { numAccount } = req.params;

        try {
            const [results] = await pool.query(
                'SELECT a.id_cuenta, a.nombre , a.correo , a.credito, b.carrera FROM alumno a JOIN carrera b ON (a.id_carrera = b.id_carrera) WHERE a.id_cuenta = ?;',
                [numAccount]
            )
            if (results.length === 0) {
                return res.status(404).json({ error: 'Alumno no encontrado' });
            }

            res.json(results);
        } catch (err) {
            res.status(500).json({ error: 'Error al consultar: ' + err.message })
        }
    });

module.exports = router;
//IO